DIC_DATETIME_RELPOS
Dictionary table of date comparison operators - before, after, equals.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(500) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
STATUS |
Char(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 6 of 6)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| BEFORE |
before |
before |
C |
28-JUL-03 |
13-FEB-04 |
| AFTER |
after |
after |
C |
28-JUL-03 |
13-FEB-04 |
| EQUALS |
equals |
equals |
C |
28-JUL-03 |
13-FEB-04 |
| ? |
we have not assigned a value yet (and it might not be applicable) |
notEntered |
C |
04-JUN-07 |
|
| ! |
applicable, but try as we might, we cannot find a value |
notAvailable |
C |
04-JUN-07 |
|
| - |
not applicable |
notApplicable |
C |
04-JUN-07 |
|
