Automotive Workshop Staff Scheduling Process

Начало на работния поток/процеса.

Retrieve all technicians from the Staff Data Model who are marked as 'Active' and not currently assigned to a long-term project.

Retrieve all upcoming vehicle service entries from the Appointments Data Model that have not yet been assigned a technician.

Sum the total estimated hours of all assigned tasks for each technician to identify overcapacity.

Subtract the total assigned workload hours from the technician's total available working hours for the week.

Create a task for the Workshop Manager to review the calculated availability and assign technicians to pending appointments.

Update the 'Status' field in the Appointment Data Model to 'Scheduled' once a technician is assigned.

Create a new entry in the Staff Schedule Data Model linking the Technician, the Appointment, and the assigned Time Slot.

Create a task for the assigned technician to review their new schedule and confirm availability.

Send an email to the technician's registered email address with the details of the new scheduled workshop task.

Send an SMS to the customer to inform them that their vehicle service has been officially scheduled.

Update the technician's 'Current Weekly Hours' property in the Staff Data Model to reflect the new assignment.

Generate a report showing the ratio of assigned hours vs. available hours across the entire workshop staff.

Delete the scheduled entry from the Staff Schedule Data Model if the customer cancels the appointment.

Край на работния поток/процеса.