Vocabularies — details

DIC_RCS_STATUS

Dictionary table used to validate field RCS_STATUS in the table Dic_Rock_NameV3. This validation was previously controlled by a check constraint. This now removed.

No. Column name Data type Notes
1 CODE Char(1) Primary key
2 DATA Varchar(40)  
3 DATE_ENTERED Date  
4 DATE_UPDATED Date  


Sample data (rows 1 to 5 of 5)

CODE DATA DATE_ENTERED DATE_UPDATED
CURRENT  16-OCT-03  16-OCT-03 
OBSOLETE  16-OCT-03   
HIERARCHY  16-OCT-03   
NON_VALIDATED ENTRY  16-OCT-03   
NON_COMPLIANT QUALIFIER  20-JUN-06