!Field EFFECTIVE is a field used in all [date sensitive|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]