This report displays details of new Policyholders who have been written.
From the Endowment menu, select New Business Details Report from the sub-menu on the left.
Additional options will be displayed:
Click New below New Business Details Report. The New Business Details screen will be displayed.
Capture details as follows:
|
Sub-Product |
Select a Sub-Product from the drop-down list.
Note: The default is ALL.
Optional |
|
Distribution Channel |
Select from a drop-down list of Financial Advisors linked to the Sub-Product (Schemes linked to the Endowment product), or select All.
Note: Values will only be displayed for selection when a Sub-Product has been selected. |
|
From Date |
The date from which data must be extracted.
Note: The system default is the current date.
This field is mandatory, and a date must be captured. |
|
To Date |
The date to which data must be extracted.
Note: The system default is the current date.
This field is mandatory, and a date must be captured |
|
Commencement Date
Processed Date |
Click the appropriate radio button to indicate whether the extract must be from the Policyholder’s Commencement Date or the date on which processing took place.
Note: The system default is Commencement Date. |
Click GENERATE.
The following message will be generated once the job has been successfully submitted.
An email will be sent to you when the report is ready to be viewed.
You will receive an email indicating that the report is ready to view.
Click View Detail below New Business 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.
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
- CLIENT ID
- 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
- DISTRIBUTION CHANNEL
Processing
When the GENERATE button is selected, find the PDF Document Template with a Process Type of NBENDOWREP 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. |
|
CLIENT ID |
|
|
|
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 |
|
|