Example With Sample Data

Employee Location Track

S.No. User Screen Name Equipment Type Tracked Timestamp Notes
1 KKALL01 RF Pick Jan 9 2025, 9:10:00 am
2 KKALL01 RF Pick Jan 9 2025, 9:15:00 am
3 KKALL01 RF Pick Jan 9 2025, 9:20:00 am
4 KKALL01 RF Cycle Count Jan 9 2025, 9:25:00 am Change in screen name
5 KKALL01 RF Cycle Count Jan 9 2025, 9:30:00 am
6 KKALL01 RF Pick PLT_JK Jan 9 2025, 9:35:00 am Change in screen name and equipment
7 KKALL01 RF Pick PLT_JK Jan 9 2025, 9:45:00 am
8 KKALL01 RF Pick Jan 9 2025, 9:50:00 am Change in equipment
9 KKALL01 RF Pick Jan 9 2025, 9:55:00 am
10 KKALL01 Jan 9 2025, 10:20:00 am RF Logout
11 KKALL01 Jan 9 2025, 11:05:00 pm RF Login
12 KKALL01 RF Pick Jan 9 2025, 11:55:00 pm
13 KKALL01 RF Pick Jan 10 2025, 12:05:00 am
14 KKALL01 Jan 10 2025, 10:20:00 am

WMS Activity

(screen - RF Mod IBLPN)

15 KKALL01 RF Pick Jan 10 2025, 10:30:00 am
16 KKALL01 RF Pick Jan 10 2025, 10:35:00 am
17 No activity after this. So last two records will not be moved to Employee Travel Time unless 24 hours have passed since Jan 10 2025, 10:35:00 am

Employee Travel Time

S.No. User Screen Name Equipment Type First Tracked Timestamp Last Tracked Timestamp Travel Time Records Consolidated from the Above Table (Employee Location Track)
1 KKALL01 RF Pick Jan 9 2025, 9:10:00 am Jan 9 2025, 9:20:00 am 600 1, 2, and 3
2 KKALL01 RF Cycle Count Jan 9 2025, 9:25:00 am Jan 9 2025, 9:30:00 am 300 4 and 5
3 KKALL01 RF Pick PLT_JK Jan 9 2025, 9:35:00 am Jan 9 2025, 9:45:00 am 600 6 and 7
4 KKALL01 RF Pick Jan 9 2025, 9:50:00 am Jan 9 2025, 9:55:00 am 300 8 and 9
5 KKALL01 RF Pick Jan 9 2025, 11:55:00 pm Jan 10 2025, 12:05:00 am 600 12 and 13

Daily Travel Time

User Screen Name Equipment Type Date Travel Time Records Consolidated from the Above Table (Employee Travel Time)
KKALL01 RF Pick Jan 9 2025 600 + 300 + 600 1, 4, and 5
KKALL01 RF Cycle Count Jan 9 2025 300 2
KKALL01 RF Pick PLT_JK Jan 9 2025 600 3