|
A work time profile record contains the start and end time of working hours. Each record can be divided into 2 halves, an 'AM' session and a 'PM' session. It is not specifically morning or afternoon as some shift hours may be in the night, so think of it as 2 parts of a single work day. Each work time profile can be used by more than 1 calendar. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the identity of the work time calendar. It also acts as a primary key for the WTCalendar table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Shows the description of the work time calendar. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the identity of the leave calendar. |
|
Name |
|
|
Code |
|
|
Data Type |
char(2) |
|
Mandatory |
No |
|
Shows the short form of the work time calendar. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the colour codes for the work time calendar. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Shows the work time pattern type. |
|
|
|