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.

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

ScheduledValuation: Elements and Attributes
Element Attributes Parent Element Description Element/Attribute Values

<ScheduledValuation>

    

The opening and closing tags of the business rule.

  

<Query>

   <ScheduledValuation>

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.

Policy or Segment literal value
RULENAME  

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

  

<PolicyValues>

   <ScheduledValuation>

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>

   <ScheduledValuation>

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>

   <ScheduledValuation>

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>

   <ScheduledValuation>

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

  

<Delete>

   <Deletes>

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.

Important Definitions

FUND UNITS

Number of valuation units in the fund as of the valuation date

FUND CASH VALUE

Cash value of the fund as of the valuation date. For unit-priced funds, this is generally valuation units x unit price.

FUND PRINCIPAL

Remaining principal value of the fund as of the valuation date, after applicable deposits, removals, and valuation adjustments.

FUND MVA AMOUNT

Fund-level market value adjustment amount calculated from the fund’s MVAAmountFormula rule.

REDEMPTION AMOUNT

Redemption amount calculated from the plan’s RedemptionAmountFormula rule for applicable funds/deposits.

SHORT TERM REDEMPTION UNITS

Short-term redemption units calculated from the plan’s RedemptionAmountFormula rule for applicable funds/deposits.

CURRENCY CODE

Currency code associated with the scheduled fund valuation 

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>