Database structure

Field Name Field Type
Field

 

width
Field explanation
Museum information:    
PMO_NR Character
7
Museum number
SUBNO Character
3
Museum sub-number
DEPOT Character
15
Specimen location
Taxonomic information:    
KLASSE Character
4
Fossil group (normalized abbreviation)
TAX_NR Numeric
5
Fossil group (normalized numeric code)
GENUS Character
35
Genus
SUB_GEN Character
35
Sub genus
CF_AFF Character
10
"cf., aff., or sp."
SPECIES Character
35
Species
SUB_SPEC Character
35
Sub species
OD Character
25
Species author (original designator)
Geographic information:    
COUNTRY Character
3
Country (normalized abbreviation)
LOK1 Character
20
Locality (general)
LOKALITET Memo
10
Locality (details)
KOMM_NR Numeric
4
Municipality (Norwegian specimens only)
UTM Character
12
Grid reference
BLAD Character
8
Map sheet (Norwegian specimens only)
GRAD_EAST Numeric
5
Grid reference (degrees east)
GRAD_NORTH Numeric
5
Grid reference (degrees north)
Stratigraphic information:    
STRAT_CODE Numeric
4
Stratigraphy (normalized numeric code)
PERIOD Character
3
Period (age) (normalized abbreviation)
EPOCH Character
3
Epoch (age) (normalized abbreviation)
STAGE Character
3
Stage (age) (normalized abbreviation)
LOK_STRAT Character
35
Local stratigraphy (if no LITH_CODE is available)
LITH_CODE Numeric
4
Lithostratigraphy (normalized numeric code)
GROUP Character
3
Lithostratigraphy (group) (normalized abbreviation)
FORMATION Character
3
Lithostratigraphy (formation) (normalized abbreviation)
MEMBER Character
3
Lithostratigraphy (member) (normalized abbreviation)
BED Character
3
Lithostratigraphy (bed) (normalized abbreviation)
LEVEL Numeric
8
Level in sampled section
BIO_CODE Numeric
4
Biostratigraphy (normalized numeric code)
Miscellaneous information:    
FINNER Character
50
Collector and date
DIVERSE Memo
10
Remarks
LOG_DATE Date
8
Date of database entry
LOG_NAME Character
3
Name (initials) of registrator

 

Publisert 6. mars 2022 13:53