Attendance Status By Planned Shifts.

This report helps in the calculation of how many people were present across the planned shifts defined. If designation data is provided, it helps to visualise how many people were present in a particular shift belonging to a particular designation.

Helpful terminologies:

ActualCheckInTime: When a person actually Clocked-In and started their shift.
ActualCheckOutTime: When a person actually Clocked-Out and ended their shift.
ExpectedCheckInTime: The pre-defined shift allotted Check-In time, that is, when the person is expected to start the shift.
ExpectedCheckOutTime: The pre-defined shift allotted Check-Out time, that is, when the person is expected to end the shift.
Actual Shift: The time interval between ActualCheckInTime and ActualCheckOutTime.
Shift: The time interval between ExpectedCheckInTime and ExpectedCheckOutTime.

Notes:

• For calculating we always consider ActualCheckInTime and ActualCheckOutTime. But If a person has not Clocked-Out then for appropriate calculation of durations, it is considered as equal to the ExpectedCheckOutTime.

• If the ACTUAL_CLOCK_OUT event is not being sent at all, in that case, a “Default Clock Out interval” can be set which is 8 hours by default but can be edited depending on the requirement. It means - ActualCheckOutTime = ActualCheckInTime + “Default Clock Out interval”.

Visual Representation for determining Attendance Status:

1. If a person has Clocked-In before the shift starts but Clocked-Out within the shift. The person is considered as present in that shift.
   

   Example: The person’s Actual Shift is from 19th Jan 7:00 AM to 19th Jan 10:00 AM and Shift is from 19th Jan 8:00 AM to 19th Jan 11:00 AM. In this case, the person is considered as present within the Shift.

   

2. If a person falls in neither of the shifts defined, they will not be considered as present in any shift.
   

   Example: The person’s Actual Shift is from 19th Jan 6:00 AM to 19th Jan 7:00 AM and Shift is from 19th Jan 8:00 AM to 19th Jan 11:00 AM. In this case, the person is considered Absent.

   

3. If a person Clocked-In before shift 1 started and Clocked-Out in shift 2 which is after shift 1. Then the person will be considered present in both shifts.
   

   Example: The person’s Actual Shift is from 19th Jan 7:00 AM to 19th Jan 12:00 Noon and the two pre-defined Shifts are from 19th Jan 8:00 AM to 19th Jan 11:00 AM and 19th Jan 11:00 AM to 19th Jan 2:00 PM. In this case, the person is considered present in both shifts.

   

4. If a person Clocked-In after shift 1 started and Clocked Out in shift 2 which is after shift1. Then the person will be considered present in both shifts.
   

   Example: The person’s Actual Shift is from 19th Jan 10:00 AM to 19th Jan 12:00 Noon and the two pre-defined Shifts are from 19th Jan 8:00 AM to 19th Jan 11:00 AM and 19th Jan 11:00 AM to 19th Jan 2:00 PM. In this case, the person is considered present in both shifts.

   

5. If a person’s ActualCheckOutTime is at the precise time the shift starts then the person is included as present in the shift.
   

   Example: The person’s Actual Shift is from 19th Jan 7:00 AM to 19th Jan 8:00 AM and Shift is from 19th Jan 8:00 AM to 19th Jan 11:00 AM. In this case, the person is considered Present in that shift.

   

6. If a person’s ActualCheckInTime is at the precise time the shift ends then the person won’t be included in the shift.
   

   Example: The person’s Actual Shift is from 19th Jan 11:00 AM to 19th Jan 1:00 PM and Shift is from 19th Jan 8:00 AM to 19th Jan 11:00 AM. In this case, the person is considered Absent in that shift.

   

7. If a person’s ActualCheckInTime is the same as ActualCheckOutTime and it is at the precise point the Shift ends then the person won’t be included in the shift.
   

   Example: The person’s Actual Shift is from 19th Jan 11:00 AM to 19th Jan 11:00 AM and Shift is from 19th Jan 8:00 AM to 19th Jan 11:00 AM. In this case, the person is considered Absent in that shift.

   

8. If a person’s ActualCheckInTime is the same as ActualCheckOutTime and it is at the precise point the Shift starts then the person will be included in the shift.
   

   Example: The person’s Actual Shift is from 19th Jan 8:00 AM to 19th Jan 8:00 AM and Shift is from 19th Jan 8:00 AM to 19th Jan 11:00 AM. In this case, the person is considered present in that shift.

   

9. If a person has Checked In the previous day and his/her/their shift extends to the next day and they fall within the two shifts range following the points above. In this case, the person will be considered in both shifts.
   

   Example: The person Clocks-In on 19th Jan 7:00 PM and his shift starts from 19th Jan 9:00 PM to 11:59 PM. The person has to extend the shift to the other day and Clocks-Out on 20th Jan 2:00 AM. The other day shift is defined from 20th Jan 1:00 AM to 20th Jan 3:00 AM. In this case, the person is considered present in 19th Shift 9:00-11:59 as well as 20th Shift 1:00-3:00.

   

---