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).