Vocabularies — details

DIC_GEOCHRON

Dictionary 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 20 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  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
-  MARSHBROOKIAN  SUB-AGE  Marshbrookian Sub-age  453  454  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
?  BURRELLIAN  AGE  Burrellian Age  455  458  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
A1  LONGVILLIAN  SUB-AGE  Longvillian Sub-age  455  456  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
A3  SOUDLEYAN  SUB-AGE  Soudleyan Sub-age  456  457  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AA  HARNAGIAN  SUB-AGE  Harnagian Sub-age  457  458  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AB  COSTONIAN  SUB-AGE  Costonian Sub-age  458  459  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AC  VELFREYAN  SUB-AGE  Velfreyan Sub-age  459  460.9  INTERP  0  DEFINITE  1.6  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AD  LLANVIRN  EPOCH  Llanvirn Epoch  460.9  467  DEFINITE  1.6  INTERP  0  British regional epoch.  C  TMCM  22-SEP-09     
AE  LLANDEILIAN  AGE  Llandeilian Age  460.9  464  DEFINITE  1.6  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AH  ABEREIDDIAN  AGE  Abereiddian Age  464  467  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AI  ARENIG  EPOCH  Arenig Epoch  467  478.6  INTERP  0  DEFINITE  1.7  British regional epoch.  C  TMCM  22-SEP-09     
AL  FENNIAN  AGE  Fennian Age  467  471  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AM  WHITLANDIAN  AGE  Whitlandian Age  471  475  INTERP  0  INTERP  0  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AN  MORIDUNIAN  AGE  Moridunian Age  475  478.6  INTERP  0  DEFINITE  1.7  Not on 2009 BGS Geological Time Chart but retained for use.  C  TMCM  22-SEP-09     
AO  TREMADOC  EPOCH  Tremadoc Epoch  478.6  488.3  DEFINITE  1.7  DEFINITE  1.7  British regional epoch.  C  TMCM  22-SEP-09     
AP  CAMBRIAN  PERIOD  Cambrian Period  488.3  542  DEFINITE  1.7  DEFINITE  1    C  TMCM  22-SEP-09     
AQ  FURONGIAN  EPOCH  Furongian Epoch  488.3  501  DEFINITE  1.7  DEFINITE  2    C  TMCM  22-SEP-09     
AR  CAMBRIAN STAGE 10  AGE  Cambrian Stage 10  488.3  492  DEFINITE  1.7  APPROX  0    C  TMCM  22-SEP-09     
AS  CAMBRIAN STAGE 9  AGE  Cambrian Stage 9  492  496  APPROX  0  APPROX  0    C  TMCM  22-SEP-09