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 |
| P |
PRE |
|
C |
02-FEB-98 |
|
| C |
CIRCA |
|
C |
02-FEB-98 |
|
| R |
REPORT OR RECORD |
|
C |
02-FEB-98 |
05-NOV-97 |
| U |
UNKNOWN |
|
C |
02-FEB-98 |
05-JAN-98 |
| . |
NOT ENTERED |
|
C |
02-FEB-98 |
|
| B |
RECEIVED BY BGS |
|
C |
02-FEB-98 |
|
| D |
DRILLED DATE |
|
C |
02-FEB-98 |
|
