alongside Endowment Valuation on the sub-menu on the left. Additional options will be displayed.This report provides specific information for valuation purposes for Endowment Products. This information is different from the information currently provided in the valuation reports for Retirement Funds and Retirement Annuity Funds.
For more information on valuation reports for Retirement Funds and Retirement Annuity Funds refer to
Reports
General
Valuation
Retirement Annuity Valuation
From the General menu, click alongside Endowment Valuation on the sub-menu on the left. Additional options will be displayed.
Click New below Endowment Valuation. The Endowment Valuation screen will be displayed.
Capture the date from which the report must apply in the From Date field and capture the date to which the report must apply in the To Date field. Capture your email address.
Click GENERATE.
Confirmation will be displayed that the report has been submitted.
The report is available for viewing.
When the GENERATE button is selected, the system will extract the information for each of the Memberships for the Scheme selected and for which the Membership Status as at the From Date captured is not EXIT FINALISED or EXIT IN PROCESS as per the details in the table below:
|
Information |
Source |
|
PolicyNumber |
Membership Reference Number |
|
Old_Pol_No |
Leave blank Note: The Zambia and Kenya endowment products are new products and there won’t be any conversion data |
|
LastMovementDate |
Start Date of the Membership Status with a Start Date less than or equal to the report To Date and greater than or equal to the report From Date |
|
Accept_Date |
Start Date of the Membership Status record for which the Membership Status is LIVE |
|
ValuationStartDate |
Report From Date |
|
ValuationEndDate |
Report To Date |
|
Rundate |
Date portion of report Timestamp |
|
MovementType |
Find the Latest Membership Status with a Start Date less than or equal to the report To Date and greater than or equal to the report From Date and find the Member Value record with a Type of ASSURANCE DETS and a Sub-Type of POLICY DECISION with a Timestamp equal to the Membership Status record. Read the value for Classification on the Member Values record. Read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is MOVEMENT and the Source System Attribute is STATUS/DECISION and the Target System ID is MOVEMENT TYPE and the Target System Attribute is MOVEMENT TYPE. Set the value to the Target System Value for the combination of Membership Status and Policy Decision. If the Source System Attribute only contains the STATUS i.e. the value for Status is not followed by a / and a value then set the value to the Target System value for the Membership Status. If the Latest Membership Status with a Start Date less than or equal to the report To Date and greater than or equal to the report From Date is LIVE and the Membership Status immediately prior to the LIVE Membership Status is ENDED set this value to REINSTATE. |
|
ContractStatus |
Same as Policy Status (see row below) |
|
PolicyStatus |
Read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is MEMBER STATUS and the Source System Attribute is STATUS/CATEGORY, and the Target System ID is POLICY STATUS and the Target System Attribute is POLICY STATUS. Read the Target System Translation value for the Source Translation value equal to the combination of Membership Status as at the report To Date and the value for Policy Category (see KAT below). Refer to the Deriving the Policy Category section below.If there is only a value for Status i.e. the Translation Value is not followed by a / and a value then find the Translation Value for the Member’s Membership Status only. |
|
Date_Commence |
Pay Day on Membership Payment Detail record and month and year of Membership CAR Start Date. |
|
KAT |
Derive the Policy Category as per the Deriving the Policy Category section below, and then read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is POLICY CATEGORY and the Source System Attribute is POLICY CATEGORY, and the Target System ID is POLICY CATEGORY and the Source System Attribute is POLICY CATEGORY. Read the Target System Translation value for the Source Translation value equal to the value for Policy Category in the Deriving the Policy Category section below, i.e. find the value for A, N, E or NE A – Active as at start and end N – New during report period E – Exited during report period NE – New and exited during report period |
|
Product_Code |
Scheme Code |
|
RiskItemID |
Leave blank |
|
BEN_NBR |
Default the value to MAIN MEMBER 1 |
|
CONTRACT_TYPE |
Value for Classification on the Member Values record for the Type ASSURANCE DETS and Sub Type POLICY PURPOSE |
|
ContractOption |
Value for Amount on the Member Values record for the Type ASSURANCE DETS and Sub Type SUM ASSURED |
|
PRODUCT_TYPE |
Value for Classification on the Member Values record for the Type ASSURANCE DETS and Sub Type POLICY PURPOSE |
|
BEN_TYPE |
Default the value to MAIN MEMBER |
|
DateOfBirth |
Date of Birth on Natural Person record to which the Membership is linked |
|
Gender |
Gender on Natural Person record to which the Membership is linked |
|
IDNumber |
ID Number on Natural Person record to which the Membership is linked |
|
Smoker |
Read the Sub-Type on the Member Values record for the Type SMOKING. Read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is SMOKER CODE and the Source System Attribute is SMOKER CODE, and the Target System ID is SMOKER CODE and the Source System Attribute is SMOKER CODE. Read the Target System Translation value for the Source System Translation equal to the value on the Member Value record. |
|
ComponentStatus |
Set to the value for Policy Status. |
|
SEC_CODE |
Leave blank |
|
Occ_Code |
Value for Description on the Member Values record for the Type ASSURED DETS and Sybtype OCCUPATION |
|
LifeAssuredGID |
Leave blank |
|
Occ_Class |
Value for Description on the Member Values record for the Type ASSURED DETS and Sybtype OCCUPATION |
|
Income |
Leave blank |
|
Education |
Leave blank |
|
SalesChannel |
Code on Sales to Intermediary to which the Membership is associated is linked as at the Date of Commencement of the Policy. |
|
EMPLOYEENUMBER |
Leave blank |
|
PRI_Number |
Code on Intermediary to which the Membership is associated. |
|
Tax_Status |
Default to INDIVIDUAL |
|
BEN_STAT_DATE |
Leave blank |
|
Gross_Sum_Assured |
Value for Amount on the Member Values record for the Type ASSURANCE DETS and Sub Type SUM ASSURED |
|
RinsuranceCover |
Leave Blank |
|
Gross_Premium |
Sum of the Regular Payment Amounts on the Membership Payment Detail records for the Membership active as at the To Date of the report |
|
Written_Premium |
Same as Gross_Premium |
|
Net_Premium |
Same as Gross_Premium |
|
PMT_FREG |
Read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is PMT FREQEUNCY and the Source System Attribute is PMT FREQEUNCY, and the Target System ID is PMT FREQEUNCY and the Source System Attribute is PMT FREQEUNCY. Read the Target System Translation value for the Source System Translation equal to the value for Frequency on the Membership Payment record. |
|
Pol_Fee |
Retrieve the Business Transactions in the Member’s CONTRIBUTION account with an Expense Type of ADM and with a Transaction Date greater than or equal to the report From Date and less than or equal to the report To Date and sum the amounts. |
|
DistributionContract |
Leave blank |
|
CommissionType1 |
Default to DRIP |
|
Value1 |
Retrieve the Business Transactions in the Member’s CONTRIBUTION account with an Expense Type of CMG and with a Transaction Date greater than or equal to the report From Date and less than or equal to the report To Date and sum the amounts. |
|
CommissionType2 |
Leave blank |
|
Value2 |
Leave blank |
|
CommissionType3 |
Leave blank |
|
Value3 |
Leave blank |
|
CommissionType4 |
Leave blank |
|
Value4 |
Leave blank |
|
Capture_Date |
Value for Period Start Date on the Member Values record for the Type ASSURED DETS and Sub Type APPL DATE |
|
Issue_Date |
CAR Start Date |
|
BEN_CEASE_DATE |
Value for Period Start Date on the Member Values record for the Type ASSURED DETS and Sub type MATURITY DATE |
|
DATE_TERMNT_POLC |
Date of Exit |
|
DATE_TERMNT_PROC |
Timestamp Date of Membership Status of EXIT FINALISED |
|
Benefit_Term |
Period from CAR Start Date (Commencement Date) to the Value for Period Start Date on the Member Values record for the Type ASSURED DETS and Sub type MATURITY DATE expressed in months. |
|
Premium_Term |
Period from CAR Start Date (Commencement Date) to the Value for Period Start Date on the Member Values record for the Type ASSURED DETS and Sub type MATURITY DATE expressed in months where the Membership Status is LIVE and is linked to a Contribution Membership Group for which there is an Income Rule. If the Membership Status is LIVE and the Contribution Membership Group to which the Membership is linked is not linked to an Income Rule set this to the Start Date of the association to the Contribution Membership Group. If the Membership Status is PAID UP set this to the same value as Benefit_Term. |
|
Life Status |
Default to SINGLE |
|
Infl_Protection |
Value for Increase Percentage on the Membership Payment record for which the Income type is REC |
|
Income_Benefit |
Default to NO |
|
Net_Sum_Assured |
Same as value for Gross_Sum_Assured |
|
Reinsurer |
Leave blank |
|
InterestRate |
Leave blank |
|
Currency |
Value for Currency for the Scheme |
|
Number of increases taken |
Count the Number of Member Values records with a Type ASSURANCE DETS and Sub Type SUM ASSURED and deduct 1. There will be a record for the original sum assured and therefore 1 must be deducted to arrive at the number of increases. |
|
BenefitCode |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then find the Event Category for the Benefit Event on the Benefit Request. |
|
ClaimGroup |
Leave blank |
|
ClaimNumber |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then read the Benefit Request Number. |
|
ClaimType |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is CAUSE OF CLAIM and the Source System Attribute is BENEFIT EVENT, and the Target System ID is CLAIM TYPE and the Source System Attribute is CLAIM TYPE. Read the Target System Translation value for the Source System Translation equal to the value for the Benefit Event. |
|
ClaimCause |
Leave blank |
|
ClaimStatus |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is CLAIM DECISION and the Source System Attribute is BENEFIT PRODUCT, and the Target System ID is CLAIM STATUS and the Source System Attribute is CLAIM STATUS. Read the Target System Translation value for the Source System Translation equal to the value for the Benefit Product linked to the Benefit Package for the Benefit Event. |
|
MovementType |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then read the Translation Value table where the Purpose is ENDOWMENT VAL and for which the Source System ID is REQUEST STATUS and the Source System Attribute is REQUEST STATUS, and the Target System ID is MOVEMENT TYPE and the Source System Attribute is MOVEMENT TYPE. Read the Target System Translation value for the Source System Translation equal to the value for the Request Status on the Benefit Request. |
|
PaymentStatus |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date and the Request Status on the Benefit Request is FINALISED set this to PAID if not leave blank. |
|
ClaimAmount |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then find the Goss Benefit Amount. |
|
AmountPaid |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date then retrieve the Business Transactions (BT’s) in the Member’s BENPAYABLE account with an Accounting Activity of BENPAYAMNT and BENPAYAMNTRV and sum the amounts. |
|
ClaimDate |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date find the Start Date on the Service Request for the Membership with a Process of DEATH or DISABILITY. |
|
EventDate |
CAR End Date. |
|
StartDate |
Transaction Date of the BT in the Member’s BENPAYABLE account with an Accounting Activity of BENPAYAMNT with the earliest Transaction Date. |
|
EndDate |
Transaction Date of the BT in the Member’s BENPAYABLE account with an Accounting Activity of BENPAYAMNT with the latest Transaction Date. |
|
Claim Notify Date |
If the Membership has a CAR End Date greater than the report From Date and less than or equal to the report To Date find the Start Date on the Service Request for the Membership with a Process of DEATH or DISABILITY. |
|
Mths_to_clm |
Calculate the number of full months from the report To Date to the Member’s CAR End Date. |
|
Repudiation reason |
|
|
Ex Gratia |
If the Benefit Product linked to the Benefit Package for the Benefit Event is REPUDIATE EX GRATIA EVENT or REPUDIATE LOSS EVENT set this to YES. If not set it to NO. |
Derive the Policy Category values as per the details in the table below.
The value in the Policy Category column will be derived as per the description in the Details column and then this value will be used to find the Translation Value for the KAT Code.
|
Policy Category |
Details |
|
A |
The CAR Start Date is less than the report From Date and the CAR End Date is null or greater than the report To Date. |
|
N |
The CAR Start Date is greater than the report From Date and less than or equal to the report To Date, and the CAR End Date is null or greater than the report To Date. |
|
E |
The CAR Start Date is less than or equal to the report From Date, and the CAR End Date is less than or equal to the report To Date and greater than the report from Date. |
|
NE |
The CAR Start Date is greater than the report From Date and less than or equal to the report To Date, and the CAR End Date is greater than the report From Date and less than or equal to the report To Date. |
Click View below Endowment Valuation. The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To view details, click on the hyperlinked display in the Action column. The Report Selection screen will be displayed.
The following columns display information per Member:
- Policy Number
- Old Policy Number
- Last Movement Date
- Accept Date
- Valuation Start Date
- Valuation End Date
- Run Date
- Movement Type
- Contract Status
- Policy Status
- Date of Commencement
- KAT
- Product Code
- Risk Item ID
- BEN NBR
- Contract Type
- Contract Option
- Product Type
- Ben Type
- Date Of Birth
- Gender
- ID Number
- Smoker
- Component Status
- Sec Code
- Occupation Code
- Life Assurance GID
- Occupation Class
- Income
- Education
- Sales Channel
- Employee Number
- PRI Number
- Tax Status
- Ben Stat Date
- Gross Sum Assured
- Reinsurance Cover
- Gross Premium
- Written Premium
- Net Premium
- Payment Frequency
- Policy Fee
- Distribution Contract
- CommissionType1
- Value1
- CommissionType2
- Value2
- CommissionType3
- Value3
- CommissionType4
- Value4
- Capture Date
- Issue Date
- Benefit Cease Date
- Policy Termination Date
- Process Termination Date
- Benefit Term
- Premium Term
- Life Status
- Inflation Protection
- Income Benefit
- Net Sum assured
- Reinsurer
- Interest Rate
- Currency
- Number of increases taken
- Benefit Code
- Claim Group
- Claim Number
- Claim Type
- Claim Cause
- Claim Status
- Movement Type
- Payment Status
- Claim Amount
- Amount Paid
- Claim Date
- Event Date
- Start Date
- End Date
- Claim Notify Date
- Months to Claim
- Repudiation reason
- Ex Gratia