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 |
|
