Click View Detail below Inactive Details Report. The Report Selection screen will be displayed.
This screen displays a list of the reports created.
The following columns are displayed:
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To display a report, click on the hyperlinked display in the Action column.
The Report Selection screen will be displayed.
Processing
When the GENERATE button selected on the Inactive Details screen, and a value for Sub-Status has been selected, the system will find the Policies (Memberships) based on the value selected as per the table below.
If no Sub-Status is selected, the system will find the Policies (Memberships) as per all of the Statuses in the table below.
If a Membership is found meeting the criteria for more than one of the Statuses, the system will only include the Membership in the report once.
|
Status |
Details |
|
EXIT FINALISED |
Find the Memberships for which the Effective Date of the Membership Status of EXIT FINALISED is less than or equal to the To Date and for which there is a Benefit Request with a Benefit Event of SURRENDER or SURRENDER BENEFIT. |
|
CANCELLED
|
Find the Memberships for which the Membership Status is ENDED and the Effective Date is greater than or equal to the From Date and less than or equal to the To Date and for which there is a with a Member Values record with a Member Value Type of ASSURANCE DETS, Subtype of POLICY DECISION and a Sub-Type Detail of CANCELLED. |
|
LAPSED |
Find the Memberships for which the Membership Status is PAID UP and the Effective Date is greater than or equal to the From Date and less than or equal to the To Date and for which there is a with a Member Values record with a Member Value Type of ASSURANCE DETS, Subtype of POLICY DECISION and a Sub-Type Detail of LAPSED. |
|
NOT TAKEN UP
|
Find the Memberships for which the Membership Status is ENDED and the Effective Date is greater than or equal to the From Date and less than or equal to the To Date and for which there is a with a Member Values record with a Member Value Type of ASSURANCE DETS, Subtype of POLICY DECISION and a Sub-Type Detail of NOT TAKEN UP. |
|
DECLINED |
Find the Memberships for which the Membership Status is ENDED and the Effective Date is greater than or equal to the From Date and less than or equal to the To Date and for which there is a with a Member Values record with a Member Value Type of ASSURANCE DETS, Subtype of POLICY DECISION and a Sub-Type Detail of DECLINED. |
Note:
This report has been optimised to produce a maximum of 250 rows. To view the full report, capture the email address of the recipient and click EXPORT.
The following columns are displayed in the report:
- POLICY NUMBER
- COMMENCEMENT DATE
- DATE FINALISED
- DATE ADDED
- MATURITY DATE
- CLIENT TITLE
- CLIENT FIRST NAME
- CLIENT SURNAME
- CLIENT DATE OF BIRTH
- CLIENT IDENTIFICATION NUMBER
- BARCLAYS BANK ACCOUNT TYPE
- CURRENT POLICY STATUS
- PRODUCT NAME
- SUB-PRODUCT CODE
- POLICY TERM
- SUM ASSURED
- ANNUAL PREMIUM INCREASE
- PREMIUM
- OCCUPATION
- EMPLOYER
- COUNTRY
- PROVINCE
- TOWN
- SALES BRANCH CODE
- SALES BRANCH
- BARCLAYS CONSULTANT
- BARCLAYS CONSULTANT NUMBER
- FINALISED USER
- DO BRANCH CODE
- DO ACCOUNT NUMBER
- STRIKE DATE
- WORK TEL
- HOME TEL
- MOBILE TEL
- POSTAL ADDRESS
- SUB STATUS
- DISTRIBUTION CHANNEL
- MEMBERSHIP GROUP
When the GENERATE button is selected, the system will find the PDF Document Template with a Process Type of INACTENDOWREP linked to the Scheme and extract the information for the Field Tags linked to the Document Template as per the details in the Source column in the table below:
|
Column Header |
Field Tag |
Source |
|
POLICY NUMBER |
MEMB REF NO |
Retrieve all the Membership Reference Numbers where the Commencement Date of the policyholder is greater or equal to the From Date of the Report and less or equal to the To Date of the Report and where the membership status is equal to LIVE and the Policy Decision is equal to ACCEPTED. |
|
COMMENCEMENT DATE |
DATE JOINED |
Commencement Date on Policyholder Details for all membership numbers extracted. |
|
DATE FINALISED |
FINDATE |
Display the Timestamp for each membership record extracted when the policy decision of the membership record changed from PENDING to ACCEPTED. |
|
DATE ADDED |
APPDATE |
Find the Application Date on Policyholder Details linked to the membership reference number for all membership records extracted. |
|
MATURITY DATE |
|
|
|
CLIENT TITLE |
MEMB TITLE |
Title field on Policyholder Details for each membership record extracted. |
|
CLIENT FIRST NAMES |
MEMB NAME 1 |
First Name field on Policyholder Details for each membership record extracted. |
|
CLIENT SURNAME |
MEMB SURNAME |
Surname field on Policyholder Details for each membership record extracted |
|
CLIENT DATE OF BIRTH |
DATE OF BIRTH |
Date of Birth field on Policyholder Details for each membership record extracted. |
|
CLIENT IDENTIFICATION NUMBER |
ID NUMBER |
ID Number field on Policyholder Details for each membership record extracted. |
|
BARCLAYS BANK ACCOUNT TYPE |
CLIENT CLASS |
Client Classification field on Policyholder Details for each membership record extracted. |
|
CURRENT POLICY STATUS |
POLICY DECISION |
Retrieve the latest value for Policy Decision on JU4HE Policy Decision Details for each membership record extracted. |
|
PRODUCT NAME |
FUND NAME |
Fund Description |
|
SUB-PRODUCT NAME |
FUND CODE |
Scheme Code |
|
PRODUCT TERM |
POLICY TERM |
Term field on Policyholder Details for each membership record extracted. |
|
SUM ASSURED |
SUM ASSURED |
Sum Assured field on Policyholder Details for each membership record extracted. |
|
ANNUAL PREMIUM INCREASE |
INCREASE RATE |
Annual Increase Percentage field on Policyholder Details for each membership record extracted. |
|
MONTHLY PREMIUM |
PREMIUM |
Premium Amount field On Policyholder Details for each membership record extracted. |
|
OCCUPATION |
OCCUPATION |
Occupation field on Policyholder Details for each membership record extracted. |
|
EMPLOYER |
EMPLOYER |
Find and display Employer on Policyholder Details for each membership record extracted |
|
COUNTRY |
COUNTRY |
Find and display the latest Country field captured on Contact Details for each membership record extracted. |
|
PROVINCE |
MEMB PROV RES |
Find and display the latest Province field captured on Contact Details for each membership record extracted |
|
TOWN |
MEM TOWN RES |
Find and display the latest Town field captured on Contact Details for each membership record extracted |
|
SALESBRANCHCODE |
BRANCH |
Branch field on Policyholder Details for each membership record extracted |
|
SALESBRANCH |
BRANCH |
Branch field on Policyholder Details for each membership record extracted. |
|
BARCLAYS CONSULTANT |
REP NAME |
Financial Advisor Field on Policyholder Details for each membership record extracted. |
|
BARCLAYS CONSULTANT NUMBER |
REP NO |
Representative Number for Financial Advisor for each membership record extracted. |
|
FINALISED USER |
USERID |
User ID of the person who finalised the membership records extracted. |
|
DO BRANCH CODE |
CASH BRNCH CDE |
Branch Code of Bank Account linked to each membership record extracted. |
|
DO ACCOUNT NUMBER |
CASH ACCNT NR |
Account Number of Bank Account captured linked to each membership record extracted. |
|
STRIKE DATE |
PAYMENT DAY |
Payment Day field on Policyholder Details for each membership record extracted. |
|
WORK TEL |
TELNO W |
Find and display the latest Work Tel field captured on Contact Details for each membership record extracted |
|
HOME TEL |
TELNO H |
Find and display the latest Home Tel field captured on Contact Details for each membership record extracted |
|
MOBILE TEL |
CELLULAR |
Find and display the latest mobile field captured on Contact Details for each membership record extracted |
|
POSTAL ADDRESS |
MEM ADDR POST |
Find and display the latest Postal Address field captured on Contact Details for each membership record extracted |
|
TOTAL POLICIES |
TOTAL POLICIES |
Sum of all the membership records extracted. |
|
TOTAL SUM ASSURED |
TOTAL SUM ASSURED |
Sum of all the Sum Assured Values extracted for each membership record. |
|
TOTAL PREMIUMS |
TOTAL PREMIUMS |
Sum of all the recurring premiums extracted for each membership record. |
|
DISTRIBUTION CHANNEL |
|
|
|
MEMBERSHIP GROUP |
|
|