Entity LeaveInfoRecord

Description of Entity LeaveInfoRecord

Information about the leave record. Displays the leave entitlement, leave period taken etc.


List of all Dependencies of the Entity LeaveInfoRecord

Name

Code

Class Name

Relation_65373

Relation_65373

Reference


List of Attributes of the Entity LeaveInfoRecord

Name

Code

EmployeeSysId

EmployeeSysId

LeaveInfoSGSPGenId

LeaveInfoSGSPGenId

Leave Type Function Code

LeaveTypeFunctCode

Year

PayRecYear

Period

PayRecPeriod

Leave Brought Forward

LveBroughtForward

Current Leave Entitlement

CurrLveEntitlement

Current Leave Period Taken

CurrLvePeriodTaken

Sub Period

PayRecSubPeriod

Leave Info Created By

LeaveInfoCreatedBy


Entity Attribute EmployeeSysId of the Entity LeaveInfoRecord

Card of Attribute EmployeeSysId of the Entity LeaveInfoRecord

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity LeaveInfoRecord

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


Entity Attribute LeaveInfoSGSPGenId of the Entity LeaveInfoRecord

Card of Attribute LeaveInfoSGSPGenId of the Entity LeaveInfoRecord

Name

LeaveInfoSGSPGenId

Code

LeaveInfoSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute LeaveInfoSGSPGenId of the Entity LeaveInfoRecord

Shows the generating identity of the leave info record. This is the primary key for the LeaveInfoRecord table.
Example: A1 / A66 / A110


Entity Attribute Leave Type Function Code of the Entity LeaveInfoRecord

Card of Attribute Leave Type Function Code of the Entity LeaveInfoRecord

Name

Leave Type Function Code

Code

LeaveTypeFunctCode

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Type Function Code of the Entity LeaveInfoRecord

Stores the type of leave.
Example: Absent / Late / NPL (No Pay Leave)


Entity Attribute Year of the Entity LeaveInfoRecord

Card of Attribute Year of the Entity LeaveInfoRecord

Name

Year

Code

PayRecYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity LeaveInfoRecord

Shows the year for the pay record.
Example: 2012


Entity Attribute Period of the Entity LeaveInfoRecord

Card of Attribute Period of the Entity LeaveInfoRecord

Name

Period

Code

PayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity LeaveInfoRecord

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.


Entity Attribute Leave Brought Forward of the Entity LeaveInfoRecord

Card of Attribute Leave Brought Forward of the Entity LeaveInfoRecord

Name

Leave Brought Forward

Code

LveBroughtForward

Data Type

double

Mandatory

No


Description of Attribute Leave Brought Forward of the Entity LeaveInfoRecord

Shows the leave that has been brought forward.


Entity Attribute Current Leave Entitlement of the Entity LeaveInfoRecord

Card of Attribute Current Leave Entitlement of the Entity LeaveInfoRecord

Name

Current Leave Entitlement

Code

CurrLveEntitlement

Data Type

double

Mandatory

No


Description of Attribute Current Leave Entitlement of the Entity LeaveInfoRecord

Shows the current leave entitlement.


Entity Attribute Current Leave Period Taken of the Entity LeaveInfoRecord

Card of Attribute Current Leave Period Taken of the Entity LeaveInfoRecord

Name

Current Leave Period Taken

Code

CurrLvePeriodTaken

Data Type

double

Mandatory

No


Description of Attribute Current Leave Period Taken of the Entity LeaveInfoRecord

Shows the current leave period taken.


Entity Attribute Sub Period of the Entity LeaveInfoRecord

Card of Attribute Sub Period of the Entity LeaveInfoRecord

Name

Sub Period

Code

PayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity LeaveInfoRecord

Holds the sub period for the pay record.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Leave Info Created By of the Entity LeaveInfoRecord

Card of Attribute Leave Info Created By of the Entity LeaveInfoRecord

Name

Leave Info Created By

Code

LeaveInfoCreatedBy

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Info Created By of the Entity LeaveInfoRecord

Shows who created the leave info.
Example: Timesheet