Vocabularies — details

DIC_DATETIME_RELPOS

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  28-JUL-03  13-FEB-04 
AFTER  after  after  28-JUL-03  13-FEB-04 
EQUALS  equals  equals  28-JUL-03  13-FEB-04 
we have not assigned a value yet (and it might not be applicable)  notEntered  04-JUN-07   
applicable, but try as we might, we cannot find a value  notAvailable  04-JUN-07   
not applicable  notApplicable  04-JUN-07