The document tag values in the table below have been added for the Contributions section of the Admin Report and associated to the PDF Process Type of ADMREP CONTRIBS:
Field Tag |
Description |
System Value |
CNTRALLOCTION01 |
Employer contributions received Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is RCS. |
CNTRALLOCTION02 |
Employer contributions received Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is RCS. |
CNTRALLOCTION03 |
Employer contributions received Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is RCS. |
CNTRALLOCTION04 |
Employer contributions received Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is RCS. |
CNTRALLOCTION05 |
Employer contributions received Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is RCS. |
CNTRALLOCTION06 |
Employer contributions received Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is RCS. |
CNTRALLOCTION07 |
Employee contributions received Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is ECS. |
CNTRALLOCTION08 |
Employee contributions received Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is ECS. |
CNTRALLOCTION09 |
Employee contributions received Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is ECS. |
CNTRALLOCTION10 |
Employee contributions received Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is ECS. |
CNTRALLOCTION11 |
Employee contributions received Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is ECS. |
CNTRALLOCTION12 |
Employee contributions received Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is ECS. |
CNTRALLOCTION13 |
Voluntary contributions received Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is not RCS or ECS. |
CNTRALLOCTION14 |
Voluntary contributions received Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is not RCS or ECS. |
CNTRALLOCTION15 |
Voluntary contributions received Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is not RCS or ECS. |
CNTRALLOCTION16 |
Voluntary contributions received Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is not RCS or ECS. |
CNTRALLOCTION17 |
Voluntary contributions received Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is not RCS or ECS. |
CNTRALLOCTION18 |
Voluntary contributions received Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is CONTRIBALLOC or DEPCONTRIB and the Income Type code is not RCS or ECS. |
CNTRALLOCTION19 |
Total contributions received Month01 |
CNTRALLOCTION01 + CNTRALLOCTION07 + CNTRALLOCTION13 |
CNTRALLOCTION20 |
Total contributions received Month02 |
CNTRALLOCTION02 + CNTRALLOCTION08 + CNTRALLOCTION14 |
CNTRALLOCTION21 |
Total contributions received Month03 |
CNTRALLOCTION03 + CNTRALLOCTION09 + CNTRALLOCTION15 |
CNTRALLOCTION22 |
Total contributions received Month04 |
CNTRALLOCTION04 + CNTRALLOCTION10 + CNTRALLOCTION16 |
CNTRALLOCTION23 |
Total contributions received Month05 |
CNTRALLOCTION05 + CNTRALLOCTION11 + CNTRALLOCTION17 |
CNTRALLOCTION24 |
Total contributions received Month06 |
CNTRALLOCTION06 + CNTRALLOCTION12 + CNTRALLOCTION18 |
CNTRALLOCTION25 |
Administration fees Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s FEEPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOFEEO. |
CNTRALLOCTION26 |
Administration fees Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s FEEPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOFEEO. |
CNTRALLOCTION27 |
Administration fees Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s FEEPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOFEEO. |
CNTRALLOCTION28 |
Administration fees Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s FEEPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOFEEO. |
CNTRALLOCTION29 |
Administration fees Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s FEEPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOFEEO. |
CNTRALLOCTION30 |
Administration fees Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s FEEPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOFEEO. |
CNTRALLOCTION31 |
Contingency reserve Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s OPERATRESMOV account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFRESERVE. |
CNTRALLOCTION32 |
Contingency reserve Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s OPERATRESMOV account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFRESERVE. |
CNTRALLOCTION33 |
Contingency reserve Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s OPERATRESMOV account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFRESERVE. |
CNTRALLOCTION34 |
Contingency reserve Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s OPERATRESMOV account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFRESERVE. |
CNTRALLOCTION35 |
Contingency reserve Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s OPERATRESMOV account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFRESERVE. |
CNTRALLOCTION36 |
Contingency reserve Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s OPERATRESMOV account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFRESERVE. |
CNTRALLOCTION37 |
Group life premiums Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION38 |
Group life premiums Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION39 |
Group life premiums Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION40 |
Group life premiums Month04 |
The sum of the amounts for the fouth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION41 |
Group life premiums Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION42 |
Group life premiums Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION43 |
Disability Income Premiums Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION44 |
Disability Income Premiums Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION45 |
Disability Income Premiums Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION46 |
Disability Income Premiums Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION47 |
Disability Income Premiums Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION48 |
Disability Income Premiums Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION49 |
Spouse cover Premiums Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION50 |
Spouse cover Premiums Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION51 |
Spouse cover Premiums Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION52 |
Spouse cover Premiums Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION53 |
Spouse cover Premiums Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION54 |
Spouse cover Premiums Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION55 |
Funeral Benefit Premiums Month01 |
The sum of the amounts for the first month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION56 |
Funeral Benefit Premiums Month02 |
The sum of the amounts for the second month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION57 |
Funeral Benefit Premiums Month03 |
The sum of the amounts for the third month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION58 |
Funeral Benefit Premiums Month04 |
The sum of the amounts for the fourth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION59 |
Funeral Benefit Premiums Month05 |
The sum of the amounts for the fifth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION60 |
Funeral Benefit Premiums Month06 |
The sum of the amounts for the sixth month in the report period for the Business Transactions in the Scheme’s PREMPAYABLE account with a Transaction Date greater than or equal to the first day of the report period month and less than or equal to the last day of the report period month and for which the Accounting Activity is SFNOPRMO or per Expense Type. |
CNTRALLOCTION61 |
Net contributions Month01 |
CNTRALLOCTION19 - CNTRALLOCTION25 - CNTRALLOCTION31 - CNTRALLOCTION37 - CNTRALLOCTION43 - CNTRALLOCTION49 - CNTRALLOCTION55 |
CNTRALLOCTION62 |
Net contributions Month02 |
CNTRALLOCTION20 - CNTRALLOCTION26 - CNTRALLOCTION32 - CNTRALLOCTION38 - CNTRALLOCTION44 – CNTRALLOCTION50 - CNTRALLOCTION56 |
CNTRALLOCTION63 |
Net contributions Month03 |
CNTRALLOCTION21 - CNTRALLOCTION27 - CNTRALLOCTION33 - CNTRALLOCTION39 - CNTRALLOCTION45 – CNTRALLOCTION51 - CNTRALLOCTION57 |
CNTRALLOCTION64 |
Net contributions Month04 |
CNTRALLOCTION22 - CNTRALLOCTION28 - CNTRALLOCTION34 – CNTRALLOCTION40 - CNTRALLOCTION46 – CNTRALLOCTION52 - CNTRALLOCTION58 |
CNTRALLOCTION65 |
Net contributions Month05 |
CNTRALLOCTION23 - CNTRALLOCTION29 - CNTRALLOCTION35 – CNTRALLOCTION41 - CNTRALLOCTION47 – CNTRALLOCTION53 - CNTRALLOCTION59 |
CNTRALLOCTION66 |
Net contributions Month06 |
CNTRALLOCTION24 – CNTRALLOCTION30 - CNTRALLOCTION36 – CNTRALLOCTION42 - CNTRALLOCTION48 – CNTRALLOCTION54 – CNTRALLOCTION60 |
CNTRALLOCTION67 |
Contributions Allocation header Month01 |
The header for the first month in the report period. |
CNTRALLOCTION68 |
Contributions Allocation header Month02 |
The header for the second month in the report period. |
CNTRALLOCTION69 |
Contributions Allocation header Month03 |
The header for the third month in the report period. |
CNTRALLOCTION70 |
Contributions Allocation header Month04 |
The header for the fourth month in the report period. |
CNTRALLOCTION71 |
Contributions Allocation header Month05 |
The header for the fifth month in the report period. |
CNTRALLOCTION72 |
Contributions Allocation header Month06 |
The header for the sixth month in the report period. |
CONTRBSRECINV01 |
Pay Centre |
The Pay Centres for the Business Transactions and Accounting Activities in: CONTRBSRECINV02 CONTRBSRECINV03 CONTRBSRECINV04 CONTRBSRECINV05 |
CONTRBSRECINV02 |
Date Contributions Received for December |
The Transaction Date of the Business Transactions with an Accounting Activity of CONTRIBALLOC or DEPOSITCONTR per Pay Centre with a Due Date month equal to the month prior to the report To Date. |
CONTRBSRECINV03 |
Date Schedule Received |
The Start Date for the Service Request with a Process of CONTRIBUTIONS and an Activity of REC MEMBER DATA and with a Due Date equal to the month prior to the report To Date, for each Pay Centre. |
CONTRBSRECINV04 |
Amount Received |
The sum of the amounts for the Business Transactions with an Accounting Activity of CONTRIBALLOC or DEPOSITCONTR per Pay Centre with a Due Date month equal to the month prior to the report To Date. |
CONTRBSRECINV05 |
Date Invested |
The Transaction Dates for the Business Transactions with an Accounting Activity of INVESTMENT or INVESTRANS-A per Pay Centre with a Due Date month equal to the month prior to the report To Date. |
CONTRIBRATES01 |
Current description |
The Description on the latest Income and Expense Rules for which the End Date is null or greater than the report To Date linked to the Income Types for which the Global Group Type is FEE, RISK PREMIUM, FEE EXPENSE or PREMIUM EXPENSE. |
CONTRIBRATES02 |
Current Rate |
The current rate using the following criteria where the End Date is null or greater than the report To Date linked to the Income Types:
the value for the rate as x.xx% of Salary where x.xx equals the value for Percentage, if it is an Income Rule and the value for Formula Type is % of SALARY.
the value for the rate as x.xx per member where x.xx equals the value for Amount, if it is an Income Rule and the value for Formula Type is FIXED AMOUNT.
the value for the rate as x.xx% of Salary where x.xx equals the value for Percentage., if it is an Expense Rule and the value for Formula Type is PERCENTAGE and the value for Formula Applied To is SALARY or RISK SALARY
the value for the rate as x.xx% of Cover where x.xx equals the value for Percentage, if it is an Expense Rule and the value for Formula Type is PERCENTAGE and the value for Formula Applied To is COVER.
The value for the rate as x.xx% of Investment Value where x.xx equals the value for Percentage, if it is an Expense Rule and the value for Formula Type is PERCENTAGE and the value for Formula Applied To is MARKET VALUE.
The value for the rate as x.xx per member where x.xx equals the value for Amount, if it is an Expense Rule and the value for Formula Type is AMOUNT. |
CONTRIBRATES03 |
Current free Cover Limit |
The Amount on the Risk Product EOH Limit record linked to the Benefit Product for the Income Types with a Global Group Type of RISK PREMIUM linked to the Income Rules and the Expense Types with a Global Group Type of PREMIUM EXPENSE linked to the Expense Rules. |
CONTRIBRATES04 |
Current Service Provider |
The Insurer on the Benefit Product for the Income Types with a Global Group Type of RISK PREMIUM linked to the Income Rules and the Expense Types with a Global Group Type of PREMIUM EXPENSE linked to the Expense Rules. |
CONTRIBRATES05 |
Future Description |
The Description on the latest Income and Expense Rules for which the Start Date is greater than the report To Date linked to the Income Types for which the Global Group Type is FEE, RISK PREMIUM, FEE EXPENSE or PREMIUM EXPENSE. |
CONTRIBRATES06 |
Future Effective Date |
The date of the latest Income and Expense Rules for which the Start Date is greater than the report To Date linked to the Income Types for which the Global Group Type is FEE, RISK PREMIUM, FEE EXPENSE or PREMIUM EXPENSE. |
CONTRIBRATES07 |
Future Rate |
The future rate using the following criteria where the Start Date is greater than the report To Date linked to the Income Types:
the value for the rate as x.xx% of Salary where x.xx equals the value for Percentage, if it is an Income Rule and the value for Formula Type is % of SALARY.
The value for the rate as x.xx per member where x.xx equals the value for Amount, if it is an Income Rule and the value for Formula Type is FIXED AMOUNT.
the value for the rate as x.xx% of Salary where x.xx equals the value for Percentage., if it is an Expense Rule and the value for Formula Type is PERCENTAGE and the value for Formula Applied To is SALARY or RISK SALARY
The value for the rate as x.xx% of Cover where x.xx equals the value for Percentage, if it is an Expense Rule and the value for Formula Type is PERCENTAGE and the value for Formula Applied To is COVER.
The value for the rate as x.xx% of Investment Value where x.xx equals the value for Percentage, if it is an Expense Rule and the value for Formula Type is PERCENTAGE and the value for Formula Applied To is MARKET VALUE.
The value for the rate as x.xx per member where x.xx equals the value for Amount, if it is an Expense Rule and the value for Formula Type is AMOUNT. |
CONTRIBRATES08 |
Future free Cover Limit |
The Amount on the Risk Product EOH Limit record linked to the Benefit Product for the Income Types with a Global Group Type of RISK PREMIUM linked to the Income Rules and the Expense Types with a Global Group Type of PREMIUM EXPENSE linked to the Expense Rules. |
CONTRIBRATES09 |
Future Service provider |
The Insurer on the Benefit Product for the Income Types with a Global Group Type of RISK PREMIUM linked to the Income Rules and the Expense Types with a Global Group Type of PREMIUM EXPENSE linked to the Expense Rules. |
CONTRIBRATES10 |
Employee contribution rate 1 |
The current Employee contribution rate on the latest Income Rules for which the End Date is null for each of the Income Types with a Global Group Type of CONTRIBUTIONS and for which the value for Income Regularity is R (Regular) and the value for Income Optionality is M (Mandatory) and the value for Contributing Party on the Scheme Income Type is EMPLOYEE. |
CONTRIBRATES11 |
Employee contribution rate 2 |
The current Employee contribution rate on the latest Income Rules for which the End Date is null for each of the Income Types with a Global Group Type of CONTRIBUTIONS and for which the value for Income Regularity is R (Regular) and the value for Income Optionality is M (Mandatory) and the value for Contributing Party on the Scheme Income Type is EMPLOYEE. |
CONTRIBRATES12 |
Employer contribution rate 1 |
The current Employer contribution rate on the latest Income Rules for which the End Date is null for each of the Income Types with a Global Group Type of CONTRIBUTIONS and for which the value for Income Regularity is R (Regular) and the value for Income Optionality is M (Mandatory) and the value for Contributing Party on the Scheme Income Type is EMPLOYER. |
CONTRIBRATES13 |
Employer contribution rate 2 |
The current Employer contribution rate on the latest Income Rules for which the End Date is null for each of the Income Types with a Global Group Type of CONTRIBUTIONS and for which the value for Income Regularity is R (Regular) and the value for Income Optionality is M (Mandatory) and the value for Contributing Party on the Scheme Income Type is EMPLOYER. |
CONTRIBS YTD01 |
Contributions received for the period desc |
The Description on the latest Business Transactions in the Scheme’s CONTRECVABLE account with an Accounting Activity of CONTRIBALLOC or DEPOSITCONTR with a Transaction Date less than or equal to the report To Date and greater than or equal to the report From Date. |
CONTRIBS YTD02 |
Contributions received for the period value |
The sum of the amounts for the Business Transactions in the Scheme’s CONTRECVABLE account with an Accounting Activity of CONTRIBALLOC or DEPOSITCONTR with a Transaction Date less than or equal to the report To Date and greater than or equal to the report From Date. |
CONTRIBS YTD03 |
Contributions received for the year to date desc |
The Description on the latest Business Transactions in the Scheme’s CONTRECVABLE account with an Accounting Activity of CONTRIBALLOC or DEPOSITCONTR with a Transaction Date less than or equal to the report To Date and greater than or equal to the first day of the month following the Scheme’s financial year end. |
CONTRIBS YTD04 |
Contributions received for the year to date value |
The sum of the amounts for the Business Transactions in the Scheme’s CONTRECVABLE account with an Accounting Activity of CONTRIBALLOC or DEPOSITCONTR with a Transaction Date less than or equal to the report To Date and greater than or equal to the first day of the month following the Scheme’s financial year end. |
CONTRIBS YTD05 |
Average contribution per member |
The value for the Contributions received for the report period divided by the number of Memberships, where the number of Memberships is for which the CAR End Date is null or greater than the report To Date and the CAR Start Date is less than the report To Date and the Membership Status is LIVE or EXIT IN PROCESS. |
SECT13ACOMPL01 |
Num Pay Centres for which the deposits were received after Cutoff date |
The number of Pay Centre for which the Transaction Date is after the cut-off date by determining if the Transaction Date is greater than Due Date plus the value for CUT-OFF DAY, or the next working day if the result is a non-working day. |
SECT13ACOMPL02 |
Num Pay Centres for which contrib schedules were received after Cutoff date |
The number of Pay Centres where the number of days between the Due Date and the Start Date on the Service Request or the between the Cycle Date and the DTEPAYROLLCOMPDATE is greater than the MEMDATA CUT-OFF value for the Due Date on the Service Request or the DTEPAYROLLCOMPDATE on the Cycle Control record. |
SECT13ACOMPL03 |
Num of Pay Centres for which the schedules do not match the deposits |
The number of Pay Centres for which there is a difference between the following:
· The sum of the amounts per pay Centre where the Business Transactions in the Scheme’s CONTRECVABLE account with a Due Date month equal to the report period month and for which the Accounting Activity is CONTRIBALLOC, CONTALLOCREV, DEPCONTRIB or DEPCONTRREV. · The sum of the amounts per pay Centre where the Business Transactions in the Scheme’s CONTRECVABLE account with a Due Date month equal to the report period month and for which the Accounting Activity is SFNOEFTP, SFNOEFTPREV, EXITCONNOEFT or EXCONNOEFTNG. |
SECT13ACOMPL04 |
Num of Pay Centres for which the deposit is less than the contribution |
The number of Pay Centres for which the value for 1 is less than the value for 2 below, for each month in the report period: 1. The sum of the amounts per Pay Centre for each month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Due Date month equal to the report period month and for which the Accounting Activity is CONTRIBALLOC, CONTALLOCREV, DEPCONTRIB or DEPCONTRREV. 2. The sum of the amounts per Pay Centre for each month in the report period for the Business Transactions in the Scheme’s CONTRECVABLE account with a Due Date month equal to the report period month and for which the Accounting Activity is SFNOEFTP, SFNOEFTPREV, EXITCONNOEFT or EXCONNOEFTNG. |