Account and Price Item Derivation (for the Retention Type Claim Based Pricing Rule Type Category)
Once the Validate Transaction and Derive Price Item (C1-TXNIP) batch calls the primary pricing rule type specified in the transaction record type, it calls the related pricing rule types (if any) defined in the primary pricing rule type. Note that the related pricing rule types are called one by one in the specified sequence. Let us understand this with the help of an example.
Primary Pricing Rule Type | Sequence | Related Pricing Rule Type |
---|---|---|
CLAIM | 10 | RETENTION TYPE CLAIM BASED |
20 | SPECIFIC STOP-LOSS | |
30 | AGGREGATE STOP-LOSS |
Example 1: Related Pricing Rule Type Sequence
In the example 1, the system first calls the related pricing rule type with the highest sequence (i.e. 10) once the CLAIM pricing rule type is called. The system calls the related pricing rule type irrespective of whether the transaction legs are derived using the primary pricing rule type. Once the RETENTION TYPE CLAIM BASED pricing rule type is called, the system calls the related pricing rule type with the next sequence (i.e. 20). This process continues until all related pricing rule types defined in the primary pricing rule type are called one by one in the specified sequence.
If the eligibility rule type is defined for a related pricing rule type, the system considers the related pricing rule type for deriving the transaction legs when the eligibility rule is satisfied. If the eligibility rule is not satisfied, the system does not consider the related pricing rule type for deriving the transaction legs. Let us understand this with the help of an example.
Primary Pricing Rule Type | Sequence | Related Pricing Rule Type | Eligibility Criteria Met |
---|---|---|---|
CLAIM | 10 | RETENTION TYPE CLAIM BASED | Yes |
20 | CLAIM BASED FEES | - | |
30 | CLAIM FEE CHARGES | No |
Example 2: Related Pricing Rule Type Eligibility Criteria
In the example 2, the eligibility criteria is defined for the RETENTION TYPE CLAIM BASED and CLAIM FEE CHARGES pricing rule types. However, the eligibility criteria for the CLAIM FEE CHARGES pricing rule type was not satisfied, and therefore it is not used for deriving the transaction legs.
The Validate Transaction and Derive Price Item (C1-TXNIP) batch maps a claim transaction to one or more price item and price item parameters which are defined in the eligible related pricing rule type. This is possible when you attach an algorithm created using the C1_ACCPRIDRV algorithm type to the Account and Price Item Derivation system event of the related pricing rule type.
This algorithm fetches the effective pricing rule for each price item and price item parameters combination specified in the related pricing rule type on the derivation date. The system considers the paid date as the derivation date. This algorithm first searches for the effective pricing rule for a price item and price item parameters combination which is defined for the policy at the bill group level. If the system does not find any effective pricing rule for a price item and price item parameters combination which is defined for the policy at the bill group level, it inherits the effective pricing rule for a price item and price item parameters combination from the parent customer level.
For example, if the system receives a claim transaction with the following details:
-
UDF_DATE_1 is set to 15-01-2018
-
Transaction Record Type is set to TR1
Transaction Record Type | Primary Pricing Rule Type | Related Pricing Rule Type | Price Item in Related Pricing Rule Type | Pricing Rule | Pricing Start Date | Pricing End Date | Assignment Level |
---|---|---|---|---|---|---|---|
TR1 | CLAIM | RETENTION TYPE CLAIM BASED | P3 | C1P3 | 01-01-2018 | 31-12-2018 | Parent Customer |
C2P3 | 01-01-2018 | 31-12-2018 | Bill Group | ||||
P4 | C1P4 | 01-01-2018 | 31-12-2018 | Parent Customer | |||
C2P4 | 01-01-2019 | 30-06-2019 | Bill Group |
Example 3: Effective Pricing Rule Derivation
In the example 3, the system fetches C2P3 and C1P4 pricing rules for P3 and P4 respectively, which are effective on the paid date. Note that the effective pricing rule for P3 is derived at the bill group level, whereas the effective pricing rule for P4 is derived from the parent customer level.
While fetching the effective pricing rule, the system first searches for the exact match for the price item parameters at both the levels. For example, if the system receives a claim transaction with the following details:
-
UDF_CHAR_1 is set to Western
-
UDF_CHAR_2 is set to Active
-
UDF_DATE_1 is set to 20-03-2018
-
Transaction Record Type is set to TR4
Transaction Record Type | Primary Pricing Rule Type | Related Pricing Rule Type | Price Item in Related Pricing Rule Type | Price Item Parameters in Related Pricing Rule Type | Pricing Rule | Pricing Start Date | Pricing End Date | Price Item Parameters in Pricing Rule | Fees | Assignment Level |
---|---|---|---|---|---|---|---|---|---|---|
TR4 | CLAIM | CLAIM BASED CHARGES | P1 | Location = UDF_CHAR_1 and Employee Status = UDF_CHAR_2 | C1P1 | 01-01-2018 | 31-12-2018 | Location = Western and Employee Status = Active | $10 | Parent Customer |
Location = Eastern and Employee Status = Active | $12 | |||||||||
Location = Eastern and Employee Status = Retired | $11 | |||||||||
Location = Western and Employee Status = Retired | $9 | |||||||||
C2P1 | 01-01-2018 | 31-12-2018 | Location = Western and Employee Status = Active | $8 | Bill Group | |||||
Location = Eastern and Employee Status = Active | $9 | |||||||||
Location = Eastern and Employee Status = Retired | $10 | |||||||||
Location = Western and Employee Status = Retired | $9 |
Example 4: Exact Match for Price Item Parameters
In the example 4, the system fetches the C2P1 pricing rule for P1 because of the following reasons:
-
The paid date (i.e. 20-03-2018) of the claim transaction falls within the date range (i.e. 01-01-2018 to 31-12-2018) of the C2P1 pricing rule which is defined at the bill group level.
-
It contains the exact match for the price item parameters which are received in the transaction.
If the system cannot find the exact match for the price item parameters at both the levels, it searches for the best fit match for the price item parameters first at the bill group level and then at the parent customer level. For example, if the system receives a claim transaction with the following details:
-
UDF_CHAR_1 is set to Western
-
UDF_CHAR_2 is set to Active
-
UDF_CHAR_3 is set to HR
-
UDF_CHAR_4 is set to Indian
-
UDF_DATE_1 is set to 07-06-2018
-
Transaction Record Type is set to TR5
Transaction Record Type | Primary Pricing Rule Type | Related Pricing Rule Type | Price Item in Related Pricing Rule Type | Price Item Parameters in Related Pricing Rule Type | Pricing Rule | Pricing Start Date | Pricing End Date | Price Item Parameters in Pricing Rule | Fees | Assignment Level |
---|---|---|---|---|---|---|---|---|---|---|
TR5 | CLAIM | RETENTION CLAIM BASED FEES | P3 | Location = UDF_CHAR_1, Employee Status = UDF_CHAR_2, Employee Department = UDF_CHAR_3, and Nationality = UDF_CHAR_4 | C1P3 | 01-01-2018 | 31-12-2018 | Location = Western and Employee Status = Active | $10 | Bill Group |
Location = Eastern and Employee Status = Active | $12 | |||||||||
Location = Eastern and Employee Status = Retired | $11 | |||||||||
Location = Western and Employee Status = Retired | $9 |
Example 5: Best Fit Match for Price Item Parameters
In the example 5, the system could not find the exact match for the price item parameters (i.e. Location = Western, Employee Status = Active, Employee Department = HR, and Nationality = Indian) in the effective pricing rule for P3. Therefore, the system searches for the best fit match. While searching for the best fit match, the system rules out the optional parameter with lowest priority (i.e. Nationality = Indian) and checks whether pricing is defined for the price item parameters (i.e. Location = Western, Employee Status = Active, and Employee Department = HR) in the effective pricing rule. If so, it considers C1P3 as the effective pricing rule for P3. If not, the system rules out the optional parameter with the next lowest priority (i.e. Employee Department = HR) and checks whether pricing is defined for the price item parameters (i.e. Location = Western and Employee Status = Active) in the effective pricing rule. If so, it considers C1P3 as the effective pricing rule for P3. If not, the status of the transaction is changed to Error.
In the example 5, the system considers pricing defined for the price item parameters (i.e. Location = Western and Employee Status = Active) as the best fit match, and therefore fetches C1P3 as the effective pricing rule for P3. While fetching the effective pricing rule, the system considers only those price item parameters specified in the related pricing rule type for which the parameter usage is set to Pricing.
The system then derives the account with a particular invoice type (to which a price item must be billed) based on the priority which is defined for the respective price item in the related pricing rule type.
Related Pricing Rule Type | Price Item | Priority | Invoice Type | Account |
---|---|---|---|---|
RETENTION TYPE CLAIM BASED | P3 | 10 | Standard | A1 |
P4 | 10 | Retention | A2 | |
20 | Standard | A1 |
Example 6: Priority Based Account Derivation
In the example 6, while mapping the claim transaction to P3, the system checks whether an account where the Invoice Type (C1INVTYP) characteristic is set to Standard exists for the bill group. If so, it considers the standard account (A1) of the bill group for billing. However, if an account where the Invoice Type (C1INVTYP) characteristic is set to Standard does not exist for the bill group, the status of the transaction is changed to Error.
Similarly, while mapping the claim transaction to P4, the system checks whether an account where the Invoice Type (C1INVTYP) characteristic is set to Retention exists for the bill group. If so, it considers the retention account (A2) of the bill group for billing. However, if an account where the Invoice Type (C1INVTYP) characteristic is set to Retention does not exist for the bill group, the system checks whether an account where the Invoice Type (C1INVTYP) characteristic is set to Standard exists for the bill group. If so, it considers the standard account (A1) of the bill group for billing. If an account where the Invoice Type (C1INVTYP) characteristic is set to Standard does not exist for the bill group, the status of the transaction is changed to Error.
Once the account is derived, the system then checks whether the account has one active contract of the contract type which is associated with the price item. If so, it fetches the contract for further processing. Once the effective pricing rule, account, and active contract are derived, the transaction is mapped to the respective price item, price item parameters, and account. A transaction leg is created for each price item, price item parameters, and account combination. For example, if the system receives a claim transaction with the following details:
-
UDF_CHAR_1 is set to Western
-
UDF_CHAR_2 is set to Active
-
UDF_CHAR_3 is set to HR
-
UDF_DATE_1 is set to 03-01-2018
-
Transaction Record Type is set to TR5
Transaction Record Type | Primary Pricing Rule Type | Related Pricing Rule Type | Price Item in Related Pricing Rule Type | Price Item Parameters in Related Pricing Rule Type | Effective Pricing Rule | Best Fit Match for Price Item Parameters in Effective Pricing Rule | Account | Active Contract | Transaction Leg |
---|---|---|---|---|---|---|---|---|---|
TR5 | CLAIM | CLAIM BASED FEES | P1 | Location = UDF_CHAR_1, Employee Status = UDF_CHAR_2, Employee Department = UDF_CHAR_3, and Nationality = UDF_CHAR_4 | PR1 | Location = Western and Employee Status = Active | A1 | C1 | TL1 |
P2 | PR2 | Location = Western and Employee Status = Active | A2 | C2 | TL2 | ||||
P3 | PR3 | Location = Western and Employee Status = Active | A3 | C3 | TL3 |
Example 7: Transaction Leg Derivation
In the example 7, the system maps the claim transaction to the following price item, price item parameters, and account combinations:
-
Price Item: P1; Price Item Parameter: Location = Western, Employee Status = Active, and Employee Department = HR; and Account: A1
-
Price Item: P2; Price Item Parameter: Location = Western, Employee Status = Active, and Employee Department = HR; and Account: A2
-
Price Item: P3; Price Item Parameter: Location = Western, Employee Status = Active, and Employee Department = HR; and Account: A3
In the example 7, the system creates three transaction legs - TL1, TL2, and TL3 for the claim transaction. Once a transaction leg is created, the respective effective pricing rule is stamped against the transaction leg. In addition, the price item parameters of the transaction leg are grouped. In the example 7, the system creates one price item parameter group which contains the following price item parameters:
-
Location = Western
-
Employee Status = Active
-
Employee Department = HR
A group is used to determine the price item pricing. A unique group ID is generated for each group. If a group with a set of price item parameters already exists in the system, a new group is not created. Instead, the existing group is used for determining the price item pricing.
If a pricing group is used while defining a pricing rule for a bill group, the system fetches the pricing rule for a claim transaction when the following conditions are met:
-
The paid date of the claim transaction falls within the pricing rule's date range.
-
The employee attributes specified in the claim transaction match the criteria defined in any one of the pricing group rule.
-
The employee attributes specified in the claim transaction match the price item parameters defined within the satisfied rule.
Let us understand this with the help of an example. A claim transaction is received with the following details:
-
UDF_CHAR_1 is set to X
-
UDF_CHAR_2 is set to Western
-
UDF_CHAR_3 is set to Indian
-
UDF_CHAR_4 is set to HR
-
UDF_CHAR_5 is set to Permanent
-
UDF_CHAR_6 is set to Senior Manager
-
UDF_CHAR_7 s set to BG1
-
UDF_DATE_1 03-01-2018
-
Transaction Record Type is set to TR6
Transaction Record Type | Primary Pricing Rule Type | Related Pricing Rule Type | Price Item in Related Pricing Rule Type | Price Item Parameters in Related Pricing Rule Type | Pricing Rule | Pricing Start Date | Pricing End Date | Pricing Group | Pricing Group Rule | Price Item Parameters | Fees |
---|---|---|---|---|---|---|---|---|---|---|---|
TR6 | CLAIM | CLAIM BASED FEES | PP1 | Designation = UDF_CHAR_6; Employee Group = UDF_CHAR_7 | PR1 | 01-01-2018 | 31-12-2018 | PG1 | Rule 1 (where Source System = X, Parameter 1 = Western, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager and Employee Group = BG1 | $10 |
Rule 1 (where Source System = X, Parameter 1 = Western, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager and Employee Group = BG2 | $12 | |||||||||
Rule 2 (where Source System = X, Parameter 1 = Eastern, and Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager and Employee Group = BG1 | $8 | |||||||||
Rule 2 (where Source System = X, Parameter 1 = Eastern, and Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager and Employee Group = BG2 | $9 |
Example 8: Effective Pricing Rule is Defined Using a Pricing Group
In the example 8, the system considers the PR1 pricing rule for PP1 because of the following reasons:
-
The paid date (i.e. 03-01-2018) of the claim transaction falls within the PR1 pricing rule's date range (i.e. 01-01-2018 to 31-12-2018).
-
The employee attributes specified in the claim transaction match the criteria defined in the Rule 1 (i.e. Source System = X, Parameter 1 = Western, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent).
-
The employee attributes specified in the claim transaction match the price item parameters defined within the Rule 1.
The system then stores the pricing group rule which is satisfied against a parameter which is defined in the Pricing Group Rule Parameter option type of the C1-ASOBLLNG feature configuration. In such case, the price item parameter group contains the price item parameters and the pricing group rule parameter. For example, Group A contains Designation = Senior Manager, Employee Group = BG1, and Pricing Group Rule Parameter = Rule 1.
In the example 8, the system could find the exact match for pricing parameters defined in the pricing group rule. However, if the exact match is not available, the system finds the effective pricing rule using the best fit match for the pricing parameters defined in the pricing group rule. Note that the system searches for the exact match in the effective pricing rules at both the bill group and parent customer levels. If the exact match is not available at both the levels, the system finds the effective pricing rule using the best fit match for the pricing parameters (defined in the pricing group rule) first at the bill group level and then at the parent customer level.
Let us understand this with the help of an example. A claim transaction is received with the following details:
-
UDF_CHAR_1 is set to X
-
UDF_CHAR_2 is set to Western
-
UDF_CHAR_3 is set to Indian
-
UDF_CHAR_4 is set to HR
-
UDF_CHAR_5 is set to Permanent
-
UDF_CHAR_6 is set to Senior Manager
-
UDF_CHAR_7 is set to BG1
-
UDF_DATE_1 is set to 31-05-2018
-
Transaction Record Type is set to TR6
Transaction Record Type | Primary Pricing Rule Type | Related Pricing Rule Type | Price Item in Related Pricing Rule Type | Price Item Parameters in Related Pricing Rule Type | Pricing Rule | Pricing Start Date | Pricing End Date | Pricing Group | Pricing Group Rule | Price Item Parameters in Pricing Rule | Fees |
---|---|---|---|---|---|---|---|---|---|---|---|
TR6 | CLAIM | CLAIM BASED FEES | PP1 | Designation = UDF_CHAR_6, Employee Group = UDF_CHAR_7 | PR1 | 01-01-2018 | 31-12-2018 | PG1 | Rule 1 (where Source System = X and Parameter 1 = Western) | Designation = Senior Manager; Employee Group = BG1 | $20 |
Rule 1 (where Source System = X and Parameter 1 = Western) | Designation = Senior Manager; Employee Group = BG2 | $21 | |||||||||
Rule 2 (where Source System = X and Parameter 1 = Eastern) | Designation = Senior Manager; Employee Group = BG1 | $18 | |||||||||
Rule 2 (where Source System = X and Parameter 1 = Eastern) | Designation = Senior Manager; Employee Group = BG2 | $19 | |||||||||
PP2 | PR2 | 01-01-2018 | 31-12-2018 | PG2 | Rule 1 (where Source System = X, Parameter 1 = Eastern, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager; Employee Group = BG2 | $5 | ||||
Rule 1 (where Source System = X, Parameter 1 = Eastern, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager; Employee Group = BG1 | $5 | |||||||||
Rule 2 (where Source System = X, Parameter 1 = Western, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager; Employee Group = BG2 | $6 | |||||||||
Rule 2 (where Source System = X, Parameter 1 = Western, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) | Designation = Senior Manager; Employee Group = BG1 | $9 |
Example 9: Effective Pricing Rule Derivation Using Best Fit Match for Pricing Parameters
In the example 9, the system could not find the exact match for the pricing parameters (i.e. Source System = X, Parameter 1 = Western, Parameter 2 = Indian, Parameter 3 = HR, and Parameter 4 = Permanent) in the effective pricing rule for PP1. Therefore, the system searches for the best fit match. While searching for the best fit match, the system rules out the optional parameter 4 (i.e. Parameter 4 = Permanent) and then checks whether the pricing group rule where Source System = X, Parameter 1 = Western, Parameter 2 = Indian, and Parameter 3 = HR exists in the effective pricing rule. If so, it considers the pricing group rule for further processing. If not, the system then rules out the optional parameter 3 (i.e. Parameter 3 = HR) and then checks whether the pricing group rule where Source System = X, Parameter 1 = Western, and Parameter 2 = Indian exists in the effective pricing rule. If so, it considers the pricing group rule for further processing. If not, the system then rules out the optional parameter 2 (i.e. Parameter 2 = Indian) and then checks whether the pricing group rule where Source System = X and Parameter 1 = Western exists in the effective pricing rule. If so, it considers the pricing group rule for further processing. If not, the status of the transaction is changed to Error.
In the example 9, the system considers Rule 1 where Source System = X and Parameter 1 = Western as the best fit match in the PR1 pricing rule for PP1. In addition, the employee attributes in the claim transaction satisfy the price item parameters (i.e. Designation = Senior Manager and Employee Group = BG1) defined within the Rule 1. Therefore, the system fetches PR1 as the effective pricing rule for PP1. In addition, the system fetches PR2 as the effective pricing rule for PP2. The system creates two price item parameter groups - One contains Designation = Senior Manager, Employee Group = BG1, and Pricing Group Rule Parameter = Rule 1 and another contains Designation = Senior Manager, Employee Group = BG1, and Pricing Group Rule Parameter = Rule 2. Once the price item parameter group is created, the system creates the aggregation parameter group. An aggregation parameter group contains all price item parameters included in the related pricing rule type for which the parameter usage is set to Aggregation.
If the effective pricing rule is not derived for a price item and price item parameters combination or if the account or active contract for the account is not derived, the system does not create a transaction leg for the respective price item.
Related Pricing Rule Type | Price Item | Price Item Parameters | Effective Pricing Rule | Account | Active Contract | Transaction Leg |
---|---|---|---|---|---|---|
RETENTION TYPE CLAIM BASED | PP11 | Designation = UDF_CHAR_6, Employee Status = UDF_CHAR_7 | - | - | - | - |
PP12 | PR12 | A1 | C1 | TL11 | ||
PP13 | PR13 | - | - | - | ||
PP14 | PR14 | A2 | - | - | ||
PP15 | PR15 | - | - | - | ||
PP16 | - | - | - | - | ||
PP17 | PR17 | A2 | C2 | TL12 |
Example 10: No. of Transaction Legs Derived
In the example 10, the system could not find the effective pricing rule for PP11 and PP16, the required account for PP13 and PP15, and the active contract for PP14 on A2. Therefore, in this case, the system creates two transaction legs - TL11 and TL12 for the transaction.
If the eligibility rule type is defined for a price item, the system maps the transaction to the price item when the eligibility rule is satisfied. If the eligibility rule is not satisfied, the system does not consider the price item for billing.
Sequence | Related Pricing Rule Type | Rule Type Eligibility Criteria Met | Price Item | Price Item Eligibility Criteria Met | Effective Pricing Rule | Account | Active Contract | Transaction Leg |
---|---|---|---|---|---|---|---|---|
10 | RETENTION TYPE CLAIM BASED | Yes | PE1 | Yes | PR1 | A1 | C1 | TL1 |
PE2 | - | PR2 | A2 | - | - | |||
PE3 | No | - | - | - | - | |||
20 | CLAIM BASED FEES | - | PE4 | - | PR3 | A1 | C2 | TL2 |
PE5 | Yes | PR4 | - | - | - | |||
PE6 | No | - | - | - | - | |||
30 | CLAIM FEE CHARGES | No | PE7 | - | - | - | - | - |
PE8 | - | - | - | - | - | |||
PE9 | - | - | - | - | - |
Example 11: Price Item Eligibility for Transaction Leg Derivation
In the example 11, the eligibility criteria is defined for the RETENTION TYPE CLAIM BASED and CLAIM FEE CHARGES pricing rule types. However, the eligibility criteria for the CLAIM FEE CHARGES pricing rule type was not satisfied, and therefore it is not used for deriving the transaction legs. The eligibility criteria for PE1 and PE5 was satisfied, but the eligibility criteria for PE3 and PE6 was not satisfied. Further, the system could not find the required account for PE5 and the active contract for PE2 on A2. Therefore, in this case, the system creates two transaction legs (i.e. TL1 and TL2) for the claim transaction. For more information about the related pricing rule type eligibility and price item eligibility features, refer to the Related Pricing Rule Type Eligibility and Price Item Eligibility sections, respectively.
Once a transaction leg is created, the derivation date is set as the processing date corresponding to the transaction leg.