Revised Version of OTA Delay

OTA Delay Logic for Login Trips

We are trying to figure out why a trip got delayed.
There are three possible reasons: Driver Delay, Employee Delay, or Traffic Delay.

We check them in this order:
Trip Delay → Driver Delay → Employee Delay → Traffic Delay

? Step 0: Check if Trip is Delayed

• A trip is called delayed if:
  Actual Trip End Time > Planned Trip End Time + Grace Time

? If trip is not delayed → No issue.
? If trip is delayed → Go to Step 1.

? Step 1: Driver Delay (only for the first employee)

• Compare driver’s arrival time at the first employee pickup with that employee’s planned sign-in time.

Condition:
If
Driver Reporting Time > First Employee’s Planned Sign-In Time + Grace Time
? Delay = Driver Delay

⚠️ Special Case: If the first employee is a No-Show, then check the next planned employee for driver delay.

? Step 2: Employee Delay (checked for each employee)

If the driver was not late, then we check the employees.

Condition:
If
Employee Actual Sign-In Time > Employee Planned Sign-In Time + Grace Time
? Delay = Employee Delay

This check is done for each employee on the trip.

? Step 3: Traffic Delay

If neither Driver nor Employee caused the delay,
? Delay = Traffic Delay

? Super Simple Version

1. First, see if the trip ended late.

2. If yes, check if driver came late for the first employee → Driver Delay.

3. If not, check if any employee signed in late → Employee Delay.

4. If neither driver nor employees were late → It’s Traffic Delay.