AngelTrack's Data Storage, Archival, and Exports

A walkthrough of how long AngelTrack stores your data, how it's stored, as well as how it can be exported

AngelTrack retains data for up to seven years, depending on the type of data. It is easy to pull data out of AngelTrack, for archival or for analysis in other software applications.

Warehouse

Data Lifetime

Most data in AngelTrack is stored for seven years, then automatically destroyed. A few data types are stored for less than seven years:

Data Type

Lifetime

Dispatch journals

6 years

Invoice journals

2 years

PHI access log

6 years

Checklist answers

2 years

PCR procedures marked 'deleted'

2 years

Documents marked 'deleted'

2 years

Announcements expired or marked 'inactive'

2 years

Payment events marked 'inactive'

2 years

Requests for transport

2 years

"Prior authorization notes" field

2 years after the receivable is marked "Finished"

Raw webserver logs

60 days

Everything else

7 years

All Grids Exportable as .CSV

Every data grid everywhere in AngelTrack is exportable. Just click the Export-Sep-21-2022-12-17-50-79-AM button, shown at the right-hand side of the grid's header row.

The export will be downloaded to you as a "comma-separated values" file, also known as a .CSV file. Many other software applications understand .CSV files and can easily import them -- notably including Microsoft Excel.

The exported .CSV will always contain whatever data is presently showing in the grid, so you can adjust the grid's filters first and then export it once you've got the grid just the way you like it.

Your spreadsheet application can then convert it to .PDF

Once you export an AngelTrack grid to Microsoft Excel™ or Google Sheets™, the resulting spreadsheet can export itself as a .PDF. You may wish to adjust your column widths and data-formats first.

All Run Reports Exportable as .PDF

Every dispatch -- whether scheduled, open, delegated, closed, or cancelled -- has an exportable run report. Links labelled "PDF" appear in many places, offering to download the dispatch's run report as a .PDF file viewable on any computer with a .PDF viewer installed.

You can also download .PDF run reports in bulk, zipped up in a batch. Most of the billing queues offer this option, as do the Closed Dispatches and Patient Edit pages. The bulk export button appears at the top right-hand side of the page. The .PDFs are bundled into a .ZIP file, along with a small Excel spread showing a summary of the included dispatches (origin, destination, patient name, etc.), and then downloaded to you.

Compact .PDFs are available too

If you intend to print the run reports on paper, and wish to conserve as much paper as possible, then choose the "Compact PDF" option. This will eliminate all of the page breaks that are normally used for readability. The entire contents of the report will be fit into the smallest possible number of pages.

All Run Reports Exportable as NEMSIS 3 .XML

All run reports are always available for export in NEMSIS 3 format. This format is an .XML document that contains all dispatch and PCR information, including electronic signatures, scanned documents, ECG strips, and so on.

The NEMSIS format was established by the NEMSIS committee for the purpose of data interchange between EMS software applications. It is used to send data from a CAD application to a PCR application, and from a PCR application to a billing application. NEMSIS version 2, aka NEMSIS "gold", is an obsolete older version; the current specification is NEMSIS version 3, with which AngelTrack is certified compliant.

AngelTrack includes extra data in the NEMSIS 3 XML, as custom values (eCustom/eCustomResults), including patient notes, billing notes, and custom PCR fields. To see the format of this additional data, refer to the State Uploads Guide.

As with .PDF exports, you can download your NEMSIS 3 .XML exports in bulk.

All Charts Exportable as Image or .CSV

Every chart everywhere in AngelTrack is exportable.

To export just the chart image, right-click it and select the appropriate "Save As..." or "Save Image As..." from your browser's popup menu.

To export the data underlying the chart, click the Export-Sep-21-2022-12-18-05-96-AM button, shown at the bottom left-hand side of the chart. The data will be downloaded as a .CSV file in the same way grids do.

Most Core Data Exportable Via the Data Export Hub

AngelTrack's core data tables -- dispatches and shifts and timeclock and such -- are exportable to .CSV by means of the Data Export Hub, which is accessible from Supervisor Home and from Billing Home.

When using the Data Export Hub, you must be a member of the Biller, Administrator, or Principal security role in order to access the finance-related data sources.

The Bulk Excel Exporter

Under Billing Home there is a tool called Bulk Excel Export. It allows you to filter a set of dispatches and then export them to Excel as a .CSV. The exported data includes about a hundred different columns, containing everything you might want to know about each dispatch.

The raw data can be used to create all manner of derivative reports using Excel's formulas, scripts, and charts. Or feed it to some other application.

If you need a piece of data that is not already a column in the export, just call AngelTrack support and request that it be added.

Programmatically Exporting Data

AngelTrack offers up many of its key records for download using URLs, so that bulk data exports can be automated:

/dispatch/xxxx Downloads the full run report for dispatch ID xxxx, as an HTML document with linked images.
/dispatch/pdf/xxxx Downloads a self-contained PDF of the full run report for dispatch ID xxxx.
/dispatch/erdropoff/xxxx Downloads the ER dropoff report for dispatch ID xxxx, as an HTML document.
/dispatch/erdropoff/pdf/xxxx Downloads a self-contained PDF of the ER dropoff report for dispatch ID xxxx.
/payment/receipt/xxxx Downloads payment event xxxx in receipt format, as an HTML document.
/payment/receipt/pdf/xxxx Downloads a self-contained PDF of payment event xxxx in receipt format.
/invoice/xxxx Downloads invoice xxxx in printable format, as an HTML document.
/invoice/pdf/xxxx Downloads a self-contained PDF of invoice xxxx in printable format.
/invoice/receipt/xxxx Downloads a printable receipt for all payments made to invoice xxxx, as an HTML document.
/invoice/receipt/pdf/xxxx Downloads a self-contained PDF of a printable receipt for all payments made to invoice xxxx.
/batch/xxxx Downloads all claims in EDI batch xxxx, as a single 837P text document ready for upload to a clearinghouse.
/batch/pdf/xxxx Downloads all claims in EDI batch xxxx, as a single .PDF document containing one completed CMS-1500 form per claim.
/claim/pdf/xxxx Downloads the filled-out CMS-1500 form for dispatch xxxx, using the current coding settings.
/incident/xxxx Downloads a printable copy of incident xxxx, as an HTML document.
/incident/pdf/xxxx Downloads a self-contained PDF of a printable copy of incident xxxx.

For example, the URL https://yourserver.angeltrack.com/dispatch/4033 will retrieve the HTML run report for dispatch ID 4033.

Be wary of an outside biller who does not accept NEMSIS 3

These requests for custom exporters usually come from outside billers, who say their software does not accept NEMSIS 3 and so they need AngelTrack to spit out its calls in a custom format.

It is usually the non-EMS billers who make these requests. They are using ordinary practice-management software -- intended for a doctor's office. If they've never heard of NEMSIS, their software probably doesn't support it because it wasn't built for EMS claims.

All modern software designed for EMS will support NEMSIS 3 datafiles. It's the national standard.