Vocabularies — details

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