ShadowPendingActivities
This business rule is used to delete an activity from the Activity screen when the specified condition is satisfied. More than one activity can be deleted, but the activity must be in pending status. The activity will appear shadowed once processed. OIPA will give an error if the user tries to delete an activity that is not in pending status.
Element/Tag | Definition | Attribute | Element/Attribute Value and Description |
---|---|---|---|
<ShadowPendingActivities> |
The opening and closing tag for each ShadowPendingActivity element when more than one exists. |
||
<ShadowPendingActivity> |
Repeatable element. This element is used only when there is a requirement to delete more than one activity. In such cases, each activity should be defined within its own individual <ShadowPendingActivity> element. |
||
<Tests> |
Allows configuration of test(s) to see if the section of rule should be invoked. In this business rule, a condition is defined to determine whether an activity should be deleted. |
Note: when multiple <Test> elements are configured, it is expected that all Test elements resolve to TRUE for the overall <Tests> to be considered TRUE (logical AND operation) and the other parts of the configuration in relation to <Tests> element is executed | |
<Test> |
This element is used to specify the condition. If this condition is satisfied, the specified activity will be deleted from the policy. |
Expression: Specify a condition. |
|
TYPE |
Expression: Indicate the type of condition. Expression is the only literal value used for this attribute. |
||
<Activities> |
This is the opening tag for the activities that should be shadowed in the Activity screen. |
||
<Activity> |
Repeatable element. |
SQL: SQL statement to determine the activity that needs to be deleted. |
XML Example
<ShadowPendingActivities> <ShadowPendingActivity>
<Tests>
<Test TYPE="Expression">BillExists > 0 AND BillAmount = 0</Test>
</Tests>
<Activities>
<Activity>
<SqlServer>SELECT TOP 1 AsActivity.ActivityGUID, AsActivity.StatusCode, AsActivity.ClientNumber FROM AsActivity JOIN AsTransaction ON AsTransaction.TransactionGUID = AsActivity.TransactionGUID WHERE PolicyGUID='[Policy:PolicyGUID]' AND TransactionName IN ('Billing','BillingStart') AND AsActivity.TypeCode IN ('01','04') AND AsActivity.StatusCode IN ('01','14', '02') AND AsActivity.EffectiveDate >= '[Activity:EffectiveDate]' ORDER BY AsActivity.EffectiveDate ASC</SqlServer>
<Oracle>SELECT AsActivity.ActivityGUID, AsActivity.StatusCode, AsActivity.ClientNumber FROM AsActivity JOIN AsTransaction ON AsTransaction.TransactionGUID = AsActivity.TransactionGUID WHERE ROWNUM = 1 AND PolicyGUID='[Policy:PolicyGUID]' AND TransactionName IN ('Billing','BillingStart') AND AsActivity.TypeCode IN ('01','04') AND AsActivity.StatusCode IN ('01','14', '02') AND AsActivity.EffectiveDate >= '[Activity:EffectiveDate]' ORDER BY AsActivity.EffectiveDate ASC</Oracle>
<DB2>SELECT AsActivity.ActivityGUID, AsActivity.StatusCode, AsActivity.ClientNumber FROM AsActivity JOIN AsTransaction ON AsTransaction.TransactionGUID = AsActivity.TransactionGUID WHERE PolicyGUID = '[Policy:PolicyGUID]' AND TransactionName IN ('Billing','BillingStart') AND AsActivity.TypeCode IN ( '01' , '04' ) AND AsActivity.StatusCode IN ( '01' , '14' , '02' ) AND AsActivity.EffectiveDate >= '[Activity:EffectiveDate]' ORDER BY AsActivity.EffectiveDate ASC FETCH FIRST 1 ROWS ONLY</DB2>
</Activity>
</Activities>
</ShadowPendingActivity>
</ShadowPendingActivities>
XML Schema
<ShadowPendingActivities>
<ShadowPendingActivity>
<Tests>
<Test></Test>
</Tests>
<Activities>
<Activity></Activity>
</Activities>
</ShadowPendingActivity>
</ShadowPendingActivities>