The Intterra utilizes several lookup tables to support the processing of the Intterra Operations and Performance tools enabling data to be enhanced beyond what is provided through the unit and incident data feeds
The lookup tables consist of data is relatively static and descriptive in nature, enabling Intterra to present the data in more customized way. Data within the look up tables enable functionality such as dropdown filters in the performance tools, symbols in the SitStat Monitor, and the tracking of available units tailored to the agency.
The initial population and maintenance of the lookup tables is a critical step in the onboarding process for the Intterra application.
In all cases, Intterra will populate an initial draft of the lookup tables based on the sample data provided. While columns will be filled in as best as possible, the client needs to review the extracted data, confirm it is how you want the data organized and fill in any missing information.
The lookup tables and their associated functions are listed below. The linked spreadsheet files or web page provide table definitions, examples and a worksheet to provide the client a convenient method to review and submit their own lookup table values.
| Table | Function | Intterra Tool(s) | Files |
|---|---|---|---|
| General Lookup Tables | |||
| Units | Client unit information references, i.e., unit icon labels, unit types, drawdown groups, etc | All | Unit Lookup Table Instructions |
| Cad Codes | Client CAD incident codes' information; provides Intterra map symbol lookup for the SitStat operational awareness tool. | All | cadCodes.xlsx |
| Response Priorities | Client unit response priority code reference; used to classify into standardized emergent (hot) or non-emergent (cold) response categories. | All | responsePriorities.xlsx |
| Stations | Client Fire Station location references; provides latitude/longitude coordinates for non-AVL equipped units located at a station. | All | stations.xlsx |
| Group and Agencies | Client agency-specific data and preferences, i.e., time zones, default latitude/longitude coordinates, etc. 'Group' is used for the overall client preferences and 'Agencies' for the more agency-specific information and preferences within the Group. | All | Group and Agencies.xlsx |
| Tool Specific Lookup Tables | |||
| Unit Status | Client CAD unit status code reference - used to standardize client unit statuses used to symbolize the unit status in SitStat. | SitStat | unitStatus.xlsx |