Entity CPFProgression

Description of Entity CPFProgression

Tax and Statutory contribution policies vary from time to time as the Government responds to different economic and social factors. Changes, if any, are gradual and implemented in phases or stages. The Payroll Module is designed around these factors.

The Central Provident Fund (CPF) is quite comprehensive with 3 stages:
- The different rates for each type of residency are created in CPF tables. It is similar to the CPR rates table seen in the CPF booklets
- Different CPF tables are then assembled into a CPF policy
- The CPF policy is then tied to an effective date according to the Government regulation

You can also create your own set of CPF tables.

This entity can be used for:
- Assigning a CPF policy to employees who have obtained permanent residency status
- Making a CPF policy change to one or more employees
- Setting MAW Limits


List of all Dependencies of the Entity CPFProgression

Name

Code

Class Name

Relation_79333

Relation_79333

Reference


List of Attributes of the Entity CPFProgression

Name

Code

EmployeeSysId

EmployeeSysId

Effective Date

CPFEffectiveDate

Career Code

CPFCareerId

CPF Policy

CPFProgPolicyId

Current

CPFProgCurrent

CPF Account No

CPFProgAccountNo

CPF Scheme

CPFProgSchemeId

CPFMAWOption

CPFMAWOption

MAW Limit

CPFMAWLimit

Remarks

CPFProgRemarks

Ordinary Wage per Period (exclude Total Wage)

CPFMAWPeriodOrdWage

Medisave Paid By Employer

CPFMedisavePaidByER


Entity Attribute EmployeeSysId of the Entity CPFProgression

Card of Attribute EmployeeSysId of the Entity CPFProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity CPFProgression

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


Entity Attribute Effective Date of the Entity CPFProgression

Card of Attribute Effective Date of the Entity CPFProgression

Name

Effective Date

Code

CPFEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity CPFProgression

Shows the effective date of the CPF progression. It also holds the primary key for the CPFProgression table.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Career Code of the Entity CPFProgression

Card of Attribute Career Code of the Entity CPFProgression

Name

Career Code

Code

CPFCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity CPFProgression

Shows the identity of the career for the employee.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute CPF Policy of the Entity CPFProgression

Card of Attribute CPF Policy of the Entity CPFProgression

Name

CPF Policy

Code

CPFProgPolicyId

Data Type

char(20)

Mandatory

No


Description of Attribute CPF Policy of the Entity CPFProgression

Shows the identity of the CPF Policy.


Entity Attribute Current of the Entity CPFProgression

Card of Attribute Current of the Entity CPFProgression

Name

Current

Code

CPFProgCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Current of the Entity CPFProgression

Shows if the employee is currently employed in that company.


Entity Attribute CPF Account No of the Entity CPFProgression

Card of Attribute CPF Account No of the Entity CPFProgression

Name

CPF Account No

Code

CPFProgAccountNo

Data Type

char(30)

Mandatory

No


Description of Attribute CPF Account No of the Entity CPFProgression

Stores the CPF account number of the employee.


Entity Attribute CPF Scheme of the Entity CPFProgression

Card of Attribute CPF Scheme of the Entity CPFProgression

Name

CPF Scheme

Code

CPFProgSchemeId

Data Type

char(20)

Mandatory

No


Description of Attribute CPF Scheme of the Entity CPFProgression

Shows the identity of the CPF scheme.
Example: Pension / NonPension / Private etc


Entity Attribute CPFMAWOption of the Entity CPFProgression

Card of Attribute CPFMAWOption of the Entity CPFProgression

Name

CPFMAWOption

Code

CPFMAWOption

Data Type

smallint

Mandatory

No


Description of Attribute CPFMAWOption of the Entity CPFProgression

Shows the minimum additional wage option.


Entity Attribute MAW Limit of the Entity CPFProgression

Card of Attribute MAW Limit of the Entity CPFProgression

Name

MAW Limit

Code

CPFMAWLimit

Data Type

double

Mandatory

No


Description of Attribute MAW Limit of the Entity CPFProgression

Shows the minimum additional wage for the CPF.


Entity Attribute Remarks of the Entity CPFProgression

Card of Attribute Remarks of the Entity CPFProgression

Name

Remarks

Code

CPFProgRemarks

Data Type

char(255)

Mandatory

No


Description of Attribute Remarks of the Entity CPFProgression

Stores any remarks about the CPF progression.


Entity Attribute Ordinary Wage per Period (exclude Total Wage) of the Entity CPFProgression

Card of Attribute Ordinary Wage per Period (exclude Total Wage) of the Entity CPFProgression

Name

Ordinary Wage per Period (exclude Total Wage)

Code

CPFMAWPeriodOrdWage

Data Type

double

Mandatory

No


Description of Attribute Ordinary Wage per Period (exclude Total Wage) of the Entity CPFProgression

Shows the ordinary wage of the CPF per period.


Entity Attribute Medisave Paid By Employer of the Entity CPFProgression

Card of Attribute Medisave Paid By Employer of the Entity CPFProgression

Name

Medisave Paid By Employer

Code

CPFMedisavePaidByER

Data Type

smallint

Mandatory

No


Description of Attribute Medisave Paid By Employer of the Entity CPFProgression

Indicates, by using a checkbox, if the employee's medisave is paid by the employer. If the checkbox is ticked, the database will show "1", otherwise "0".