|
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. |
|
Name |
Code |
Class Name |
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
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 |
|
|
|