Entity WeekLeavePattern

Description of Entity WeekLeavePattern

This entity would record the different types of Leave patterns for any week in general. This weekly Leave pattern would not include the public holiday or company given holiday. These patterns cover a period of 1 week from Monday to Sunday. Any day of the week can be set as full-day, half-day, quarter-day, off-day or as a holiday.


List of all Dependencies of the Entity WeekLeavePattern

Name

Code

Class Name

Relation_52458

Relation_52458

Reference


List of Attributes of the Entity WeekLeavePattern

Name

Code

Week Leave Pattern ID

WeekLeavePatternId

Leave Sunday

LveSunday

Leave Monday

LveMonday

Leave Tuesday

LveTuesday

Leave Wednesday

LveWenesday

Leave Thursday

LveThursday

Leave Friday

LveFriday

Leave Saturday

LveSaturday


Entity Attribute Week Leave Pattern ID of the Entity WeekLeavePattern

Card of Attribute Week Leave Pattern ID of the Entity WeekLeavePattern

Name

Week Leave Pattern ID

Code

WeekLeavePatternId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Week Leave Pattern ID of the Entity WeekLeavePattern

This attribute is the unique identity for this entity. It uniquely identifies the weekly leave pattern of the company. This is also the primary key for the WeekLeavePattern table.


Entity Attribute Leave Sunday of the Entity WeekLeavePattern

Card of Attribute Leave Sunday of the Entity WeekLeavePattern

Name

Leave Sunday

Code

LveSunday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Sunday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Sunday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Leave Monday of the Entity WeekLeavePattern

Card of Attribute Leave Monday of the Entity WeekLeavePattern

Name

Leave Monday

Code

LveMonday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Monday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Monday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Leave Tuesday of the Entity WeekLeavePattern

Card of Attribute Leave Tuesday of the Entity WeekLeavePattern

Name

Leave Tuesday

Code

LveTuesday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Tuesday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Tuesday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Leave Wednesday of the Entity WeekLeavePattern

Card of Attribute Leave Wednesday of the Entity WeekLeavePattern

Name

Leave Wednesday

Code

LveWenesday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Wednesday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Wednesday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Leave Thursday of the Entity WeekLeavePattern

Card of Attribute Leave Thursday of the Entity WeekLeavePattern

Name

Leave Thursday

Code

LveThursday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Thursday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Thursday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Leave Friday of the Entity WeekLeavePattern

Card of Attribute Leave Friday of the Entity WeekLeavePattern

Name

Leave Friday

Code

LveFriday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Friday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Friday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc


Entity Attribute Leave Saturday of the Entity WeekLeavePattern

Card of Attribute Leave Saturday of the Entity WeekLeavePattern

Name

Leave Saturday

Code

LveSaturday

Data Type

decimal(4,3)

Mandatory

No


Description of Attribute Leave Saturday of the Entity WeekLeavePattern

This attribute holds the leave application pattern for that particular day, i.e. Saturday. It can be 1 for full day. 0.5 for half day, 0.25 for quarter day, etc