Sage EasyPay Data Model

Entity Employee

Description of Entity Employee

This entity holds the record of the person that is employed by the company. It only stores the latest and most current record about the employee.

Example: Which department the employee is working in; who is the supervisor; what is the salary the employee is earning etc.

With this entity separate from the personal record, employee records will show the same person, who has previously resigned, re-joining the company using a different employee number. The company can also keep a record of all the past employees as a history record.

List of all Dependencies of the Entity Employee

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

Reference

List of Attributes of the Entity Employee

Employment Act Deduction Cap

IsSalaryDeductCap

Entity Attribute EmployeeSysId of the Entity Employee

Card of Attribute EmployeeSysId of the Entity Employee

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity Employee

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

Entity Attribute PersonalSysId of the Entity Employee

Card of Attribute PersonalSysId of the Entity Employee

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	Yes

Description of Attribute PersonalSysId of the Entity Employee

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 Employee ID of the Entity Employee

Card of Attribute Employee ID of the Entity Employee

Name	Employee ID
Code	EmployeeId
Data Type	char(30)
Mandatory	No

Description of Attribute Employee ID of the Entity Employee

Differentiates each employee. It would distinctively identify each employee in the company.

Entity Attribute Identity No of the Entity Employee

Card of Attribute Identity No of the Entity Employee

Name	Identity No
Code	IdentityNo
Data Type	char(30)
Mandatory	No

Description of Attribute Identity No of the Entity Employee

Shows the identity number of the person.

Entity Attribute Identity Type of the Entity Employee

Card of Attribute Identity Type of the Entity Employee

Name	Identity Type
Code	IdentityTypeCode
Data Type	char(20)
Mandatory	No

Description of Attribute Identity Type of the Entity Employee

Holds the type of identity card each employee has.
Example: NRIC(Pink) / NRIC(Blue) / FIN

Entity Attribute Country Of Birth of the Entity Employee

Card of Attribute Country Of Birth of the Entity Employee

Name	Country Of Birth
Code	CountryOfBirth
Data Type	char(60)
Mandatory	No

Description of Attribute Country Of Birth of the Entity Employee

Holds the country of birth of the employee.
Example: Singapore / Malaysia / Indonesia

Entity Attribute Date Of Birth of the Entity Employee

Card of Attribute Date Of Birth of the Entity Employee

Name	Date Of Birth
Code	DateOfBirth
Data Type	date
Mandatory	No

Description of Attribute Date Of Birth of the Entity Employee

Holds the date of birth for the employee.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Name of the Entity Employee

Card of Attribute Name of the Entity Employee

Name	Name
Code	EmployeeName
Data Type	char(150)
Mandatory	No

Description of Attribute Name of the Entity Employee

Stores the employee’s name. The employee’s name is the same as the Personal name found in the Personal entity.

Entity Attribute Gender of the Entity Employee

Card of Attribute Gender of the Entity Employee

Name	Gender
Code	Gender
Data Type	char(1)
Mandatory	No

Description of Attribute Gender of the Entity Employee

Shows the gender of the family member.
Example: Male = "1". Female = "0".

Entity Attribute Nationality of the Entity Employee

Card of Attribute Nationality of the Entity Employee

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

Description of Attribute Nationality of the Entity Employee

Holds the nationality of the person.
Example: Singaporean / Malaysian / Indonesian

Entity Attribute Cessation Date of the Entity Employee

Card of Attribute Cessation Date of the Entity Employee

Name	Cessation Date
Code	CessationDate
Data Type	date
Mandatory	No

Description of Attribute Cessation Date of the Entity Employee

Shows the date the employee discontinues his service and leaves the company. This can be due to resignation, termination etc.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Hire Date of the Entity Employee

Card of Attribute Hire Date of the Entity Employee

Name	Hire Date
Code	HireDate
Data Type	date
Mandatory	No

Description of Attribute Hire Date of the Entity Employee

Holds the date the employee was hired. This date is when the employee officially starts working.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Probation Period of the Entity Employee

Card of Attribute Probation Period of the Entity Employee

Name	Probation Period
Code	ProbationPeriod
Data Type	integer
Mandatory	No

Description of Attribute Probation Period of the Entity Employee

Probation period given to a new employee. It usually lasts anywhere from 1 month to 12 months depending on the progress of the new employee. After this period, the employer would determine if he wants the employee to continue to work for the company. There may not necessarily be a probation period for every new employee.

Entity Attribute ProbationUnit of the Entity Employee

Card of Attribute ProbationUnit of the Entity Employee

Name	ProbationUnit
Code	ProbationUnit
Data Type	char(10)
Mandatory	No

Description of Attribute ProbationUnit of the Entity Employee

Records the unit of probation for the employee. It would act as a fixed setting for the rest of the employees.
Example: “Mth” for months

Entity Attribute HighestEduCode of the Entity Employee

Card of Attribute HighestEduCode of the Entity Employee

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

Description of Attribute HighestEduCode of the Entity Employee

Stores the employee’s highest education. It is derived from the education record provided by the employee.
Example: Masters / Degree / Diploma

Entity Attribute Retirement Age of the Entity Employee

Card of Attribute Retirement Age of the Entity Employee

Name	Retirement Age
Code	RetirementAge
Data Type	integer
Mandatory	No

Description of Attribute Retirement Age of the Entity Employee

This attribute stores the retirement age for all employees. In Singapore, the retirement age is usually 62. Depending on their work performance and their medical fitness, employees have the choice to work till the age of 65.

Entity Attribute Retirement Date of the Entity Employee

Card of Attribute Retirement Date of the Entity Employee

Name	Retirement Date
Code	RetirementDate
Data Type	date
Mandatory	No

Description of Attribute Retirement Date of the Entity Employee

Shows the date when the employee decides to stop working. A default value is calculated by using the Retirement Age and the date of birth. However, the user can overwrite it manually.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Supervisor of the Entity Employee

Card of Attribute Supervisor of the Entity Employee

Name	Supervisor
Code	Supervisor
Data Type	char(30)
Mandatory	No

Description of Attribute Supervisor of the Entity Employee

Shows the supervisor's employee identity.

Entity Attribute Residence Status of the Entity Employee

Card of Attribute Residence Status of the Entity Employee

Name	Residence Status
Code	ResidenceStatus
Data Type	char(20)
Mandatory	No

Description of Attribute Residence Status of the Entity Employee

Shows if the employee is a citizen of the country or holds a permanent residence or is a foreign worker.

Entity Attribute Supervisory Position of the Entity Employee

Card of Attribute Supervisory Position of the Entity Employee

Name	Supervisory Position
Code	IsSupervisor
Data Type	smallint
Mandatory	No

Description of Attribute Supervisory Position of the Entity Employee

Shows that the employee is a supervisor. The employee’s name would appear on the supervisor’s name list.

Entity Attribute PreviousSvcYear of the Entity Employee

Card of Attribute PreviousSvcYear of the Entity Employee

Name	PreviousSvcYear
Code	PreviousSvcYear
Data Type	double
Mandatory	No

Description of Attribute PreviousSvcYear of the Entity Employee

Stores the year in which the employee has made a service to the company from previous years.
Example: Employee A has worked in a company A from 1998-2002 then left to work in another company B. In 2005, Employee A decides to come back to work for company A. Therefore his PreviousSvcYear would be 1998-2002.

Entity Attribute Confirmation Date of the Entity Employee

Card of Attribute Confirmation Date of the Entity Employee

Name	Confirmation Date
Code	ConfirmationDate
Data Type	date
Mandatory	No

Description of Attribute Confirmation Date of the Entity Employee

Confirmation date of when the employee started working. This field cannot be edited.
It is usually in the format: DD-MM-YYYY.

Entity Attribute CustBoolean1 of the Entity Employee

Card of Attribute CustBoolean1 of the Entity Employee

Name	CustBoolean1
Code	CustBoolean1
Data Type	smallint
Mandatory	No

Description of Attribute CustBoolean1 of the Entity Employee

Enables the customer to customize the section. It comes in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. Ticking the box will show “1” in the database while not checking the box will show “0”.

Entity Attribute CustBoolean2 of the Entity Employee

Card of Attribute CustBoolean2 of the Entity Employee

Name	CustBoolean2
Code	CustBoolean2
Data Type	smallint
Mandatory	No

Description of Attribute CustBoolean2 of the Entity Employee

Entity Attribute CustBoolean3 of the Entity Employee

Card of Attribute CustBoolean3 of the Entity Employee

Name	CustBoolean3
Code	CustBoolean3
Data Type	smallint
Mandatory	No

Description of Attribute CustBoolean3 of the Entity Employee

Entity Attribute CustDate1 of the Entity Employee

Card of Attribute CustDate1 of the Entity Employee

Name	CustDate1
Code	CustDate1
Data Type	date
Mandatory	No

Description of Attribute CustDate1 of the Entity Employee

Enables the customer to customize the section. The customer can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection.
It is in the format: DD-MM-YYYY.

Entity Attribute CustDate2 of the Entity Employee

Card of Attribute CustDate2 of the Entity Employee

Name	CustDate2
Code	CustDate2
Data Type	date
Mandatory	No

Description of Attribute CustDate2 of the Entity Employee

Entity Attribute CustDate3 of the Entity Employee

Card of Attribute CustDate3 of the Entity Employee

Name	CustDate3
Code	CustDate3
Data Type	date
Mandatory	No

Description of Attribute CustDate3 of the Entity Employee

Entity Attribute CustInteger1 of the Entity Employee

Card of Attribute CustInteger1 of the Entity Employee

Name	CustInteger1
Code	CustInteger1
Data Type	integer
Mandatory	No

Description of Attribute CustInteger1 of the Entity Employee

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute CustInteger2 of the Entity Employee

Card of Attribute CustInteger2 of the Entity Employee

Name	CustInteger2
Code	CustInteger2
Data Type	integer
Mandatory	No

Description of Attribute CustInteger2 of the Entity Employee

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute CustInteger3 of the Entity Employee

Card of Attribute CustInteger3 of the Entity Employee

Name	CustInteger3
Code	CustInteger3
Data Type	integer
Mandatory	No

Description of Attribute CustInteger3 of the Entity Employee

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute CustNumeric1 of the Entity Employee

Card of Attribute CustNumeric1 of the Entity Employee

Name	CustNumeric1
Code	CustNumeric1
Data Type	double
Mandatory	No

Description of Attribute CustNumeric1 of the Entity Employee

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Entity Attribute CustNumeric2 of the Entity Employee

Card of Attribute CustNumeric2 of the Entity Employee

Name	CustNumeric2
Code	CustNumeric2
Data Type	double
Mandatory	No

Description of Attribute CustNumeric2 of the Entity Employee

Entity Attribute CustNumeric3 of the Entity Employee

Card of Attribute CustNumeric3 of the Entity Employee

Name	CustNumeric3
Code	CustNumeric3
Data Type	double
Mandatory	No

Description of Attribute CustNumeric3 of the Entity Employee

Entity Attribute CustString1 of the Entity Employee

Card of Attribute CustString1 of the Entity Employee

Name	CustString1
Code	CustString1
Data Type	char(50)
Mandatory	No

Name	CustString2
Code	CustString2
Data Type	char(50)
Mandatory	No

Name	CustString3
Code	CustString3
Data Type	char(50)
Mandatory	No

Name	CustString4
Code	CustString4
Data Type	char(50)
Mandatory	No

Name	CustString5
Code	CustString5
Data Type	char(50)
Mandatory	No

Name	Employment Act Deduction Cap
Code	IsSalaryDeductCap
Data Type	smallint
Mandatory	No

Description of Attribute Employment Act Deduction Cap of the Entity Employee

Indicates if the employee is assigned to the Employment Act Salary Deduction Cap, in a form of a checkbox.

Home