Documentation for ProTrack Warehouse 7.5.
The Daily Inquiry in ProTrack Warehouse is a valuable tool for performing validation of work performed; educating employees on engineered standards, ensuring delays are credited to the proper function, and to check employees for performance issues.
The Daily Inquiry screen helps you to see the current performance of an employee. In addition to providing visibility of an employee's workday, this screen provides several additional features for approving, reshuffling, changing, adding or deleting work from the employee's past or present workday.
This section mentions the abbreviations that are present in the Daily Inquiry screen.
Abbreviation |
Expansion and Description |
---|---|
ADD |
Addition – An assignment pending reshuffle. |
CAL |
Calculating – Standard calculation for an assignment is currently processing. |
COM |
Completed – An assignment that was completed by an employee and has been fully processed. |
ERR |
Error – An assignment that was completed by an employee but could not be slotted into the work schedule. |
GRP |
Group – Multiple pre-downloaded assignments worked simultaneously. ProTrackWarehouse groups them together as a single work assignment. |
HLD |
Hold – Assignment is placed on hold. |
KVI |
Key Volume Indicator – An assignment waiting for KVI values to be entered. Example of KVI is number of pallets or number of cases. |
Table 2. Daily Inquiry Abbreviations
To access the Daily Inquiry screen:
Fig.2 Daily Inquiry
To view an employee's details in the Daily Inquiry screen, the employees can be searched for by providing the following search criteria in the Search Daily Inquiry screen:
To search for an employee:
Fig.3 Daily Inquiry - Initial Search
Tips
Fig.4 Daily Inquiry - Search
Fig.5 Daily Inquiry - Detailed View of an Employee's Daily Activity
Tip
The centered date matches the "Schedule Date" in the center section below.
The yellow and dark blue bars illustrate the employee's schedules on each day. The yellow bar represents the schedule the employee was assigned to work. The blue bar represents the actual schedules the employee worked. Only days containing actual work schedules will have a blue bar. In the screenshot above, you can see that the employee was assigned to a schedule all 5 days (Saturday through Wednesday), but did not work on Sunday.
Also contained within the bars are the Schedule start and end times:
Fig.6 Daily Inquiry – Weekly View – Schedule Start and End Times Within the Graphs
The date currently being viewed has a hyperlink. Clicking on this enables you to edit the Schedule's start and end times manually. This is useful when the employee did not work the schedule to which they were assigned. The following section describes this process.
Configuring employee Schedules in ProTrack Warehouse provides a pretty good approximation of when employees will be working, but aren't perfect because employees may come in early or late, and likewise may leave early or late. In such cases, it's often necessary to adjust the scheduled start and end times, with the employee's actual start and end times. This is accomplished using either a Time and Attendance data feed (see Section 5.2 in the ProTrack Warehouse Configuration Manual), or by editing the times manually.
Info
If your ProTrack Warehouse system has a Time and Attendance (TA) data feed, then the Schedule start and end times are most often adjusted automatically by the actual swipe-in and out times captured by the TA system. In such cases, editing the Schedule start and end times manually is rarely required.
There are two general types of editing you will do to an employee's work schedule:
In the following screenshot, the employee was scheduled to start at 5:00 a.m. but didn't actually start working until 6:00, so it is necessary to adjust the Schedule start time by an hour. To fix this, click on the blue bar representing the current day's work schedule.
Unable to render embedded object: File (Circle Detailed DI.jpg) not found.
Fig.7 Daily Inquiry – Employee Work Schedule Needs to be Adjusted to Start 1 Hour Later
A popup window appears:
Unable to render embedded object: File (Edit Schedule.jpg) not found.
Fig.8 Daily Inquiry - Edit Schedule
On the left side, enter the new Start Time of 2:00 PM, and click the button. The D.I. refreshes with the new Schedule start time of 2:00 PM. Note the blue bar has shifted to the right by an hour and the Start of Shift activity now has a Start Time of 14:00:00.
Unable to render embedded object: File (Updated Schedule.jpg) not found.
Fig.9 Daily Inquiry – After Edited Schedule Start Time
The same process may be applied for editing a Schedule's End Time.
When an employee is assigned to a Schedule that differs vastly from the actual hours they worked, it's possible that some assignments may have been associated to the wrong work schedule when the WMS files were imported. These situations are easily identified using the Weekly View on the Daily Inquiry screen as the yellow and blue bars will not match up at all. These assignments can be manually transferred to their proper work schedule using a similar approach taken when editing the Schedule's End Time.
In the following screenshot, on 1/10/11 the employee was scheduled to work a 12:30 PM to 1:30 AM shift (as illustrated in the yellow bar). However, the blue bars (representing the actual worked schedule) look strange; the employee's actual work schedules are stretched end-to-end, which indicate that there were assignments occurring during that time when the employee was not scheduled to be working.
Daily Inquiry – Employee Assigned to Incorrect Schedule
This single work schedule contains assignments that should have been split between two work schedules. Scrolling downward to look at the individual assignments reveals this to be obviously true:
Large Gap Between Assignments – These 2 Assignments Should Have Been Associated to 2 Different Work Schedules
To correct this, we want to associate all assignments (up to and including the one ending at 7:45 AM) to the previous day. This is accomplished by editing the end time of the previous day's schedule to sometime after 7:45 AM (perhaps the employee went home at 8:00 AM) and selecting the Assignment Transfer option. Click on the date who's work schedule you want to edit (in this example 1/9/11). Now, viewing the Daily Inquiry for this date, click on the blue bar to edit its Schedule Times.
Edit Schedule – Transfer Assignments by Specifying a New Schedule End Time
On the right side, enter the correct Schedule End Time (when the employee clocked out), select the second radio button "Transfer Assignments", and click Save. The Schedule End Time will be changed to the specified time, and any assignments ending after this specified Schedule End Time will be transferred to the adjacent work schedule. Behind the scenes, ProTrack re-derives the buffer split time (between the two work schedules) based on the specified end time.
Upon saving this Schedule, the next day's (in this example, Monday) Schedule Start Time will most likely adjust to a much later time. It will snap forward in time to when the actual first assignment of the Monday shift occurred. This is evident as the blue bar for Monday 1/10/11 is much shorter and starts at 9:51 PM now.
Worked 1/9/11 Schedule – After Editing End Time & Transferring Assignments
Now note how long the 1/9/11 work schedule is; its Start Time is still set in accordance to the Scheduled Start Time and needs to be adjusted. Edit this to the employee's actual start time as described in the previous section. The final resultant work schedule for 1/9/2011 is shown below.
Final Modified Worked Schedule
Splitting a Work Schedule and Transferring Assignments
There are cases where a single work schedule may need to be split into two separate work schedules. This may occur if an employee leaves for several hours in the middle of his shift or if he worked a split shift on a single day, but his Schedules weren't configured accordingly ahead of time. ProTrack supports the configuration of two Schedules on a single calendar day, but if this isn't configured before the employee works it will be necessary to go back and correct the Work Schedules.
In the example below, this associate was assigned to a typical day-shift schedule (6 AM – 6 PM), but went home for a few hours in the middle of the day. He then returned at 12:30 PM.
Single Work Schedule Needing to be Split Due to Time Off-Clock
To correct this issue, click on the blue bar to edit the Schedule Times. In the popup window, on the right side, enter the time that he clocked out and select the option, "Split Work Schedule and Transfer Assignments". This action will effectively cut the work schedule at the specified End Time; all assignments ending before this time will remain on the current schedule and all assignments after will be transferred to a new work schedule. The Start and End Times of the newly-created work schedule will be determined using the assignments transferred to it.
Split a Work Schedule by Editing Its End Time
Upon clicking the Save button, the Daily Inquiry refreshes back to the same work schedule, which has now been shortened. Note that some of the assignments were transferred out of this work schedule and are no longer listed on the D.I.
Resultant Daily Inquiry – First Work Schedule
To bring up the newly-created work schedule, click the Search button and search for this employee. You will now see two links for this employee for this day, indicating that there are two work schedules on that day. Click on the second link to bring up the second work schedule.
Daily Inquiry Search – Multple Work Schedules for a Single Day
Bringing up the second work schedule for this employee reveals the newly-created work schedule.
Daily Inquiry Header Field Description
Field |
Description |
---|---|
Total Hours |
Total time the Employee worked that day, from SOD to EOD |
Time on Standard |
Total time the Employee spent on Standard Activities |
Adjusted Std. Time Earned |
Total time the Employee should spend on Standard Activities with Learning Curve applied. |
Std Time |
Total time the Employee should spend on Standard Activities |
Delay Time |
Total time spent on Delays. |
Indirect Time |
Total time spent on Indirect Activities |
Paid Break |
Total time an Employee spends on Paid Break |
Unpaid Break |
Total time an Employee spend on an Unpaid Break |
KVI / HLD |
Total time in Standard Activities that are currently in KVI or HLD status |
Adjusted Performance |
The comparison of the Standard Time allowed on a specific task to the Actual Time used for that same task. |
Baseline Performance |
The Comparison of the Standard Time Allowed on a Specific Task or Operation to the Actual Time Used for that Same Task or Operation |
Utilization |
The Comparison of Actual Time on Standard to the Total Time Available. Is Time on Standard divided by (Total time – Break – Lunch). Shows how much time of your day was spend on Standard Activities |
Effectiveness |
The Comparison of Actual Time on Delays to the Total Time Available. is Time on Standard plus Indirect divided by (Total time – Break – Lunch). |