|
Contains a summary of the wages and wage components from all the sub period records. |
|
Name |
Code |
Class Name |
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
System generated identifier. It is blind to the user. It also holds the primary key for the Employee table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the year for the pay record. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the period for the pay record. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Calculates the Foreign Worker Levy. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Calculates the Skills Development Fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the contribution to the Foreign Worker Levy. This is related to "CalFWL". |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the contribution to the Skills Development Fund. This is related to "CalSDF". |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the current ordinary wage. These wages are due pertaining to the employee's employment in that month. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the current additional wage. These wages are not due so employees and employers must make CPF contributions based on these wages earned by the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the previous ordinary wage. These wages are due pertaining to the employee's employment in that month. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the previous additional wage. These wages are not due so employees and employers must make CPF contributions based on these wages earned by the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the additional contribution to the employee's CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the ordinary contribution to the employee's CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the ordinary contribution to the employer's CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the additional contribution to the employer's CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the actual additional employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the actual additional employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the actual ordinary employee CPF. This is the Final Calculated EE CPF for the Period which is required in the Year End IR8S. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the actual ordinary employer CPF. This is the Final Calculated ER CPF for the Period which is required in Year End IR8S. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the ordinary voluntary employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the ordinary voluntary employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the additional voluntary employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the additional voluntary employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total contribution to the employee's CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total contribution to the employer's CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the CPF Wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Skills Development Fund wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the overseas employee CPF. This attribute by default is 0 and is for the user to amend the figure. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the overseas employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total Chinese Development Assistance Council fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total Singapore Indian Development Association fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total Eurasian Community Fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total Mosque Building and Mendaki Fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total commission. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the ordinary medisave for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the additional medisave for the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the CPF status. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the CPF class. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A current ordinary wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A current additional wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A previous ordinary wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A previous additional wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A CPF wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A ordinary employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A additional employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the company's additional employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the company's additional employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's contribution limit. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's contribution option. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage contribution for the current additional wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's contribution for the previous additional wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's balance for the current additional wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's balance for the previous additional wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's balance limit. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's balance option. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A additional employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A ordinary employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A actual additional employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A actual additional employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A actual ordinary employee CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the IR8A actual ordinary employer CPF. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total Yayasan Mendaki Fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the total mosque building fund. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's balance ordinary wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the Minimum Additional Wage's contribution to the ordinary wage. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the tax category. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the marital status. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the amount of child relief a working mother gets. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the current taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the previous taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the current additional taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the previous additional taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the current tax amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the previous tax amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the paid current tax amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the paid previous tax amount. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the tax relief for EPF. This is the for the Malaysia Payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the tax relief for Zakat. This is the for the Malaysia Payroll. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the tax benefit. |
|
|
|