Sage EasyPay Data Model

Entity SubPeriodRecord

Description of Entity SubPeriodRecord

This record is created whenever the user initialises the new sub period. Without the record for the sub period, YTD processing and pay processing are not permitted.

List of all Dependencies of the Entity SubPeriodRecord

Reference

Reference

Reference

Reference

List of Attributes of the Entity SubPeriodRecord

EmployeeSysId

PaySubPeriodSGSPGenId

Sub Period Start Date

Entity Attribute EmployeeSysId of the Entity SubPeriodRecord

Card of Attribute EmployeeSysId of the Entity SubPeriodRecord

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity SubPeriodRecord

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

Entity Attribute PaySubPeriodSGSPGenId of the Entity SubPeriodRecord

Card of Attribute PaySubPeriodSGSPGenId of the Entity SubPeriodRecord

Name	PaySubPeriodSGSPGenId
Code	PaySubPeriodSGSPGenId
Data Type	char(30)
Mandatory	Yes

Description of Attribute PaySubPeriodSGSPGenId of the Entity SubPeriodRecord

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

Entity Attribute Year of the Entity SubPeriodRecord

Card of Attribute Year of the Entity SubPeriodRecord

Name	Year
Code	PayRecYear
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity SubPeriodRecord

Shows the year for the pay record.
Example: 2012

Entity Attribute Period of the Entity SubPeriodRecord

Card of Attribute Period of the Entity SubPeriodRecord

Name	Period
Code	PayRecPeriod
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity SubPeriodRecord

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

Entity Attribute Sub Period of the Entity SubPeriodRecord

Card of Attribute Sub Period of the Entity SubPeriodRecord

Name	Sub Period
Code	PayRecSubPeriod
Data Type	integer
Mandatory	Yes

Description of Attribute Sub Period of the Entity SubPeriodRecord

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)

Entity Attribute Sub Period Status of the Entity SubPeriodRecord

Card of Attribute Sub Period Status of the Entity SubPeriodRecord

Name	Sub Period Status
Code	SubPeriodStatus
Data Type	char(20)
Mandatory	No

Description of Attribute Sub Period Status of the Entity SubPeriodRecord

Shows the status of the sub period.
Example: Locked / Active

Entity Attribute Sub Period Start Date of the Entity SubPeriodRecord

Card of Attribute Sub Period Start Date of the Entity SubPeriodRecord

Name	Sub Period Start Date
Code	SubPeriodStartDate
Data Type	date
Mandatory	No

Description of Attribute Sub Period Start Date of the Entity SubPeriodRecord

The Start Date is computed from the first day and first month of the SubPeriodTemplate entity.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Sub Period End Date of the Entity SubPeriodRecord

Card of Attribute Sub Period End Date of the Entity SubPeriodRecord

Name	Sub Period End Date
Code	SubPeriodEndDate
Data Type	date
Mandatory	No

Description of Attribute Sub Period End Date of the Entity SubPeriodRecord

The End Date is computed from the last day and last month of the SubPeriodTemplate entity.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Suspend Pay of the Entity SubPeriodRecord

Card of Attribute Suspend Pay of the Entity SubPeriodRecord

Name	Suspend Pay
Code	PaySuspense
Data Type	smallint
Mandatory	No

Description of Attribute Suspend Pay of the Entity SubPeriodRecord

This attribute will only be enabled if the Pay Group has been locked. If true, it will supercede all conditions to stop creating pay records. This will prevent payroll processing so long as the check box is ticked. If there is a need to suspend the pay, tick the checkbox and the database will show "1", otherwise, untick the checkbox and the database will show "0"

Home