!Field
EFFECTIVE is a field used in all [date sensitive] tables to indicate the date that the data contained within the record becomes effective.  

!Domain
EFFECTIVE is also an [application domain|DOMAIN] that imparts the following characteristics:
* Oracle data type is [DATE]