Ad-Hoc Reporting: Automatic Calculation Columns

Ad-Hoc Reporting: Automatic Calculation Columns

Purpose

Agencies often use standard calculations for time intervals on an incident. Instead of having to create a Custom Column to calculate these time intervals on every report that requires them, First Due created a series of these calculations as Columns inside their respective Data Sources.

Related Articles


Video




Information


  1. Follow the normal procedure for selecting Columns as found in Ad-Hoc Reporting: Columns.
  2. By adding one or more of these columns, the date time difference calculation will be automatically made for you based on the values in the record.
  3. Automatic time calculation columns are usually identified by containing the word "to" or "total" in reference to a time. They also do not have an associated NEMSIS code because they are created internally by calculating between two NEMSIS fields.

Automatic Calculations by Data Source:

ePCR Reports:

PSAP to Unit Notified Time

      Unit Notified by Dispatch (eTimes.03) – PSAP Call (eTimes.01)

Dispatch Notified to Unit Notified Time

      Unit Notified by Dispatch (eTimes.03) – Dispatch Notified (eTimes.02) 

Call Received to Unit En Route Time

      Unit En Route (eTimes.05) – PSAP Call (eTimes.01)

       If PSAP Call (eTimes.01) is null, use Dispatch Notified (eTimes.02)

Unit Notified to En Route Time

      Unit En Route (eTimes.05) – Unit Notified by Dispatch (eTimes.03)

Total Unit Response Time

      Unit Arrived on Scene (eTimes.06) – Unit Notified (eTimes.03) 

Unit En Route to Arrived on Scene Time

      Unit Arrived on Scene (eTimes.06) – Unit En Route (eTimes.05) 

Scene Time 

      Unit Left Scene (eTimes.09) – Unit Arrived on Scene (eTimes.06) 

      If Unit Left Scene is null, use Unit Back in Service (eTimes.13)

Patient Scene Time

      Unit Left Scene (eTimes.09) – Arrived at Patient (eTimes.07) 

      If Unit Left Scene is null, use Unit Back in Service (eTimes.13)

Transport Time

      Patient Arrived at Destination (eTimes.11) – Unit Left Scene (eTimes.09) 

Destination Transfer of Care 

      Destination Patient Transfer of Care (eTimes.12) – Patient Arrived at Destination (eTimes.11) 

Arrival at Destination to Back in Service Time

      Unit Back in Service (eTimes.13) – Patient Arrived at Destination (eTimes.11) 

Destination Patient Transfer of Care to Back in Service

      Unit Back in Service (eTimes.13) – Destination Patient Transfer of Care (eTimes.12)

Total Unit Call Time (Time on Task)

      Unit Back in Service (eTimes.13) – Unit Notified by Dispatch (eTimes.03) 

Total Overall Call Duration

      Unit Back in Service (eTimes.13) – PSAP Call (eTimes.01)

      If PSAP Call (eTimes.01)is null, use Dispatch Notified (eTimes.02), if null, use Unit Notified by  Dispatch (eTimes.03)

Canceled Response Time

      Unit Canceled (eTimes.14) – Unit Notified by Dispatch (eTimes.03) 


Incident Reports:

Total Call Duration

Time to First Arrival



Incident Report Apparatus:

Dispatch to Clear

Dispatch to Enroute

Enroute to Scene

Scene to Clear

Dispatch to Scene


EMS QA/QI:

Days Since Last Update



Hydrants:

Days Since Last Service

Days Since Last Flow Test

​


    • Related Articles

    • Ad-Hoc Reporting: Summary Grouping

      Purpose To demonstrate the different ways that you can group data into a Summary Report in Ad-Hoc Reports. Summary Reports are a broad look at totals, averages, trends, or percentages in your agency's data. This data can then be used to create custom ...

    • Ad-Hoc Reporting: Custom Columns

      Purpose To create a custom calculation column for a Tabular Report in Ad-Hoc Reports in the Reports Module. Related Articles Report List Features Ad-Hoc Reporting: Report Type Ad-Hoc Reporting: Columns Ad-Hoc Reporting: Sort Ad-Hoc Reporting: Data ...

    • Ad-Hoc Reporting: Columns

      Purpose To demonstrate how to create the Columns to display the chosen fields from your Data Source in an Ad-Hoc Report. Columns are created to show the pertinent data fields from the records in your Tabular Report. Related Articles Report List ...

    • Ad-Hoc Reporting: Summary Rows

      Purpose This article will review creating Summary Rows in a Tabular report in Ad-Hoc Reports. Related Articles Report List Features Ad-Hoc Reporting: Report Type Ad-Hoc Reporting: Columns Ad-Hoc Reporting: Tabular Grouping Video Instructions 1. ...

    • Ad-Hoc Reporting: Sort

      Purpose This article will review the Ad-Hoc Sorting Section within the Reports module. Related Articles Report List Features Ad-Hoc Reporting: Columns Ad-Hoc Reporting: Criteria Video Instructions 1. You are navigating to Sort from Ad-Hoc Reporting: ...