Example of an active annuities dataframe
active_annuities_xmpl.RdDataframe contains one row for each active annuity, that means for each annuity that has
not yet been canceled
Data belongs to the set of claims_data_xmpl, active_annuities_xmpl and pool_of_annuities_xmpl.
Format
active_annuities_xmpl
A data frame with 132 rows and 11 columns:
- Claim_id
Claim ID
- Annuity_id
Annuity ID for the case of multiple annuities in one claim
- Origin_year
Origin year of the claim
- Calendar_year
Calendar year
- Entering_year
Year in which insurer and recipient have agreed on the annuity
- Annuity_start
Year in which payment starts, may be a past or a future year
- Annuity_end
Year in which payment ends, must be a future year as it is an active annuity
- Birth_year
Birth year of recipient for assigning survival probability from mortality tables
- Gender
Gender of recipient for assigning mortality table
- Annual_payment
Agreed annual payment
- Dynamic
If a dynamic increase of the annual payment is part of the agreement, it can be specified here, e.g. 0.02 for 2% annual payment increasement