For every entity, primary key attributes (suffix _ID) are listed first, other attributes follow in alphabetical order. Foreign keys are recognized by a _Pt suffix (pointer).
IOPI-GPL (Global Plant Checklist) Data definitions refer to Bisby (1994).
Data element: Attachment to Potential Taxon Name Identifier
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Reference Detail Identifier
Type: LONG
Data element: Person Abbreviation According to Halliday & al. 1980
Type: CHAR(30)
Data element: Person Abbreviation Recommended Form (Brummitt & Powell 1992)
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 3.3.
Type: CHAR(20)
Data element: Person Abbreviation According to Stafleu & Cowan 1976 & seq.
Type: CHAR(20)
Data element: Person User Defined Abbreviation
Semantics: A non-standard author abbreviation catalogue specific to the repective institution housing the database.
Type: CHAR(30)
Data element: Person Flourished
Semantics: This field may contain the lifespan of the respective person or, if this is unknown, the time range in which the person is known to have worked. Integrity: Input may have only the following forms: "dd-mm-yyyy - dd-mm-yyyy" for lifespan, "dd-mm-yyyy -" or "- ddmm-yyyy" if only one of the two dates of the lifespan is known, "yyyy" or "yyyy - yyyy" if only a year or range of years in which the person has worked is known.
Type: CHAR(23)
Data element: Person Is Collector Flag
Type: LOGICAL (Y/N)
Data element: Person Is Taxonomist Flag
Type: LOGICAL (Y/N)
Data element: Person Main Taxonomic Groups Interested In
Type: CHAR(11)
Data element: Book Identifier
Type: LONG
Data element: Book (Monograph) Abbreviated Title
Semantics: E.g. title abbreviations for name citations according to TL-2 (Stafleu & Cowan, 1976-1988).
Type: CHAR(99)
Data element: Book Full Title
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.4 (in part).
Type: CHAR(99)
Data element: Book Total Number of Pages
Semantics: May also include values like "i-ix, 1-299, 5 plates".
Type: CHAR(25)
Data element: Book Edition No.
Type: CHAR(30)
Data element: ISBN Number
Data element: Publication Town,State and Country
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.12 (in part).
Type: CHAR(79)
Data element: Publication Publisher
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.12 (in part).
Type: CHAR(100)
Data element: Book - is - Thesis Flag
Type: LOGICAL Y/N
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Book Reference Detail Identifier
Type: LONG
Data element: Book Reference Detail Volume
Semantics: IOPI-GPC Data Definitions: Corresponds in part to data item 2.6. Volume refers to the book itself, i.e. not to a series title (see entites "Publication Series" and "Series Detail"
Type: CHAR(7)
Data element: Book Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Institution Identifier
Type: LONG
Data element: Postal Address Identifier
Type: LONG
Data element: Institution Abbreviation (Holmgren & al. 1990, Heywood & al. 1990)
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 3.4 (proposed for version 6, data item no. 3.3 in v. 5.1).
Type: CHAR(5)
Data element: Institution Name
Semantics: Full official name of the institution or company.
Type: CHAR(99)
Data element: Institution Town
Type: CHAR(44)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Classification Intersection Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Comment Identifier
Type: LONG
Data element: Comment Creation Date
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 4.5.
Type: DATE
Data element: Comment Long Text
Type: MEMO
Data element: Reference Detail Identifier
Type: LONG
Data element: Comment Short Text
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 4.2.
Type: CHAR(79)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Cultivar Group Identifier
Type: LONG
Data element: Cultivar Group Name
Type: CHAR(99)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Cultivar Identifier
Type: LONG
Data element: Cultivar Phrase Name
Type: CHAR(99)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Database Identifier
Type: LONG
Data element: Database Short Name
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.9.
Type: CHAR(10)
Data element: Database Name
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.4 (in part).
Type: CHAR(250)
Data element: Publication Publisher
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.12 (in part).
Type: CHAR(100)
Data element: Publication Town,State and Country
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.12 (in part).
Type: CHAR(79)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Database Reference Detail Identifier
Type: LONG
Data element: Database Edition Number
Semantics: IOPI-GPC Data Definitions: Corresponds in part to data item 2.6.
Type: CHAR(10)
Data element: Database Export Date
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.11.
Type: DATE
Data element: Database Part or File
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.10.
Type: CHAR(10)
Data element: Database Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Gazetteer: TDWG Standard Geographic Unit Identifier
Type: LONG
Data element: Gazetteer: Area Highest Point Elevation in m
Type: INTEGER(4)
Condition: -8000
Data element: Gazetteer: Area Lowest Point Elevation in m
Type: INTEGER(4)
Condition: -8000
Data element: Gazetteer: Area Validity Starting Date
Type: DATE
Data element: Gazetteer: TDWG Standard Geographic Unit Identifier
Type: LONG
Data element: ISO Political Country Code
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 5.3 (in part).
Type: CHAR(2)
Data element: Gazetteer: TDWG Standard Geographic Unit Abbreviation
Type: CHAR(6)
Data element: Gazetteer: TDWG Standard Geographic Unit Name
Type: CHAR(75)
Data element: Gazetteer: TDWG Standard Geographic Unit Rank
Semantics: 1 = Kontinent, 2 = Region, 3 = Botanical country, 4 = Basic recording unit.
Type: INTEGER(1)
Value range: 1,2,3,4
Data element: Gazetteer: TDWG Geographical Area Standard Version
Data element: Gazetteer: Area Validity Ending Date
Type: DATE
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Geographical Area Record Identifier
Type: LONG
Data element: Geographical Area Record Incoming Area Name
Type: CHAR()
Data element: Geographical Area Record Incoming Occurrence Status
Type: CHAR()
Data element: POSS Plant Occurrence Status Standard Identifier
Type: LONG
Data element: Reference Title Identifier
Type: LONG
Data element: Geographical Area Record Standard Area Derived Flag
Type: LOGICAL (Y/N)
Data element: Gazetteer: TDWG Standard Geographic Unit Identifier
Type: LONG
Data element: Reference Title Identifier
Type: LONG
Data element: Geographical Area Record Standard Occurrence Derived Flag
Type: LOGICAL (Y/N)
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Geographical Dataset Identifier
Type: LONG
Data element: Geographical Dataset Area Standard Used
Type: CHAR()
Data element: Geographical Dataset Occurrence Standard Used
Type: CHAR()
Data element: Reference Title Identifier
Type: LONG
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Geographical Record Identifier
Type: LONG
Data element: Geographical Dataset Identifier
Type: LONG
Data element: Global Distribution Summary Identifier
Type: LONG
Data element: Full Botanical Name Identifier
Type: LONG
Data element: Geographic Distribution Complete Concatenated Phrase
Type: MEMO
Data element: Reference Title Identifier
Type: LONG
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Global Distribution Summary Identifier
Type: LONG
Data element: Global Distribution Summary Occurrence in Standardized Continents
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 6.1.
Type: CHAR(8)
Data element: Global Distribution Summary Derived Flag
Data element: Reference Title Identifier
Type: LONG
Data element: Global Distribution Completeness Flag
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 6.4.
Type: LOGICAL Y/N
Default value: 0
Data element: Global Introduced / Cultivated Distribution Summary Phrase
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 6.3.
Type: CHAR(79)
Data element: Global Natural Distribution Summary Phrase
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 6.2.
Type: CHAR(80)
Data element: Global Distribution Incoming Distribution Phrase
Type: TEXT( 99)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Homonym Assignment Identifier
Type: LONG
Data element: Homonym Assignment Type Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Homonym Assignment Type Identifier
Type: LONG
Data element: Homonym "non"-Relationship Assignment Type
Type: CHAR(10)
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Hybrid Formula Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Indirectly Linked Plant Information Identifier
Data element: Informal Reference Identifier
Type: LONG
Data element: Informal Reference Additional Description
Semantics: This field can be used discuss the informal reference to justify or qualify its use. In case of an "in sched." reference, the herbarium specimen label information may here be cited in detail.
Type: CHAR(80)
Data element: Informal Reference Date
Semantics: Date on which personal communication took place or the date of the letter or document used as a reference.
Type: DATE
Data element: Informal Reference Deposited at
Semantics: Place where the informal reference has been deposited. In case of letters, notes and other documents this may be an archive. In case of herbarium labels ("in sched." - type), a herbarium should be cited.
Type: CHAR(80)
Data element: Informal Reference Type
Semantics: A short description or latin abbreviation of the type of informal reference.
Type: CHAR(12)
Example values: in adnot., in litt., in sched., pers. comm.
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Rank Identifier and Taxonomic Sequence Number
Semantics: A fixed value used by the system for the following purposes:
(1) as primary key for the rank table to relate to other tables
(2) as the sort key to taxonomic ranks (ID numbers are assigned according to the taxonomical hierarchie)
(3) as an indicator, where the name contains rank-dependent elements (i.e. in the case of infraspecies, hybrids and aggregates).
Type: INTEGER(2)
Data element: Rank Abbreviation
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 1.14 and also to 1.12, aggregate marker, because the system treats aggregates and microspecies as ranks just above and below species level.
Type: CHAR(10)
Data element: Rank Name
Type: CHAR(20)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Nomenclatural Status Designator Identifier
Type: LONG
Data element: Nomenclatural Status
Type: CHAR(16)
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Periodical Reference Detail Identifier
Type: LONG
Data element: Periodical Number
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.6 (in part).
Type: CHAR(5)
Data element: Periodical Volume
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.6 (in part).
Type: CHAR(5)
Data element: Periodical Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Periodical Identifier
Type: LONG
Data element: Periodical Identifier
Type: LONG
Data element: ISSN Number
Data element: Periodical Abbreviated Title
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.5. Wherever possible, periodical abbreviations are used according to Bridson & Smith (1991).
Type: CHAR(130)
Data element: Periodical Full Title
Type: CHAR(254)
Data element: Periodical Series
Semantics: In citations this item must be treated as part of the title. Numbering and abbreviation always refer to title including series. Note: This data item does not refer to Publication Series.
Type: CHAR(100)
Data element: Periodical Identifier
Type: LONG
Data element: Periodical Publication Town, State and Country
Type: CHAR(125)
Data element: Periodical Publisher
Type: CHAR(60)
Data element: Periodical Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Person Identifier
Type: LONG
Data element: Person Identifier
Type: LONG
Data element: Person First Names and Prefix
Semantics: Comment: Unabreviated first names and name prefix(es) like "d'", "von", etc.
Type: CHAR(150)
Data element: Person Initials and Prefix
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 3.2 (as proposed for version 6 of the Data Definition Document, 3.1 in part as to version 5.1).
Type: CHAR(15)
Data element: Person Last Name
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 3.1 (as proposed for version 6 of the Data Definition Document, 3.1 in part as to version 5.1>.
Type: CHAR(100)
Data element: Person Title
Type: CHAR(10)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Person - Institutional Affiliation Intersection Identifier
Type: LONG
Data element: Institution Identifier
Type: LONG
Data element: Person Identifier
Type: LONG
Data element: Person - Institutional Affiliation, Time Period at Institution
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 3.5 (new data item proposed for version 6 of the Data Definition Document>.
Type: CHAR(N)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Person Team Identifier
Type: LONG
Data element: Person Team Description of Group
Type: CHAR()
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Person Team Membership List Entry Identifier
Type: LONG
Data element: Person Team Identifier
Type: LONG
Data element: Person Identifier
Type: LONG
Data element: Person Team Sequence Number of Person
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 3.7 (new data item proposed for version 6 of the Data Definition document).
Internal system use only, not directly visible to the user. Determines the position from the left in which a person is cited in a team character string.
Type: INTEGER(2)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Person Team Identifier
Type: LONG
Data element: Reference Detail Identifier
Type: LONG
Data element: Person Team Identifier
Type: LONG
Data element: Reference Detail Identifier
Type: LONG
Data element: Homonym Flag
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 1.21.
If there exists more than one record with the same name elememts (i.e. monomial, binomial or trinomial including rank designator) all these records are flagged as homonyms. Homonyms which do not have exactly the same name must be defined by way of an explicit homonym declaration. They are not flagged.
Integrity: If a name record with homonym status is deleted, the flag has to be checked for the other records of the same name.
Type: LOGICAL Y/N
Data element: Hybrid or Graft-Chimera Qualifier
Semantics: IOPI-GPC Data Definitions: Includes data item 1.9 (intergeneric hybrids) and 1.11 (interspecific hybrids), because the rank of the hybrid is defined by the rank of the plant name.
0 = Not a hybrid or graft chimera
x = Hybrid
+ = Graft-chimera
(x)= Somatic hybrid obtained by parasexual process (Cultivated Code article 14)
Type: CHAR(3)
Default value: 0
Value range: (x), +, 0, x
Data element: Missapplication Warning Flag
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 1.20.
If the flag is set, at least one potential taxon with the system status S (synonym) or L (sensu lato synonym) and the status detail SMA or LMA (misapplied name) exists.
Integrity: If a potential taxon record with misapplied name status is deleted or changed to another status, the flag has to be reevaluated.
Type: LOGICAL Y/N
Data element: Name Element (Epithet, Generic or Other Taxon Monomial)
Semantics: IOPI-GPC Data Definitions: Corresponds to data items 1.6, 1.7, 1.8, 1.10, 1.15.
Contains botanical name (for ranks higher than species) or species epithet (for species) or infraspecific epithet (for infraspecies).
Type: CHAR(33)
Data element: Name Structure
Semantics: Internal system use only, invisible to the user. A system-oriented data item, made necessary by the inclusion of hybrid formulas and unnamed taxa and helpful in the construction of binominals and trinominals from name elements.
M = Monomial (e.g. name of genus, family or order name)
B = Binomial (e.g. species)
T = Trinomial (infraspecies)
H = Hybrid formula
U = Unnamed taxon
Type: CHAR(1)
Value range: B, H, M, T, U
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Rank Identifier and Taxonomic Sequence Number
Semantics: A fixed value used by the system for the following purposes:
(1) as primary key for the rank table to relate to other tables
(2) as the sort key to taxonomic ranks (ID numbers are assigned according to the taxonomical hierarchie)
(3) as an indicator, where the name contains rank-dependent elements (i.e. in the case of infraspecies, hybrids and aggregates).
Type: INTEGER(2)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Plant Name "emend." Citation Association Identifier
Type: LONG
Data element: Reference Detail Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Plant Name Sanctioning Reference Intersection Identifier
Type: LONG
Data element: Reference Detail Identifier
Type: LONG
Data element: Reference Detail Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: POSS Plant Occurrence Status Standard Identifier
Type: LONG
Data element: POSS Cultivated Status
Semantics: IOPI-GPS Data Definitions: Corresponds to data item 5.7 (in part).
POSS Plant Occurrence and Status Scheme version 1.00: Cultivated status. Allowed values:
C = Cultivated
S = Assumed to be cultivated
D = Doubtfully cultivated
E = Formerly cultivated (Extinct)
A = Not cultivated
F = Recorded as cultivated in error
- = No information
U = None of the above
X = Not applicable
Type: CHAR(1)
Default value: -
Value range: -, A, C, D, E, F, S, U
Data element: POSS Introduction Agency
Semantics: IOPI-GPS Data Definitions: Data item 5.7 (in part).
POSS Plant Occurrence and Status Scheme version 1.00: Introduction agency. Allowed values:
M = Introduced by man
N = Introduced by natural means
- = No information
U = None of the above
X = Not applicaple because field Introduced Status has value "Not introduced" or "No information"
Type: CHAR(1)
Default value: -
Value range: -, M, N, X
Data element: POSS Introduced Status
Semantics: IOPI-GPS Data Definitions: Corresponds to data item 5.7 (in part).
POSS Plant Occurrence and Status Scheme version 1.00 introduced status. Allowed values:
I = Introduced
S = Assumed to be introduced
D = Doubtfully introduced
E = Formerly introduced (Extinct)
A = Not introduced
F = Recorded as introduced in error
- = No information
U = None of the above
X = Not applicaple
Type: CHAR(1)
Default value: -
Value range: -, A, D, E, F, I, S, U
Data element: POSS Native Status
Semantics: IOPI-GPS Data Definitions: Corresponds to data item 5.7 (in part).
POSS Plant Occurrence and Status Scheme version 1.00 Native Status. Allowed values:
N = Native
S = Assumed to be native
D = Doubtfully native
E = Formerly native (Extinct)
A = Not native
F = Recorded as native in error
- = No information
U = None of the above
X = Not applicaple
Type: CHAR(1)
Default value: -
Value range: -, A, D, E, F, N, S, U
Data element: POSS Occurrence Information
Semantics: POSS version 1.0, Data Item 1: Occurrence. Allowed values:
P = Present
S = Assumed present
D = Doubt over presence
E = Extinct
F = Recorded as present in error
A = Absent
- = No information
Type: CHAR(1)
Default value: -
Value range: -, D, E, F, P, S
Data element: POSS Standard Plant Occurrence Status Version
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Postal Address Identifier
Type: LONG
Data element: Postal Address Code
Type: CHAR(12)
Data element: Postal Address Country
Type: CHAR(18)
Data element: Postal Address Line
Type: CHAR(50)
Data element: Postal Address Line
Type: CHAR(50)
Data element: Postal Address Line
Type: CHAR(50)
Data element: Postal Address Town
Type: CHAR(35)
Data element: Person Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Potential Taxon Systematic Sequence Number
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Reference Detail Identifier
Type: LONG
Data element: Reference Detail Item Designator
Semantics: Used to further specify an illustration, figure, table, map etc. or even a location within a figure (grid square of map, part of illustration). Must either refer to a numbered item, or be used in combination with a precise page citation.
Type: CHAR(30)
Example values: plate 1, map 22 grid a15, fig. 10b
Data element: Reference Precise Page Citation
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.8.
Used, for exaple, for the citation of a protologue or to cite the page of an illustration.
Type: CHAR(30)
Data element: Reference Title Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Reference Title Identifier
Type: LONG
Data element: Reference Role of Author(s) Identifier
Type: LONG
Data element: Person Team Identifier
Type: LONG
Data element: Book Reference Detail Identifier
Type: LONG
Data element: Database Reference Detail Identifier
Type: LONG
Data element: Reference Title Identifier
Type: LONG
Data element: Informal Reference Identifier
Type: LONG
Data element: Reference Title Is Not Paper Flag
Type: LOGICAL (Y/N)
Data element: Reference Title Original Citation
Semantics: The title citation as provided by the original source of information (not atomized)
Type: CHAR(250)
Data element: Reference Page Range for Title
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.7.
Can be the page range within a composite work or within a periodical.
Integrity: See data element "Reference Title Type of Reference".
Type: CHAR(13)
Data element: Periodical Reference Detail Identifier
Type: LONG
Data element: Reference Title Publication Date
Semantics: The actual date of publication as needed to determine nomeclatural priority.
Data element: Reference Title Type of Reference
Semantics: This attribute is used to establish the relation to the respective details of the titles reference citation and to determine the layout of input forms. Maps and plans are normally treated like books if they are published, and as informal references if not. Pamphlets are treated as books.
Integrity:
IF PublicType = "AP" (Article in periodical)
DbDetai_Pt = 0, PeDetai_Pt < 0, BkDetai_Pt = 0, InfmRef_Pt = 0, InTtitle_Pt = 0, Unpublished flag = 0, PageRange: filled.
IF PublicType = "BK" (Book)
DbDetai_Pt = 0, PeDetai_Pt = 0, BkDetai_Pt < 0, InfmRef_Pt = 0, InTtitle_Pt = 0, Unpublished flag = 0 or 1, PageRange: empty or filled.
IF PublicType = "IR" (Informal reference)
DbDetai_Pt = 0, PeDetai_Pt = 0, BkDetai_Pt = 0, InfmRef_Pt < 0, InTtitle_Pt = 0, Unpublished flag = 1, PageRange: empty or filled.
IF PublicType = "DB" (Database)
DbDetai_Pt < 0, PeDetai_Pt = 0, BkDetai_Pt = 0, InfmRef_Pt = 0, InTtitle_Pt = 0, Unpublished flag = 0 or 1, PageRange: empty.
IF PublicType = "IN" (Title is part of other title, "in" reference)
DbDetai_Pt = 0, PeDetai_Pt = 0, BkDetai_Pt = 0, InfmRef_Pt = 0, InTtitle_Pt < 0, Unpublished flag = NIL, PageRange: normally filled.
IF PublicType = "NA" (Not applicable, dummy titles etc.)
DbDetai_Pt = 0, PeDetai_Pt = 0, BkDetai_Pt = 0, InfmRef_Pt = 0, InTtitle_Pt = 0, Unpublished flag = 0, PageRange: empty.
Type: CHAR(2)
Value range: AP, BK, DB, IN, IR, NA
Data element: Reference Publication Year
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 4.3.
The year of publication as given by the publication itself.
Integrity: Must be a 4-digit number, maximum value is current year +1.
Type: INTEGER(4)
Data element: Publication Series Detail Identifier
Type: LONG
Data element: Reference Title
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 2.4 (in part).
Type: CHAR(160)
Data element: Reference Unpublished Flag
Type: LOGICAL Y/N
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Type Reference Identifier
Semantics: Internal system use only, invisible to the user.
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Type information
Type: CHAR(250)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Referenced Status and Taxon Circumscription Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Nomenclatural Status Designator Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Status Type Detail Identifier
Type: LONG
Data element: System - Oriented Status of Potential Taxon Record
Semantics: IOPI-GPC Data Definitions: Corresponds to data item 1.3 (in part).
Status attribute values have been defined according to how the system is to handle the record. Nomenclatural and taxonomic details are handled by the "Status Type Detail" attribute in the entity of the same name and by the entity "Nomeclatural Status".
Allowed values:
A = Name is an accepted taxon name.
V = Name is a either a variant of another name or a rejected name for which another name must be used (i.e., the correct name must be provided, but that name does not have to be a an accepted name).
U = Name does not refer to a taxon, or status reference does not provide a taxon link (i.e., name is neither "A" nor "V" nor "S" nor "L").
S = Name is not accepted according to the status reference (i.e., the provided single accepted name should be used instead of this name).
L = Same as "S", but "sensu lato", i.e. at least two accepted names have to be provided.
I = Identical concepts. Potential taxon has the same name and concept as another potential taxon (or the few characters given for the first one do not express another concept than that of the second potential taxon). Both circumscription references can be cited with the potential taxon.
Type: CHAR(1)
Default value: A
Value range: A, I, L, S, U, V
Data element: Status Tentative Flag
Semantics: IOPI-GPC Data Definitions: Includes dataitem 1.22, "Doubtful Synonym Flag".
Type: LOGICAL Y/N
Data element: Reference Title Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Reference Role of Author(s) Identifier
Type: LONG
Data element: Reference Role of Author(s)
Type: CHAR(30)
Value range: Compiler, Compiler, Ed., Ed., Editor, Editor, Editores, Editors, Eds., Herausgeber, Herausgeber, ed., editor, editores, editors, eds.
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: s.l. Synonym / Accepted Names Intersection Identifier
Type: LONG
Data element: Potential Taxon Name Identifier
Type: LONG
Data element: Referenced Status and Taxon Circumscription Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Publication Series Detail Identifier
Type: LONG
Data element: Publication Series Title Identifier
Type: LONG
Data element: Publication Series Detail
Semantics: Number or other designator referring to the series (not periodical) the publication belongs to.
Integrity: Field PublSer_Pt must be > 0
Input integrity: No input allowed while PublSer_Pt = 0 (i.e., series name must be chosen before detail).
Type: CHAR(100)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Publication Series Title Identifier
Type: LONG
Data element: Publication Series Editor
Data element: Publication Series Title
Semantics: N.B.: This is not the title of a periodical.
Type: CHAR(99)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Status Type Detail Identifier
Type: LONG
Data element: Status Type Detail Abbreviation
Type: CHAR(3)
Data element: Status Type Detail Description
Type: CHAR(25)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Taxonomic Coordination History Identifier
Type: LONG
Data element: Taxonomic Coordination Completion Date
Semantics: IOPI-GPC Data Definitions: Corresponds to dataitem 1.27.
Type: DATE
Data element: Taxonomic Coordination and Preference Priority
Data element: Reference Title Identifier
Type: LONG
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
Data element: Unnamed Taxon Identifier
Type: LONG
Data element: Undefined "Phrase" Part of Unnamed Taxon "Phrase" Name
Type: CHAR(79)
Data element: User Identifier
Type: LONG
Data element: Last Date of Write-Access to Record
Type: DATE
AltitudMin
FromDate
HigherA_Pt
ISOCCod_Pt
StAreaAbbr
StAreaName
StAreaRank
StVersion
UntilDate
UpdatBy_Pt
UpdateDate
Geographical area record
GeoArea_ID
IncAreaName
IncOccStat
POSSCod_Pt
StADrBy_Pt
StADrFlag
StArea_ID
StODrBy_Pt
StODrFlag
UpdatBy_Pt
UpdateDate
Geographical dataset
Dataset_ID
AreaStndrd
OccrStndrd
Source_Pt
UpdatBy_Pt
UpdateDate
Geographical record
GeogRec_ID
Dataset_Pt
GlobDis_Pt
IncName_Pt
IncRecStrg
PrimSrc_Pt
UpdatBy_Pt
UpdateDate
Global Distribution Summary
GlobDis_ID
GlContOcc
GlDDerFlag
GlDDrBy_Pt
GlDiOKFlag
GlIntDistr
GlNatDistr
InGlDisPhr
UpdatBy_Pt
UpdateDate
Homonym Assignment
HoAsgn_ID
HomType_Pt
Homonym_Pt
PotTaxn_Pt
UpdatBy_Pt
UpdateDate
Homonym Assignment Type
HomType_ID
HomonmType
UpdatBy_Pt
UpdateDate
Hybrid Formula
Hybform_ID
HybIsNm_Pt
Parent1_Pt
Parent2_Pt
UpdatBy_Pt
UpdateDate
Indirectly Linked Plant Information
ILnkInf_ID
Informal Reference
InfmRef_ID
AddDescr
InfRefDate
InfRefStor
InfRefType
UpdatBy_Pt
UpdateDate
Name Rank
Rank_ID
RankAbbrev
RankName
UpdatBy_Pt
UpdateDate
Nomenclatural Status Designator
NmclSta_ID
NmclStatus
UpdatBy_Pt
UpdateDate
Periodical Detail
PeDetai_ID
PeriNumber
PeriVolume
Periodi_Pt
UpdatBy_Pt
UpdateDate
Periodical Directory
Periodi_ID
Acceptd_Pt
ISSN
PAbbrTitle
PFullTitle
PSeries
Preceed_Pt
PubliTown
Publisher
Supersd_Pt
UpdatBy_Pt
UpdateDate
Person
Person_ID
Accept_Pt
FirstAPrfx
InitsAPrfx
LastNames
Title
UpdatBy_Pt
UpdateDate
Person - Institutional Affiliation History
PInstCu_ID
Instit_Pt
Person_Pt
TimePeriod
UpdatBy_Pt
UpdateDate
Person Team
PerTeam_ID
TeamDescrp
UpdatBy_Pt
UpdateDate
Person Team Membership List
PTMList_ID
PerTeam_Pt
Person_Pt
Seniority
UpdatBy_Pt
UpdateDate
Plant Name
FullNam_ID
BaExAut_Pt
BasiAut_Pt
CoExAut_Pt
CombRef_Pt
HomnymFlag
HybridQual
MisWrnFlag
NameElmnt
NameStruct
OblgTax_Pt
Rank_No
UpdatBy_Pt
UpdateDate
Plant Name Emendavit Reference
EmendCt_ID
EmRefer_Pt
EmTaxon_Pt
UpdatBy_Pt
UpdateDate
Plant Name Sanctioning Reference Intersection
SancRef_ID
BaScRef_Pt
CoScRef_Pt
SancNam_Pt
UpdatBy_Pt
UpdateDate
POSS Standard Plant Occurrence Status
POSSCod_ID
CultivStat
IntrodAgen
IntrodStat
NativeStat
Occurrenc
POSSVersn
UpdatBy_Pt
UpdateDate
Postal Address
Address_ID
Code
Country
Line1
Line2
Line3
Town
UpdatBy_Pt
UpdateDate
Potential Taxon Name
PotTax_ID
Basio_Pt
FullNam_Pt
SystSequNo
UpdatBy_Pt
UpdateDate
Reference Detail
RefDetl_ID
ItemDetail
PreciPgCit
Title_Pt
UpdatBy_Pt
UpdateDate
Reference Title
Title_ID
AutRole_Pt
AutTeam_Pt
BkDetai_Pt
DbDetai_Pt
InTitle_Pt
InfmRef_Pt
IsNotPaper
OrCitation
PageRange
PeDetai_Pt
PublicDate
PublicType
PublicYear
SerDetl_Pt
Title
UnpublFlag
UpdatBy_Pt
UpdateDate
Reference to type information
TypeRef_ID
PotTaxn_Pt
TypeInfo
UpdatBy_Pt
UpdateDate
Referenced Status Assignation
RefStat_ID
Accept_Pt
NmclSta_Pt
PotTaxn_Pt
StatDtl_Pt
SystStatus
TentatFlag
Title_Pt
UpdatBy_Pt
UpdateDate
Role of Author(s)
AutRole_ID
AuthorRole
UpdatBy_Pt
UpdateDate
s.l. Status / Accepted Names Association
SLSANIs_ID
PpAccNm_Pt
RefStat_Pt
UpdatBy_Pt
UpdateDate
Series Detail
SerDetl_ID
SerTitl_Pt
SeriesDt
UpdatBy_Pt
UpdateDate
Series Title
SerTitl_ID
SeriesEdtr
SeriesTitl
UpdatBy_Pt
UpdateDate
Status Type Detail
StatDtl_ID
StatDetAbb
StatDetDes
UpdatBy_Pt
UpdateDate
Taxonomic Co-ordination and Preference
TaxCoHi_ID
Completion
Priority
Title_Pt
UpdatBy_Pt
UpdateDate
Unnamed Taxon
UnnTaxn_ID
UndfNmPart
UpdatBy_Pt
UpdateDate