This table contains the computed CPF information for the Sub Period Record. All statutory related data will be stored in this table.
Example: CPF Contribution / CPF Wage

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Shows the generating identity of the detail record. This is also the primary key for the PolicyRecord table.
Example: A1 / A66 / A110

Shows the Monthly Variable Component capping for every employee.
Example: Capping at "10"

Shows the year for the pay record.
Example: 2012

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.

Holds the sub period for the pay record.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet

Shows the sum of the allocated Monthly Variable Component.

Shows the sum of the allocated National Wages Council.

Shows the current Monthly Variable Component.

Shows the current National Wages Council.

Shows the previous Monthly Variable Component.

Shows the previous National Wages Council.

Shows the current ordinary wage. These wages are due pertaining to the employee's employment in that month.

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.

Shows the previous ordinary wage. These wages are due pertaining to the employee's employment in that month.

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.

Shows the ordinary contribution to the employee's CPF.

Shows the additional contribution to the employee's CPF.

Shows the ordinary contribution to the employer's CPF.

Shows the additional contribution to the employer's CPF.

Shows the CPF Wage.

Shows the mode of payment for CPF.

Shows the total contribution to the employee's CPF.

Shows the total contribution to the employer's CPF.

Shows the rate of the current National Wages Council for the number of working days.

Shows the rate of the current Monthly Variable Component for the number of working days.

Shows the rate of the previous National Wages Council for the number of working days.

Shows the rate of the previous Monthly Variable Component for the number of working days.

Stores the current back payment of the National Wages Council.

Stores the previous back payment of the National Wages Council.

Stores the current back payment of the Monthly Variable Component.

Stores the previous back payment of the Monthly Variable Component.

Shows the current mandatory contribution the employee has to make.

Shows the current voluntary contribution the employee has to make.

Shows the current mandatory contribution the employer has to make.

Shows the current voluntary contribution the employer has to make.

Shows the previous mandatory contribution the employee has to make.

Shows the previous voluntary contribution the employee has to make.

Shows the previous mandatory contribution the employer has to make.

Shows the previous voluntary contribution the employer has to make.

Shows the current mandatory wage the employee has to make.

Shows the current voluntary wage the employee has to make.

Shows the current mandatory wage the employer has to make.

Shows the current voluntary wage the employer has to make.

Shows the previous mandatory wage the employee has to make.

Shows the previous voluntary wage the employee has to make.

Shows the previous mandatory wage the employer has to make.

Shows the previous voluntary wage the employer has to make.

Shows the current taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable.

Shows the previous taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable.

Shows the current additional taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable.

Shows the previous additional taxable wage. Every tax has different regulations about the limitations to the amount of wages that can be taxable.

Shows the current tax amount.

Shows the previous tax amount.

Shows the paid current tax amount.

Shows the paid previous tax amount.

Shows the tax benefit.

Shows the current foreign National Wages Council.

Shows the previous foreign National Wages Council.

Shows the current foreign Monthly Variable Component.

Shows the previous foreign Monthly Variable Component.

Shows the allocated foreign National Wages Council.

Shows the allocated foreign Monthly Variable Component.

Shows the current foreign back pay of the National Wages Council.

Shows the previous foreign back pay of the National Wages Council.

Shows the current foreign back pay of the Monthly Variable Component.

Shows the previous foreign back pay of the Monthly Variable Component.