CLOCKS_ORDER_BEFORE_PROCESSING

Description:

This parameter determines whether to sort the clocks in the pending table (CLOCK_TRAN_PEND_J) by date and time before processing.

When set to true, the clocks in the pending table are ordered by date and time before processing.

When set to false, the clocks in the pending table are processed based on CTPJ_ID. This is the default.

Note: The default behavior is recommended for most customers. When clocks are ordered by date and time before processing, the work date associated with the clocks could vary, depending on when the clock processor runs.

For example, consider this scenario:

  • The employee's Day Start Time is 21:00.
  • The MAX_OFF_TIME registry value is 4.
  • The CLOCK_TRAN_PEND_J table contains these clock records (in this order):
    • ON June 8, 16:30
    • ON June 8, 21:05
    • OFF June 8, 20:34
    • OFF June 8, 23:03

By default, after the Process Clocks task runs, the 16:30-20:34 clocks are attached to June 8 and the 21:05-23:03 clocks are attached to June 9. Since the 21:05 ON clock is processed before the 20:34 OFF clock, the MAX_OFF_TIME value does not apply.

If the clocks are ordered by date and time before processing, the 21:05 ON clock would be processed after the 20:34 OFF clock. Since the difference in clocks is less than the MAX_OFF_TIME of 4 hours, the 16:30-20:34 and 21:05-23:03 clocks would all be attached to June 8. However, this result assumes the clock processor runs after all the clocks are added to the pending table. If the Process Clocks task runs before the 20:34 OFF clock, the clocks would end up on different work dates as above.

Valid Values:

true, false

Default Value:

false

Location:

system/WORKBRAIN_PARAMETERS/

Effective:

2021.11.00, 7.0.0.39, 2021.08.00.3