DIC_CODE_STAT
Dictionary table containing dictionary code status descriptions, eg. Current.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE_STATUS |
Varchar(1) |
Primary key
|
| 2 |
CODE_STATUS_DESCRIPTION |
Varchar(78) |
|
| 3 |
TRANSLATION |
Varchar(78) |
|
| 4 |
STATUS |
Varchar(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 3 of 3)
| CODE_STATUS |
CODE_STATUS_DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| C |
THIS DICTIONARY CODE'S STATUS IS CURRENT |
CURRENT |
C |
23-MAR-93 |
|
| D |
THIS DICTIONARY CODE'S STATUS IS DEVELOPMENTAL |
DEVELOPMENT |
C |
23-MAR-93 |
|
| O |
THIS DICTIONARY CODE'S STATUS IS OBSOLETE |
OBSOLETE |
C |
23-MAR-93 |
|
