List of Entities, Diagram: CDEFD Unit Management

Entities are listed in alphabetical order. For every entity, primary key attributes (if present) are listed first, other attributes follow in alphabetical order. Foreign keys are recognized by a _Pt suffix (pointer).
Every attribute name is followed by the name of its data element, which in many cases provides a short description of the attribute's meaning. Type and example values refer to the data element.


Accession or Inventory Code

AccCode_ID
Data element: Accession or Inventory Code Identifier
Type: LONG
AccCode
Data element: Accession or Inventory Code or Number
Type: CHAR()
AccDate
Data element: Accession Date
Type: DATE
AccResponsible_Pt
Data element: Person Team Identifier
Type: LONG
AccSystem_Pt
Data element: Accession or Inventory Coding System Identifier
Type: LONG


Accession or Inventory Coding System

AccSystem_ID
Data element: Accession or Inventory Coding System Identifier
Type: LONG
AccSystemAbbr
Data element: Accession or Inventory Coding System Abbreviation
Type: CHAR()
AccSystemDescription
Data element: Accession or Inventory Coding System Description
Type: MEMO
AccSystemName
Data element: Accession or Inventory Coding System Name
Type: CHAR()
BulkFlag
Data element: Accession or Inventory Coding System Bulk Accession Possible Flag
Type: LOGICAL (Y/N)
CharactersAllowedFlag
Data element: Accession or Inventory Coding System Rules Alphabet Characters Allowed Flag
Type: LOGICAL (Y/N)
DigitsAllowedFlag
Data element: Accession or Inventory Coding System Rules Digits Allowed Flag
Type: LOGICAL (Y/N)
InternalFlag
Data element: Accession or Inventory Coding System Internal Use Only Flag
Type: LOGICAL (Y/N)
MachineReadableCodeType
Data element: Accession or Inventory Coding Machine Readable System Type
Type: CHAR()
Example values: bar code 3 of 9, responder
OtherAllowedCharacters
Data element: Accession or Inventory Coding System Rules List of Other Allowed Characters
Type: CHAR()
UniqueFlag
Data element: Accession or Inventory Coding System Unique Codes Used Flag
Type: LOGICAL (Y/N)
UpperCaseOnlyFlag
Data element: Accession or Inventory Coding System Rules Upper Case Only Flag
Type: LOGICAL (Y/N)


Accounting Mechanism

No attributes defined.


Collection or Subcollection

CollectionAbbr
Data element: Collection or Subcollection Standard Abbreviation
Type: CHAR()
CollectionLocation_Pt
Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
CollectionName
Data element: Collection or Subcollection Name
Type: CHAR()
Collection_ID
Data element: Collection or Subcollection Identifier
Type: LONG
DefaultAccSystemCode_Pt
Data element: Accession or Inventory Coding System Identifier
Type: LONG
DefaultStorageMedium_Pt
Data element: Storage Medium Identifier
Type: LONG
ParentCollection_Pt
Data element: Collection or Subcollection Identifier
Type: LONG
StorageLocDetailFlag
Data element: Collection or Subcollection Storage Location Detail Entry Required Flag
Type: LOGICAL (Y/N)
StoredUnderNameFlag
Data element: Collection or Subcollection Stored Under Name Entry Requiered Flag
Type: LOGICAL (Y/N)


Derived Unit

AdditCuratorialIdentifier
Data element: Derived Unit Curatorial Collection Number Suffix
Type: CHAR()
Collection_Pt
Data element: Collection or Subcollection Identifier
Type: LONG
DerivUnitCreatEvent_Pt
Data element: Derived Unit Creation Event Identifier
Type: LONG
DistribRestrictNotes
Data element: Derived Unit Distribution Restriction Notes
Type: MEMO
DistribRestrictSetBy_Pt
Data element: Person Team Identifier
Type: LONG
DistribRestrictSetDate
Data element: Derived Unit Distribution Restriction Set Date
Type: DATE
DistribRestriction
Data element: Unit Restriction Imposed on Distribution
Type: CHAR()
Example values: Generally available, Only to defined institutions, Only to ...
EnsembleSetIdentifier
Data element: Unit Object Identifier
Type: LONG
FieldUnitShortcut_Pt
Data element: Unit Object Identifier
Type: LONG
ParentLinkCertainFlag
Data element: Unit Parent Link Certain Flag
Type: LOGICAL (Y/N)
PermanentLoanFlag
Data element: Unit on Permanent Loan Flag
Type: LOGICAL (Y/N)
PreparationIdentifier
Data element: Derived Unit Preparation Number
Type: CHAR()
Presence
Data element: Derived Unit Presence or Accessibility in Collection
Type: CHAR()
StorageLocationDetail
Data element: Unit Detailed Location within Collection
Type: CHAR()
Example values: Drawer 1, 3A12, Lower right corner of herbarium sheet
StorageMedium_Pt
Data element: Storage Medium Identifier
Type: LONG
StoredUnderName_Pt
Data element: Scientific Name Object Identifier
Type: LONG
TopmostSimilarUnit_Pt
Data element: Unit Object Identifier
Type: LONG


Gathering or Field Unit

FieldCode
Data element: Field Identifier Non-Standard Number or Phrase
Type: CHAR()
FieldNo
Data element: Field Identifier Sequential Number
Type: LONG
FieldNoPrefix
Data element: Field Identifier Sequential Number Prefix
Type: CHAR()
FieldNoSuffix
Data element: Field Identifier Sequential Number Suffix
Type: CHAR()
GatheringEvent_Pt
Data element: Gathering Event Identifier
Type: LONG
GatheringMethod
Data element: Gathering Method
Type: CHAR()
IndivLocalityDescription
Data element: Gathering Individual Locality Description
Type: CHAR()


Loan

Loan_ID
Data element: Loan Identifier
Type: LONG
DeadlineDate
Data element: Loan Deadline for Return Date
Type: DATE
RecipientLoanIdentifier
Data element: Loan Recipient Loan Identifier Code
Type: CHAR()
RemindersSent
Data element: Loan Reminder Letters Sent
Type: MEMO
Request_Pt
Data element: Person Team Identifier
Type: LONG
ReturnCompleteFlag
Data element: Loan Completely Returned Flag
Type: LOGICAL (Y/N)
Rspnsbl_Pt
Data element: Person Team Identifier
Type: LONG
SenderLoanIdentifier
Data element: Loan Sender Loan Identifier Code
Type: CHAR()


Permit

Permit_ID
Data element: Permit Identifier
Type: LONG
PermitAuthority
Data element: Permit Issuing Authority
Type: CHAR()
PermitDescription
Data element: Permit Description
Type: MEMO
PermitNo
Data element: Permit Number
Type: CHAR()
PermitType
Data element: Permit Type
Type: CHAR()
Example values: CITES, Collection permit, Export Permit


Person Team

PersonTeam_ID
Data element: Person Team Identifier
Type: LONG
PersonTeamDescription
Data element: Person Team Description of Group
Type: CHAR()


Person(s), Institute, Company, or Organization

PICO_ID
Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
PICOAddress_Pt
Data element: Address Identifier
Type: LONG
PICOType
Data element: Person(s), Institution, Organization, Company, or Organization Type


Transfer Agreement

Agreement_ID
Data element: Transfer Agreement Identifier
Type: LONG
Agreement
Data element: Permanent Transfer Agreement
Type: MEMO


Transfer Event

TransferEvent_ID
Data element: Transfer Event Identifier
Type: LONG
Carrier_Pt
Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
PostageCharged
Data element: Transfer Event Total Postage Charged
Type: LONG
ReceiptAcknowledgedDate
Data element: Transfer Receipt Acknowledged by Recipient Date
Type: DATE
ReceivingDate
Data element: Transfer Date Received
Type: DATE
ReceivingNotes
Data element: Transfer Notes upon Receiving
Type: MEMO
Recipient_Pt
Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
Sender_Pt
Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
SendingDate
Data element: Transfer Date of Sending
Type: DATE
SendingNotes
Data element: Transfer Notes on Sending
Type: MEMO


Unit

Unit_ID
Data element: Unit Object Identifier
Type: LONG
Confidentiality
Data element: Unit Confidential Data Designation
Type: CHAR()
ConfidentialityNotes
Data element: Unit Confidentiality Assignment Notes
Type: MEMO
ConfidentialitySetBy_Pt
Data element: Person Team Identifier
Type: LONG
ConfidentialitySetDate
Data element: Unit Confidentiality Assigned on Date
Type: DATE
DataSource
Data element: Unit Data Source
Type: CHAR()
MaterialCategory_Pt
Data element: Material Category Identifier
Type: LONG
OriginalSourceGraphics
Data element: Unit Transcription Original Source Graphics
Type: PICTURE
OriginalSourceText
Data element: Unit Transcription Original Source Text
Type: MEMO
OwnedBy_Pt
Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
TranscribedFlag
Data element: Unit Data Transcribed Flag
Type: LOGICAL (Y/N)
TranscriptionNotes
Data element: Unit Data Transcription Notes
Type: MEMO


Unit Transfer

UnitTransfer_ID
Data element: Unit Transfer Identifier
Type: LONG
Loan_Pt
Data element: Loan Identifier
Type: LONG
TransferAgreement_Pt
Data element: Transfer Agreement Identifier
Type: LONG
TransferEvent_Pt
Data element: Transfer Event Identifier
Type: LONG
UnitTransferType
Data element: Unit Transfer Type
Type: CHAR()
Unit_Pt
Data element: Unit Object Identifier
Type: LONG

This HTML document has been generated by an export function written in the scripting language of the CASE/4/0 program (MicroTool 1995).