List of Entities, Diagram: CDEFD Derived Unit Subtypes

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.


Chemical Substance Identification Event

No attributes defined.


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


Published Exsiccata

Exsiccat_ID
Data element: Published Exsiccatum Identifier
ExsiccatBookletRef_Pt
Data element: Reference Title Identifier
Type: LONG
ExsiccatFascicleNo
Data element: Exsiccatum Fascicle Number
Type: CHAR()
ExsiccatName
Data element: Exsiccatum Name
Type: CHAR()
ExsiccatNotesRef_Pt
Data element: Reference Title Identifier
Type: LONG
ExsiccatRef_Pt
Data element: Reference Title Identifier
Type: LONG
ExsiccatSerialNoEnd
Data element: Exsiccatum Serial Number
Type: CHAR()
ExsiccatSerialNoStart
Data element: Exsiccatum Serial Number
Type: CHAR()


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 Chemical Identification

No attributes defined.


Unit Subtype Cultivation

CultivationNote
Data element: Cultivation Unit Experience Note
Type: MEMO
CultivationTransfInterval
Data element: Cultivation Transfer Interval
Type: DOUBLE


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


Unit Subtype Herbarium Label

AdditionalLabelText
Data element: Label Later Text Additions
LabelFooter
Data element: Label Footer
Type: CHAR()
LabelTitle1
Data element: Label First Title
Type: CHAR()
LabelTitle2
Data element: Label Second Title
Type: CHAR()


Unit Subtype Published Exsiccatum Specimen

Exsiccat_Pt
Data element: Published Exsiccatum Identifier
SerialNumber
Data element: Exsiccatum Serial Number
Type: CHAR()
TaxonName_Pt
Data element: Scientific Name Object Identifier
Type: LONG


Unit Subtype Quantification

QuantifValue
Data element: Quantity Measured
Type: DOUBLE
QuantifValueError
Data element: Quantification Value Error
Type: DOUBLE
QuantifValuePrecisModif
Data element: Quantification Value Precision Modifier
Type: CHAR()
QuantityQualificationText
Data element: Quantitification Text
Type: CHAR()
Example values: Much, Large, Small, Minute
UnitOfMeasurement
Data element: Quantitification Unit of Measurement
Type: CHAR()

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