Output¶
Active Lives - Valuation¶
-
ActiveLivesValOutput¶ Active lives valuation output.
Columns
- MODEL_VERSIONPandasDtype.String
The tagged model version.
- LAST_COMMITPandasDtype.String
The last git commit.
- RUN_DATE_TIMEPandasDtype.DateTime
The run date and time.
- SOURCEPandasDtype.String
The underlying policy model used.
- POLICY_IDPandasDtype.String
The policy ID of the policy holder.
- COVERAGE_IDPandasDtype.String
The coverage ID of the policy holder.
- DATE_BDPandasDtype.DateTime
Projected begining policy duration date.
- DATE_EDPandasDtype.DateTime
Projected ending policy duration date.
- DURATION_YEARPandasDtype.Int
Projected policy duration year.
- LIVES_BDPandasDtype.Float16
Projected average lives inforce begining policy duration.
- LIVES_MDPandasDtype.Float16
Projected average lives inforce mid-point of policy duration.
- LIVES_EDPandasDtype.Float16
Projected average lives inforce ending policy duration.
- DISCOUNT_BDPandasDtype.Float16
Discount factor used begining policy duration.
- DISCOUNT_MDPandasDtype.Float16
Discount factor used mid-point of policy duration.
- DISCOUNT_EDPandasDtype.Float16
Discount factor used ending policy duration.
- BENEFIT_AMOUNTPandasDtype.Float16
Projected benefit amount.
- INCIDENCE_RATEPandasDtype.Float16
Final incidence rate with margin and sensitivites applied.
- BENEFIT_COSTPandasDtype.Float16
Projected benefit cost (PV future benefits x incidence rate).
- PVFBPandasDtype.Float16
Present value of future benefits.
- PVFNBPandasDtype.Float16
Present value of future bet benefits.
- ALR_BDPandasDtype.Float16
Projected ALR amount at begining policy duration.
- ALR_EDPandasDtype.Float16
Projected ALR amount at ending policy duration.
- ALR_DATEPandasDtype.DateTime
Projected valuation dates using val date as base.
- ALRPandasDtype.Float16
Projected ALR amount as of projected valuation date.
Disabled Lives - Valuation¶
-
DisabledLivesValOutput¶ Disabled lives valuation output.
Columns
- MODEL_VERSIONPandasDtype.String
The tagged model version.
- LAST_COMMITPandasDtype.String
The last git commit.
- RUN_DATE_TIMEPandasDtype.DateTime
The run date and time.
- SOURCEPandasDtype.String
The underlying policy model used.
- POLICY_IDPandasDtype.String
The policy ID of the disabled claimant.
- CLAIM_IDPandasDtype.String
The claim ID of the disabled claimant.
- COVERAGE_IDPandasDtype.String
The coverage ID of the disabled claimant.
- DATE_BDPandasDtype.DateTime
Projected begining claim duration date.
- DATE_EDPandasDtype.DateTime
Projected ending claim duration date.
- DURATION_YEARPandasDtype.Int
Projected claim duration year.
- DURATION_MONTHPandasDtype.Int
Projected claim duration month.
- BENEFIT_AMOUNTPandasDtype.Float16
Projected benefit amount.
- CTRPandasDtype.Float16
Final claim termination rate with margin and sensitivites applied.
- LIVES_BDPandasDtype.Float16
Projected average lives inforce begining claim duration.
- LIVES_MDPandasDtype.Float16
Projected average lives inforce mid-point of claim duration.
- LIVES_EDPandasDtype.Float16
Projected average lives inforce ending claim duration.
- DISCOUNT_BDPandasDtype.Float16
Discount factor used begining claim duration.
- DISCOUNT_MDPandasDtype.Float16
Discount factor used mid-point of claim duration.
- DISCOUNT_EDPandasDtype.Float16
Discount factor used ending claim duration.
- PVFB_BDPandasDtype.Float16
Present value of future benefits begining claim duration.
- PVFB_EDPandasDtype.Float16
Present value of future benefit ending claim duration.
- DATE_DLRPandasDtype.DateTime
Projected valuation dates using val date as base.
- DLRPandasDtype.Float16
Projected DLR amount as of projected valuation date.