You are here: Transaction Rules > Transaction Elements > EffectiveDate Element

Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01

# EffectiveDate Element

## Description

Every activity has an effective date associated with it, which is controlled by this element. It will be the first field displayed when an activity is added via the Activity screen. It is important for auditing and processing purposes to track when activities are processed. This element also controls the display and values of the Effective Date field in the transaction. This is a required element for all transactions.

## EffectiveDate Element/Attribute Table

Element/Tag | Definition | Attribute | Element/Attribute Value and Description
--- | --- | --- | ---
<EffectiveDate> | This is the start and end tag of the element. | STATUS | Enabled: Allows entry of the EffectiveDate field. Disabled: Restricts entry of the EffectiveDate field.
| TITLE | String: Display name of the EffectiveDate field.
TYPE | SYSTEM: Defaults the EffectiveDate to the current system date. USER SQL: Defaults the EffectiveDate with the result of a Query. Query is written within the value section of the tag.

## XML Example

    <EffectiveDate STATUS="Enabled" TYPE="SYSTEM"></EffectiveDate>

    <EffectiveDate STATUS="Disabled" TITLE="Effective Date" TYPE="SYSTEM"></EffectiveDate>

`<EffectiveDate STATUS="Enabled" TITLE="Composite/Effective Date" TYPE="SQL">SELECT DateValue FROM AsPolicyField WHERE FieldName=’PolicyEffectiveDate’ AND PolicyGUID=’[PolicyGUID].ActivityGMT DESC</EffectiveDate>`

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents