Vocabularies — details

DIC_GEOCHRON

Table holding codes, names and radiometric ages of geochronological intervals that can be used in BGS databases. It is this table that acts as the domain constraint on corporate data tables.

No. Column name Data type Notes
1 CODE Varchar(10) Primary key
2 DESCRIPTION Varchar(10)  
3 RANK_CODE Varchar(10)  
4 TRANSLATION Varchar(10)  
5 MIN_AGE Varchar(10)  
6 MAX_AGE Varchar(10)  
7 MIN_AGE_TYPE_CODE Varchar(10)  
8 MIN_AGE_PLUS_OR_MINUS Varchar(10)  
9 MAX_AGE_TYPE_CODE Varchar(10)  
10 MAX_AGE_PLUS_OR_MINUS Varchar(10)  
11 COMMENTS Varchar(10)  
12 STATUS Varchar(10)  
13 USER_ENTERED Varchar(10)  
14 DATE_ENTERED Varchar(10)  
15 USER_UPDATED Varchar(10)  
16 DATE_UPDATED Varchar(10)  


Sample data (rows 1 to 10 of 410)

CODE DESCRIPTION RANK_CODE TRANSLATION MIN_AGE MAX_AGE MIN_AGE_TYPE_CODE MIN_AGE_PLUS_OR_MINUS MAX_AGE_TYPE_CODE MAX_AGE_PLUS_OR_MINUS COMMENTS STATUS USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED
CHENEYAN  AGE  Cheneyan Age  453  455  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
MARSHBROOKIAN  SUB-AGE  Marshbrookian Sub-age  453  454  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
BURRELLIAN  AGE  Burrellian Age  455  458  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
A1  LONGVILLIAN  SUB-AGE  Longvillian Sub-age  455  456  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
A3  SOUDLEYAN  SUB-AGE  Soudleyan Sub-age  456  457  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
AA  HARNAGIAN  SUB-AGE  Harnagian Sub-age  457  458  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
AB  COSTONIAN  SUB-AGE  Costonian Sub-age  458  459  INTERP  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
AC  VELFREYAN  SUB-AGE  Velfreyan Sub-age  459  460.9  INTERP  DEFINITE  1.6  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09     
AD  LLANVIRN  EPOCH  Llanvirn Epoch  460.9  467  DEFINITE  1.6  INTERP  British regional epoch.  TMCM  22-SEP-09     
AE  LLANDEILIAN  AGE  Llandeilian Age  460.9  464  DEFINITE  1.6  INTERP  Not on 2009 BGS Geological Time Chart but retained for use.  TMCM  22-SEP-09