Sage EasyPay Data Model

Entity LeaveRecord

Description of Entity LeaveRecord

This aids in managing and computing the leave for the employees in the company. The computation (daily cost) is used in the Payroll Module and the Costing Module.

List of all Dependencies of the Entity LeaveRecord

Relation_133895

Reference

List of Attributes of the Entity LeaveRecord

Lve Record Date

LveRecDate

Lve Record Start Time

Lve Record Convert Days

LveRecConvertDays

Lve Record Calendar Day

LveRecCalendarDay

Lve Certification Date

LveCertificationDate

Entity Attribute Lve Record Date of the Entity LeaveRecord

Card of Attribute Lve Record Date of the Entity LeaveRecord

Name	Lve Record Date
Code	LveRecDate
Data Type	date
Mandatory	Yes

Description of Attribute Lve Record Date of the Entity LeaveRecord

Shows the date of the leave record. This is the primary key for the LeaveRecord table.
It is usually in the format: DD-MM-YYYY.

Entity Attribute Lve Record Start Time of the Entity LeaveRecord

Card of Attribute Lve Record Start Time of the Entity LeaveRecord

Name	Lve Record Start Time
Code	LveRecStartTime
Data Type	time
Mandatory	Yes

Description of Attribute Lve Record Start Time of the Entity LeaveRecord

Shows the start time of the leave record. This is the primary key for the LeaveRecord table.

Entity Attribute Lve Record End Time of the Entity LeaveRecord

Card of Attribute Lve Record End Time of the Entity LeaveRecord

Name	Lve Record End Time
Code	LveRecEndTime
Data Type	time
Mandatory	No

Description of Attribute Lve Record End Time of the Entity LeaveRecord

Shows the end time of the leave record.

Entity Attribute Lve Record Days of the Entity LeaveRecord

Card of Attribute Lve Record Days of the Entity LeaveRecord

Name	Lve Record Days
Code	LveRecDays
Data Type	double
Mandatory	No

Description of Attribute Lve Record Days of the Entity LeaveRecord

Shows the number of days taken.

Entity Attribute Lve Record Hours of the Entity LeaveRecord

Card of Attribute Lve Record Hours of the Entity LeaveRecord

Name	Lve Record Hours
Code	LveRecHours
Data Type	double
Mandatory	No

Description of Attribute Lve Record Hours of the Entity LeaveRecord

Shows the number of hours taken, calculated from the number of days.

Entity Attribute Lve Record Convert Days of the Entity LeaveRecord

Card of Attribute Lve Record Convert Days of the Entity LeaveRecord

Name	Lve Record Convert Days
Code	LveRecConvertDays
Data Type	double
Mandatory	No

Description of Attribute Lve Record Convert Days of the Entity LeaveRecord

Shows the number of days to convert.

Entity Attribute Lve Record Calendar Day of the Entity LeaveRecord

Card of Attribute Lve Record Calendar Day of the Entity LeaveRecord

Name	Lve Record Calendar Day
Code	LveRecCalendarDay
Data Type	double
Mandatory	No

Description of Attribute Lve Record Calendar Day of the Entity LeaveRecord

Shows if the leave record goes according to the calendar day.

Entity Attribute Lve Certification Date of the Entity LeaveRecord

Card of Attribute Lve Certification Date of the Entity LeaveRecord

Name	Lve Certification Date
Code	LveCertificationDate
Data Type	date
Mandatory	No

Description of Attribute Lve Certification Date of the Entity LeaveRecord

Shows the date of the leave certification.
It is usually in the format: DD-MM-YYYY.

Home