Entity LeaveDeductionRecord

Description of Entity LeaveDeductionRecord

This entity shows that a portion of leave that has been brought forward can be automatically deducted or forfeited. You must first enable it on the Leave Type then set the amount to forfeit in the allocation table.


List of all Dependencies of the Entity LeaveDeductionRecord

Name

Code

Class Name

Relation_65372

Relation_65372

Reference


List of Attributes of the Entity LeaveDeductionRecord

Name

Code

EmployeeSysId

EmployeeSysId

LveDeductSGSPGenId

LveDeductSGSPGenId

Leave Type Function Code

LeaveTypeFunctCode

Year

PayRecYear

Period

PayRecPeriod

Sub Period

PayRecSubPeriod

Current Leave Days

CurrentLveDays

Current Leave Hours

CurrentLveHours

Previous Leave Increment Days

PreviousLveIncDays

Previous Leave Increment Hours

PreviousLveIncHours

Leave Auto Option

LveAutoOption

Leave Amount

LveAmount

Leave Day Rate ID

LveDayRateId

Leave Hour Rate ID

LveHourRateId

Current Day Rate Amount

CurrentDayRateAmt

Current Hour Rate Amount

CurrentHourRateAmt

Previous Day Rate Amount

PreviousDayRateAmt

Previous Hour Rate Amount

PreviousHourRateAmt

Leave Deduction Created By

LveDedCreatedBy


Entity Attribute EmployeeSysId of the Entity LeaveDeductionRecord

Card of Attribute EmployeeSysId of the Entity LeaveDeductionRecord

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity LeaveDeductionRecord

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


Entity Attribute LveDeductSGSPGenId of the Entity LeaveDeductionRecord

Card of Attribute LveDeductSGSPGenId of the Entity LeaveDeductionRecord

Name

LveDeductSGSPGenId

Code

LveDeductSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute LveDeductSGSPGenId of the Entity LeaveDeductionRecord

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


Entity Attribute Leave Type Function Code of the Entity LeaveDeductionRecord

Card of Attribute Leave Type Function Code of the Entity LeaveDeductionRecord

Name

Leave Type Function Code

Code

LeaveTypeFunctCode

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Type Function Code of the Entity LeaveDeductionRecord

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


Entity Attribute Year of the Entity LeaveDeductionRecord

Card of Attribute Year of the Entity LeaveDeductionRecord

Name

Year

Code

PayRecYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity LeaveDeductionRecord

Shows the year for the pay record.
Example: 2012


Entity Attribute Period of the Entity LeaveDeductionRecord

Card of Attribute Period of the Entity LeaveDeductionRecord

Name

Period

Code

PayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity LeaveDeductionRecord

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


Entity Attribute Sub Period of the Entity LeaveDeductionRecord

Card of Attribute Sub Period of the Entity LeaveDeductionRecord

Name

Sub Period

Code

PayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity LeaveDeductionRecord

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 Current Leave Days of the Entity LeaveDeductionRecord

Card of Attribute Current Leave Days of the Entity LeaveDeductionRecord

Name

Current Leave Days

Code

CurrentLveDays

Data Type

double

Mandatory

No


Description of Attribute Current Leave Days of the Entity LeaveDeductionRecord

Shows the current number of days of leave.


Entity Attribute Current Leave Hours of the Entity LeaveDeductionRecord

Card of Attribute Current Leave Hours of the Entity LeaveDeductionRecord

Name

Current Leave Hours

Code

CurrentLveHours

Data Type

double

Mandatory

No


Description of Attribute Current Leave Hours of the Entity LeaveDeductionRecord

Shows the current number of hours of leave.


Entity Attribute Previous Leave Increment Days of the Entity LeaveDeductionRecord

Card of Attribute Previous Leave Increment Days of the Entity LeaveDeductionRecord

Name

Previous Leave Increment Days

Code

PreviousLveIncDays

Data Type

double

Mandatory

No


Description of Attribute Previous Leave Increment Days of the Entity LeaveDeductionRecord

Shows the previous leave increment in days.


Entity Attribute Previous Leave Increment Hours of the Entity LeaveDeductionRecord

Card of Attribute Previous Leave Increment Hours of the Entity LeaveDeductionRecord

Name

Previous Leave Increment Hours

Code

PreviousLveIncHours

Data Type

double

Mandatory

No


Description of Attribute Previous Leave Increment Hours of the Entity LeaveDeductionRecord

Shows the previous leave increment in hours.


Entity Attribute Leave Auto Option of the Entity LeaveDeductionRecord

Card of Attribute Leave Auto Option of the Entity LeaveDeductionRecord

Name

Leave Auto Option

Code

LveAutoOption

Data Type

smallint

Mandatory

No


Description of Attribute Leave Auto Option of the Entity LeaveDeductionRecord

Shows the auto option for leave.


Entity Attribute Leave Amount of the Entity LeaveDeductionRecord

Card of Attribute Leave Amount of the Entity LeaveDeductionRecord

Name

Leave Amount

Code

LveAmount

Data Type

double

Mandatory

No


Description of Attribute Leave Amount of the Entity LeaveDeductionRecord

Shows the leave amount.


Entity Attribute Leave Day Rate ID of the Entity LeaveDeductionRecord

Card of Attribute Leave Day Rate ID of the Entity LeaveDeductionRecord

Name

Leave Day Rate ID

Code

LveDayRateId

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Day Rate ID of the Entity LeaveDeductionRecord

Stores the identity of the leave day rate.
Example: GRPDayFormula1 / GRPDayFormula2 etc


Entity Attribute Leave Hour Rate ID of the Entity LeaveDeductionRecord

Card of Attribute Leave Hour Rate ID of the Entity LeaveDeductionRecord

Name

Leave Hour Rate ID

Code

LveHourRateId

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Hour Rate ID of the Entity LeaveDeductionRecord

Stores the identity of the leave hour rate.
Example: GRPHourFormula1 / GRPHourFormula2 etc


Entity Attribute Current Day Rate Amount of the Entity LeaveDeductionRecord

Card of Attribute Current Day Rate Amount of the Entity LeaveDeductionRecord

Name

Current Day Rate Amount

Code

CurrentDayRateAmt

Data Type

double

Mandatory

No


Description of Attribute Current Day Rate Amount of the Entity LeaveDeductionRecord

Shows the current day rate amount.


Entity Attribute Current Hour Rate Amount of the Entity LeaveDeductionRecord

Card of Attribute Current Hour Rate Amount of the Entity LeaveDeductionRecord

Name

Current Hour Rate Amount

Code

CurrentHourRateAmt

Data Type

double

Mandatory

No


Description of Attribute Current Hour Rate Amount of the Entity LeaveDeductionRecord

Shows the current hour rate amount.


Entity Attribute Previous Day Rate Amount of the Entity LeaveDeductionRecord

Card of Attribute Previous Day Rate Amount of the Entity LeaveDeductionRecord

Name

Previous Day Rate Amount

Code

PreviousDayRateAmt

Data Type

double

Mandatory

No


Description of Attribute Previous Day Rate Amount of the Entity LeaveDeductionRecord

Shows the previous day rate amount.


Entity Attribute Previous Hour Rate Amount of the Entity LeaveDeductionRecord

Card of Attribute Previous Hour Rate Amount of the Entity LeaveDeductionRecord

Name

Previous Hour Rate Amount

Code

PreviousHourRateAmt

Data Type

double

Mandatory

No


Description of Attribute Previous Hour Rate Amount of the Entity LeaveDeductionRecord

Shows the previous hour rate amount.


Entity Attribute Leave Deduction Created By of the Entity LeaveDeductionRecord

Card of Attribute Leave Deduction Created By of the Entity LeaveDeductionRecord

Name

Leave Deduction Created By

Code

LveDedCreatedBy

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Deduction Created By of the Entity LeaveDeductionRecord

Shows who created the leave deduction.
Example: Timesheet