Sage EasyPay Data Model

Entity BonusReport

Description of Entity BonusReport

A report ID serves two purposes:
- Storing parameters
- Reporting payments made

Any change in the existing ID will result in previous data (for the report) being lost.
The bonus report is for storing data about the bonus. It has details about the employee's leave, what amount of bonus they receive, bonus factor etc.

List of all Dependencies of the Entity BonusReport

Relation_90719

Reference

List of Attributes of the Entity BonusReport

Entity Attribute BonusEmployeeSysId of the Entity BonusReport

Card of Attribute BonusEmployeeSysId of the Entity BonusReport

Name	BonusEmployeeSysId
Code	BonusEmployeeSysId
Data Type	char(20)
Mandatory	Yes

Description of Attribute BonusEmployeeSysId of the Entity BonusReport

System generated identifier. It is blind to the user. This also acts as a primary key for the BonusReport table.

Entity Attribute Bonus Amount of the Entity BonusReport

Card of Attribute Bonus Amount of the Entity BonusReport

Name	Bonus Amount
Code	BonusAmount
Data Type	double
Mandatory	No

Description of Attribute Bonus Amount of the Entity BonusReport

Shows the amount of bonus the employee will receive.

Entity Attribute Bonus Wage of the Entity BonusReport

Card of Attribute Bonus Wage of the Entity BonusReport

Name	Bonus Wage
Code	BonusWage
Data Type	double
Mandatory	No

Description of Attribute Bonus Wage of the Entity BonusReport

Shows the normal wage amount before the bonus.

Entity Attribute Bonus Day Month of the Entity BonusReport

Card of Attribute Bonus Day Month of the Entity BonusReport

Name	Bonus Day Month
Code	BonusDayMonth
Data Type	double
Mandatory	No

Description of Attribute Bonus Day Month of the Entity BonusReport

Shows the month of when the bonus will be given.
Example: January = "1" / February = "2" / March = "3" etc

Entity Attribute Bonus EE NPL of the Entity BonusReport

Card of Attribute Bonus EE NPL of the Entity BonusReport

Name	Bonus EE NPL
Code	BonusEENPL
Data Type	double
Mandatory	No

Name	Bonus EE Sick
Code	BonusEESick
Data Type	double
Mandatory	No

Name	Bonus EE Annual
Code	BonusEEAnnual
Data Type	double
Mandatory	No

Name	Bonus EE Absent
Code	BonusEEAbsent
Data Type	double
Mandatory	No

Name	Bonus Factor
Code	BonusFactor
Data Type	double
Mandatory	No

Name	Bonus Prorate Factor
Code	BonusProrateFactor
Data Type	double
Mandatory	No

Name	BonusWageF
Code	BonusWageF
Data Type	double
Mandatory	No

Name	Bonus Exchange Rate ID
Code	BonusExRateId
Data Type	char(20)
Mandatory	No

Name	Bonus Exchange Rate
Code	BonusExRate
Data Type	double
Mandatory	No

Description of Attribute Bonus Exchange Rate of the Entity BonusReport

Shows the exchange rate for the foreign bonus amount.

Home