|
This entity would record the different types of working patterns for any week in general. This weekly work 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 work pattern of the company. It is also the primary key for the WeekWorkPattern table. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Sunday. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Monday. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Tuesday. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Wednesday. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Thursday. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Friday. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute would record the work pattern for that particular day of the week, i.e. Saturday. |
|
|
|