Sage EasyPay Data Model

Entity CPFPayment

Description of Entity CPFPayment

This allows the user to specify which sub period to pay CPF. The last sub period is always compulsory to pay CPF (for balancing).

List of all Dependencies of the Entity CPFPayment

Relation_70556

Reference

List of Attributes of the Entity CPFPayment

EmployeeSysId

CPF Payment Sub Period

CPFPaymentSubPeriod

CPF Payment Option

CPFPaymentOption

Entity Attribute EmployeeSysId of the Entity CPFPayment

Card of Attribute EmployeeSysId of the Entity CPFPayment

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity CPFPayment

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

Entity Attribute CPF Payment Sub Period of the Entity CPFPayment

Card of Attribute CPF Payment Sub Period of the Entity CPFPayment

Name	CPF Payment Sub Period
Code	CPFPaymentSubPeriod
Data Type	integer
Mandatory	Yes

Description of Attribute CPF Payment Sub Period of the Entity CPFPayment

Holds the sub period to make the CPF payment.

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)

Entity Attribute CPF Payment Option of the Entity CPFPayment

Card of Attribute CPF Payment Option of the Entity CPFPayment

Name	CPF Payment Option
Code	CPFPaymentOption
Data Type	smallint
Mandatory	No

Description of Attribute CPF Payment Option of the Entity CPFPayment

Shows the mode of payment for CPF.

Home