Sage EasyPay Data Model

Entity DayHourRate

Description of Entity DayHourRate

This Table contains the non-lexical formulas for user selection.

1. GRP Formula
2. BRP Formula
3. OT Formula

These are the general formulas. The actual computations are hard coded in the software.

List of Attributes of the Entity DayHourRate

Day Hour Rate ID

DayHourRateId

Day Hour Rate Category

DayHourRateCategory

Day Hour Rate Formula

DayHourRateFormula

Entity Attribute Day Hour Rate ID of the Entity DayHourRate

Card of Attribute Day Hour Rate ID of the Entity DayHourRate

Name	Day Hour Rate ID
Code	DayHourRateId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Day Hour Rate ID of the Entity DayHourRate

Shows the identity of the day hour rate. It also holds the primary key for the DayHourRate table.
Example: BRPDayFormula1 / OTDayFormula2 / GRPHourFormula4 etc

Legend:
BRP = Best Rate of Pay
GRP = Gross Rate of Pay

Entity Attribute Day Hour Rate Category of the Entity DayHourRate

Card of Attribute Day Hour Rate Category of the Entity DayHourRate

Name	Day Hour Rate Category
Code	DayHourRateCategory
Data Type	char(20)
Mandatory	No

Description of Attribute Day Hour Rate Category of the Entity DayHourRate

Shows the category of the day hour rate.
Example: BRPDayRate / OTDayRate / GRPHourRate etc

Legend:
BRP = Best Rate of Pay
GRP = Gross Rate of Pay

Entity Attribute Day Hour Rate Formula of the Entity DayHourRate

Card of Attribute Day Hour Rate Formula of the Entity DayHourRate

Name	Day Hour Rate Formula
Code	DayHourRateFormula
Data Type	char(255)
Mandatory	No

Description of Attribute Day Hour Rate Formula of the Entity DayHourRate

Shows the formula for the day hour rate.

Example:
TW / (Working Days in the Mth)
or
((TW + Shift & Allowance Subj to OT) * 12) / (52 * Working Days per Wk)
or
[(TW + Shift & Allowance Subj to GRP) / Calendar Days in the Mth] / Empee Working Hrs

Legend:
TW = Total Wage
GRP = Gross Rate of Pay

Home