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 20 of 22)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
TAS  TOTAL ALKALIS VERSUS SILICA CLASSIFICATION    09-DEC-96  09-MAR-00 
MAIN  MAIN HIERARCHY    13-DEC-96  09-MAR-00 
NB  NEIGHBOUR (OBSOLETE)    06-FEB-97  17-JUN-04 
ART  ARTIFICIAL DEPOSITS (OBSOLETE)    05-MAR-98  17-JUN-04 
BRO  BROKEN-ROCKS (OBSOLETE)    05-MAR-98  17-JUN-04 
HTM  HYDROTHERMAL ROCKS (OBSOLETE)    05-MAR-98  17-JUN-04 
MIG  META-IGNEOUS ROCKS (OBSOLETE)    05-MAR-98  17-JUN-04 
MIM  META-IGNEOUS-ROCK BASED ON MODAL COMPOSITION) (OBSOLETE)    05-MAR-98  17-JUN-04 
MST  META-SEDIMENTARY ROCK BASED ON TEXTURAL ATTRIBUTES (OBSOLETE)    09-MAR-00  17-JUN-04 
MSM  META-SEDIMENTARY ROCK BASED ON MODAL COMPOSITION (OBSOLETE)    09-MAR-00  17-JUN-04 
MIT  META-IGNEOUS-ROCK BASED ON TEXTURAL ATTRIBUTES (OBSOLETE)    05-MAR-98  17-JUN-04 
MSO  METASOMATIC-ROCK (OBSOLETE)    05-MAR-98  17-JUN-04 
NAT  NATURAL SUPERFICIAL DEPOSITS (OBSOLETE)    05-MAR-98  17-JUN-04 
UDCS  UNCONSOLIDATED DEPOSITS CLASSIFICATION SCHEME    20-DEC-01  17-JUN-04 
UPF  METAMORPHIC-ROCKS, UNKNOWN PROTOLITH (OBSOLETE)    05-MAR-98  17-JUN-04 
MSR  METAMORPHIC SEDIMENTARY ROCKS (OBSOLETE)    23-MAR-98  17-JUN-04 
MNCR  METAMORPHIC NORMAL CRYSTALLINE ROCKS (OBSOLETE)    07-APR-98  17-JUN-04 
MECR  METAMORPHIC EXOTIC CRYSTALLINE ROCKS (OBSOLETE)    07-APR-98  17-JUN-04 
MVOL  METAVOLCANICLASTIC ROCKS (OBSOLETE)    07-APR-98  17-JUN-04 
UPT  METAMORPHIC ROCKS, UNKNOWN PROTOLITH BASED ON TEXTURAL COMPOSITION (OBSOLETE)    09-MAR-00  17-JUN-04