|
This entity would record the different types of Pay patterns for any week in general. This weekly Pay Pattern would not include the public holiday or company given 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 pay pattern of the company. This is the primary key for the WeeklyPayPattern table. |
|
Name |
|
|
Code |
|
|
Data Type |
decimal(4,3) |
|
Mandatory |
No |
|
This attribute holds the payment 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 payment 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 payment 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 payment 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 payment 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 payment 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 payment 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 |
|
|
|