DIC_FORMAL_CODE
Dictionary table with codes and descriptions for some types of entry into tables.
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(2) |
Primary key
|
2 |
DATA |
Varchar(20) |
|
3 |
DATE_ENTERED |
Date |
|
4 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 19 of 19)
CODE |
DATA |
DATE_ENTERED |
DATE_UPDATED |
F |
FORMAL ENTRY |
31-MAR-92 |
22-SEP-92 |
I |
INFORMAL ENTRY |
31-MAR-92 |
22-SEP-92 |
P |
PARTIAL ENTRY |
22-SEP-92 |
27-APR-93 |
C |
CODE ONLY |
18-DEC-92 |
|
DS |
BGS.DIC_STRAT ENTRY |
31-MAR-92 |
|
OC |
OBSOLETE CODE |
11-NOV-93 |
|
ON |
OBSOLETE NAME & CODE |
11-NOV-93 |
|
R |
RESERVED ENTRY |
20-MAY-93 |
|
U |
UNVERIFIED ENTRY |
27-APR-93 |
|
PR |
PROV SHEET ENTRY |
03-MAY-96 |
|
NU |
NOT USED BY BGS |
17-OCT-96 |
|
FL |
FORMAL, LOCAL |
17-OCT-96 |
|
FN |
FORMAL, NATIONAL |
17-OCT-96 |
|
FW |
FORMAL, WIDER |
17-OCT-96 |
|
IL |
INFORMAL, LOCAL |
17-OCT-96 |
|
IN |
INFORMAL, NATIONAL |
17-OCT-96 |
|
IW |
INFORMAL, WIDER |
17-OCT-96 |
|
CP |
CODED BUT UNDEFINED |
08-JUL-98 |
|
DM |
DIGITALMAP COMPOSITE |
16-AUG-99 |
|