DIC_GEOCHRON_INTERIM
Dictionary table which is 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 20 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 |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| OF |
FENNIAN |
AGE |
Fennian |
470 |
475 |
DEFINITE |
0 |
INTERP |
0 |
C |
18-FEB-04 |
|
| OA |
ASHGILL |
EPOCH |
Ashgill |
443 |
449 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| PF |
UFIMIAN-KAZANIAN |
AGE |
Ufimian-Kazanian |
252.1 |
256 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
18-NOV-02 |
| NS |
SERRAVALLIAN |
AGE |
Serravallian |
11.2 |
14.8 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| NT |
TORTONIAN |
AGE |
Tortonian |
7.1 |
11.2 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| NZ |
ZANCLEAN |
AGE |
Zanclean |
3.6 |
5.3 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
18-NOV-02 |
| O |
ORDOVICIAN |
PERIOD |
Ordovician |
443 |
495 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| O1 |
TREMADOC |
EPOCH |
Tremadoc |
485 |
495 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| O3 |
LLANDEILIAN |
AGE |
Llandeilian |
458 |
464 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| O4 |
CARADOC |
EPOCH |
Caradoc |
449 |
458 |
DEFINITE |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| OB |
MORIDUNIAN |
AGE |
Moridunian |
480 |
485 |
INTERP |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| RZ |
PALAEOZOIC |
ERA |
Palaeozoic |
248.2 |
545 |
DEFINITE |
4.8 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| TA |
ANISIAN |
AGE |
Anisian |
234.3 |
241.7 |
DEFINITE |
4.6 |
DEFINITE |
4.7 |
C |
18-FEB-04 |
|
| TR |
RHAETIAN |
AGE |
Rhaetian |
205.7 |
209.6 |
DEFINITE |
4 |
DEFINITE |
4.1 |
C |
18-FEB-04 |
|
| J |
JURASSIC |
PERIOD |
Jurassic |
142 |
205.7 |
DEFINITE |
2.6 |
DEFINITE |
4 |
C |
18-FEB-04 |
|
| CA |
LANGSETTIAN (WESTPHALIAN A) |
AGE |
Langsettian (Westphalian A) |
313.5 |
316 |
INTERP |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| OP |
PUSGILLIAN |
AGE |
Pusgillian |
447.5 |
449 |
INTERP |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| AS |
SIDERIAN |
PERIOD |
Siderian |
2300 |
2500 |
APPROX |
0 |
DEFINITE |
0 |
C |
18-FEB-04 |
|
| QB |
BEESTONIAN |
STAGE |
Beestonian |
.5 |
1.15 |
QUAT |
0 |
QUAT |
0 |
C |
18-FEB-04 |
|
