List of Entities, Diagram: CDEFD Taxon Identification
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.
Accounting Mechanism
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()
Person Team
- PersonTeam_ID
- Data element: Person Team Identifier
Type: LONG
- PersonTeamDescription
- Data element: Person Team Description of Group
Type: CHAR()
Potential Taxon Name
- PotTax_ID
- Data element: Potential Taxon Name Object Identifier
Type: LONG
- Basio_Pt
- Data element: Potential Taxon Name Object Identifier
Type: LONG
- FullNam_Pt
- Data element: Potential Taxon Name Object Identifier
Type: LONG
- SystSequNo
- Data element: Potential Taxon Systematic Sequence Number
Type: LONG
- UpdatBy_Pt
- Data element: User Identifier
Type: LONG
- UpdateDate
- Data element: Last Date of Write-Access to Record
Type: DATE
Reference Detail
- RefDetl_ID
- Data element: Reference Detail Identifier
Type: LONG
- ItemDetail
- Data element: Reference Detail Item Designator
Type: CHAR(30)
Example values: plate 1, map 22 grid a15, fig. 10b
- PreciPgCit
- Data element: Reference Precise Page Citation
Type: CHAR(30)
- Title_Pt
- Data element: Reference Title Identifier
Type: LONG
- UpdatBy_Pt
- Data element: User Identifier
Type: LONG
- UpdateDate
- Data element: Last Date of Write-Access to Record
Type: DATE
Reference Title
- Title_ID
- Data element: Reference Title Identifier
Type: LONG
- AutRole_Pt
- Data element: Reference Role of Author(s) Identifier
Type: LONG
- AutTeam_Pt
- Data element: Person Team Identifier
Type: LONG
- BkDetai_Pt
- Data element: Book Reference Detail Identifier
Type: LONG
- DbDetai_Pt
- Data element: Database Reference Detail Identifier
Type: LONG
- InTitle_Pt
- Data element: Reference Title Identifier
Type: LONG
- InfmRef_Pt
- Data element: Informal Reference Identifier
Type: LONG
- IsNotPaper
- Data element: Reference Title Is Not Paper Flag
Type: LOGICAL (Y/N)
- OrCitation
- Data element: Reference Title Original Citation
Type: CHAR(250)
- PageRange
- Data element: Reference Page Range for Title
Type: CHAR(13)
- PeDetai_Pt
- Data element: Periodical Reference Detail Identifier
Type: LONG
- PublicDate
- Data element: Reference Title Publication Date
- PublicType
- Data element: Reference Title Type of Reference
Type: CHAR(2)
Value range: AP, BK, DB, IN, IR, NA
- PublicYear
- Data element: Reference Publication Year
Type: INTEGER(4)
- SerDetl_Pt
- Data element: Publication Series Detail Identifier
Type: LONG
- Title
- Data element: Reference Title
Type: CHAR()
- UnpublFlag
- Data element: Reference Unpublished Flag
Type: LOGICAL Y/N
- UpdatBy_Pt
- Data element: User Identifier
Type: LONG
- UpdateDate
- Data element: Last Date of Write-Access to Record
Type: DATE
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
This HTML document has been generated by an export function written in the scripting language of the CASE/4/0 program (MicroTool 1995).