| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 23 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 23 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 23 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 23 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 23 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 24 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 23 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
8 | P2IE_CPRSI | HR IE: Irish Payroll PRSI Cumulation Table | 13 | ERCON | Total ER PRSI Contribution | decimal | 15 | 2 | | |
9 | P2IE_PRSI | Payroll Result: PRSI (IE) | 11 | ERCON | Total ER PRSI Contribution | decimal | 11 | 2 | | |
10 | P2NZ_KIWCO | Kiwi Saver and Complying Fund Details | 11 | ERCON | Employer Contribution Amount | decimal | 15 | 2 | | |
11 | P2RR_CAW | Payroll Results: Table for CPF on AW/SG | 25 | ERCON | Constant for Employer Contribution to CPF | decimal | 9 | 3 | | |
TOPBenefits |
12 | T5UBD | To be deleted - no longer used! | 8 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
13 | T5UBG | Benefit Flexible Spending Account | 13 | ERCON | Benefit Employer Flexible Spending Account Contribution | nvarchar | 4 | 0 | | |
14 | T5UBX | To be deleted - no longer used! | 3 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
15 | T5UCX | To be deleted - no longer used! | 4 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
16 | T74FD | Benefit Savings Plan | 8 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
17 | T74FE | Benefit employer contribution rule variant | 4 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
18 | T74FF | Benefit employer contribution rule | 4 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
19 | T74FL | Benefit miscellaneous plan | 12 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
20 | T74GE | Benefit employer contribution rule variant texts | 5 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
21 | T74HD | Benefit stock purchase plan | 7 | ERCON | Employer's Benefits Contribution Variant | nvarchar | 4 | 0 | | |
TOPChina |
22 | T7CN20 | Contribution base | 21 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | |
TOPIndia |
23 | T7INO1 | One Day Salary Deduction | 8 | ERCON | Employer Contribution (Y/N) | nvarchar | 1 | 0 | | |
TOPPublic Sector |
24 | T5PBSR2D | SI contr. table for Govt Non-pensionable Employees | 30 | ERCON | Constant for Employer Contribution to CPF | decimal | 9 | 3 | | |
25 | T5PBSR2E | PR contr. table for Govt. non-pensionable employees. | 33 | ERCON | Constant for Employer Contribution to CPF | decimal | 9 | 3 | | |
TOPSingapore |
26 | T5R1C | CPF Contribution rate of Soc. Insurance / SG | 28 | ERCON | Constant for Employer Contribution to CPF | decimal | 9 | 3 | | |
27 | T5R1G | Contr. rates for convers. to CPF scheme on change of PR | 24 | ERCON | Constant for Employer Contribution to CPF | decimal | 9 | 3 | | |