DIC_MAPPING_STAT
Dictionary table with codes for mapping status (stage in preparation), eg. pending. Used for DIGMAPGB Index.
| No. |
Column name |
Data type |
Notes |
| 1 |
LDOMAIN |
Numeric(22) |
Primary key
|
| 2 |
DOMAINVALUE |
Varchar(6) |
|
| 3 |
DOMAINDESC |
Varchar(78) |
|
| 4 |
TRANSLATION |
Varchar(78) |
|
| 5 |
CODE_STATUS |
Varchar(1) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 3 of 3)
| LDOMAIN |
DOMAINVALUE |
DOMAINDESC |
TRANSLATION |
CODE_STATUS |
DATE_ENTERED |
DATE_UPDATED |
| 1 |
C |
MAPPING STATUS IS CURRENT |
CURRENT |
C |
23-MAR-93 |
|
| 1 |
P |
MAPPING STATUS IS PENDING |
PENDING |
C |
23-MAR-93 |
|
| 1 |
D |
MAPPING STATUS IS DEVELOPMENTAL |
DEVELOPMENTAL |
C |
23-MAR-93 |
|
