Sage EasyPay Data Model

Entity EmpCertification

Description of Entity EmpCertification

This entity is for the Philippines Payroll.

List of all Dependencies of the Entity EmpCertification

Relation_1809187

Relation_1809187

Reference

List of Attributes of the Entity EmpCertification

EmpCertificationSysId

EmpCertificationSysId

CertificationType

CertificationType

CertificationNo

CertificationNo

CertificationDate

CertificationDate

Entity Attribute EmployeeSysId of the Entity EmpCertification

Card of Attribute EmployeeSysId of the Entity EmpCertification

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity EmpCertification

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Entity Attribute EmpCertificationSysId of the Entity EmpCertification

Card of Attribute EmpCertificationSysId of the Entity EmpCertification

Name	EmpCertificationSysId
Code	EmpCertificationSysId
Data Type	integer
Mandatory	Yes

Entity Attribute CertificationType of the Entity EmpCertification

Card of Attribute CertificationType of the Entity EmpCertification

Name	CertificationType
Code	CertificationType
Data Type	char(20)
Mandatory	No

Entity Attribute CertificationNo of the Entity EmpCertification

Card of Attribute CertificationNo of the Entity EmpCertification

Name	CertificationNo
Code	CertificationNo
Data Type	char(20)
Mandatory	No

Entity Attribute CertificationDate of the Entity EmpCertification

Card of Attribute CertificationDate of the Entity EmpCertification

Name	CertificationDate
Code	CertificationDate
Data Type	date
Mandatory	No

Entity Attribute Year of the Entity EmpCertification

Card of Attribute Year of the Entity EmpCertification

Name	Year
Code	Year
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity EmpCertification

Shows the year.
Example: 2013

Entity Attribute Month of the Entity EmpCertification

Card of Attribute Month of the Entity EmpCertification

Name	Month
Code	Month
Data Type	integer
Mandatory	No