Vocabularies — details

DIC_XYSOURCE

Dictionary table constraining the values entered into the XYSOURCE (source of spatial coordinates) field in the new BGS.BOREHOLE table.

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

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
DIGITISED    02-FEB-98   
KEYBOARD    02-FEB-98   
MICROWRITER    02-FEB-98   
LARGE SCALE PLAN    02-FEB-98   
UNKNOWN    02-FEB-98   
NOT ENTERED    02-FEB-98