CreateRates

The CreateRates business rule creates a rate group data table record and the rate data table records to go with it. Activity processing is expected to add rates by a “forward” processing activity. The CreateRates rule applies only to insurance rates, and not to interest rates.

The CreateRates rule must be attached to a Plan level transaction at either Primary or Subsidiary Company and be listed in the TransactionBusinessRulePacket of the transaction.

CreateRates Elements/Attributes
Element/Tag Attribute Definition Element/Attribute Value and Description

<CreateRates>

 

Opening and closing element of the rule.

 

<RateGroup>

 

Required:   

Designates a section in the rule that allows the creation of a new rate group data table record and a new set of rates.

 

<RateDescription>

 

Required:   

Identifies the rate group data table record to add by its description. This description must already exist.

Math variable or field containing a rate description.

<EffectiveDate>

 

Required:   

Provides the date for the EffectiveDate column of AsRateGroup .

Math variable or field containing a valid date value.

<ActiveFromDate>

 

Required:   

Provides the date for the ActiveFromDate column of AsRateGroup.

Math variable or field containing a valid date value.

<CreateRate>

 

Required, Repeatable:   

Designates a section of the rule that provides a specific set of criteria (if applicable for the rate group data table record) and the new rates to go with them.

 

<Criteria>

 

Optional:   

Designates a section to provide a specific set of criteria to go with a new set of rates.

 

<Criterion>

 

Required, Repeatable:   

Provides a criteria value and criteria column.

Math variable or field containing a text value.

NAME

Required:   

Provides the business name for a criteria column as defined in AsRateGroup.

Literal value, math variable or field containing a text value.

<RateCollection>

 

Required:   

Provides the new rates in a collection. The collection key correlates to an integer criteria value. The collection value is the new rate.

Math variable defined as a COLLECTION variable type.

XML Example

<CreateRates>
<RateGroup>
<RateDescription>SeriesFRatesMV</RateDescription>
<EffectiveDate>NewEffectiveDate</EffectiveDate>
<ActiveFromDate>NewEffectiveDate</ActiveFromDate>
<CreateRate>
<Criteria>
<Criterion NAME="Gender">GenderMaleMV</Criterion>
<Criterion NAME="UWClass">UWSelectMV</Criterion>
</Criteria>
<RateCollection>NewRatesMaleSelectCollection</RateCollection>
</CreateRate>
<CreateRate>
<Criteria>
<Criterion NAME="Gender">GenderMaleMV</Criterion>
<Criterion NAME="UWClass">UWStandardMV</Criterion>
</Criteria>
<RateCollection>NewRatesMaleStandardCollection</RateCollection>
</CreateRate>
<CreateRate>
<Criteria>
<Criterion NAME="Gender">GenderMaleMV</Criterion>
<Criterion NAME="UWClass">UWSmokerMV</Criterion>
</Criteria>
<RateCollection>NewRatesMaleSmokerCollection</RateCollection>
</CreateRate>
</RateGroup>
</CreateRates>

 

 

 

 

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