Capabilities

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

Overview

The Data Agent will read from the Tiburon database. To do this we need a user to connect to the database. You should create a read only user. The frequency the query is run is configurable by you - its typically set to every 5 minutes.

By default, the Data Agent reads the Tiburon CAD tables. In views mode, the Data Agent reads three views instead: one for incidents, one for responders and one for notes. The incident view must expose SysId and ClosedAt. The responder and notes views must expose IncidentId, which matches the SysId of the incident view. Backfill is available in views mode.

Standard Data Fields

These are the standard data fields the Data Agent reads from Tiburon. The tables below show each GovWorx field and the Tiburon table column it comes from. In views mode, your views expose the GovWorx field names directly.

Note: Additional fields are considered enhancement requests.

Incident fields

GovWorx field	Tiburon source	Notes
Incident ID	`CARSCall.CALLKEY`	CAD record key.
Incident Number	`CARSCall.CALL_NO`
Case Number	`CARSCall.REPORT_NO`
Incident Type	`CARSCall.CALL_TYPE_FINAL`	Uses CALL_TYPE_ORIG when CALL_TYPE_FINAL is empty.
Caller Number	`CARSCall.FIRST_COMP_PHONE`
Caller Name	`CARSCall.COMP_NAME`
Agency	`CARSCall.AGENCY`	The Agencies setting filters on this column.
Agency Type	`CARSCall.SERVICE`
Incident Date	`CARSCall.CALL_ENTRY_DATE, CALL_ENTRY_TIME`	The Data Agent joins the date and the time.
Disposition	`CARSCall.DISPOSITION`
Location	`CARSCall.LOCATION_ADDRESS`
Priority	`CARSCall.PRIORITY`
Latitude	`CARSCall.YCOORD`
Longitude	`CARSCall.XCOORD`
Call Position	`CARSCall.ENTRY_WORKSTN`
Call Taker ID	`CARSCall.ENTRY_OPER_ID`
Call Source	`CARSSegments.SEGMENT_911_SOURCE`	Reads the ALI segment of the call. Uses NON-EMERGENCY when the call has no ALI segment.
Call Received Time	`CARSCall.CALL_CREATED_DATE, CALL_CREATED_TIME`	The earliest CAD note timestamp setting replaces this with the earliest note time.
Call Pickup Time	`CARSCall.CALL_CREATED_DATE, CALL_CREATED_TIME`	Same value as Call Received Time.
Closed At	`CARSCall.CALL_CLOSE_DATE, CALL_CLOSE_TIME`	The Data Agent reads closed calls that were entered in the last day.

Notes

GovWorx field	Tiburon source	Notes
Note Text	`CARSCallCompleteSegments.SEGMENT_NARRATIVE`	The Data Agent skips segments with no narrative.
Note By	`CARSCallCompleteSegments.DISPATCHER_ID`
Note Time	`CARSCallCompleteSegments.SEGMENT_DATE, SEGMENT_TIME`

Responders and units

GovWorx field	Tiburon source	Notes
Unit Name	`CARSCallUnit.UNIT_ID`
Call Sign	`CARSCallUnit.CALL_NO`
Personnel ID	`CARSUnitAsgn.PERS_ID`	Matches CARSUnitAsgn to CARSCallUnit on UNITKEY.
Dispatched By	`CARSCall.DISPATCHER_ID`
Dispatched At	`CARSCallUnit.UNIT_DISPATCH_DATE, UNIT_DISPATCH_TIME`
Enroute At	`CARSCallUnit.UNIT_ENROUTE_DATE, UNIT_ENROUTE_TIME`
Arrived At	`CARSCallUnit.UNIT_ONSCENE_DATE, UNIT_ONSCENE_TIME`
Cleared At	`CARSCallUnit.UNIT_CLEAR_DATE, UNIT_CLEAR_TIME`

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 Tiburon database
`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
`Password**`	Password	Database password
`Database*`	Text	Database Schema to read from
`Agencies`	Text	Comma separated list of agencies to filter to
`Append WITH (NOLOCK) to all table references (default: true)`	Toggle	Toggle will add WITH (NOLOCK) to every table and view the Data Agent queries. On by default when the setting is blank.
`Views mode: query pre-built SQL views (one each for incidents, responders, notes) instead of raw CAD tables`	Toggle	Toggle will read from the three views named below in place of the CAD tables.
`CARSCall table name override (used when Views mode is off)`	Text	Name of the table to read in place of CARSCall.
`CARSSegments table name override (used when Views mode is off)`	Text	Name of the table to read in place of CARSSegments.
`CARSCallUnit table name override (used when Views mode is off)`	Text	Name of the table to read in place of CARSCallUnit.
`CARSUnitAsgn table name override (used when Views mode is off)`	Text	Name of the table to read in place of CARSUnitAsgn.
`CARSCallCompleteSegments table name override (used when Views mode is off)`	Text	Name of the table to read in place of CARSCallCompleteSegments.
`Incident view name (required when Views mode is on). Must expose SysId and ClosedAt; should expose Agency and IncidentDate`	Text	Name of the incident view. Required in views mode.
`Responder view name (required when Views mode is on). Must expose IncidentId matching the incident view's SysId`	Text	Name of the responder view. Required in views mode.
`Notes view name (required when Views mode is on). Must expose IncidentId matching the incident view's SysId`	Text	Name of the notes view. Required in views mode.
`Views mode: lookback window in hours used only when no last-run cursor exists yet (default: 2)`	Number	How far back the first run looks for closed incidents. Default: 2.
`Views mode: maximum lookback in hours (default: 8)`	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.
`Views mode: backfill a fixed date range instead of the rolling cursor (rolling polling is suspended while this is on)`	Toggle	Toggle will query a fixed date range, for backfilling historical data. Normal polling stops while this is on.
`Backfill range start (yyyy-MM-dd HH:mm, CAD-local)`	Text	Beginning time of the fixed range.
`Backfill range end (yyyy-MM-dd HH:mm, CAD-local)`	Text	End time of the fixed range.
`Split the backfill range into chunks no longer than (hh:mm) to avoid query timeouts (default: 01:00)`	Text	Splits the fixed range into chunks of this length. Default: 01:00.
`Responder/notes query mode. Switch to 'inlist' if the default slows down your views.`	Text	Use subquery (default) or inlist. Use inlist only if the default slows down your views.
`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

**: Either Integrated Security or (Username and Password) is required.

CAD Connector - Tiburon