Time Logs Integrity Audit

Checking for common data issues in the time_logs table...

ISSUE: Julia Espinosa-Gonzalez has a Long ( > 16h ) shift on 2026-01-26 11:15:00 (ID: 113, Hours: 74.74)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 28 (2026-01-12 10:15:00) and ID 60 (2026-01-19 10:10:15)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 79 (2026-01-18 16:30:00) and ID 81 (2026-01-19 12:30:22)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 95 (2026-01-20 10:31:00) and ID 96 (2026-01-20 13:45:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 97 (2026-01-20 10:30:00) and ID 98 (2026-01-20 13:30:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 99 (2026-01-22 08:02:11) and ID 102 (2026-01-23 06:07:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 103 (2026-01-23 11:29:00) and ID 104 (2026-01-23 14:31:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 115 (2026-01-27 07:56:49) and ID 117 (2026-01-29 11:25:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 117 (2026-01-29 11:25:00) and ID 119 (2026-01-28 08:02:49)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 138 (2026-01-26 14:15:00) and ID 139 (2026-01-29 14:25:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 139 (2026-01-29 14:25:00) and ID 140 (2026-01-27 14:25:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 172 (2026-02-16 07:53:38) and ID 173 (2026-02-12 11:43:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 174 (2026-02-12 14:43:00) and ID 175 (2026-02-16 12:48:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkouts: ID 184 (2026-02-18 12:50:00) and ID 185 (2026-02-16 09:45:00)
ISSUE: Julia Espinosa-Gonzalez has two consecutive checkins: ID 186 (2026-02-16 09:48:00) and ID 187 (2026-02-18 09:50:00)
ISSUE: Marlen Adame-Lopez has two consecutive checkouts: ID 114 (2026-01-26 11:15:00) and ID 135 (2026-01-26 14:15:00)
ISSUE: Overlapping shifts for Julia Espinosa-Gonzalez!
Shift A: 2026-01-23 06:53:12 to 2026-01-23 14:31:00 (ID: 104)
Shift B: 2026-01-23 08:30:36 to 2026-01-26 11:15:00 (ID: 113)
ISSUE: Overlapping shifts for Julia Espinosa-Gonzalez!
Shift A: 2026-02-17 10:30:00 to 2026-02-17 13:30:00 (ID: 179)
Shift B: 2026-02-17 10:29:48 to 2026-02-17 15:46:00 (ID: 181)

Total issues found: 18



Return to Dashboard