Vocabularies — details

DIC_SOIL_CODE

Dictionary of soil codes

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


Sample data (rows 1 to 3 of 3)

CODE DESCRIPTION STATUS TRANSLATION DATE_ENTERED DATE_UPDATED
Not applicable  NOT APPLICABLE  26-NOV-03   
Applicable, but try as we might, we cannot find a value  NOT AVAILABLE  26-NOV-03   
We have not assigned a value yet (and it might not be applicable)  NOT ENTERED  26-NOV-03