Configuration

Explanation

host*

Host of the reporting database

user*

Database user

password*

Database password

database*

Database Schema to read from

Use Stored Procedure Query

Toggle on will cause the agent to query a SP in SQL. GovWorx will assist in the query fields needed to be returned from SP.

Stored Procedure Name

Name of SP in SQL

Use Method of Call Received for Call Source

Toggle will enable Method of Call Receive field from Response_Master_Incident table to be used for CommsCoach Call Source

Use Confirmation Number for Incident Number

Toggle will enable Confirmation Number field from Response_Master_Incident table to be used for CommsCoach Event Number

Use Time_CallEnteredQueue as CommsCoach Event Date

Toggle will use Time_CallEnteredQueue from Response_Master_Incident table as CommsCoach Event Time

Add Location_Name field to CommsCoach Location

Toggle will append the CAD Address with the Premise Name field from CAD (on: 123 Main Street)

(off: 123 Main Street - Starbucks)

Include caller location in caller name field

Toggle will append the CAD Caller name with the Caller Location field from CAD (on: John Smith)

(off: John Smith - Starbucks Parking Lot)

Filter Out Cloned Incidents

Toggle will enable SQL query to check the linked incidents table and not pull any CAD incidents into CommsCoach that where cloned from other CAD Incidents (i.e. "ADD AGENCY")

Agency Type (NOT IN)

Comma separated values to list agency types to exclude from data query

*Required Field