DIC_DATE_STATUS
A dictionary of valid Date Statuses for beginning/ending of Dataset data capture
| No. |
Column name |
Data type |
Notes |
| 1 |
DATE_STATUS_CODE |
Varchar(2) |
Primary key
|
| 2 |
DATE_STATUS_DESC |
Varchar(20) |
|
| 3 |
START_DATE_ENTRY_FLAG |
Char(1) |
|
| 4 |
END_DATE_ENTRY_FLAG |
Char(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 7 of 7)
| DATE_STATUS_CODE |
DATE_STATUS_DESC |
START_DATE_ENTRY_FLAG |
END_DATE_ENTRY_FLAG |
DATE_ENTERED |
DATE_UPDATED |
| KN |
KNOWN |
Y |
Y |
21-JAN-99 |
02-JUL-99 |
| NA |
NOT APPLICABLE |
Y |
Y |
21-JAN-99 |
02-JUL-99 |
| NK |
NOT KNOWN |
Y |
Y |
21-JAN-99 |
02-JUL-99 |
| ON |
ONGOING |
N |
Y |
21-JAN-99 |
23-NOV-99 |
| CM |
COMPLETED |
N |
Y |
21-JAN-99 |
23-NOV-99 |
| CU |
CURRENT |
Y |
N |
21-SEP-99 |
|
| CD |
CONTINUOUSLY UPDATED |
N |
Y |
21-JAN-99 |
11-JUL-01 |
