DIC_DATE_ACCURACY
A dictionary of valid Date Accuracies used to describe Dataset start/end dates of capture (see DIC_DATE_STATUS)
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(2) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(20) |
|
| 3 |
DATE_ENTERED |
Date |
|
| 4 |
DATE_UPDATED |
Date |
|
| 5 |
TRANSLATION |
Varchar(50) |
|
Sample data (rows 1 to 12 of 12)
| CODE |
DESCRIPTION |
DATE_ENTERED |
DATE_UPDATED |
TRANSLATION |
| CN |
CENTURY |
22-FEB-99 |
04-JUN-07 |
century |
| DA |
DAY |
21-JAN-99 |
04-JUN-07 |
day |
| DE |
DECADE |
21-JAN-99 |
04-JUN-07 |
decade |
| - |
NOT APPLICABLE |
21-JAN-02 |
04-JUN-07 |
not applicable |
| ! |
NOT AVAILABLE |
21-JAN-02 |
04-JUN-07 |
not available |
| ? |
NOT ENTERED |
21-JAN-02 |
04-JUN-07 |
not entered |
| YR |
YEAR |
21-JAN-99 |
04-JUN-07 |
year |
| MT |
MONTH |
02-DEC-99 |
04-JUN-07 |
month |
| HR |
HOUR |
04-JUN-07 |
|
hour |
| MN |
MINUTE |
04-JUN-07 |
|
minute |
| SC |
SECOND |
04-JUN-07 |
|
second |
| MS |
MILLISECOND |
04-JUN-07 |
|
millisecond |
