DIC_MGT
Dictionary table used to constrain the values entered into the DATA_MANAGEMENT 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 20 of 25)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| A |
LAND SURVEY (NORTH) PDA_BINDEX DATABASE |
|
C |
02-FEB-98 |
|
| B |
LAND SURVEY (SOUTH) PDB_BINDEX DATABASE |
|
C |
02-FEB-98 |
|
| C |
KEYWORTH NGDC_BORES DATABASE |
|
C |
02-FEB-98 |
|
| D |
DIGITISING TABLES |
|
C |
02-FEB-98 |
|
| E |
(E)X_FORM CODING FORM |
|
C |
02-FEB-98 |
|
| F |
NON-SPECIFIC FORM |
|
C |
02-FEB-98 |
|
| G |
GSM_REGISTER CODING FORM |
|
C |
02-FEB-98 |
|
| H |
MARINE GEOLOGY INDEX |
|
C |
02-FEB-98 |
|
| I |
INDEX CODING FORM |
|
C |
02-FEB-98 |
|
| L |
LEEDS PROJECT |
|
C |
02-FEB-98 |
|
| M |
NEWCASTLE BINDEX DATABASE |
|
C |
02-FEB-98 |
|
| N |
NEWCASTLE CODING FORM |
|
C |
02-FEB-98 |
|
| O |
OFFSHORE DATABASE |
|
C |
02-FEB-98 |
|
| P |
GEOPHYSICS DATA |
|
C |
02-FEB-98 |
|
| R |
REGISTER CODING FORM |
|
C |
02-FEB-98 |
|
| S |
POSITIONAL DATA ADJUSTED BECAUSE OF SPECIAL KNOWLEDGE OF SITE |
|
C |
02-FEB-98 |
|
| U |
NORTHERN IRELAND CODING FORM |
|
C |
02-FEB-98 |
|
| W |
WALLINGFORD WELL RECORD REGISTER |
|
C |
02-FEB-98 |
|
| X |
REFERENCE RECORD |
|
C |
02-FEB-98 |
|
| K |
UNKNOWN |
|
C |
02-FEB-98 |
05-JAN-98 |
