Sage EasyPay Data Model

Entity LeaveApplication

Description of Entity LeaveApplication

Leave applications can be created using a number of ways:
- Individual basis: Using the Modify Leave feature / Leave Calendar
- Multiple employees: Using the Global Application feature
- By employees themselves: Using the ePortal online application
- By importing: Using the interface method and import designer

All submitted leave applications can be further adjusted. Those applications created by employees themselves through the ePortal application will be listed with the remark "Created by ePortal".

List of all Dependencies of the Entity LeaveApplication

Reference

Reference

Reference

Reference

List of Attributes of the Entity LeaveApplication

Entity Attribute EmployeeSysId of the Entity LeaveApplication

Card of Attribute EmployeeSysId of the Entity LeaveApplication

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity LeaveApplication

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

Entity Attribute LeaveAppSGSPGenId of the Entity LeaveApplication

Card of Attribute LeaveAppSGSPGenId of the Entity LeaveApplication

Name	LeaveAppSGSPGenId
Code	LeaveAppSGSPGenId
Data Type	char(30)
Mandatory	Yes

Description of Attribute LeaveAppSGSPGenId of the Entity LeaveApplication

Shows the generating identity of the leave application. It also holds the primary key for the LeaveApplication table.
Example: A3 / A28 / A42

Entity Attribute Lve Record Category of the Entity LeaveApplication

Card of Attribute Lve Record Category of the Entity LeaveApplication

Name	Lve Record Category
Code	LveRecCategory
Data Type	char(20)
Mandatory	No

Description of Attribute Lve Record Category of the Entity LeaveApplication

Shows the category of the leave records.

Entity Attribute From Date of the Entity LeaveApplication

Card of Attribute From Date of the Entity LeaveApplication

Name	From Date
Code	LveAppFromDate
Data Type	date
Mandatory	No

Name	From Time
Code	LveAppStartTime
Data Type	time
Mandatory	No

Name	To Date
Code	LveAppToDate
Data Type	date
Mandatory	No

Name	To Time
Code	LveAppEndTime
Data Type	time
Mandatory	No

Name	Hour Application
Code	LveAppIsHour
Data Type	smallint
Mandatory	No

Name	Approved
Code	LveRecApproved
Data Type	smallint
Mandatory	No

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

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

Name	Last Modified
Code	LastModified
Data Type	timestamp
Mandatory	No

Name	Created By
Code	CreatedBy
Data Type	char(20)
Mandatory	No

Description of Attribute Created By of the Entity LeaveApplication

Shows who was the creator.
Example: "S" which stands for System, i.e. it was system generated.

Home