Hexagon 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 Hexagon 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:

SELECT 
	agency_event.cdts as EventCreatedTime,
	agency_event.num_1 as Event_Number,
	agency_event.tycod as Protocol_ID,
	event_type.eng as protocol_Descr,
	agency_event.cpers as Calltaker_ID,
	CONCAT(persl.fname,' ',persl.lname) as Calltaker_Name,
	agency_event.cterm as ComputerName
FROM agency_event
JOIN event_type ON agency_event.tycod=event_type.tycod
JOIN persl ON agency_event.cpers=persl.empid
WHERE
	(agency_event.cdts >= DATEADD(day, -1, CONVERT(date, GETDATE())) AND agency_event.cdts < DATEADD(day, -0, CONVERT(date, GETDATE())))