List of Entities, Diagram: CDEFD Some Unit Related Entities

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.


Association

AssociationDoubtfulFlag
Data element: Association Doubtful Flag
Type: LOGICAL (Y/N)
AssociationType
Data element: Association Type Designation
Type: CHAR()
FirstUnit_Pt
Data element: Unit Object Identifier
Type: LONG
SecondUnit_Pt
Data element: Unit Object Identifier
Type: LONG


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


Free Identification Event

FreeIdentifEvent_ID
Data element: Free Identification Event Identifier
Type: LONG
FreeIdentifBy_Pt
Data element: Person Team Identifier
Type: LONG
FreeIdentifEventDate
Data element: Free Identification Event Date
Type: DATE
FreeIdentifNotes
Data element: Free Identification Event Notes
Type: MEMO
MaterialDescription
Data element: Free Description for Non-categorized Unit Material
Type: CHAR()
Unit_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()


Material Category

MaterialCateg_ID
Data element: Material Category Identifier
Type: LONG
MaterialCategDescription
Data element: Material Category Description
Type: MEMO
MaterialCategName
Data element: Material Category Name
Type: CHAR()


Storage Medium

StorageMedium_ID
Data element: Storage Medium Identifier
Type: LONG
MediumDescription
Data element: Storage Medium Description
Type: MEMO
StorageMedium
Data element: Storage Medium Designation
Type: CHAR()


Taxon Identification Event

TaxonIdentifEvent_ID
Data element: Taxon Identification Event Identifier
Type: LONG
TaxonIdentifBy_Pt
Data element: Person Team Identifier
Type: LONG
TaxonIdentifCitavit_Pt
Data element: Reference Detail Identifier
Type: LONG
TaxonIdentifEventDate
Data element: Taxon Identification Event Date
Type: DATE
TaxonIdentifModif
Data element: Taxon Identification Modifier
Type: CHAR()
Value range: aff., c., cf., near
TaxonIdentifModifRank
Data element: Taxon Identification Modifier Rank Referred to
Type: INTEGER(2)
Default value: Lowest rank in identified taxon
TaxonIdentifNotes
Data element: Taxon Identification Event Notes
Type: MEMO
TaxonIdentifType
Data element: Taxon Identification Type
Type: CHAR()
Default value: Determined
Value range: Absent, Confirmed, Determined, Negative
TaxonIdentifVerifLevel
Data element: Standard (ITF) Verification Level for Identification
Type: CHAR(1)
Default value: space
Value range: 0, 1, 2, 3, 4, space
TaxonIdentified_Pt
Data element: Potential Taxon Name Object Identifier
Type: LONG
Unit_Pt
Data element: Unit Object Identifier
Type: LONG


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 Subtype Designation

UnitSubtype_ID
Data element: Unit Subtype Identifier
Type: LONG
UnitSubtype
Data element: Unit Subtype Name
Type: CHAR()
UnitSubtypeDescription
Data element: Unit Subtype Description

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