Entity LeaveType

Description of Entity LeaveType

The Leave Type contains the general definition of the leave itself, with settings ranging from colour codes to eligibility conditions. The amount of leave and limits on how much can be brought forward is set in an Allocation Table. Settings for a leave type is distributed over several tabs on the Leave Type window. It controls the general type and appearance of the leave.


List of all Dependencies of the Entity LeaveType

Name

Code

Class Name

Relation_189058

Relation_189058

Reference

Relation_170786

Relation_170786

Reference

Relation_170709

Relation_170709

Reference

Relation_161423

Relation_161423

Reference

Relation_153943

Relation_153943

Reference

Relation_153942

Relation_153942

Reference

Relation_153940

Relation_153940

Reference

Relation_153934

Relation_153934

Reference

Relation_1374443

Relation_1374443

Reference


List of Attributes of the Entity LeaveType

Name

Code

Leave Type ID

LeaveTypeId

Leave Credit

LeaveCredit

Leave Abbreviation

LeaveAbbrev

Color Code

LeaveColorCode

Active

LeaveTypeActive

Description

LeaveTypeDesc

Leave Unit

LeaveUnit

Has Special Eligible

HasSpecialEligible

Special Eligible Code

SpecialEligibleCode

Special Eligible Method

SpecialEligibleMethod

Special Eligible Value

SpecialEligibleValue


Entity Attribute Leave Type ID of the Entity LeaveType

Card of Attribute Leave Type ID of the Entity LeaveType

Name

Leave Type ID

Code

LeaveTypeId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Leave Type ID of the Entity LeaveType

Stores the identity for the type of leave. It is the primary key for the LeaveType table.
Example: Absent / Annual / Late etc.


Entity Attribute Leave Credit of the Entity LeaveType

Card of Attribute Leave Credit of the Entity LeaveType

Name

Leave Credit

Code

LeaveCredit

Data Type

smallint

Mandatory

No


Description of Attribute Leave Credit of the Entity LeaveType

Shows the leave credit for the employee.


Entity Attribute Leave Abbreviation of the Entity LeaveType

Card of Attribute Leave Abbreviation of the Entity LeaveType

Name

Leave Abbreviation

Code

LeaveAbbrev

Data Type

char(2)

Mandatory

No


Description of Attribute Leave Abbreviation of the Entity LeaveType

Shows the abbreviations of the leave.
Example: "AB" = Absent / "AN" = Annual / "MA" = Maternity etc


Entity Attribute Color Code of the Entity LeaveType

Card of Attribute Color Code of the Entity LeaveType

Name

Color Code

Code

LeaveColorCode

Data Type

integer

Mandatory

No


Description of Attribute Color Code of the Entity LeaveType

Shows the colour codes set for each type of leave.


Entity Attribute Active of the Entity LeaveType

Card of Attribute Active of the Entity LeaveType

Name

Active

Code

LeaveTypeActive

Data Type

smallint

Mandatory

No


Description of Attribute Active of the Entity LeaveType

Shows if the leave type is active.


Entity Attribute Description of the Entity LeaveType

Card of Attribute Description of the Entity LeaveType

Name

Description

Code

LeaveTypeDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity LeaveType

Shows the description of the leave type.
Example: Absent / Annual / Maternity etc


Entity Attribute Leave Unit of the Entity LeaveType

Card of Attribute Leave Unit of the Entity LeaveType

Name

Leave Unit

Code

LeaveUnit

Data Type

smallint

Mandatory

No


Description of Attribute Leave Unit of the Entity LeaveType

Shows the unit for the leave.


Entity Attribute Has Special Eligible of the Entity LeaveType

Card of Attribute Has Special Eligible of the Entity LeaveType

Name

Has Special Eligible

Code

HasSpecialEligible

Data Type

smallint

Mandatory

No


Description of Attribute Has Special Eligible of the Entity LeaveType

Indicates if the employee is eligible for that type of leave, in a form of a checkbox. Eligibility is determined by the number of months before or after a specific date. However, not all leave types have this eligibility. The leave types that have this eligibility are: Absent, Annual, Compassionate, Late and No Pay Leave.


Entity Attribute Special Eligible Code of the Entity LeaveType

Card of Attribute Special Eligible Code of the Entity LeaveType

Name

Special Eligible Code

Code

SpecialEligibleCode

Data Type

char(20)

Mandatory

No


Description of Attribute Special Eligible Code of the Entity LeaveType

Shows the option for the eligibility of the leave type. Eligibility is determined by the number of months before or after a specific date.
Example: The default setting for maternity leave is 6 months before "the birth of child". In order to trigger this, the employee would need a child record. The Date-of-Birth of the child and Date-of-Hire of the employee would be compared to determine the eligibility. The leave would not be initialised if the employee is not eligible.


Entity Attribute Special Eligible Method of the Entity LeaveType

Card of Attribute Special Eligible Method of the Entity LeaveType

Name

Special Eligible Method

Code

SpecialEligibleMethod

Data Type

char(20)

Mandatory

No


Description of Attribute Special Eligible Method of the Entity LeaveType

Shows the option for the eligibility of the leave type. Eligibility is determined by the number of months before or after a specific date.
Example: This employee is eligible for this particular type of leave if he has worked more than 5 months "before/after" the birth of his child.


Entity Attribute Special Eligible Value of the Entity LeaveType

Card of Attribute Special Eligible Value of the Entity LeaveType

Name

Special Eligible Value

Code

SpecialEligibleValue

Data Type

integer

Mandatory

No


Description of Attribute Special Eligible Value of the Entity LeaveType

Shows the number of months the employee has worked. Eligibility is determined by the number of months before or after a specific date.
Example: This employee is eligible for a particular type of leave if she has worked for more than "3" months