Capabilities

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

Overview

The Data Agent reads from the Peraton CAD Oracle database. It connects with a database user and reads the CAD event tables. To do this we need a read only user. On each run, the Data Agent reads incidents that closed inside the time window. The default window is the last 30 minutes. A fixed date range is available to backfill history.

Oracle 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 Oracle database over the appropriate network and port (typically TCP 1521).
Minimum Permissions: The provided database user must have read-only access to the CAD tables. Write access is not required or recommended.
Service Name: Provide the Oracle service name, not the SID.

Troubleshooting Tips

Login Failed? Verify the database user is enabled and not locked out.
Timeout Errors? Check network routes and firewall rules.
Connection Refused? Ensure the host, port and service name match the Oracle listener.

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

PowerShell Command:

Test-NetConnection -ComputerName {CAD Database server name or IP} -Port 1521

Standard Data Fields

These are the standard data fields the Data Agent reads from Peraton. The Data Agent reads closed incidents. The tables below show each GovWorx incident field and the Peraton column it comes from. Source names are CAD.CAD_ROW_DBEVH columns unless the row says otherwise.

Note: Additional fields are considered enhancement requests.

Incident fields

GovWorx field	Peraton source	Notes
Incident ID	`EVENTNUMBER`	CAD record key.
Incident Number	`EVENTNUMBER`
Incident Type	`FINTYPEDESCR`
Initial Incident Type	`TYPEDESCR`
Agency	`AGENCY`
Agency Type	`CLASS`
Priority	`PRIORITY`
Incident Date	`ENTRYDATE`
Call Received Time	`ACDDATE`	Uses ENTRYDATE when empty. The earliest CAD note timestamp setting replaces this with the earliest note time.
Location	`LOCATION`
Longitude	`XCOORD`
Latitude	`YCOORD`
Closed At	`CLOSEDATE`
Caller Name	`CALLERNAME`
Caller Number	`CALLERTELEPHONE`
Call Position	`ENTRYWKS`	The entry workstation.
Call Taker ID	`ENTRYPERSID`
Call Source	`SOURCE`

Notes

GovWorx field	Peraton source	Notes
Note ID	`CAD_ROW_DBEVH_TXT.WORKSTATION`
Note Text	`CAD_ROW_DBEVH_TXT.TEXT`
Note By	`CAD_ROW_DBEVH_TXT.PERSID`
Note Time	`CAD_ROW_DBEVH_TXT.ENTRYDATE`

Responders and units

GovWorx field	Peraton source	Notes
Unit Name	`CAD_ROW_DBEVH_UNA_STL.UNIT`
Personnel ID	`CAD_ROW_DBEVH_UNA.DISPWKS`	Matches the unit to the incident.
Dispatched By	`CAD_ROW_DBEVH_UNA.DISPPERSID`
Dispatched At	`Status log entry DSP`	The Data Agent does not fill the status times yet. The status log date column is not confirmed.
Enroute At	`Status log entry ENR`	Same as Dispatched At.
Arrived At	`Status log entry ONS`	Same as Dispatched At.
Cleared At	`Status log entry AOR`	Same as Dispatched At.

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 CAD Oracle database
`Port (default 1521)`	Text	Oracle listener port. The Data Agent uses 1521 when this is blank.
`Service Name*`	Text	Oracle service name
`Username*`	Text	Database user
`Password*`	Password	Database password
`How far back to query (hh:mm or days.hh:mm, default 00:30)`	Text	How far back the Data Agent looks for closed incidents on each run. Default: 00:30.
`Use a fixed date range instead of time back`	Toggle	Toggle will query over a fixed date range instead of time back, for backfilling historical data.
`Fixed range start (yyyy-mm-dd hh:mm)`	Text	Start of the fixed date range
`Fixed range end (yyyy-mm-dd hh:mm)`	Text	End of the fixed date range
`Query times in UTC (default) instead of local time`	Toggle	Toggle on reads the time range as UTC. Toggle off reads it as local server time. Default: on.
`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.

Note: *: Required.

CAD Connector - Peraton