Vocabularies — details

DIC_GEOCHRON_INTERIM

An "interim" version of DIC_GEOCHRON. This table holds all the entries in DIC_GEOCHRON plus some deprecated entries (old codes that should no longer be used). This is so that data tables that still use deprecated codes will continue to function. This is the table that data tables still using deprecated geochronological codes should reference. Table structure the same as DIC_GEOCHRON.

No. Column name Data type Notes
1 DOMAINVALUE Varchar(2) Primary key
2 DOMAINDESC Varchar(50)  
3 RANK Varchar(15)  
4 TRANSLATION Varchar(50)  
5 MIN_AGE Numeric(22)  
6 MAX_AGE Numeric(22)  
7 MIN_AGE_TYPE_CODE Varchar(10)  
8 MIN_AGE_PLUS_OR_MINUS Numeric(22)  
9 MAX_AGE_TYPE_CODE Varchar(10)  
10 MAX_AGE_PLUS_OR_MINUS Numeric(22)  
11 STATUS Char(1)  
12 DATE_ENTERED Date  
13 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 227)

DOMAINVALUE DOMAINDESC RANK TRANSLATION MIN_AGE MAX_AGE MIN_AGE_TYPE_CODE MIN_AGE_PLUS_OR_MINUS MAX_AGE_TYPE_CODE MAX_AGE_PLUS_OR_MINUS STATUS DATE_ENTERED DATE_UPDATED
OE  LLANVIRN  EPOCH  Llanvirn  458  470  DEFINITE  DEFINITE  18-FEB-04   
OF  FENNIAN  AGE  Fennian  470  475  DEFINITE  INTERP  18-FEB-04   
OA  ASHGILL  EPOCH  Ashgill  443  449  DEFINITE  DEFINITE  18-FEB-04   
PF  UFIMIAN-KAZANIAN  AGE  Ufimian-Kazanian  252.1  256  DEFINITE  DEFINITE  18-FEB-04  18-NOV-02 
NS  SERRAVALLIAN  AGE  Serravallian  11.2  14.8  DEFINITE  DEFINITE  18-FEB-04   
NT  TORTONIAN  AGE  Tortonian  7.1  11.2  DEFINITE  DEFINITE  18-FEB-04   
NZ  ZANCLEAN  AGE  Zanclean  3.6  5.3  DEFINITE  DEFINITE  18-FEB-04  18-NOV-02 
ORDOVICIAN  PERIOD  Ordovician  443  495  DEFINITE  DEFINITE  18-FEB-04   
O1  TREMADOC  EPOCH  Tremadoc  485  495  DEFINITE  DEFINITE  18-FEB-04   
O3  LLANDEILIAN  AGE  Llandeilian  458  464  DEFINITE  DEFINITE  18-FEB-04