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 |