Tags for Contributions

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.