ScheduledValuation

This business rule allows the transaction to which it is attached to execute valuation for all Plan level policies returned by a query contained within the rule without adding policy financial activities to those policies. The rule also includes “switches” to include the PolicyValues business rule during the valuation process, write deposit information and what “left-over” processes from prior attempts may be deleted.

[PlanGUID] and [CompanyGUID] are not available to the syntax of the ScheduledValuation Query element.

ScheduledValuation Elements/Attributes
Element Description Attribute Element/Attribute Value and Description

<ScheduledValuation>

The opening and closing tags of the business rule.

   

<Query>

Required :

Defines a SQL that returns zero or more policy GUIDs. Each policy GUID identifies a policy where valuation will be executed.

 

A valid SQL statement returning policy GUIDs.

<Computation>

Defines the type of computation to perform depending on the results of the Query element above. Used only when alternate valuation calculations are to be used.

RULENAME

Required. Specifies the computation rule to execute for each entity in the Query element.

Policy or Segment literal value

<PolicyValues>

Required :

This element indicates if the PolicyValues business rule will execute during the valuation process on each policy. The PolicyValues business rule for the plan under which this transaction is defined would be executed.

 

Yes: PolicyValues will be executed.

No: PolicyValues will not be executed.

    VALUEFINANCIALENTRY

Optional: 'Yes' or 'No', or a Field with a value of 'Yes' or 'No'.

Yes: Financial entry calculations and math will need to be executed in PolicyValues BR. IsValueFinancialEntry context value will be assigned a values Yes.

No: No financial entry calculation in PolicyValues IsValueFinancialEntry will have value No.

Default Value ="No"

<WriteDeposits>

Required :

This element indicates if deposit records are written to the AsScheduledValuationDeposit table.

 

Yes: (Default) Deposit records will be written.

No: Deposit records will not be written.

<WriteChild>

This element that indicates if child deposit records are written to the AsScheduledValuationDeposit Table. By default, this value is set to "No".

  Yes:- Indicates that Child Fund deposit records should be written to Scheduled Valuation.

No: - Indicates that Child Fund deposit records are not written to Scheduled Valuation.

<Deletes>

The opening and closing tags for the section. This section defines what entries are deleted out of the AsValuesRequest table before processing starts.

   

<Delete>

This element defines the records of AsValueRequest table that are deleted based on their status.

 

Reference to a MathVariable that contains a valid status code for an AsValuesRequest record.

XML Example

For Scheduled Valuation:

<ScheduledValuation>
<Query>SELECT AsPolicy.PolicyGUID FROM AsPolicy WHERE AsPolicy.StatusCode IN ('01','39','49','57','59')          
       AND AsPolicy.PolicyGUID NOT IN(SELECT PolicyGUID FROM AsValuesRequest WHERE AsValuesRequest.ActivityGUID = '[ThisActivityGUID]' AND AsValuesRequest.StatusCode = '01')
</Query>
<PolicyValues>Yes</PolicyValues>
<WriteDeposits>MathVariable</WriteDeposits>
<WriteChild>Yes</WriteChild> 
<Deletes>
<Delete>Pending</Delete>
<Delete>SystemError</Delete>
<Delete>Processing</Delete>
</Deletes>
<Query>SQL Query</Query>
<PolicyValues VALUEFINANCIALENTRY="Yes|No" OR Fieldname or MV with Yes|No>Yes|No</PolicyValues>
<ScheduledValuation>
 

For Scheduled Computation:

<ScheduledValuation>
<Query>SELECT AsPolicy.PolicyGUID FROM AsPolicy WHERE AsPolicy.StatusCode IN ('01','08','49','57','59') AND AsPolicy.PlanGUID = 'C5EE0DA4-3003-42C1-9468-D91DA546B79F'</Query>
<Computation RULENAME=”MyComputationRule”>Policy</Computation>
</ScheduledValuation>
 

 

 

 

 

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