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 |