Product Name:
Start Date:
|
Effective Date |
|
|
Nature of product |
|
|
Country |
e.g. South Africa / Namibia |
|
Product |
e.g. Defined Contribution / FIC / Defined Benefit |
|
Currency |
e.g. ZAR |
|
Business Unit |
e.g. Actuarial / Industry / Private / Umbrella |
|
Type of Product: |
e.g. Annuity Fund / Beneficiary Fund / Retirement Fund |
|
Tax Status |
|
|
Contributions |
Approved / Unapproved |
|
If Unapproved |
Individual / Corporate / Not applicable |
|
Sector |
Control Boards / Government / Other |
|
Type of Service |
e.g. Admin Only / Full Admin |
|
Pooling Status |
e.g. Main Fund / Sub Umbrella / None / Participating Contract |
|
Priority Status |
High / Normal / Test |
|
Pension Status |
Contracted in / Contracted out |
|
Type of Launch |
New Fund / Takeover |
|
Language |
|
|
Retirement Products |
|
|
Type of Ret Product |
e.g. Pension / Provident |
|
Flexible Investment |
Y / N |
|
Underwriting Basis |
Audit Exempt / Non Audit exempt / Not applicable |
|
Details |
|
|
Code |
|
|
Name |
|
|
Short Name |
|
|
Main Product of Pool Details |
|
|
Commencement Date |
|
|
Previous Product Code |
|
|
Sponsor |
|
|
Sponsor is Principal Employer |
Y / N |
|
Principal Employer |
|
|
Basic Product Data |
|
|
Launch Date |
|
|
Financial Year End |
|
|
Apply Financial Periods to Sub-Funds |
Y / N |
|
Interest on Late Contribution Payment |
Y / N |
|
Interest from |
Transaction date / Due date |
|
Interest to |
Exit date / Realisation Date |
|
Automatic Member Registration |
Y / N |
|
Apply Fixed Switching Dates to Allocation Changes |
Y / N |
|
Investment Choice at Income Type Level |
Y / N |
|
Member Switching Restriction After Date of Joining Product |
Number of Months |
|
Free Member Switches |
|
|
per |
Anniversary yr / Calendar yr / Financial yr / Policy yr |
|
Administrator Branch |
|
|
Code |
Start Date |
Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Description (Legislative Body) |
Financial Services Board |
S.A. Revenue Services |
Commissioner of Inland Revenue |
|
Legislative Body Branch |
|
|
|
|
Registration Number |
|
|
|
|
Effective Date |
|
|
|
|
|
Person 1 |
Person 2 |
Person 3 |
|
Surname |
|
|
|
|
Initials |
|
|
|
|
First Name |
|
|
|
|
Title |
|
|
|
|
Date Of Birth |
|
|
|
|
Language |
|
|
|
|
Role of Person |
Trustee / Prin Off |
Trustee / Prin Off |
Trustee / Prin Off |
|
Date Registered |
|
|
|
|
Registration Number |
|
|
|
|
Alt Principal Officer |
Y / N |
Y / N |
Y / N |
|
Trustee Details |
|
|
|
|
Role of Trustee |
Chairman / Memb |
Chairman / Memb |
Chairman / Memb |
|
Responsibility |
|
|
|
|
Employee Rep |
Y / N |
Y / N |
Y / N |
|
Type (External Organisation unit / Natural Person) |
Financial Advisor name |
Effective Date |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Captured accounts
(These are accounts that are not selectable from the Corporate Client list, e.g. Product Bank Account)
|
|
Account 1 |
Account 2 |
Account 3 |
|||
|
Bank Details |
|
|
|
|||
|
Bank Name |
|
|
|
|||
|
Branch |
|
|
|
|||
|
Branch Code |
|
|
|
|||
|
Account Details |
|
|
|
|||
|
Account Type |
Cur/Sav/Tran |
Cur/Sav/Tran |
Cur/Sav/Tran |
|||
|
Account Number |
|
|
|
|||
|
Account Name |
|
|
|
|||
|
Mandate |
Y / N |
Y / N |
Y / N |
|||
|
Line Number |
|
|
|
|||
|
Bank Interface |
None / ACB / FNB Online / CPY / LDC / Nedbank CPS |
None / ACB / FNB Online / CPY / LDC / Nedbank CPS |
None / ACB / FNB Online / CPY / LDC / Nedbank CPS |
|||
|
Account Limits |
|
|
|
|||
|
Monthly CR |
|
|
|
|||
|
Daily CR |
|
|
|
|||
|
Transaction CR |
|
|
|
|||
|
Monthly DR |
|
|
|
|||
|
Daily DR |
|
|
|
|||
|
Transaction DR |
|
|
|
|||
|
Bank Interfaces |
|
|
|
|||
|
Process |
e.g. Distribution / Income / Switching etc. |
e.g. Distribution / Income / Switching etc. |
e.g. Distribution / Income / Switching etc. |
|||
|
Bank Interface |
e.g. ACB / Cashfocus / LDC / Nedinform / Nedbank CPS, etc. |
e.g. ACB / Cashfocus / LDC / Nedinform / Nedbank CPS, etc. |
e.g. ACB / Cashfocus / LDC / Nedinform / Nedbank CPS, etc. |
|||
|
Service Type |
One-day / two-day / five day |
One-day / two-day / five day |
One-day / two-day / five day |
|||
|
Detail Usercode |
|
|
|
|||
|
Header Usercode |
|
|
|
|||
|
Description |
|
|
|
|||
Linked accounts
(e.g. Administrator, Administrator Branch, Principal Employer, Participating Employer, Insurer, Investment Manager)
Note:
The items below will have been captured under Corporate Client, and selected for use by the Product.
|
|
Corporate Client 1 |
Corporate Client 2 |
Corporate Client 3 |
|
Organisation Details |
|
|
|
|
Account |
|
|
|
Membership Groups may be any of the following: Annuity / Benefit / Commission / Contributions / Investments / Medical Aid / Payment Day / Voluntary.
____________________Membership Group.
|
|
|
|
Code |
Description |
|
|
|
|
|
|
|
|
|
|
|
|
____________________Membership Group.
|
|
|
|
Code |
Description |
|
|
|
|
|
|
|
|
|
|
|
|
Membership Group Groupings
|
Grouping Description |
Grouping Type |
Membership Group Code |
Membership Group Description |
|
|
|
|
|
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|
|
|
|
||
|
|
|
||
|
|
|
|
|
Portfolio 1 |
Portfolio 2 |
Portfolio 3 |
|
Investment Medium Name |
|
|
|
|
Portfolio Description |
|
|
|
|
Investment Account Number |
|
|
|
|
Minimum Switch Out % |
|
|
|
|
Maximum Switch Out % |
|
|
|
|
Switch Dates |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Initial Charge % |
|
|
|
|
Net Investment Indicator |
|
|
|
Income Types
Note:
The index numbers in the first column are used elsewhere in this coding sheet to refer to these income types.
|
Index |
Income Type |
Scheme Income Type Description |
Contrib Party |
Incl. |
|
1 |
|
|
EE / ER / Other |
Y / N |
|
2 |
|
|
EE / ER / Other |
Y / N |
|
3 |
|
|
EE / ER / Other |
Y / N |
|
4 |
|
|
EE / ER / Other |
Y / N |
|
5 |
|
|
EE / ER / Other |
Y / N |
|
6 |
|
|
EE / ER / Other |
Y / N |
|
7 |
|
|
EE / ER / Other |
Y / N |
|
8 |
|
|
EE / ER / Other |
Y / N |
Income Splits
|
Index |
Income Type |
Portfolio 1 % |
Portfolio 2 % |
Portfolio 3 % |
|
|
|
% |
% |
% |
|
|
|
% |
% |
% |
|
|
|
% |
% |
% |
|
|
|
% |
% |
% |
Income Rules
Note:
The type of membership group to be linked will depend on the income type.
|
|
Income Type (Index ......) |
Income Type (Index ......) |
Income Type (Index ......) |
Income Type (Index ......) |
|
Description |
|
|
|
|
|
Frequency |
Ann/BiAnn /Mly/Quart |
Ann/BiAnn /Mly/Quart |
Ann/BiAnn /Mly/Quart |
Ann/BiAnn /Mly/Quart |
|
Base Month |
|
|
|
|
|
Regular Income |
|
|
|
|
|
Calculation Type |
%Sal / Fixed |
%Sal / Fixed |
%Sal / Fixed |
%Sal / Fixed |
|
Type of Scale |
|
|
|
|
|
Percentage of Salary |
|
|
|
|
|
Amount |
|
|
|
|
|
Min Amount |
|
|
|
|
|
Max Amount |
|
|
|
|
|
Contr Fixed at NRD |
Y / N |
Y / N |
Y / N |
Y / N |
|
Contr Cease NRD |
Y / N |
Y / N |
Y / N |
Y / N |
|
Membership Group to be linked to |
|
|
|
|
|
|
Income Type (Index ......) |
Income Type (Index ......) |
Income Type (Index ......) |
Income Type (Index ......) |
|
Description |
|
|
|
|
|
Frequency |
Ann/BiAnn /Mly/Quart |
Ann/BiAnn /Mly/Quart |
Ann/BiAnn /Mly/Quart |
Ann/BiAnn /Mly/Quart |
|
Base Month |
|
|
|
|
|
Regular Income |
|
|
|
|
|
Calculation Type |
%Sal / Fixed |
%Sal / Fixed |
%Sal / Fixed |
%Sal / Fixed |
|
Type of Scale |
|
|
|
|
|
Percentage of Salary |
|
|
|
|
|
Amount |
|
|
|
|
|
Min Amount |
|
|
|
|
|
Max Amount |
|
|
|
|
|
Contr Fixed at NRD |
Y / N |
Y / N |
Y / N |
Y / N |
|
Contr Cease NRD |
Y / N |
Y / N |
Y / N |
Y / N |
|
Membership Group to be linked to |
|
|
|
|
|
Fee Details |
|
|
Description |
|
|
Income Type |
|
|
Transaction Fee Details |
|
|
Amount |
|
|
Percentage |
|
|
Minimum Amount |
|
|
Maximum Amount |
|
Note:
There may be more than one set of retirement ages, if different for the various membership groups.
|
Gender |
M / F / Both |
M / F / Both |
M / F / Both |
|
|
Description |
|
|
|
|
|
Retirement Age |
|
|
|
|
|
Maximum late |
|
|
|
|
|
Normal (range) |
|
|
|
|
|
Early |
|
|
|
|
|
Date Calculation Basis |
|
|
|
|
|
Following |
Y / N |
Y / N |
Y / N |
|
|
Coinciding |
Y / N |
Y / N |
Y / N |
|
|
Exact |
Y / N |
Y / N |
Y / N |
|
|
Fixed Date |
(Day and Month) |
(Day and Month) |
(Day and Month) |
|
|
Benefit Membership Group to be linked to |
|
|
|
|
Note:
There could be more than one product of the same type. The product numbers are used elsewhere in this coding sheet to refer to these benefit products.
|
|
Product 1 |
Product 2 |
Product 3 |
Product 4 |
|
Description |
|
|
|
|
|
Maximum Benefit Amount |
|
|
|
|
|
Underwriter |
|
|
|
|
|
Type of Benefit * |
|
|
|
|
|
Formula Applied to ** |
|
|
|
|
|
Formula Type** |
|
|
|
|
|
Type of Scale ** |
|
|
|
|
|
Type of Result ** |
|
|
|
|
|
Payment Type ** |
|
|
|
|
|
Purchase from Underwriter |
|
|
|
|
|
Calculation method ** |
|
|
|
|
|
Guarantee Period |
|
|
|
|
|
Rounding Method ** |
|
|
|
|
|
Number of Decimals |
|
|
|
|
|
Policy Date |
|
|
|
|
|
Policy No. |
|
|
|
|
|
Date Signed |
|
|
|
|
|
|
Product 5 |
Product 6 |
Product 7 |
Product 8 |
|
Description |
|
|
|
|
|
Maximum Benefit Amount |
|
|
|
|
|
Underwriter |
|
|
|
|
|
Type of Benefit * |
|
|
|
|
|
Formula Applied to ** |
|
|
|
|
|
Formula Type** |
|
|
|
|
|
Type of Scale ** |
|
|
|
|
|
Type of Result ** |
|
|
|
|
|
Payment Type ** |
|
|
|
|
|
Purchase from Underwriter |
|
|
|
|
|
Calculation method ** |
|
|
|
|
|
Guarantee Period |
|
|
|
|
|
Rounding Method ** |
|
|
|
|
|
Number of Decimals |
|
|
|
|
|
Policy Date |
|
|
|
|
|
Policy No. |
|
|
|
|
|
Date Signed |
|
|
|
|
* BENEFIT PRODUCT TYPES
|
ADB |
Accident Death Benefit |
|
STD |
Standard Benefit – Scheme Credit |
|
DDB |
Dread Disease Benefit |
|
DIS |
Disability Benefit |
|
FAM |
Family Cover – Funeral Benefit |
|
DISL |
Lump Sum Disability |
|
GLA |
Group Life Assurance Benefit |
|
DISP |
Partial Disability |
|
GLE |
Separate Group Life Benefit |
|
DIST |
Temporary Disability |
|
HLN |
Home Loan Guarantee |
|
DTH |
Death |
|
PHI |
PHI Benefit |
|
FAS |
Final Av Sal |
|
PUP |
Paid-up Benefit |
|
FUN |
Funeral Benefit |
|
REF |
Refund of Contributions |
|
MIR |
Minimum Individual Reserve |
|
SCP |
Spouse and Children Benefit |
|
etc. |
To be defined as required |
** AVAILABLE OPTIONS
|
Formula Type |
Formula Applied To |
Type of Scale |
|
Amount |
|
Age Months |
|
Percentage |
Monthly Salary |
Age |
|
Factor |
|
Age Years |
|
Calc Type |
|
Agenear-yrdob |
|
Calctypeloop |
|
Months |
|
etc. |
|
Service |
|
|
|
Service Months |
|
|
|
Service Years |
|
|
Annuity Amt Benefit Amt Conversion Initial Inv Amt Market Value Membership Payment Request Risk Salary Salary Annualised Cons |
Sliding Scale |
|
|
etc. |
Years After NRD |
|
|
|
Years to NRD |
|
|
|
Date Greater |
|
|
|
Date Less |
|
|
|
Shift |
|
|
|
YY After NRD |
|
|
|
Rate Table |
|
|
|
etc. |
|
Type of Result |
Payment Type |
Calculation Method |
|
Amount |
Annuity |
Added Years |
|
Factor |
Cash |
GMP Revaluation |
|
Months |
Living Annuity |
Age CAPITAL BUDGET |
|
Years |
Transfer |
DOX-DJF |
|
etc. |
etc. |
DOX-ERD |
|
|
|
DOX-GMPA |
|
|
|
DOX-LRD |
|
|
|
DOX-NRD |
|
|
|
DOX-PHI |
|
|
|
DOX-SP DEATH |
|
|
|
SPA |
|
|
|
GMP Revaluation |
|
|
|
GMPA Revaluation |
|
|
|
HIGHESTYRAVG |
|
|
|
Interpolate |
|
|
|
Interpolate 2D |
|
|
|
Interpolate |
|
|
|
Highestyravg |
|
|
|
Added Years |
|
|
|
Invstmt no unit |
|
|
|
Invstmt unit |
|
|
|
Prephi |
|
|
|
Service Hours |
|
|
|
Tax Amount |
|
|
|
Tax Rate |
|
|
|
etc. |
|
Rounding Method |
Purchase from Underwriter |
Accounting Process |
|
Exact |
Always |
Benefit Deficit |
|
Round Down |
Never |
Capital Value |
|
Round Up |
Sometimes |
Fund Profit |
|
Round Normal |
|
Risk Adjust Pos |
|
Yrs / Mnths next |
|
etc. |
|
etc. |
|
|
Note:
The index numbers in the second column are used as an optional secondary index to number the scales within the products.
|
Ben Prod Index No. / Description |
Scale of Ben Index No. |
Scheme Income Type |
Percentage Amount Multiple |
From |
To |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Note:
Only for those benefit products where EOH is applicable.
|
Ben Prod Index No. / Description |
EOH Limit Amount
|
EOH Indicator (based on Sal / Cover) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ben Prod |
Table Type |
NRA |
Age |
Male Factor |
Female Factor |
|
|
|
|
|
||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|
||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|
||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
Table Type Options
MIN BEN ANNUITY
COMMUTATION
ANNUITY CAP VAL
ANNUITY PEN AMT
|
Ben Product |
|
|
Scheme Income Type |
|
|
Type of Dismemberment |
|
|
Calculation Parameter |
|
|
Classification |
|
|
Type of Dependant |
|
|
% per Type of Dependant |
|
|
% per Dependant |
|
|
Amount |
|
|
Average Period |
|
|
Factor |
|
|
Age/Service/Amount |
|
|
From |
|
|
To |
|
|
Reserve Guaranteed (Y / N) |
|
AVAILABLE OPTIONS
|
Calculation Parameters |
Type of Dependant |
Classification |
|
BANK FACTOR |
DEPENDANT |
STATE PENSION |
|
EQUALISATION |
SPOUSE |
PENSION |
|
FULL TIME |
|
BACKDATED |
|
MAXIMUM SERVICE |
|
SPOUSE PENSION |
|
PART TIME |
|
BOUGHT EXCESS |
|
STATE COM FACT |
|
TRANSFER |
|
ETC |
|
PROTECTED CASH |
|
|
|
BASIC |
|
|
|
ANNUAL ALLOWANCE |
|
|
|
REFUND |
|
|
|
LUMPSUM |
|
|
|
TOTAL COMM |
|
Benefit Product
|
|
|
Benefit Event |
|
|
Service Definition |
|
|
Final Average Period |
|
|
Normal Pension Definition |
|
|
Minimum Service |
|
|
Early Retirement / Death |
|
|
Minimum Service |
|
|
Reduction % |
|
|
% (simple) for each year |
|
|
Ill-Health Retirement |
|
|
% of service to NRD |
|
|
Reduction % |
|
|
% (simple) for each year |
|
|
Late Retirement |
|
|
Accrual continuation after NRD (Y / N) |
|
|
Salary averaged at |
|
|
Accrual Increase % |
|
|
Applicable for service from |
|
AVAILABLE OPTIONS
|
Benefit Event |
Service Definition |
Salary Averaged At |
|
NORMAL |
YRS/MNTHS LAST |
LRD & NRD |
|
EARLY |
ROUND UP |
NRD ONLY |
|
ILL-HEALTH |
ROUND DOWN 0.05 |
LRD ONLY |
|
LATE |
ETC |
|
|
DEATH DIVORCE |
|
|
Applicable for Service From
DOE – NRD
NRD – LRD
DOE – LRD
|
Event * |
Benefit Membership Group |
Ben Prod Index No. / Description |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
* EVENTS
|
Death - of Member - of Spouse - of Child - etc. |
Disability - Disability - Permanent Health Insurance - etc. |
|
Retiral - Normal - Early - Ill-health - etc. |
Withdrawal - Resignation - Retrenchment - Dismissal - etc. |
Note:
Provide the appropriate rule sets, as required for the product.
|
Rule Set to select |
|
Note:
Bank account rules are completed only for relevant accounting activities for the product.
|
|
Account Activity 1 |
Account Activity 2 |
Account Activity 3 |
|
|
Process/Activity / |
Process/Activity / |
Process/Activity / |
|
Bank Rule Subject |
|
|
|
|
Scheme Income Type |
|
|
|
|
Portfolio |
|
|
|
|
Pay Centre |
|
|
|
|
Bank Account |
|
|
|
|
To Account |
|
|
|
|
From Account |
|
|
|
|
Effective Date |
|
|
|
|
|
Account Activity 4 |
Account Activity 5 |
Account Activity 6 |
|
|
Process/Activity / |
Process/Activity / |
Process/Activity / |
|
Bank Rule Subject |
|
|
|
|
Scheme Income Type |
|
|
|
|
Portfolio |
|
|
|
|
Pay Centre |
|
|
|
|
Bank Account |
|
|
|
|
To Account |
|
|
|
|
From Account |
|
|
|
|
Effective Date |
|
|
|
|
|
Account Activity 7 |
Account Activity 8 |
Account Activity 9 |
|
|
Process/Activity / |
Process/Activity / |
Process/Activity / |
|
Bank Rule Subject |
|
|
|
|
Scheme Income Type |
|
|
|
|
Portfolio |
|
|
|
|
Pay Centre |
|
|
|
|
Bank Account |
|
|
|
|
To Account |
|
|
|
|
From Account |
|
|
|
|
Effective Date |
|
|
|
|
Diary Date Description |
Frequency |
Base Date |
Non-Compliance Risk |
|
|
Ad hoc/Ann/Mly |
|
|
|
|
Ad hoc/Ann/Mly |
|
|
|
|
Ad hoc/Ann/Mly |
|
|
|
|
Ad hoc/Ann/Mly |
|
|