Capabilities

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

Bidirectional capabilities are not available for this connector.

Overview

The Data Agent reads closed incidents from the TAC Public Safety SQL Server database with read-only access. It reads either the GOVCALLS and GOVUNITS views or the CALL and UNIT tables.

The Data Agent reads incidents closed within a rolling window of 30 minutes by default. It resumes from the last closed incident it read. Backfill reads a fixed time interval instead.

No CAD data is stored on the local server running the Data Agent.

SQL Server Configuration Notes

To ensure a successful and secure connection, verify the following:

Firewall Access: Ensure the server hosting the GovWorx Data Agent can reach the SQL Server over the appropriate network and port (typically TCP 1433).
Minimum Permissions: The provided database user must have read-only access to relevant tables, views, or stored procedures. Write access is not required or recommended.
Instance Visibility: If using a named instance, confirm SQL Server Browser service is running, or explicitly provide the port number.

Troubleshooting Tips

Login Failed? Verify the SQL user is enabled and not locked out.
Timeout Errors? Check network routes and firewall rules.
Invalid Database? Ensure the database field in the config matches the actual schema name.
No responders on incidents? In views mode, the INCIDENTNUMBER column in the unit view must match the INCIDENTNUMBER column in the call view in type and format.
Invalid source name? The call and unit names accept a plain or bracketed object name with an optional schema, such as [dbo].[GOVCALLS].

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 TAC Public Safety. The tables below show each GovWorx field and the column it comes from, for both the views and the tables. The Data Agent trims blank padding from text values.

Note: Additional fields are considered enhancement requests.

Incident fields

GovWorx field	TAC Public Safety source	Notes
Incident ID	`View: SYSID` `Table: PK`	CAD record key.
Incident Number	`View: INCIDENTNUMBER` `Table: TRN_NO`
Case Number	`View: CASEID` `Table: OCA, ACCI_NO, FIRE_NO, EMS_NO`	In table mode, the first value that is not empty. Uses TRN_NO when all four are empty.
Incident Type	`View: INCIDENTTYPE` `Table: CODE`
Initial Incident Type	`Table: FCODE`	Table mode only.
Agency	`View: AGENCY` `Table: AGENCY`
Agency Type	`View: AGENCYTYPE` `Table: POLICE, FIRE, EMS`	In table mode, PD, FD or EMS for the first flag set to 1.
Incident Date	`View: INCIDENTDATE` `Table: DATE, TRC`	In table mode, the date and the time combined.
Disposition	`View: DISPOSITION` `Table: DISPO`
Location	`View: LOCATION` `Table: COMMON_NAM, LOC1, LOC2, BUILDING, APT, CITY, ZIP`	In table mode, these columns joined with spaces.
Priority	`View: PRIORITY` `Table: P`
Latitude	`View: LATITUDE` `Table: LATITUDE`
Longitude	`View: LONGITUDE` `Table: LONGITUDE`
Caller Number	`View: CALLERNUMBER`	View mode only.
Caller Name	`View: CFNM, CMI, CLNM`	View mode only. First, middle and last name joined with spaces.
Call Position	`View: CALLPOSITION` `Table: SOURCEPOS`
Call Taker ID	`View: CALLTAKER` `Table: DIS`
Call Source	`View: CALLSOURCE`	View mode only.
Call Received Time	`View: CALLRECEIVEDTIME` `Table: DATE, TRC`	In view mode, uses DATEOFCALL and then INCIDENTDATE when empty. The earliest CAD note timestamp setting replaces this with the earliest note time.
Closed At	`View: CLOSEDATE` `Table: UNIT.CLR_DATE, UNIT.TCL`	In table mode, the latest clear time of any unit on the call.
Response Area	`View: RESPONSEAGENCY` `Table: RESPONSE`

Notes

GovWorx field	TAC Public Safety source	Notes
Note ID	`View: SYSID` `Table: PK`	The incident key plus a note suffix.
Note Text	`View: NOTEAT` `Table: NARATIVE`	One consolidated narrative for each incident. The view stores it in NOTEAT.
Note By	`View: CALLTAKER` `Table: DIS`	Uses DISPATCHER (view) or USER (table) when empty.
Note Time	`View: CALLRECEIVEDTIME` `Table: LASTUPDATE`	In table mode, uses the call received time when LASTUPDATE is empty.

Responders and units

GovWorx field	TAC Public Safety source	Notes
Unit Name	`View: UNITNAME` `Table: UNIT`
Personnel ID	`View: PERSONNELID` `Table: BADGE1`
Dispatched By	`View: DISPATCHER (call)` `Table: CAD`	In table mode, uses DISP2 from the call when CAD is empty.
Dispatched At	`View: DISPATCHEDAT` `Table: TDP_DATE, TDP`
Enroute At	`View: ENROUTEAT` `Table: ENR_DATE, ENR`
Arrived At	`View: ARRIVEDAT` `Table: ARV_DATE, TAR`
Cleared At	`View: CLEAREDAT` `Table: CLR_DATE, TCL`

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 name or IP of the SQL Server
`Database name*`	Text	Database to read from
`Use integrated security`	Toggle	Toggle will enable the use of a domain service account that is configured to run the agent service as authentication to SQL server
`Username`	Text	Database user. Not needed with integrated security.
`Password`	Password	Database password. Not needed with integrated security.
`Source schema`	Text	Choose views to read the GOVCALLS and GOVUNITS views. Choose tables to read the CALL and UNIT tables. Default: views.
`Call table/view`	Text	Name of the call view or table. Default: [GOVCALLS] for views, [CALL] for tables.
`Unit table/view`	Text	Name of the unit view or table. Default: [GOVUNITS] for views, [UNIT] for tables.
`Time back to query`	Text	Time back to query ([days.]hh:mm). Default: 00:30, 30 minutes. The Data Agent uses this on the first run. Later runs resume from the last closed incident.
`Backfill enabled`	Toggle	Toggle will query over a fixed time interval instead of time back, for backfilling historical data.
`Backfill: Beginning time`	Text	Beginning time of the fixed interval (yyyy-mm-dd hh:mm)
`Backfill: End time`	Text	End time of the fixed interval
`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.

* Required

CAD Connector - TAC Public Safety