Vocabularies — details

DIC_ROCK_NAME_TYPE

A dictionary of acceptable Rock Classification Scheme code types

No. Column name Data type Notes
1 CODE Varchar(1) 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 5 of 5)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
NON-VALIDATED INPUT  FOR NON-VALIDATED ROCK NAME AND CODE  16-OCT-03   
FOR USE IN BOREHOLE CLASSIFICATION   FOR USE IN BOREHOLE CLASSIFICATION  08-JUN-01   
OBSOLETE ROCK NAME  OBSOLETE ROCK NAMES NOT RCS COMPLIANT  14-MAR-01  14-MAR-01 
CURRENT ROCK NAME  CURRENT ROCK CODE RCS COMPLIANT   09-DEC-96  14-MAR-01 
HIERARCHICAL ROCK NAME   ROCK NAME ONLY USED IN HIERARCHY  14-MAR-01  14-MAR-01