Example: Pair Formation and Generating Time Tickets
The following is an example to illustrate how information derived from time events is stored in tables.
In the example, work time events from Communication Channel 2 (CC2) are used, that is, the data comprises completion confirmations from PP.
Times are processed including seconds. In the following examples, the times are specified without seconds for the sake of clarity. The date has also been omitted.
Pair formation and time ticket generation using an example
A notification of set up begin for 06:00 is to be processed for an employee. There are no further time events for the day in question.
The following entries are made in the pair table PT:
From - To |
Pair type |
Status from pair formation |
____ - 06:00 |
1 (at work) |
2 (no clock-in) |
06:00 - ____ |
1 (at work) |
E (no end notification) |
The following entry is created in the time ticket table WST:
From - To |
Labor time |
Setup time |
06:00 - ____ |
0.00 hrs |
0.00 hrs |
The following entry is in the link table AT:
Line PT |
Line WST |
Status labor/setup time |
2 |
1 |
Set up |
The system now receives a clock-in posting for 05:55. This means that the entries in the pair table PT are as follows:
From - To |
Pair type |
Status from pair formation |
05:55 - 06:00 |
1 (at work) |
BLANK |
06:00 - ____ |
1 (at work) |
E (no end notification) |
No changes are made to tables WST and AT.
The system now processes a setup end notification for 07:00 and a work begin notification for 07:06
The entries in the pair table PT are then as follows:
From - To |
Pair type |
Status from pair formation |
05:55 - 06:00 |
1 (at work) |
BLANK |
06:00 - 07:00 |
1 (at work) |
BLANK |
07:00 - 07:06 |
1 (at work) |
BLANK |
07:06 - ____ |
1 (at work) |
E (no end notification) |
The following is added to the existing entry in time ticket table WST:
From - To |
Labor time |
Setup time |
06:00 - 07:06 |
0.00 hrs |
1.00 hrs |
The entry in the link table AT is as follows:
Line PT |
Line WST |
Status labor/setup time |
2 |
1 |
Set up |
4 |
1 |
Labor |
The system now processes a work end notification for 10:00.
The entries for the day in the pair table PT are then as follows:
From - To |
Pair type |
Status from pair formation |
05:55 - 06:00 |
1 (at work) |
BLANK |
06:00 - 07:00 |
1 (at work) |
BLANK |
07:00 - 07:06 |
1 (at work) |
BLANK |
07:06 - 10:00 |
1 (at work) |
BLANK |
10:00 - ____ |
1 (at work) |
3 (no clock-out posting) |
The following is added to the existing entry in the time ticket table WST:
From - To |
Labor time |
Setup time |
06:00 - 10:00 |
2.40 hrs |
1.00 hrs |
No changes are made to the entries in the link table AT:
Line PT |
Line WST |
Status labor/setup time |
2 |
1 |
Set up |
4 |
1 |
Labor |
Finally, the system processes a work begin notification for 10:30 and a work end notification for 11:00.
The entries for the day in pair table PT are as follows:
From - To |
Pair type |
Status from pair formation |
05:55 - 06:00 |
1 (at work) |
BLANK |
06:00 - 07:00 |
1 (at work) |
BLANK |
07:00 - 07:06 |
1 (at work) |
BLANK |
07:06 - 10:00 |
1 (at work) |
BLANK |
10:00 - 11:00 |
1 (at work) |
BLANK |
11:00 - ____ |
1 (at work) |
3 (no clock-out posting) |
A new entry is created in the time ticket table:
From - To |
Labor time |
Setup time |
06:00 - 10:00 |
2.40 hrs |
1.00 hrs |
10:30 - 11:00 |
0.50 hrs |
0.00 hrs |
An entry is also added to link table AT:
Line PT |
Line WST |
Status labor/setup time |
2 |
1 |
Set up |
4 |
1 |
Labor |
6 |
2 |
Labor |
The employee’s daily work schedule is used as the basis for calculating actual times. In the above example, the employee has a break of 30 minutes during the period from 07:06 to 10:00.