ZOLL RescueNet CAD Export Script

Extracting the necessary data from your CAD is a key first step in sending your CAD data to Clear/Voyager AI

Corti customers will begin by using an export from their CAD system to identify and share the CAD records of in scope calls. This is often done with a SQL query, but default exports may also work.

For Corti's Clear/Voyager AI solution, Corti looks for the following data from the CAD for each call:

File Type

Key Data Points

.csv

Incident ID - or other unique Identifier

Call Start Time

Workstation ID - Identifier to pair to channel from Call Recorder

Call Taker ID

Protocol ID - Chief complaint, etc. - this is how the incident protocol will be displayed within Corti

Corti has worked with customers that use Zoll RescueNet CAD systems and have used the following script to high degree of success in the past. As all organizations may opt to configure their systems slightly different, this may require modifications to extract the appropriate data points for your organization. The below script can be used in a daily run to extract CAD data for the previous day's activity:

WITH cte AS (
SELECT 
	CaseNumber,
	Determinant,
	ta.hostname,
	ta.takenby,
	e.name,
	CONCAT(ta.calldate,' ',ta.calltime) AS TripDateTime,
	ROW_NUMBER() OVER (PARTITION BY CaseNumber ORDER BY ta.id) AS rn
FROM ProQASessions p
JOIN Trips_Audit ta on p.CaseNumber = ta.IncidentID
JOIN Employees e ON ta.takenby=e.code
WHERE 
	(CAST(calldate AS DATE) >= DATEADD(day, -1, CONVERT(date, GETDATE())) AND CAST(calldate AS DATE) < DATEADD(day, -0, CONVERT(date, GETDATE())))
)
SELECT  
	CaseNumber,
	Determinant,
	hostname,
	takenby,
	name,
	TripDateTime
FROM cte
WHERE rn = 1;