Vocabularies — details

DIC_EDAT

Dictionary table constraining the values entered into the DATE_KNOWN_TYPE 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 7 of 7)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
PRE    02-FEB-98   
CIRCA    02-FEB-98   
REPORT OR RECORD    02-FEB-98  05-NOV-97 
UNKNOWN    02-FEB-98  05-JAN-98 
NOT ENTERED    02-FEB-98   
RECEIVED BY BGS    02-FEB-98   
DRILLED DATE    02-FEB-98   
OpenGeoscience
Maps and viewers
Apps
Data collections
Data downloads
Scans and photos
Web services