| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 15 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 15 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 15 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 15 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 15 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 16 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 15 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
8 | P2IE_CPRSI | HR IE: Irish Payroll PRSI Cumulation Table | 12 | EECON | Total EE PRSI Contributions | decimal | 15 | 2 | | |
9 | P2IE_PRSI | Payroll Result: PRSI (IE) | 10 | EECON | Total EE PRSI Contributions | decimal | 11 | 2 | | |
10 | P2NZ_KIWCO | Kiwi Saver and Complying Fund Details | 10 | EECON | Employee Contribution Amount | decimal | 15 | 2 | | |
11 | P2RR_CAW | Payroll Results: Table for CPF on AW/SG | 24 | EECON | Constant for Employee Contribution to CPF | decimal | 9 | 3 | | |
TOPBenefits |
12 | T74FD | Benefit Savings Plan | 9 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | |
13 | T74FG | Benefit employee contribution rule variant | 4 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | |
14 | T74FH | Benefit employee contribution rule | 4 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | |
15 | T74FL | Benefit miscellaneous plan | 11 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | |
16 | T74GG | Benefit employee contribution rule variant texts | 5 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | |
17 | T74HD | Benefit stock purchase plan | 6 | EECON | Benefit Employee Contribution Rule Variant | nvarchar | 4 | 0 | | |
TOPChina |
18 | T7CN20 | Contribution base | 13 | EECON | Employee contribution constant | decimal | 13 | 2 | | |
TOPPublic Sector |
19 | T5PBSR2D | SI contr. table for Govt Non-pensionable Employees | 29 | EECON | Constant for Employee Contribution to CPF | decimal | 9 | 3 | | |
20 | T5PBSR2E | PR contr. table for Govt. non-pensionable employees. | 32 | EECON | Constant for Employee Contribution to CPF | decimal | 9 | 3 | | |
TOPSingapore |
21 | T5R1C | CPF Contribution rate of Soc. Insurance / SG | 27 | EECON | Constant for Employee Contribution to CPF | decimal | 9 | 3 | | |
22 | T5R1G | Contr. rates for convers. to CPF scheme on change of PR | 23 | EECON | Constant for Employee Contribution to CPF | decimal | 9 | 3 | | |