Sage EasyPay Data Model

Entity AwardDisc

Description of Entity AwardDisc

This is the main setup for the award / discipline.

List of all Dependencies of the Entity AwardDisc

Reference

Reference

Reference

Reference

Reference

List of Attributes of the Entity AwardDisc

Entity Attribute PersonalSysId of the Entity AwardDisc

Card of Attribute PersonalSysId of the Entity AwardDisc

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity AwardDisc

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.

Entity Attribute AwardDiscSysId of the Entity AwardDisc

Card of Attribute AwardDiscSysId of the Entity AwardDisc

Name	AwardDiscSysId
Code	AwardDiscSysId
Data Type	integer
Mandatory	Yes

Description of Attribute AwardDiscSysId of the Entity AwardDisc

A system generated identity. It is blind to the user. This also holds the primary key for the AwardDisc table.

Entity Attribute Award or Discipline Date of the Entity AwardDisc

Card of Attribute Award or Discipline Date of the Entity AwardDisc

Name	Award or Discipline Date
Code	AwardDiscDate
Data Type	date
Mandatory	No

Description of Attribute Award or Discipline Date of the Entity AwardDisc

Shows the date of the award / discipline.
It is in the format: DD-MM-YYYY.

Entity Attribute Amount of the Entity AwardDisc

Card of Attribute Amount of the Entity AwardDisc

Name	Amount
Code	AwardAmount
Data Type	double
Mandatory	No

Description of Attribute Amount of the Entity AwardDisc

Shows the amount for the award received.

Entity Attribute Payroll Date of the Entity AwardDisc

Card of Attribute Payroll Date of the Entity AwardDisc

Name	Payroll Date
Code	PayrollDate
Data Type	date
Mandatory	No

Description of Attribute Payroll Date of the Entity AwardDisc

Shows the date of the payroll.
It is in the format: DD-MM-YYYY.

Entity Attribute PayrollEmployeeSysId of the Entity AwardDisc

Card of Attribute PayrollEmployeeSysId of the Entity AwardDisc

Name	PayrollEmployeeSysId
Code	PayrollEmployeeSysId
Data Type	integer
Mandatory	No

Description of Attribute PayrollEmployeeSysId of the Entity AwardDisc

A system generated identity. It is blind to the user.

Entity Attribute Pay Element ID of the Entity AwardDisc

Card of Attribute Pay Element ID of the Entity AwardDisc

Name	Pay Element ID
Code	PayrollPayElementId
Data Type	char(20)
Mandatory	No

Description of Attribute Pay Element ID of the Entity AwardDisc

Shows the identity of the pay element.
Example:
INCO = Income Tax Deduction / Withheld
NOIL = Notice in Lieu Deductions
NATI = National Service Pay
COMC = Community Chest
etc

or

Transport and/or Medical Claims for the Training entity.

Entity Attribute Year of the Entity AwardDisc

Card of Attribute Year of the Entity AwardDisc

Name	Year
Code	PayrollYear
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity AwardDisc

Shows the year for the payroll.
Example: 2013

Entity Attribute Period of the Entity AwardDisc

Card of Attribute Period of the Entity AwardDisc

Name	Period
Code	PayrollPeriod
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity AwardDisc

Shows the period of the payroll.
Example: January = "1" / February = "2" / March = "3" etc

Entity Attribute Sub Period of the Entity AwardDisc

Card of Attribute Sub Period of the Entity AwardDisc

Name	Sub Period
Code	PayrollSubPeriod
Data Type	integer
Mandatory	No

Description of Attribute Sub Period of the Entity AwardDisc

Shows the sub period for the payroll.

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 Processed On of the Entity AwardDisc

Card of Attribute Processed On of the Entity AwardDisc

Name	Processed On
Code	PayrollProcessDate
Data Type	date
Mandatory	No

Name	Reference No
Code	ReferenceNo
Data Type	char(20)
Mandatory	No

Name	Remarks
Code	Remarks
Data Type	char(100)
Mandatory	No

Name	Follow up Date
Code	FollowUpDate
Data Type	date
Mandatory	No

Name	Offence Date
Code	OffenceDate
Data Type	date
Mandatory	No

Description of Attribute Offence Date of the Entity AwardDisc

Shows the date of offence.
It is in the format: DD-MM-YYYY.

Home