Sage EasyPay Data Model

Entity Shift

Description of Entity Shift

This will show if the employee is on a standard shift table. The entity will help to calculate the average amount for the gross rate pay.

Change shift average period description: Number of months to average the total shift amount for the calculation of gross rate pay. For example: type in '6' and Sage EasyPay will average the past six-month's shift amount for calculating GRP.

List of all Dependencies of the Entity Shift

Relation_56519

Reference

Ref_5125

Reference

Relation_648542

Reference

List of Attributes of the Entity Shift

Entity Attribute Shift Table ID of the Entity Shift

Card of Attribute Shift Table ID of the Entity Shift

Name	Shift Table ID
Code	ShiftTableId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Shift Table ID of the Entity Shift

Shows the identity of the shift table. This also acts as a primary key for the Shift table.
Example: Standard Shift Table

Entity Attribute Description of the Entity Shift

Card of Attribute Description of the Entity Shift

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

Description of Attribute Description of the Entity Shift

Shows the description of the shift table.
Example: Standard Shift Table

Entity Attribute Shift Average Period of the Entity Shift

Card of Attribute Shift Average Period of the Entity Shift

Name	Shift Average Period
Code	ShiftAveragePeriod
Data Type	integer
Mandatory	No

Description of Attribute Shift Average Period of the Entity Shift

This is the number of months to average the total shift amount for the calculation of gross rate pay (GRP).
Example: Type in '6' and EPE will average out the past six-month's shift amount for calculating GRP.

Home