New Policy Values
When creating a (new) policy 3 fields are automatically calculated: Start Date, Expiry Date and Value
...
Product (or insurance scheme)
Family composition (only influences the Value)
The user-defined Enrollment Date (influences both start/expiry dates and Value)
Calculation of the Start Date
The Start Date is calculated based on:
The user-defined Enrollment Date
The Product Administration Period
The Product Enrollment Grace Period
The Product Start Cycles (1,2,3,4)
...
Rules:
If the product has an Administration Period, the period is systematically (blindly) added to the enrollment date provided by user (and the rest of the calculation is based on this new shifted enrollment date).
If the Product has no Start Cycle, the Start Date = the Enrollment Date + Grace Period (if there is one)
...
if Enrollment Date = 12/12/2020, then Start Date = 01/06/2021 (next year first cycle)
Calculation of the Expiry Date
The Expiry Date is calculated based on:
...
if start date = 01/11/2020, then Expiry Date = 31/10/2021
if start date = 01/11/2020, then Expiry Date = 31/10/2021
Calculation of the Value
The Value is calculated based on:
The Family composition (number of adults and number of children)
The Product Maximum Members parameter (limiting the covered family members)
The Product Contributions params: Lump Sum, Threshold Members, Contribution Adult, Contribution Child,
The Product Registration params: Registration Lump Sum and Registration Fee
The Product Assembly params: Assembly Lump Sum and Assembly Fee
The Product Enrollment Discount and Enrollment Discount Period
...
The Policy Value is the sum of 3 ‘buckets’ (contributions, registrations and assemblies assembly) minus a discount:
Value = Contributions + Registrations + Assemblies Assembly - Discount
Except the discount (which depends on enrollment date), these values are only dependent on the family composition. If the Product has a Maximum Members, family members are ordered based on their creation (i.e. recording in system) date time and all members beyond the Maximum Members parameter are simply not taken into account in any calculation.
In other words, the order in which the user records the family members may change the policy value (for example, if he records all the children first, the ‘child contribution’ will be used, while the adults count will be capped).
(remaining) Family members are ‘classified’ (counted) in 4 categories:
adults in ‘standard’ family relationships (like husband, brother,…) - further called adults
adults in ‘other’ family relationship (i.e. special value of the binding relationship) - further called other adults
children in ‘standard’ family relationships (like husbandson, brother,…) - further called children
children in ‘other’ family relationships - further called other children
Calculation of the contributions
There are 2 major strategies to compute contributions part: with a lump sum or without.
...
A family with 1 adult, 1 ‘other’ adult and 8 (non-'other') children will have a contribution = 10.000 + 1.000 (the ‘other’ adult) + 4*500 (members above threshold = 1 + 8 - 5)
Calculation of the registrations
The 2 same major strategies applies to registrations part calculation: with or without lump sum.
...
with a registration lump sum, the registrations part is the lump sum
without the lump sum, the amount is simply the number of members * registration fee
Calculation of the
...
assembly
The assemblies assembly follow the exact same logic as the registrations part: 2 strategies (with and without lump sum) and, without lump sum, all members are equally.
Calculation of the discount
The discount is a simple percentage of the 3 other ‘buckets’ (contributions + registrations + assembliesassembly) which is applied only if the enrollment date is before a relative date limit.
Policy Renewal Values
//TODOthe start date - enrollment discount period.
Example:
For a product with a Enrollment discount of 10% and a Enrollment Discount period of 1 month, if the registrations + registrations + assembly = 10.000, the enrollment date 05/04/2021 and a start date of 01/06/2021 (cfr. start date calculation to reach this situation). Since 05/04/2021 < 01/05/2021 (01/06/2021 - 1 month), there will be a discount of 1.000.