Skip to main content
All CollectionsReference GuidesQuick ReferenceReport References
Activity Detail By Job Number QRG - Capacity IQ® Transport
Activity Detail By Job Number QRG - Capacity IQ® Transport
William Pelino avatar
Written by William Pelino
Updated over 5 months ago

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.

image-20240425-161531.png

Job #

  • Enter a From and To range if you are looking for specific job numbers.

image-20240425-161646.png

Job Type

  • You can choose to run this report for Patient jobs only, Item jobs only, or both Patient and Item jobs combined.

image-20240422-174046.png

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.

image-20240425-161816.png

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).

image-20240425-162021.png

Location

  • Select which jobs to include in the report based on either an Origin, Destination, or Both. The report defaults to include all locations.

image-20240425-162113.png

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.

image-20240425-162207.png

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.

image-20240425-162259.png

Sort By

  • Choose how the data is sorted. Options include:

    • Completion Date

    • Destination

    • Job #

    • Origin

    • Patient

    • Reason Code

    • Transporter

image-20240425-162439.png

Protected Health Information (PHI)

  • You can choose to display or omit patient PHI in the report.

image-20240425-162522.png

Output

  • Choose the format of the report data. Options include Adobe, Excel, or Excel Unformatted.

image-20240422-174225.png

Run Report

  • Click Run Report once all fields are populated.

image-20240410-174440.png

Analyzing The Activity Detail By Job Number Report

image-20240425-162616.png

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
Destination: Include All Discharge 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

Did this answer your question?