Employee Shift Assignment

This Decision Flow determines which workers are eligible for shift assignment based on availability, position, preferred shift, and worked hours. It effectively filters a roster of employees to find the best match for a specific shift request.

Solution components:

The solution consists of a main Decision Flow that orchestrates two Decision Tables.

• Employee Shift Assignment (Decision Flow) retrieves candidates, evaluates their eligibility, and collects the results.
• Employee Table: A Decision Table that functions as a data lookup. It accepts a "Needed Position" (e.g., Barista, Bartender) as input. It outputs a list of employees fitting that position, along with their current status: "Employee's Name," "Employee Availability," "Maximum Worked Hours Limit," and "Employee's Preferred Shift".
• Assign Decision: A Decision Table that evaluates whether a specific employee can be assigned to the requested shift. It takes the employee's attributes (Availability, Max Hours, Preferred Shift) and the "Shift Needs Workers" time as inputs to produce an "Assign Decision" (Assign/Do Not Assign) and a logic-based "Assign Comment".