Work Code Tiebreaker

Definition: Returns people with the target work code records for the time frame defined by the From and Through fields. This base rule is primarily used to determine who’s next in line for a working opportunity when all things could be equal across a combination of queried work codes and dates; simply put a tie breaking rule.

Return value: Values of type Number. Candidates returned are assigned an order number based on the returned date value. For more information see example at the bottom of this topic.

Source: Staffing Table (checked Roster records), the List Target area, the Special Day Group area, the Advanced tab of the Position area; the General tab of the Work Code area.

Sorting: If this base rule is used for sorting in a List Target or a List, then people with a Work Code Count = 0 return value are preferred (sorted to the top) over other candidates in an ascending sort; otherwise they are pushed to the bottom of the list in a descending sort. If no dynamic ‘Where’ condition is specified then people with empty values or values failing the condition sort at the top in an ascending sort. Records of equal sorting priority for all sorting rules are sorted in random order.

Arguments Value
Work Code gray number(s) A delimited list of the selected work code gray numbers to use for tie breaking. The argument can query multiple codes and returns the dates collectively in a single list.
Return type Number
Minimum hours The minimum number of hours the person must have in the target work code record in order to be counted. If blank or zero Minimum hours will not be performed.
Maximum hours The maximum number of hours the person must have in the target work code record in order to be counted. If blank or zero Maximum hours will not be performed.
From: Defines the start of the time frame to return work code records. Enter a Dynamic date or real date value in the past. The default value is blank.
Through: Defines the end of the last work code record to be returned. If blank the staffing start date is used. The default value is blank.
The table below shows the outcome of one work code, Overtime. This rule evaluates the sort order for candidates using a combination of dates and queried work codes to find the candidate who has not worked an overtime opportunity or has the least recent overtime opportunity. As shown below, in an ascending sort order Chris Tan places in first place because she has not worked any overtime. Jeff, Bart, and Joe are tied equally in third because they have two candidates ahead, Will and Chris.
USER Sort Order Asc. Most Recent Date Last OT Date 1 Last OT Date 2 Last OT Date 3 Last OT Date 4 Last OT Date 5
Tan, Chris 1 none - - - - -
Sisk, Will 2 6-19-2015 6-19-2015 - - - -
Ciraulo, Jeff 3 6-22-2015 6-22-2015 - - - -
Money, Bart 3 6-22-2015 6-22-2015 - - - -
Well, Joe 3 6-22-2015 6-22-2015 - - - -
Lopez, Jim 6 6-22-2015 6-22-2015 6-19-2015 - - -
Tarly, Pat 7 6-24-2015 6-24-2015 6-17-2015 - - -
Castro, Jon 8 6-24-2015 6-24-2015 6-17-2015 6-8-2015 - -
Linh, Bui 9 6-24-2015 6-24-2015 6-17-2015 6-8-2015 6-7-2015 6-6-2015
York, Andy 9 6-24-2015 6-24-2015 6-17-2015 6-8-2015 6-7-2015 6-6-2015