Vocabularies — details

DIC_WSTK

Dictionary containing information about water strikes in a borehole. Eg. artesian flow, perched water table.

No. Column name Data type Notes
1 CODE Varchar(2) Primary key
2 DESCRIPTION Varchar(68)  
3 TRANSLATION Varchar(50)  
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
NS  WATER NOT STRUCK    01-JAN-00   
UNKNOWN    01-JAN-00   
WA  WATER STRUCK:ARTESIAN FLOW    01-JAN-00   
WP  WATER STRUCK:PERCHED WATER TABLE    01-JAN-00  18-JUL-01 
WS  WATER STRUCK    01-JAN-00