Sage EasyPay Data Model

Entity IntercorpLveDetails

Description of Entity IntercorpLveDetails

Shows the leave details for the Intercorp.

List of Attributes of the Entity IntercorpLveDetails

Entity Attribute Company Code of the Entity IntercorpLveDetails

Card of Attribute Company Code of the Entity IntercorpLveDetails

Name	Company Code
Code	InterLveCompCode
Data Type	char(50)
Mandatory	Yes

Description of Attribute Company Code of the Entity IntercorpLveDetails

Shows the company code for the intercorp leave details. This holds the primary key for the IntercorpLveDetails table.

Entity Attribute InterLve Staff No of the Entity IntercorpLveDetails

Card of Attribute InterLve Staff No of the Entity IntercorpLveDetails

Name	InterLve Staff No
Code	InterLveStaffNo
Data Type	integer
Mandatory	Yes

Description of Attribute InterLve Staff No of the Entity IntercorpLveDetails

Shows the staff number for the leave details. This holds the primary key for the IntercorpLveDetails table.

Entity Attribute InterLve Start Date of the Entity IntercorpLveDetails

Card of Attribute InterLve Start Date of the Entity IntercorpLveDetails

Name	InterLve Start Date
Code	InterLveStartDate
Data Type	date
Mandatory	Yes

Description of Attribute InterLve Start Date of the Entity IntercorpLveDetails

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

Entity Attribute InterLve Start Time of the Entity IntercorpLveDetails

Card of Attribute InterLve Start Time of the Entity IntercorpLveDetails

Name	InterLve Start Time
Code	InterLveStartTime
Data Type	time
Mandatory	Yes

Description of Attribute InterLve Start Time of the Entity IntercorpLveDetails

Shows the start time of the leave. This holds the primary key for the IntercorpLveDetails table.

Entity Attribute InterLveEndDate of the Entity IntercorpLveDetails

Card of Attribute InterLveEndDate of the Entity IntercorpLveDetails

Name	InterLveEndDate
Code	InterLveEndDate
Data Type	date
Mandatory	No

Description of Attribute InterLveEndDate of the Entity IntercorpLveDetails

Shows the end date for the leave.
It is usually in the format: DD-MM-YYYY.

Entity Attribute InterLveDuration of the Entity IntercorpLveDetails

Card of Attribute InterLveDuration of the Entity IntercorpLveDetails

Name	InterLveDuration
Code	InterLveDuration
Data Type	double
Mandatory	No

Description of Attribute InterLveDuration of the Entity IntercorpLveDetails

Stores the duration of the leave.

Entity Attribute InterLveLeaveCode of the Entity IntercorpLveDetails

Card of Attribute InterLveLeaveCode of the Entity IntercorpLveDetails

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

Description of Attribute InterLveLeaveCode of the Entity IntercorpLveDetails

Shows the code for the leave.

Entity Attribute InterLveEndTime of the Entity IntercorpLveDetails

Card of Attribute InterLveEndTime of the Entity IntercorpLveDetails

Name	InterLveEndTime
Code	InterLveEndTime
Data Type	time
Mandatory	No

Description of Attribute InterLveEndTime of the Entity IntercorpLveDetails

Shows the end time of the leave.

Entity Attribute InterLveEPETimeStamp of the Entity IntercorpLveDetails

Card of Attribute InterLveEPETimeStamp of the Entity IntercorpLveDetails

Name	InterLveEPETimeStamp
Code	InterLveEPETimeStamp
Data Type	timestamp
Mandatory	No

Description of Attribute InterLveEPETimeStamp of the Entity IntercorpLveDetails

Displays the timestamp for the leave of Sage EasyPay Enterprise.

Entity Attribute InterLveTimeStamp of the Entity IntercorpLveDetails

Card of Attribute InterLveTimeStamp of the Entity IntercorpLveDetails

Name	InterLveTimeStamp
Code	InterLveTimeStamp
Data Type	timestamp
Mandatory	No

Description of Attribute InterLveTimeStamp of the Entity IntercorpLveDetails

Shows the timestamp for the intercorp staff information.

Home