Activity Detail By Job Number Report
The Activity Detail by Job Number Report shows status change details for each completed transport transaction. This report uses a wide range of data filter options to include specific patients, transporters, locations, and job types.
Best Practice Metrics Captured In The Activity Detail By Job Number Report
Metric | Best Practice Goal |
% Of Discharges Completed By Transport Department Note: See Discharges by Transport section of this reference guide for additional details on this metric | 70% |
Generating The Activity Detail By Job Number Report
Database - Where Your Facility's Data Is Stored
Production - Data that is stored in the production database (this is your current data).
Use when live up-to-the-minute data is needed.
Contains the data from the current time and for the past number of days as defined in Archive Management. This is typically 7 days but may range between 1 and 30 days. If you do not know the number of days, your TeleTracking System Administrator should be able to assist.
Archive - Data that is stored in the archive database (this is your older data).
Does not capture data for the current day.
Users can access reports as far back as the go-live date.
Campus
Campus Drop-Down
Defaults to your campus. The only exception is if you have access to multiple campuses. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate a report.
Date & Time
Completion Date
Click on the Calendar Icon to select the needed dates.
The system defaults to the entire day however, you may want to isolate specific shifts if you are trying to investigate issues with not meeting metrics.
Job #
Enter a From and To range if you are looking for specific job numbers.
Job Type
You can choose to run this report for Patient jobs only, Item jobs only, or both Patient and Item jobs combined.
Patient
You can run this report for a specific patient if you choose. If you leave set to the default, the report will include all patients.
Search By
Employee
Defaults to include all transporters (recommended).
Click on the magnifying glass to choose a specific transporter.
Employee Category
Will run the report only for the chosen category. You must have these categories built-in dictionary management to use this option (not commonly used).
Location
Select which jobs to include in the report based on either an Origin, Destination, or Both. The report defaults to include all locations.
Reason Code
You can run the report based on specific reason codes for delays. Only those jobs delayed for the specific reason(s) will be reported. If you need to select multiple reason codes, press the Ctrl keyboard button and click the desired reason codes. If no reason codes are selected, the report will default to include all delay reasons.
Completion Time
Enter the number of minutes that it should take for a transport job to go from Pending status to Completed status. A transport job that takes longer than this number of minutes to complete will be noted with a * in the OVR column of the report.
Sort By
Choose how the data is sorted. Options include:
Completion Date
Destination
Job #
Origin
Patient
Reason Code
Transporter
Protected Health Information (PHI)
You can choose to display or omit patient PHI in the report.
Output
Choose the format of the report data. Options include Adobe, Excel, or Excel Unformatted.
Run Report
Click Run Report once all fields are populated.
Analyzing The Activity Detail By Job Number Report
Above is an example Activity Detail By Job Number Report. We will now break down the information to learn how to read the data.
Job Number - The job number for the transport job.
Requester - The name of the user that requested the transport job.
Origin - The location where the transport job began.
Destination - The location where the transport job ended.
Patient/Item - Displays the name of the patient or item being moved.
Note: For an outpatient transport job, this column will display ‘Outpatient’.
Appt - Time the transport job status became an Appointment.
Pend. - Time the transport job status became Pending.
Disp. - Time the transport job status became Dispatched.
InProg. - Time the transport job status became In Progress.
Comp. - Time the transport job status became Completed.
Outlier InPg/Comp - Job In Progress > 100 minutes; Job Completion < 3 minutes or > 100 minutes. Outliers show ‘*’.
Transporter - Names of the transporter(s) who were dispatched to the job.
Delay Code - If a transport job was in any delay status, the reason for the delay will appear here.
Ovr - Job completion is > than the Completion Time parameter set prior to generating the report. Jobs that went over the completion time parameter set when running the report will show *.
Total # of Requests - Total number of transport requests falling within the chosen report parameters.
Average Completion Time - Average time from Pending to Complete for all jobs. This is also known as Total Trip Time.
# Over (Completion Time) - Total number of jobs over the Completion Time parameter set prior to running the report.
Total # of Outliers - Total number of jobs considered outliers falling with the chosen report parameters.
Completion Time Objective from Pending to Completion - This is the parameter that was set prior to running the report.
% Over (Completion Time) - Percentage of jobs > than the Completion Time parameter set prior to running the report.
Discharges By Transport
As mentioned previously, the Average Discharges/Transfers Report is also used to help calculate the Best Practice Metric for the Percentage of Discharges Completed by Transport. In order to ensure the accuracy of data, there are two specific reports that will need to be run to capture data points for a calculation. The two reports are the Activity Detail by Job Number and the Average Discharges/Transfers Report.
Report To Run | Instructions For Generating Report Parameters | Metric To Capture |
Activity Detail By Job Number | Origin: Include All Home Locations | Total Discharges By Transport |
Average Discharges/Transfers | Events To Include: Discharges Only | Total # Of Discharges |
Once the reports are generated and you have captured the metrics, the following calculation will provide the Best Practice Metric for Discharges Completed by Transport.
Total Discharges by Transport / Total # of Discharges = Percentage of Discharges Completed by Transport