EffectiveDate Element

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 Elements/Attributes
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.   

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> 


 

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us