DIC_ROCK_HIERARCHYV3
Dictionary table which is part of version 3 of the BGS Rock Classification Scheme. This table contains codes for the types of hierarchy within the RCS.
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(4) |
Primary key
|
2 |
DESCRIPTION |
Varchar(80) |
|
3 |
STATUS |
Char(1) |
|
4 |
TRANSLATION |
Varchar(80) |
|
5 |
DATE_ENTERED |
Date |
|
6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 5 of 5)
CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
DATE_ENTERED |
DATE_UPDATED |
TAS |
TOTAL ALKALIS VERSUS SILICA CLASSIFICATION |
C |
|
09-DEC-96 |
09-MAR-00 |
MAIN |
MAIN HIERARCHY |
C |
|
13-DEC-96 |
09-MAR-00 |
UDCS |
UNCONSOLIDATED DEPOSITS CLASSIFICATION SCHEME |
C |
|
09-JAN-02 |
|
NVI |
NON-VALIDATED INPUT |
C |
|
31-JUL-02 |
25-JUN-03 |
CPST |
Composite Code (used where child=composite and parent=non-composite) |
C |
Composite Code |
08-APR-08 |
|