Capabilities

Capabilities	Supported
Connector Capabilities
Read	Yes
Backfill	No
Bidirectional Capabilities
Incident Create	No
Incident Update	No
Narrative Update	No

Customers of this CAD may be able to use bidirectional capabilities through IntelliComm. See Bidirectional CAD Integrations.

Overview

The Data Agent connects to Enterpol's SQL Server database. GovWorx needs a user with permission to do so.

Network Requirements: The server running the Data Agent should be able to connect to the CAD Reporting server over port 1433. This can be tested using PowerShell.

PowerShell Command:

Test-NetConnection -ComputerName {CAD Reporting Server name or IP} -Port 1433

Standard Data Fields

These are the standard data fields the Data Agent reads from Enterpol. The tables below show each GovWorx field and the Enterpol column it comes from. Source names are columns of the vCommCoach_IncidentUnits view unless the row says otherwise.

Note: Additional fields are considered enhancement requests.

Incident fields

GovWorx field	Enterpol source	Notes
Incident ID	`IncidentID`
Incident Number	`CadNumber`
Case Number	`CaseNumber`
Incident Type	`IncidentType`
Caller Number	`CallerPhone`
Caller Name	`CallerName`	Only with the Include caller name setting on.
Agency	`Agency`
Incident Date	`IncidentDateTime`
Disposition	`Disposition`
Location	`IncidentAddress1`
Priority	`Priority`
Latitude	`Latitude`
Longitude	`Longitude`
Call Position	`CallTakerPosition`
Call Taker ID	`CallTakerPersonID`	The Use personnel names setting reads CallTaker instead.
Call Taker Name	`CallTaker`
Call Source	`CallSource`
Call Received Time	`DateTimeCallReceived`	The earliest CAD note timestamp setting replaces this with the earliest note time.
Closed At	`DatTimeCallClosed`	The Data Agent reads closed incidents only.

Notes

GovWorx field	Enterpol source	Notes
Note ID	`vCommCoach_IncidentUnitMemos.id`
Note By	`vCommCoach_IncidentUnitMemos.EnteredBy`	The Use personnel names setting reads EnteredByName when the column exists.
Note Text	`vCommCoach_IncidentUnitMemos.Description`	The Data Agent skips empty text.
Note Time	`vCommCoach_IncidentUnitMemos.DateTime`
Initial dispatch note	`IncidentDescription`	Only with the initial dispatch setting on and the column present. One note for each incident, with the call taker as author. The time is IncidentDateTime, or DateTimeCallReceived when empty.
Incident Log memo	`vCommCoach_IncidentLogMemos.Description, ExpandedNotes, enteredby, DateTime`	Only with the Incident Log memos setting on. ExpandedNotes follows Description after a line with two dashes. A memo with the same text and time as an existing note is skipped.

Responders and units

GovWorx field	Enterpol source	Notes
Unit Name	`vCommCoachUnits.UnitName`	Matched on UnitID.
Personnel ID	`UnitCallSign`
Dispatched By	`vCommCoach_IncidentUnitMemos.EnteredBy`	The first memo with TypeOfMemo Dispatched for the unit. Uses CallTaker when there is no such memo or the TypeOfMemo column does not exist. The Use personnel names setting reads EnteredByName.
Dispatched At	`DateTimeUnitNotifiedByDispatch`
Enroute At	`DateTimeUnitEnRoute`
Arrived At	`DateTimeUnitArrivedOnScene`
Cleared At	`DateTimeUnitBackInService`

Data Agent Settings

To prepare for this connection, we need the following details. These are settings in the GovWorx Data Agent configuration for this connector. A toggle is an on/off switch in that configuration.

Setting	Type	Explanation
`Host`	Text	Host of the reporting database
`Use Integrated Security`	Toggle	Whether to use Windows Authentication to connect to the database
`Username`	Text	Database username. Provide when not using integrated security
`Password`	Password	Database password. Provide when not using integrated security
`Database name`	Text	Database name
`Include caller name`	Toggle	Toggle will fill Caller Name from the CAD. When off, Caller Name stays empty.
`Include initial dispatch/call comments as CAD notes`	Toggle	Toggle will add the incident description as the first note of each incident. This works only when the vCommCoach_IncidentUnits view has the IncidentDescription column.
`Use personnel names as personnel IDs`	Toggle	Toggle will use the call taker name as the Call Taker ID. It also uses the EnteredByName column of vCommCoach_IncidentUnitMemos, when present, as the note author.
`Include Incident Log memos from vCommCoach_IncidentLogMemos as CAD notes`	Toggle	Toggle will add Incident Log memos as CAD notes. The vCommCoach_IncidentLogMemos view must exist.
`First-run lookback in hours used only when no last-run cursor exists yet (default: 3)`	Number	Hours back to look on the first run, before the Data Agent has a last-run time. Default: 3.
`Maximum lookback in hours`	Number	Caps how far back a stale cursor can reach so an idle or reconnected connector does not issue an oversized catch-up query. Default: 8.
`Use earliest CAD note timestamp for Received At`	Toggle	Toggle will use the earliest CAD note time as Call Received Time. Use it when the first note marks the start of the call better than the CAD pickup time. Call Pickup Time does not change. When no note has a time, Call Received Time stays as read from CAD. Default: off. This setting is on every CAD connector.

CAD Connector - Enterpol