Sage EasyPay Data Model

Entity Training

Description of Entity Training

The entity is a sub module which provides features for tracking skills training courses, fees, course schedules, government grants and other training-related details.

List of all Dependencies of the Entity Training

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

List of Attributes of the Entity Training

Total Training Amount

Government Grant Type

ePortalNominateEmpSysId

Plan Date

PlanDate

CertificateExpiryDate

Entity Attribute Course Code of the Entity Training

Card of Attribute Course Code of the Entity Training

Name	Course Code
Code	CourseCode
Data Type	char(20)
Mandatory	No

Description of Attribute Course Code of the Entity Training

Shows the code for the course. This is the primary key for the Course table.

Entity Attribute PersonalSysId of the Entity Training

Card of Attribute PersonalSysId of the Entity Training

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	No

Description of Attribute PersonalSysId of the Entity Training

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 TrainingSysId of the Entity Training

Card of Attribute TrainingSysId of the Entity Training

Name	TrainingSysId
Code	TrainingSysId
Data Type	integer
Mandatory	Yes

Description of Attribute TrainingSysId of the Entity Training

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

Entity Attribute Submission Date of the Entity Training

Card of Attribute Submission Date of the Entity Training

Name	Submission Date
Code	SubmissionDate
Data Type	date
Mandatory	No

Description of Attribute Submission Date of the Entity Training

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

Entity Attribute Approve the Status of the Entity Training

Card of Attribute Approve the Status of the Entity Training

Name	Approve the Status
Code	Approve
Data Type	smallint
Mandatory	No

Description of Attribute Approve the Status of the Entity Training

Indicates if the status is approved or not, in a form of a checkbox.

Entity Attribute CourseResult of the Entity Training

Card of Attribute CourseResult of the Entity Training

Name	CourseResult
Code	CourseResult
Data Type	double
Mandatory	No

Description of Attribute CourseResult of the Entity Training

Shows the results of the course.

Entity Attribute Attendance % of the Entity Training

Card of Attribute Attendance % of the Entity Training

Name	Attendance %
Code	AttendancePercent
Data Type	double
Mandatory	No

Description of Attribute Attendance % of the Entity Training

Shows the attendance in percentage.

Entity Attribute Remarks of the Entity Training

Card of Attribute Remarks of the Entity Training

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

Description of Attribute Remarks of the Entity Training

Stores any remarks about the training.

Entity Attribute Total Training Amount of the Entity Training

Card of Attribute Total Training Amount of the Entity Training

Name	Total Training Amount
Code	TotalTrainingFee
Data Type	double
Mandatory	No

Description of Attribute Total Training Amount of the Entity Training

Shows the total fee for the training.

Entity Attribute Total Tax Amount of the Entity Training

Card of Attribute Total Tax Amount of the Entity Training

Name	Total Tax Amount
Code	TotalTaxAmount
Data Type	double
Mandatory	No

Description of Attribute Total Tax Amount of the Entity Training

States the tax amount for the training.

Entity Attribute Sponsorship Type of the Entity Training

Card of Attribute Sponsorship Type of the Entity Training

Name	Sponsorship Type
Code	SponsorType
Data Type	integer
Mandatory	No

Description of Attribute Sponsorship Type of the Entity Training

Shows the type of sponsorship, in a form of radio buttons.
Example: Percentage / Amount

Entity Attribute SponsorValue of the Entity Training

Card of Attribute SponsorValue of the Entity Training

Name	SponsorValue
Code	SponsorValue
Data Type	double
Mandatory	No

Description of Attribute SponsorValue of the Entity Training

Shows the value of the sponsorship. It can either be in percentage or an amount.

Entity Attribute Received of the Entity Training

Card of Attribute Received of the Entity Training

Name	Received
Code	SponsorReceived
Data Type	date
Mandatory	No

Description of Attribute Received of the Entity Training

Shows the date of when the sponsorship was received.
It is in the format: DD-MM-YYYY.

Entity Attribute Government Grant Type of the Entity Training

Card of Attribute Government Grant Type of the Entity Training

Name	Government Grant Type
Code	GovGrantType
Data Type	integer
Mandatory	No

Description of Attribute Government Grant Type of the Entity Training

Shows the type of government grant, in a form of radio buttons.
Example: Percentage / Amount

Entity Attribute GovGrantValue of the Entity Training

Card of Attribute GovGrantValue of the Entity Training

Name	GovGrantValue
Code	GovGrantValue
Data Type	double
Mandatory	No

Description of Attribute GovGrantValue of the Entity Training

Shows the value of the government grant. It can either be in percentage or an amount.

Entity Attribute GovGrantReceived of the Entity Training

Card of Attribute GovGrantReceived of the Entity Training

Name	GovGrantReceived
Code	GovGrantReceived
Data Type	date
Mandatory	No

Description of Attribute GovGrantReceived of the Entity Training

Shows the date of when the government grant was received.
It is in the format: DD-MM-YYYY.

Entity Attribute Claim Amount of the Entity Training

Card of Attribute Claim Amount of the Entity Training

Name	Claim Amount
Code	ClaimAmount
Data Type	double
Mandatory	No

Description of Attribute Claim Amount of the Entity Training

Shows the employee claim amount.

Entity Attribute Claim Advance of the Entity Training

Card of Attribute Claim Advance of the Entity Training

Name	Claim Advance
Code	ClaimAdvance
Data Type	double
Mandatory	No

Description of Attribute Claim Advance of the Entity Training

Shows the employee claim in advance.

Entity Attribute Approve Claim of the Entity Training

Card of Attribute Approve Claim of the Entity Training

Name	Approve Claim
Code	ClaimApprove
Data Type	smallint
Mandatory	No

Description of Attribute Approve Claim of the Entity Training

Indicates if the claim has been approved, in a form of a checkbox.

Entity Attribute Payroll Date of the Entity Training

Card of Attribute Payroll Date of the Entity Training

Name	Payroll Date
Code	PayrollDate
Data Type	date
Mandatory	No

Description of Attribute Payroll Date of the Entity Training

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

Entity Attribute PayrollEmployeeSysId of the Entity Training

Card of Attribute PayrollEmployeeSysId of the Entity Training

Name	PayrollEmployeeSysId
Code	PayrollEmployeeSysId
Data Type	integer
Mandatory	No

Description of Attribute PayrollEmployeeSysId of the Entity Training

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

Entity Attribute Processed On of the Entity Training

Card of Attribute Processed On of the Entity Training

Name	Processed On
Code	PayrollProcessDate
Data Type	date
Mandatory	No

Description of Attribute Processed On of the Entity Training

Shows when the payment was processed.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Year of the Entity Training

Card of Attribute Year of the Entity Training

Name	Year
Code	PayrollYear
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity Training

Shows the year for the payroll.
Example: 2013

Entity Attribute Period of the Entity Training

Card of Attribute Period of the Entity Training

Name	Period
Code	PayrollPeriod
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity Training

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

Entity Attribute Sub Period of the Entity Training

Card of Attribute Sub Period of the Entity Training

Name	Sub Period
Code	PayrollSubPeriod
Data Type	integer
Mandatory	No

Description of Attribute Sub Period of the Entity Training

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 Pay Element ID of the Entity Training

Card of Attribute Pay Element ID of the Entity Training

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

Name	Paid Claim
Code	TrainingPaid
Data Type	smallint
Mandatory	No

Name	Status
Code	ePortalStatus
Data Type	char(20)
Mandatory	No

Name	Employee ID
Code	ePortalEmployeeSysId
Data Type	integer
Mandatory	No

Name	ePortalNominateEmpSysId
Code	ePortalNominateEmpSysId
Data Type	integer
Mandatory	No

Name	Plan Date
Code	PlanDate
Data Type	date
Mandatory	No

Name	CertificateExpiryDate
Code	CertificateExpiryDate
Data Type	date
Mandatory	No

Description of Attribute CertificateExpiryDate of the Entity Training

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

Home