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
N  NON-VALIDATED INPUT  FOR NON-VALIDATED ROCK NAME AND CODE  C  16-OCT-03   
B  FOR USE IN BOREHOLE CLASSIFICATION   FOR USE IN BOREHOLE CLASSIFICATION  C  08-JUN-01   
O  OBSOLETE ROCK NAME  OBSOLETE ROCK NAMES NOT RCS COMPLIANT  C  14-MAR-01  14-MAR-01 
C  CURRENT ROCK NAME  CURRENT ROCK CODE RCS COMPLIANT   C  09-DEC-96  14-MAR-01 
H  HIERARCHICAL ROCK NAME   ROCK NAME ONLY USED IN HIERARCHY  C  14-MAR-01  14-MAR-01