Sage EasyPay Data Model

Entity CPFTableCode

Description of Entity CPFTableCode

This table code is for creating new CPF tables and modifying existing ones. CPF rates are created and modified through this table.

List of all Dependencies of the Entity CPFTableCode

Relation_57523

Reference

Relation_79238

Reference

List of Attributes of the Entity CPFTableCode

CPF Table Code ID

CPFTableCodeId

CPF Residence Type ID

Ordinary Wage Capping per Period

CPFPeriodCapping

Less Than Capping

CPFLessThanCapping

Greater Than Capping (%)

CPFGreaterThanCapping

Entity Attribute CPF Table Code ID of the Entity CPFTableCode

Card of Attribute CPF Table Code ID of the Entity CPFTableCode

Name	CPF Table Code ID
Code	CPFTableCodeId
Data Type	char(20)
Mandatory	Yes

Description of Attribute CPF Table Code ID of the Entity CPFTableCode

Shows the identity of the CPF table code. This also acts as a primary key for the CPFTableCode table.

Entity Attribute CPF Residence Type ID of the Entity CPFTableCode

Card of Attribute CPF Residence Type ID of the Entity CPFTableCode

Name	CPF Residence Type ID
Code	CPFResidenceTypeId
Data Type	char(20)
Mandatory	No

Description of Attribute CPF Residence Type ID of the Entity CPFTableCode

Shows the identity of the residence type, to determine if the employee will be receiving CPF or not.
Example: Local / PR1 / EP / FW etc

Entity Attribute CPF Scheme ID of the Entity CPFTableCode

Card of Attribute CPF Scheme ID of the Entity CPFTableCode

Name	CPF Scheme ID
Code	CPFSchemeId
Data Type	char(20)
Mandatory	No

Description of Attribute CPF Scheme ID of the Entity CPFTableCode

Shows the identity of the CPF scheme.
Example: Private / Private - Full

Entity Attribute Description of the Entity CPFTableCode

Card of Attribute Description of the Entity CPFTableCode

Name	Description
Code	CPFTableDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity CPFTableCode

The CPF description.
Example:
Local Citizen - Employer 16%, Employee 20% with effect from September 1, 2012

Entity Attribute Ordinary Wage Capping per Period of the Entity CPFTableCode

Card of Attribute Ordinary Wage Capping per Period of the Entity CPFTableCode

Name	Ordinary Wage Capping per Period
Code	CPFPeriodCapping
Data Type	double
Mandatory	No

Description of Attribute Ordinary Wage Capping per Period of the Entity CPFTableCode

Shows the capping for the CPF per period.

Entity Attribute Less Than Capping of the Entity CPFTableCode

Card of Attribute Less Than Capping of the Entity CPFTableCode

Name	Less Than Capping
Code	CPFLessThanCapping
Data Type	double
Mandatory	No

Description of Attribute Less Than Capping of the Entity CPFTableCode

Shows the CPF that is less than the capping.

Entity Attribute Greater Than Capping (%) of the Entity CPFTableCode

Card of Attribute Greater Than Capping (%) of the Entity CPFTableCode

Name	Greater Than Capping (%)
Code	CPFGreaterThanCapping
Data Type	double
Mandatory	No

Description of Attribute Greater Than Capping (%) of the Entity CPFTableCode

Shows the CPF that is greater than the capping.

Home