Vocabularies — details

DIC_ROCK_HIERARCHY

A Dictionary of Hierarchical codes for use within the Rock Classification Scheme

No. Column name Data type Notes
1 CODE Varchar(4) Primary key
2 DESCRIPTION Varchar(80)  
3 TRANSLATION Varchar(80)  
4 STATUS Char(1)  
5 DATE_ENTERED Date  
6 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 22)

CODE DESCRIPTION TRANSLATION STATUS 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 
NB  NEIGHBOUR (OBSOLETE)    O  06-FEB-97  17-JUN-04 
ART  ARTIFICIAL DEPOSITS (OBSOLETE)    O  05-MAR-98  17-JUN-04 
BRO  BROKEN-ROCKS (OBSOLETE)    O  05-MAR-98  17-JUN-04 
HTM  HYDROTHERMAL ROCKS (OBSOLETE)    O  05-MAR-98  17-JUN-04 
MIG  META-IGNEOUS ROCKS (OBSOLETE)    O  05-MAR-98  17-JUN-04 
MIM  META-IGNEOUS-ROCK BASED ON MODAL COMPOSITION) (OBSOLETE)    O  05-MAR-98  17-JUN-04 
MST  META-SEDIMENTARY ROCK BASED ON TEXTURAL ATTRIBUTES (OBSOLETE)    O  09-MAR-00  17-JUN-04 
MSM  META-SEDIMENTARY ROCK BASED ON MODAL COMPOSITION (OBSOLETE)    O  09-MAR-00  17-JUN-04