Included in this month's Release Notes:
- Last & Next Operators for Date and Datetime (Days Only)
Last & Next Additional Calendar Units
Create PDF Settings UI
Extend Custom Columns to Criteria
Extend Custom Columns to Filters
NFIRS Deprecated Columns Data Source for NERIS
Daily Log Data Source
Occupancy Log Data Source
Work Order Labor Data Source
Work Order Comments Data Source
Work Order Items Data Source
ITM Reports Parent Data Source
Fire Investigation Compartment Fire Fields Data Source
Fire Investigation Structure Fire Fields Data Source
Fire Investigation Vehicle Fire Fields Data Source
Fire Investigation Wildfire Data Source
Fire Investigation Marine Fire Data Source
Additional Fields to Incident Report (NERIS)
Status Code Refactor for FD Permits
Minor Ad Hoc Updates:
Activity Date added to Daily Log
Accrual Start Date added to Personnel
Scheduling Notes expanded to include Time Off and Trades
Hypothesis removed from Fire Investigation dataset
Occupancy Notes added to Occupancy data source
Ad Hoc – Last & Next Additional Calendar Units
What - The Last and Next date operators within Ad Hoc Criteria have been enhanced to support additional calendar units beyond days. Users can now define relative date ranges using Days, Weeks (Monday–Sunday), Months, Quarters, and Years, allowing reports to align with common business reporting cycles. Each calendar unit resolves to its full logical calendar range rather than a rolling period—for example, selecting Last 1 Month returns the entire previous calendar month. The Criteria UI dynamically updates the inclusion option based on the selected unit (such as Include Current Week or Include Current Quarter), ensuring clarity when defining date filters. A calendar unit is required whenever Last or Next is selected, with Days set as the default. All ranges are evaluated using standard midnight-to-midnight calendar boundaries unless a configured Time Boundary overrides the behavior. Performance remains consistent with existing operators such as Equals and Between, ensuring reliable execution across reports.
Why - Many reporting scenarios require filtering data by meaningful business periods such as weeks, months, quarters, or years. Previously, users relied on day-based logic or predefined date presets to approximate these timeframes, which limited flexibility and sometimes produced inaccurate results when aligned with calendar boundaries. Expanding the Last and Next operators to support multiple calendar units allows users to build precise, self-service relative date filters that match real-world reporting needs without relying on static presets. This enhancement also establishes a scalable framework for long-term reporting flexibility, enabling users to define their own relative time logic while maintaining consistent and predictable calendar behavior.
How
Navigate to Ad Hoc Reports → Edit or Create Report.
In the report builder, add a date or datetime field to Criteria.
Select the Last or Next operator.
Enter the numeric value representing the offset (for example, 1, 2, or 3).
Select the Calendar Unit from the dropdown:
Days
Weeks
Months
Quarters
Years
Optionally enable the Include Current [Unit] toggle, which dynamically updates based on the selected calendar unit (for example Include Current Month).
Save or run the report to apply the relative date range.
Note: Calendar units evaluate using standard midnight-to-midnight boundaries unless a Time Boundary configuration overrides the default behavior.
Note: The Calendar Unit field is required when using Last or Next and defaults to Days.
Use Case - A reporting user needs to review activity that occurred during the previous calendar quarter to prepare a periodic operational summary. Instead of manually determining the exact start and end dates for the quarter, the user applies the Last 1 Quarter criteria to a report. The system automatically evaluates the full previous quarter based on standard calendar boundaries, ensuring the report consistently returns the correct timeframe regardless of when it is run. Similarly, another user generating weekly operational reports can filter data using Last 2 Weeks or Next 1 Week, aligning report results with structured Monday-through-Sunday reporting cycles without requiring manual date calculations.
Ad Hoc – Last & Next Operators for Date and Datetime (Days Only)
What - New Last and Next operators have been introduced for Date and Datetime fields within Ad Hoc Criteria, allowing users to define relative date ranges based on a configurable number of days. These operators appear in the Criteria operator list between Not Equal and Before, providing a more flexible alternative to preloaded date presets. When selected, users enter a required numeric value representing the number of days relative to the current date, with the option to Include Current Day in the evaluated range. Date calculations are performed strictly using calendar-day logic, ensuring predictable results for operational reporting windows such as recent activity or upcoming scheduled events. This implementation focuses on day-based ranges only, while the underlying user interface structure prepares the system to support additional calendar units in future enhancements.
Why - Previously, users relied on fixed, predefined date ranges that often did not align with real operational reporting needs. This limited the ability to quickly adjust report criteria to reflect specific timeframes such as the last few operational days or the next several scheduled days. Introducing configurable Last and Next operators provides greater flexibility by allowing users to define their own relative day ranges directly within report criteria. This approach improves reporting accuracy and efficiency while establishing the foundation for a broader relative date framework that will later support expanded calendar units and more advanced date filtering capabilities.
How
Navigate to Ad Hoc Reports → Edit or Create Report.
Add a Date or Datetime field to the Criteria section of the report builder.
From the Operator dropdown, select Last or Next.
Enter a numeric value representing the number of days to evaluate relative to the current date.
Optionally enable Include Current Day if the current date should be included in the evaluated range.
Save or run the report to apply the relative date filter.
Note: The number of days field is required and must contain a numeric value.
Note: Date calculations follow calendar-day boundaries, ensuring consistent and predictable filtering results.
Use Case - A reporting user needs to review incidents recorded during the last three operational days to monitor recent activity levels. Instead of manually adjusting report dates each day, the user applies the Last 3 Days operator to the incident date field. Each time the report runs, the system automatically evaluates the correct three-day window relative to the current date. Similarly, a scheduling coordinator preparing for upcoming events can apply Next 5 Days to identify records scheduled within the next operational period, ensuring reports remain accurate without requiring manual updates to the date criteria.
Ad Hoc – PDF Settings UI
What - The Ad Hoc Settings tab has been updated to improve how PDF configuration options are presented. Rather than displaying all PDF-related settings inline within the Settings page, these options are now contained within a dedicated PDF Settings interface that is collapsed by default and only revealed when a user chooses to access it. This enhancement prevents the Settings page from becoming excessively long as additional PDF formatting capabilities are introduced. When expanded, the PDF Settings section displays all existing configuration options exactly as they function today. The interface may appear as an expandable section or modal component, consistent with existing application design standards, ensuring a clean and scalable layout without changing the underlying behavior of any PDF configuration features.
Why - As PDF formatting capabilities expand, displaying all configuration options directly within the Settings page can create unnecessary visual clutter and push commonly used controls—such as Sharing—farther down the page. By moving these options into an on-demand interface, the Settings tab remains organized, easier to navigate, and better suited to accommodate future PDF-related enhancements. This approach improves usability while maintaining a consistent interface pattern across the platform.
How
Navigate to Ad Hoc Reports → Edit or Create Report.
Open the Settings tab.
Locate the PDF Settings section.
Select PDF Settings to expand the section or open the configuration modal.
Adjust the available PDF formatting options as needed.
If presented in a modal:
Select Save to apply changes.
Select Cancel or close the window to discard changes and retain the previous configuration.
Note: All previously available PDF configuration options remain unchanged in functionality.
Note: The PDF Settings section is collapsed by default to keep the Settings page organized and focused on commonly used options.
Use Case - A reporting user creating a printable report needs to configure page orientation and formatting for a PDF export. Instead of scrolling through a long Settings page to find these controls, the user opens the PDF Settings section directly within the Settings tab. After expanding the section, they configure the desired PDF formatting options and save their changes before generating the report. This approach keeps the Settings page concise while still providing full access to PDF configuration when needed.
Ad Hoc – “NFIRS Deprecated Columns” Data Source for NERIS
What - A new Ad Hoc data source titled NFIRS Deprecated Columns has been introduced to expose incident fields that were removed during the transition from NFIRS to NERIS. While the Incident Report (NERIS) data source contains the modern incident schema, several legacy NFIRS attributes were not carried forward, which could create reporting gaps for historical or transitional analysis. This new data source provides direct access to those deprecated NFIRS fields and is designed to be joined with Incident Report (NERIS) using the incident identifier. The dataset maintains a strict one-to-one relationship with NERIS incident records, ensuring that joins do not introduce duplicate rows or alter record counts. All columns retain their original NFIRS naming conventions and data types, preserving familiarity for users and maintaining compatibility with existing reporting logic while enabling accurate cross-model reporting.
Why - During the transition from NFIRS to NERIS, certain legacy data elements were intentionally excluded from the new schema. While this improves the modern data model, it also creates challenges for users who need to analyze incidents across both reporting standards—particularly for year-over-year analysis, compliance reporting, and operational performance tracking. Without access to deprecated NFIRS fields, users would need to manually reconcile datasets or rely on external data exports. Introducing the NFIRS Deprecated Columns data source restores access to these legacy attributes within the reporting environment, allowing users to seamlessly combine NFIRS and NERIS data while preserving historical accuracy and continuity.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the NFIRS Deprecated Columns data source.
Ensure the report also includes the Incident Report (NERIS) data source.
Create or confirm the join between the two data sources using the Incident Identifier field.
Select the desired deprecated NFIRS fields alongside NERIS incident fields when building report columns or criteria.
Run or save the report to analyze incidents using both legacy and modern reporting attributes.
Note: The NFIRS Deprecated Columns data source maintains a 1:1 relationship with NERIS incidents, ensuring joins do not change row counts.
Note: Column names and data types match their original NFIRS definitions to support continuity with existing reporting logic.
Use Case - A reporting user needs to generate a full-year incident analysis report during a period when the organization transitioned from NFIRS to NERIS. Early incidents in the year relied on NFIRS classification fields that no longer exist in the NERIS schema. By joining NFIRS Deprecated Columns with Incident Report (NERIS), the user can incorporate both legacy NFIRS attributes and modern NERIS fields within the same report. This allows the organization to produce accurate annual reporting, compare operational metrics across the transition period, and maintain compliance reporting without needing to reconcile historical data outside the reporting platform.
Ad Hoc – Custom Columns in Criteria
What - Custom Columns created within Ad Hoc Reports can now be used directly within Criteria, allowing users to filter report results based on calculated values. Previously, Custom Columns could only be displayed in report outputs, preventing users from restricting data using those calculated results. With this enhancement, Custom Columns appear in the Criteria column selection list alongside standard report fields. The available operators automatically align with the Custom Column’s resulting data type, ensuring consistent filtering behavior—for example, numeric calculations support numeric comparison operators while text-based calculations support text operators. Multiple Custom Columns can be created and independently referenced within Criteria, enabling users to apply calculated conditions across different fields within the same report. Custom Columns behave like native report fields in Criteria, providing a seamless experience without requiring changes to existing report-building workflows.
Why - Reporting users often rely on calculated logic—such as derived values, thresholds, or conditional indicators—to evaluate operational performance and data quality. Previously, while Custom Columns could calculate these values, users could not apply filtering logic based on those calculations. This required manual analysis or external data processing to isolate relevant records. Enabling Custom Columns within Criteria allows users to enforce calculated business rules directly within the report itself, improving accuracy, reducing manual effort, and enabling more advanced analytical scenarios such as threshold monitoring, compliance validation, and exception identification.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Columns section, create a Custom Column using the desired calculation or formula.
Save or apply the Custom Column configuration.
Open the Criteria section of the report builder.
In the Column dropdown, select the Custom Column you created.
Choose an operator appropriate to the Custom Column’s evaluated data type.
Enter the desired criteria value or condition.
Save or run the report to apply the calculated filter.
Note: Operators available in Criteria automatically adjust based on the Custom Column’s resulting data type.
Note: Multiple Custom Columns can be used independently within Criteria in the same report.
Use Case - A reporting user creates a Custom Column that calculates the number of days between an incident date and its completion date to measure processing time. By applying Criteria to this Custom Column—such as filtering for values greater than a defined threshold—the user can quickly identify records that exceed expected processing timelines. Similarly, a user might create a Custom Column that flags records meeting specific operational conditions and then apply Criteria to return only those flagged results. This allows users to produce targeted reports that highlight exceptions, trends, or compliance issues directly within the reporting tool.
Ad Hoc – Custom Columns in Filters
What - Custom Columns created within Ad Hoc Reports can now be used directly in Filters, allowing users to refine report results based on calculated values. Previously, Custom Columns could be displayed but could not influence report filtering, limiting their usefulness in dashboards and operational analysis. With this enhancement, Custom Columns appear in the Filters selection list alongside standard report fields. Filter operators automatically align with the Custom Column’s resulting data type, ensuring consistent behavior—numeric calculations support numeric comparison operators, text-based calculations support text operators, and other calculated formats behave according to their evaluated type. Multiple Custom Columns can be filtered within the same report, enabling layered filtering scenarios and more precise control over report output.
Why - Many analytical scenarios rely on derived values, such as calculated thresholds, date differences, or conditional logic that highlights operational exceptions. Previously, users could calculate these values using Custom Columns but could not directly filter reports using them, which limited their ability to quickly isolate meaningful data. Enabling Filters on Custom Columns allows users to refine results based on calculated logic, improving dashboard interactivity, enabling more targeted operational reporting, and supporting deeper data exploration without requiring external data processing.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Columns section, create a Custom Column using the desired formula or calculation.
Save or apply the Custom Column configuration.
Open the Filters section of the report builder.
In the Column dropdown, select the Custom Column you created.
Choose the appropriate filter operator, which automatically aligns with the Custom Column’s data type.
Enter the filter value or condition.
Apply the filter and run the report.
Note: Filter operators automatically adjust based on the evaluated data type of the Custom Column.
Note: Multiple Custom Columns can be used within Filters to create layered filtering logic.
Use Case - A reporting user creates a Custom Column that calculates the number of days between an incident creation date and its resolution date. By adding a Filter to return only records where the calculated value exceeds a defined threshold, the user can quickly identify incidents that took longer than expected to resolve. In another scenario, a dashboard report includes a Custom Column that derives a compliance indicator based on several fields. By filtering the report to display only rows where the indicator meets a specific condition, the dashboard highlights records that require attention, allowing users to quickly focus on operational exceptions.
Ad Hoc – Occupancy Log Data Source
What - A new Ad Hoc reporting data source titled Occupancy Log has been introduced, enabling users to report on log entries associated with Occupancy records. These log entries capture operational and preplanning information recorded within the Occupancy workflow that was previously not available for reporting. The data source is structured as a one-to-many (1:M) relationship, where a single Occupancy record may contain multiple associated log entries. The dataset exposes key attributes such as log identifier, combined log date and time, duration, entry type, involved party, log content, and the user who recorded the entry. Log text is presented in a clean, readable format suitable for reporting and analysis, and the data source fully supports standard Ad Hoc capabilities including filtering, grouping, sorting, summarization, and calculated fields.
Why - Operational notes and activity logs recorded within Occupancy records often contain valuable planning and situational information. However, because these log entries were previously limited to the operational interface, organizations had limited ability to analyze or audit occupancy-related activities through reporting. Introducing the Occupancy Log data source allows users to include this information in Ad Hoc reports, improving visibility into occupancy-related actions, enabling historical analysis of activity logs, and supporting more informed operational planning and review.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the Occupancy Log data source.
Optionally add the Occupancy data source to the report.
Create or confirm the relationship between Occupancy and Occupancy Log using the appropriate occupancy identifier.
Select Occupancy Log fields such as Log Date/Time, Entry Type, Duration, Log Content, or Recorded By as report columns.
Apply filters, grouping, or summaries as needed to analyze occupancy log activity.
Save or run the report.
Note: Each Occupancy record may contain multiple log entries, so reports may return multiple rows per occupancy when log details are included.
Note: The data source supports full Ad Hoc reporting functionality, including calculated fields and aggregation.
Use Case - A planning officer wants to review operational notes recorded for commercial occupancies during recent inspections and preplanning activities. By creating a report that joins Occupancy with Occupancy Log, the user can display each log entry along with occupancy details such as location and occupancy type. The report can be grouped by entry type or filtered by log date, allowing the organization to review recent updates, track planning activities, and analyze trends in occupancy-related notes across multiple properties.
Ad Hoc – Daily Log Data Source
What - A new Ad Hoc reporting data source titled Daily Log has been introduced to provide reporting access to records created within the Daily Log Activities submodule. Each Daily Log entry represents a documented operational event captured by an agency, including details about what occurred, when it occurred, and who recorded it. The data source follows a one-to-one record model, where each Daily Log entry is represented by a single row, ensuring predictable behavior in tabular and summary reports. The dataset exposes key activity attributes such as Activity ID, Activity Type, Event Type, Apparatus, Activity Timestamp, Duration, Description, and Created By. By making Daily Log information available within Ad Hoc reporting, users can now incorporate operational activity data into summaries, dashboards, scheduled reports, and broader analytical workflows.
Why - While Daily Log entries can be viewed and filtered within the Activities module, that interface is primarily designed for operational record keeping rather than broader analysis. Users previously had limited ability to summarize activity trends, build dashboards, or schedule reports based on Daily Log information. Introducing the Daily Log data source enables organizations to analyze operational activity across time periods, identify trends, monitor participation, and incorporate Daily Log data into larger reporting strategies that support operational oversight and decision-making.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the Daily Log data source.
Select relevant Daily Log fields such as Activity Type, Event Type, Activity Timestamp, Duration, Apparatus, Description, or Created By as report columns.
Apply criteria, grouping, sorting, or summaries to analyze activity patterns or trends.
Optionally join the Created By field with Personnel data to analyze activity by user.
Save or run the report.
Note: Each Daily Log entry appears as a single row, ensuring compatibility with both tabular and aggregated reports.
Note: Daily Log data can be used in dashboards, scheduled reports, and summary analytics.
Use Case - An operations manager wants to review the volume and types of daily activities recorded by staff over the past month. Using the Daily Log data source, the manager builds a report that groups entries by Activity Type and summarizes the total number of entries and duration of activities. By joining the Created By field with Personnel, the report also shows which personnel recorded each activity, enabling leadership to evaluate workload distribution, monitor operational activity trends, and generate scheduled summary reports for ongoing review.
Ad Hoc – Work Order Labor Data Source
What - A new Ad Hoc reporting data source titled Work Order Labor has been introduced to expose individual labor records associated with Work Orders in the Assets module. Instead of summarizing labor only at the work order level, this data source provides row-level visibility into each labor entry, enabling more granular reporting and analysis. The dataset supports a one-to-many (1:M) relationship with Work Orders, where each Work Order can contain multiple labor records. It includes comprehensive labor attributes such as labor completion date, hours worked, labor rates, flat labor costs, and total cost values, supporting both hourly labor tracking and flat-cost labor entries. The data source also introduces consolidated reporting fields that unify attribution across labor sources, allowing users to easily identify who completed the work, whether performed by a vendor, one or more users, or no assigned entity. This design mirrors the behavior found in the Work Orders interface while expanding the ability to analyze labor activity through reporting.
Why - Labor activity represents a critical component of asset maintenance, operational workload, and budget tracking, but previously users could not easily analyze labor details outside the Work Orders interface. Without direct reporting access to labor records, organizations had limited ability to evaluate workforce utilization, vendor involvement, or the financial impact of maintenance work. Introducing the Work Order Labor data source enables deeper operational insight by exposing detailed labor records within Ad Hoc reporting. This allows organizations to build reports that support cost analysis, vendor evaluation, labor trend monitoring, and budget planning while aligning reporting outputs with how labor information is captured within the Work Orders workflow.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the Work Order Labor data source.
Optionally add the Work Orders data source to include additional asset or maintenance context.
Create or confirm the relationship between Work Orders and Work Order Labor using the Work Order identifier.
Select relevant labor fields such as Completed By, Labor Completion Date, Hours Worked, Labor Rate, or Total Labor Cost as report columns.
Apply criteria, grouping, sorting, or summaries to analyze labor activity, vendor involvement, or labor costs.
Save or run the report.
Note: Each labor record appears as its own row, allowing detailed analysis when multiple labor entries exist for a single Work Order.
Note: The Completed By fields consolidate vendor and user attribution to simplify grouping and filtering across different labor assignment models.
Use Case - A fleet manager needs to analyze maintenance labor costs across all apparatus repairs performed during the past quarter. By joining Work Order Labor with Work Orders, the manager builds a report that displays labor entries grouped by Completed By, showing whether work was performed by internal personnel or external vendors. The report summarizes total hours and labor costs for each group, helping leadership evaluate vendor usage, monitor workforce utilization, and identify opportunities to optimize maintenance budgets.
Ad Hoc – Work Order Comments Data Source
What - A new Work Order Comments data source is now available in Ad Hoc reporting, making individual comments logged against Work Orders fully reportable. Each comment is represented as its own row, allowing users to analyze comment activity in detail rather than being limited to viewing comments only within the Work Order interface. The data source functions as a child of Work Orders, preserving the relationship between each comment and its parent record. Available fields include key comment details such as the comment identifier, creation date, author, and comment text. The data source supports standard Ad Hoc functionality, including filtering, grouping, sorting, summary reporting, and calculated fields, while maintaining expected reporting behavior for one-to-many relationships.
Why - Comments often contain important operational context, follow-up details, and audit history related to maintenance activity. Previously, because Work Order comments were only accessible within the Work Order screen, users could not easily review comment trends, filter comments by date or author, or include comment activity in dashboards and scheduled reports. Making Work Order Comments available as a reporting data source improves visibility into maintenance communication, supports auditing and oversight, and expands the analytical value of Work Order reporting without changing how Work Orders themselves function.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the Work Order Comments data source.
Optionally add the Work Orders data source to include parent work order details in the report.
Create or confirm the relationship between Work Orders and Work Order Comments using the appropriate Work Order identifier.
Select the desired comment fields, such as Comment Creation Date, Comment Author, and Comment Text.
Apply Criteria, grouping, sorting, or summaries to analyze comment activity.
Save or run the report.
Note: Because Work Order Comments is a child data source, reports that include both Work Orders and Comments will return multiple rows when a single Work Order has multiple comments.
Note: The data source supports standard Ad Hoc reporting features, including tabular reports, summaries, and calculated fields.
Use Case - A maintenance supervisor wants to review all comments added to Work Orders over the past month to identify recurring issues, follow-up needs, or delays noted during repair activity. By building a report with Work Order Comments joined to Work Orders, the supervisor can group comments by author, filter by creation date, and review comment text alongside work order details. This makes it easier to audit communication history, monitor maintenance follow-up activity, and include comment trends in scheduled operational reporting.
Ad Hoc – Work Order Items Data Source
What - A new Work Order Items data source is now available in Ad Hoc reporting, providing visibility into the one-to-many item records associated with each Work Order. This enhancement exposes the materials and parts used during repair and maintenance activities as reportable records, with each item represented individually under its parent work order. The data source combines both Asset Inventory items and manually entered Other Parts into a unified reporting dataset, while clearly identifying the item type for each record. Available item attributes include Item Name, Item Type, SKU, Source Location, Destination, Quantity, Cost, and Total Cost, allowing users to analyze both usage and material expenses in detail. Because the data source is modeled as a child of Work Orders, it preserves item-level detail while supporting standard Ad Hoc reporting behaviors such as filtering, grouping, sorting, summaries, and calculated fields.
Why - Materials and parts are a key component of maintenance cost analysis, inventory usage tracking, and operational reporting, but previously users could only report on work order details at a higher level without access to the individual items tied to each work order. This limited visibility into what parts were used, where they came from, how much they cost, and how those costs accumulated across maintenance activity. Introducing the Work Order Items data source allows users to report on all associated item records directly within Ad Hoc, improving cost transparency, supporting more detailed maintenance analysis, and aligning reporting capabilities with the item details already visible in the Work Order experience.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the Work Orders data source.
Add the Work Order Items child data source.
Create or confirm the relationship between Work Orders and Work Order Items using the appropriate Work Order identifier.
Select item-level fields such as Item Name, Item Type, Quantity, Cost, Total Cost, Source Location, or Destination.
Apply Criteria, grouping, sorting, summary rows, or calculated fields as needed.
Save or run the report.
Note: Reports that include Work Order Items return one row per associated item, so a single Work Order may appear multiple times when multiple items are included.
Note: Both Inventory items and Other Parts are included in the same dataset, with Item Type available to distinguish between them.
Use Case - A maintenance manager needs to review the parts and material costs associated with recent apparatus repairs. By adding Work Order Items to a report, the manager can see each item used on a work order, including whether it came from inventory or was entered as an other part, along with quantities and total cost. The report can be grouped by Item Type or Destination, summarized by Total Cost, and filtered for a specific date range or asset group. This makes it easier to track material usage, identify high-cost repairs, and support maintenance budget planning with item-level detail.
Ad Hoc – ITM Reports Data Source
What - A new ITM Reports parent data source has been introduced to Ad Hoc reporting, providing a high-level reporting view of Inspection, Testing, and Maintenance (ITM) reports submitted by partner businesses. Each ITM Report is represented as a single row, ensuring a one-to-one relationship with ITM report records and preventing row duplication when performing summary analysis. The data source serves as the primary reporting entry point for the ITM module, consolidating key report attributes such as business name, address, inspection district, inspection zone, property use, identifiers, and report timestamps into a unified dataset. The structure also supports child relationships, allowing related datasets—such as Occupancy—to be joined for expanded reporting context while preserving the integrity of the parent ITM report records. All columns are fully compatible with standard Ad Hoc reporting capabilities, including filtering, grouping, sorting, summary rows, and calculated fields.
Why - Prior to this enhancement, users lacked a dedicated parent-level reporting dataset for ITM reports, making it difficult to perform high-level analysis on inspection activity, partner business participation, and geographic inspection trends. Without a structured parent data source, users could encounter challenges when attempting to aggregate ITM activity or combine ITM data with related operational context. Introducing the ITM Reports data source provides a stable foundation for ITM reporting, allowing organizations to analyze inspection activity efficiently while maintaining correct data relationships. This structure also prepares the reporting environment for future expansion of ITM-related datasets and reporting capabilities.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, add the ITM Reports data source.
Select desired report fields such as Business Name, Address, Inspection District, Inspection Zone, Property Use, or Report Timestamp.
Apply Criteria, grouping, sorting, or summary rows to analyze ITM report activity.
Optionally add the Occupancy data source as a child relationship to incorporate additional property context.
Save or run the report.
Note: Each ITM Report appears as a single row, ensuring accurate aggregation and summary reporting.
Note: Joining Occupancy or other related datasets expands report detail while maintaining the integrity of the parent ITM report record.
Use Case - A fire prevention division wants to evaluate inspection activity performed by partner businesses across different districts. Using the ITM Reports data source, a reporting user builds a summary report grouping ITM reports by Inspection District and Business Name. The report summarizes the number of submitted ITM reports within a given timeframe, providing leadership with visibility into inspection coverage and participation levels across jurisdictions. By optionally joining Occupancy data, the organization can also analyze inspection trends by property type or location, supporting strategic planning and oversight of inspection programs.
Ad Hoc – Fire Investigation Compartment Fire Fields Data Source
What - A new Fire Investigation Compartment Fire Fields data source has been introduced in Ad Hoc reporting, providing access to dynamic fields associated with the Compartment Fire investigation type within the Fire Investigation module. Certain investigation fields appear only when specific investigation types are selected during report creation, and this data source exposes those Compartment Fire–specific attributes for reporting. The dataset includes fields related to HVAC airflow, duct or diffuser characteristics, structural features, and interior conditions, such as HVAC Air Flows, HVAC Duct or Diffuser Size, HVAC Duct or Diffuser Type, HVAC Description, Doors, Windows, Inside Walls, and Exterior Walls. The data source maintains a strict one-to-one (1:1) relationship with Fire Investigation records, ensuring that including these fields in reports does not create duplicate rows or alter the underlying dataset. It is structured as a child data source of Fire Investigation, allowing users to incorporate Compartment Fire–specific details only when needed while maintaining full compatibility with standard Ad Hoc reporting capabilities.
Why - The Fire Investigation module supports dynamic fields that appear based on the investigation type selected during the investigation workflow. While these fields provide valuable technical details for specific investigation scenarios, they were previously not available in reporting. This limited users’ ability to analyze structural conditions, ventilation characteristics, and compartment features across multiple investigations. By introducing the Fire Investigation Compartment Fire Fields data source, these specialized fields become accessible for reporting and analysis while preserving the correct relationship to the parent Fire Investigation record. This enhancement enables deeper investigative insights and establishes a scalable framework for exposing additional investigation-type datasets in the future.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
Add the Fire Investigation data source to the report.
Add the Fire Investigation Compartment Fire Fields child data source.
Confirm the 1:1 relationship between Fire Investigation and Fire Investigation Compartment Fire Fields.
Select desired fields such as HVAC Air Flows, HVAC Duct or Diffuser Size, HVAC Duct or Diffuser Type, HVAC Description, Doors, Windows, Inside Walls, or Exterior Walls.
Apply Criteria, sorting, grouping, summary rows, or calculated fields as needed.
Save or run the report.
Note: This data source is designed specifically for Compartment Fire investigation records and may return empty values for investigations that do not include this investigation type.
Note: The 1:1 relationship ensures that including these fields does not duplicate Fire Investigation rows in reports.
Use Case - A fire investigation unit wants to analyze structural and ventilation characteristics observed during compartment fire investigations over the past year. Using the Fire Investigation data source combined with Fire Investigation Compartment Fire Fields, the investigator builds a report that includes HVAC airflow descriptions, duct sizes, and wall construction details for each investigation. By grouping results by Investigation District or filtering by date range, the team can identify patterns in ventilation or compartment conditions that may influence fire behavior, supporting both investigative review and training analysis.
Ad Hoc – Fire Investigation Structure Fire Fields Data Source
What - A new Fire Investigation Structure Fire Fields data source is now available in Ad Hoc reporting, exposing dynamic fields associated specifically with the Structure Fire investigation type in the Fire Investigation module. These fields become available when the Structure Fire investigation type is selected during an investigation and include detailed information about the building, fire protection systems, safety conditions, and investigative observations. The data source is configured as a child data source of Fire Investigation and maintains a strict 1:1 relationship with the parent investigation record, allowing users to include Structure Fire–specific details in reports without introducing duplicate rows. Available fields support reporting on items such as Structure Type, Year Built, Structure Height, Length, and Width, Floors Above Grade and Below Grade, Building Occupied at Time of Fire, Foundation Type, Material Type, Exterior Covering Type, Roof Type, Construction Type, Sprinklers, Standpipes, Security Cameras, Smoke Detectors, Hidden Keys, Security Bars, Door and Window Conditions, Fire Attack Method, Obstacles to Extinguishment, First On Scene details, and general interior, exterior, and investigator observations. The data source also supports aggregated reporting on Fire Protection Systems and is fully compatible with standard Ad Hoc functionality such as Criteria, Sorting, Grouping, Summary Rows, and Calculated Fields.
Why - Structure fire investigations often require analysis of building features, protection systems, and scene observations that are specific to the Structure Fire investigation type. Previously, these dynamic fields were captured in the investigation workflow but were not easily available for broader reporting and analysis. By exposing these fields through a dedicated reporting data source, users can now evaluate structural characteristics, identify safety system trends, and review investigative conditions across multiple incidents without losing data integrity. This enhancement improves visibility into structure fire investigations and creates a scalable pattern for reporting on additional investigation-type-specific datasets in the future.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
Add the Fire Investigation data source to the report.
Add the Fire Investigation Structure Fire Fields child data source.
Confirm the 1:1 relationship between Fire Investigation and Fire Investigation Structure Fire Fields.
Select the desired Structure Fire fields, such as Structure Type, Year Built, Smoke Detectors, Sprinklers, Fire Protection Systems, Door and Window Conditions, or Investigator Comments.
Apply Criteria, Sorting, Grouping, Summary Rows, or Calculated Fields as needed.
Save or run the report.
Note: This data source is intended for investigations that include the Structure Fire investigation type, so fields may be blank when that investigation type does not apply.
Note: The 1:1 relationship preserves report integrity and prevents row duplication when these fields are included.
Note: Fire Protection Systems values are consolidated into a single reportable field for easier analysis.
Use Case - A fire investigation team wants to review structure fire incidents to better understand how building characteristics and protection systems may have influenced incident conditions. Using Fire Investigation with the Fire Investigation Structure Fire Fields child data source, the team can build a report showing attributes such as Structure Type, Year Built, Sprinklers, Smoke Detectors, and Obstacles to Extinguishment alongside the investigation record. This allows investigators and analysts to compare structure conditions across incidents, identify common patterns in building safety features, and support post-incident review, training, and trend analysis.
Ad Hoc – Fire Investigation Vehicle Fire Fields Data Source
What - A new Fire Investigation Vehicle Fire Fields data source has been added to Ad Hoc reporting, exposing dynamic fields associated with the Vehicle Fire investigation type in the Fire Investigation module. These fields become available when the Vehicle Fire investigation type is selected during an investigation and capture details specific to vehicle-related incidents. The dataset is structured as a child data source of Fire Investigation and maintains a strict 1:1 relationship with the parent investigation record, ensuring that including these fields in a report does not create duplicate rows. Available attributes support reporting on vehicle characteristics, investigative details, and inspection findings, including Vehicle Make, Model, Year, VIN, Odometer Reading, License Plate and Country, Theft Status, Recovery Details, Job Number, File Number, Loss Location, Insurance Status, Occurrence Date, Assignment Date, Receipt Date, Inspection Time and Location, Fire and Police Report references, Alarm System presence and type, Hidden Keys, Key Location, Number of Keys, Personal Effects in the vehicle, and contents found in the trunk or cargo area. All fields are fully compatible with standard Ad Hoc reporting features, including Criteria, Sorting, Grouping, Summary Rows, and Calculated Fields.
Why - Vehicle fire investigations involve specialized data points that are only captured when the Vehicle Fire investigation type is used. Previously, these dynamic fields were available in the investigation workflow but not easily accessible for broader reporting and analysis. This limited users’ ability to evaluate vehicle characteristics, security conditions, and investigation timelines across multiple incidents. By introducing the Fire Investigation Vehicle Fire Fields data source, these vehicle-specific attributes can now be incorporated into reports alongside standard Fire Investigation data, enabling deeper analysis of vehicle fire incidents and supporting investigative review, training, and trend analysis.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
Add the Fire Investigation data source to the report.
Add the Fire Investigation Vehicle Fire Fields child data source.
Confirm the 1:1 relationship between Fire Investigation and Fire Investigation Vehicle Fire Fields.
Select the desired vehicle-related fields such as Vehicle Make, Vehicle Model, VIN, Theft Status, Inspection Date, or Alarm System Type.
Apply Criteria, Sorting, Grouping, Summary Rows, or Calculated Fields to analyze vehicle investigation data.
Save or run the report.
Note: This dataset applies specifically to investigations that include the Vehicle Fire investigation type, so some fields may be blank for investigations where that type does not apply.
Note: The 1:1 relationship ensures that including these fields does not change the total number of Fire Investigation records returned in the report.
Use Case - A fire investigation unit wants to analyze trends in vehicle fire incidents over the past year. By combining Fire Investigation with Fire Investigation Vehicle Fire Fields, investigators can create a report displaying vehicle attributes such as Make, Model, Year, Theft Status, and Alarm System presence alongside investigation dates and locations. This allows the team to identify patterns related to vehicle type, security conditions, or investigation timelines, helping investigators better understand factors associated with vehicle fire incidents and support ongoing training and analysis.
Ad Hoc – Fire Investigation Wildfire Data Source
What - A new Fire Investigation Wildfire data source has been introduced in Ad Hoc reporting, exposing fields that appear dynamically when Wildfire is selected as the Scene Type within the Fire Investigation module. These fields capture investigation details specific to wildfire incidents and are now available for reporting alongside standard Fire Investigation data. The dataset is configured as a child data source of Fire Investigation and maintains a strict 1:1 relationship with the parent investigation record, ensuring wildfire details can be included in reports without creating duplicate rows or altering record counts. Certain attributes—such as Security, Fire Type, and Fire Spread Factor—are presented as list-based columns that translate stored codes into readable values through dictionary lookups. All other wildfire-related fields mirror the column names and data types used in the underlying dataset, ensuring consistency between the investigation interface and reporting outputs while remaining fully compatible with standard Ad Hoc features.
Why - Wildfire investigations often require the capture of scene-specific details that differ from other fire investigation types. Previously, these dynamic fields were available only within the investigation workflow, limiting the ability to analyze wildfire incidents across reports or combine wildfire-specific attributes with broader investigation data. By introducing the Fire Investigation Wildfire data source, organizations can now include wildfire-specific attributes in reporting and analysis. This enhancement enables investigators and analysts to examine wildfire incidents more effectively while maintaining accurate relationships between investigation records and their associated scene-type details.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
Add the Fire Investigation data source to the report.
Add the Fire Investigation Wildfire child data source.
Confirm the 1:1 relationship between Fire Investigation and Fire Investigation Wildfire.
Select desired wildfire-related fields such as Security, Fire Type, Fire Spread Factor, or other wildfire investigation attributes.
Apply Criteria, Sorting, Grouping, Summary Rows, or Calculated Fields as needed.
Save or run the report.
Note: This data source returns values only for investigations where the Scene Type is Wildfire.
Note: List-based fields automatically translate stored codes into readable values for reporting.
Note: The 1:1 relationship ensures wildfire details can be included without duplicating investigation records.
Use Case - A fire investigation team wants to analyze wildfire incidents reported over the past season to better understand factors influencing fire behavior and spread. Using Fire Investigation with the Fire Investigation Wildfire child data source, analysts create a report that includes attributes such as Fire Type, Fire Spread Factor, and Security conditions alongside the investigation record. By grouping results by district or date range, the team can identify patterns in wildfire conditions and contribute insights that support training, planning, and incident review.
Ad Hoc – Fire Investigation Marine Fire Data Source
What - A new Fire Investigation Marine Fire data source is now available in Ad Hoc reporting, exposing dynamic fields associated with the Marine scene type in the Fire Investigation module. These fields capture marine-specific investigation details entered when a fire investigation is documented with a marine scene type. The data source is configured as a child data source of Fire Investigation and maintains a strict 1:1 relationship with the parent investigation record, allowing users to include marine-specific details in reports without creating duplicate rows or altering report counts. Fields such as Loss Location and Engine are presented as readable list-based values through code lookups, while all remaining marine investigation fields retain their underlying names and data types for consistency with the source data. All columns are fully compatible with standard Ad Hoc features, including Criteria, Sorting, Grouping, Summary Rows, and Calculated Fields.
Why - Marine fire investigations often require scene-specific details that are not relevant to other investigation types. Previously, these fields were only available within the Fire Investigation workflow, which limited users’ ability to analyze marine incidents across reports or combine marine-specific information with broader investigation data. By introducing the Fire Investigation Marine Fire data source, users can now include those investigation details directly in Ad Hoc reporting, improving visibility into marine fire incidents and supporting more detailed review, analysis, and trend reporting.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
Add the Fire Investigation data source to the report.
Add the Fire Investigation Marine Fire child data source.
Confirm the 1:1 relationship between Fire Investigation and Fire Investigation Marine Fire.
Select the desired marine-related fields, such as Loss Location, Engine, or other available marine investigation attributes.
Apply Criteria, Sorting, Grouping, Summary Rows, or Calculated Fields as needed.
Save or run the report.
Note: This data source returns values only for investigations where the Scene Type includes Marine.
Note: Loss Location and Engine display readable values using system lookups rather than stored internal codes.
Note: The 1:1 relationship ensures that adding this data source does not duplicate Fire Investigation records.
Use Case - A fire investigation team needs to review marine fire incidents documented over the past year to identify patterns in vessel-related investigations. By combining Fire Investigation with the Fire Investigation Marine Fire child data source, the team can report on marine-specific attributes such as Loss Location and Engine alongside standard investigation details. This allows investigators to compare incident characteristics across marine scenes, support case review, and analyze trends that may inform future training or investigative planning.
Ad Hoc – Additional Fields to Incident Report (NERIS)
What - The Incident Report (NERIS) data source in Ad Hoc reporting has been expanded to include several additional fields that already exist within the NERIS incident reporting form but were previously unavailable for reporting. These new fields provide deeper insight into incident impacts, evacuation activity, and exposure-related scenarios. Added fields include Number of People or Businesses Displaced and Cause for Displacements, which capture displacement impact and contributing factors. A new Hazsit Evacuated field records the number of individuals evacuated due to hazardous situations. Exposure-related reporting is also enhanced through new fields such as Is Exposure, Exposure Number, Exposure Type, Exposure Item, and Exposure Damage. Fields that store coded NERIS values automatically translate those codes into readable descriptions using the NERIS dictionary, ensuring reports display meaningful information. These additions maintain the existing one-row-per-Incident ID dataset structure, preserving performance and preventing duplicate records.
Why - Certain operational details captured within the NERIS incident reporting workflow—such as displacement impacts, hazardous evacuations, and exposure classifications—were previously unavailable within the reporting environment. This created gaps for agencies seeking to analyze community impact, evaluate evacuation activity, or review exposure-related incidents across reports. By adding these fields to the Incident Report (NERIS) data source, users gain direct reporting access to important incident attributes while maintaining consistency with the data captured in the incident documentation process. This enhancement improves reporting completeness and supports deeper operational analysis without altering the structure or performance of existing reports.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
In the Data Sources panel, select Incident Report (NERIS).
In the Columns section, locate the newly available fields, including:
Number of People or Businesses Displaced
Cause for Displacements
Hazsit Evacuated
Is Exposure
Exposure Number
Exposure Type
Exposure Item
Exposure Damage
Add the desired fields to the report output.
Apply Criteria, Grouping, Sorting, or Summary Rows as needed to analyze incident data.
Save or run the report.
Note: Fields that store coded NERIS values automatically translate into readable descriptions within reports.
Note: The Is Exposure field is derived from the exposure value in the incident record and returns TRUE when the exposure value is greater than zero.
Note: The dataset continues to maintain a one-row-per-Incident ID structure, ensuring no duplication of incident records.
Use Case - A fire department wants to analyze community impact and evacuation activity related to recent incidents. Using the Incident Report (NERIS) data source, a reporting user builds a report that includes Number of People or Businesses Displaced, Cause for Displacements, and Hazsit Evacuated. By grouping incidents by cause for displacement and summarizing the number of displaced individuals, leadership can better understand how incidents affect residents and businesses. The same report can also include exposure-related fields to identify trends in incidents involving exposure scenarios, helping agencies evaluate response patterns and operational impact.
Ad Hoc – Status Code Refactor for FD Permits
What - The FD Permit status evaluation logic used in Ad Hoc reporting has been refactored to align with the status logic displayed in the Permits module. Previously, permits that appeared as Expired in the user interface were not always returned as expired in certain Ad Hoc reports—specifically FDR-PERM-001 and FDR-PERM-002—due to differences between how permit status was calculated in the application versus the reporting layer. This enhancement ensures that permit status in reports follows the same business rules used by the application, accurately reflecting expiration conditions. The update supports both automatic permit workflows, where status is derived from lifecycle state combined with expiration logic, and manual workflows, where status is explicitly assigned. As a result, permits that are functionally expired are now consistently returned as Expired in Ad Hoc reports even if the underlying lifecycle state remains approved or in another non-expired status.
Why - Inconsistent status logic between the Permits module interface and Ad Hoc reporting could cause confusion when users attempted to validate permit expiration or compliance through reports. Permits that appeared expired in the operational interface might not be included in report results when filtering for expired records. Aligning the reporting logic with the application’s status evaluation ensures that reports accurately reflect operational data, improving data trust, compliance visibility, and reporting consistency.
How
Navigate to Ad Hoc Reports → Run or Edit Report.
Open an existing permit report such as FDR-PERM-001 or FDR-PERM-002, or create a new report using FD Permit data.
Apply Criteria or Filters based on Permit Status (for example, Expired).
Run the report to view results.
Note: Permit status is now evaluated using the same logic as the Permits module, ensuring reports match the status displayed in the application.
Note: Both automatic workflow permits (status derived from lifecycle state and expiration date) and manual workflow permits (explicitly assigned statuses) are supported.
Note: No changes to report configuration or filters are required for this update to take effect.
Use Case - A fire prevention office runs a report to identify expired fire department permits that may require follow-up or renewal. Previously, some permits displayed as Expired in the Permits module were not included in Ad Hoc report results due to differences in status evaluation. With this refactor, the report now returns all permits that the system considers expired according to the same business rules used in the application interface. This allows inspectors and administrators to confidently track compliance and identify permits that require attention without needing to manually reconcile discrepancies between operational views and reports.
Ad Hoc – Minor Updates
What - Several minor updates have been implemented across Ad Hoc reporting data sources to improve data completeness and alignment with operational workflows. The Daily Log data source now includes an Activity Date field, enabling clearer date-based reporting on daily activity entries. The Personnel data source now exposes Accrual Start Date, allowing reports to reference the beginning date for personnel accrual tracking. Within the All Scheduling Data dataset, the Notes field has been expanded to include notes related to Time Off and Trades, ensuring that scheduling-related commentary is consistently available in reporting outputs. The Hypothesis field has been removed from the Fire Investigation dataset to reflect changes in the underlying data model. Additionally, the Occupancy data source now includes an Occupancy Notes field, allowing operational notes recorded within occupancy records to be included directly in reports.
Why - These updates improve the completeness, clarity, and usability of reporting data by exposing additional fields that exist within operational workflows while removing fields that are no longer relevant. Adding fields such as Activity Date, Accrual Start Date, and Occupancy Notes allows users to analyze operational timelines and contextual information more effectively. Expanding Scheduling Notes to include Time Off and Trades ensures that scheduling-related details are fully represented in reports. Removing outdated fields helps maintain a clean and accurate reporting schema that reflects the current application structure.
How
Navigate to Ad Hoc Reports → Create or Edit Report.
Select the relevant data source (such as Daily Log, Personnel, All Scheduling Data, or Occupancy).
Locate the newly available fields in the Columns selection list:
Activity Date in Daily Log
Accrual Start Date in Personnel
Notes in All Scheduling Data (now including Time Off and Trades)
Occupancy Notes in Occupancy
Add the desired fields to the report.
Apply Criteria, Grouping, Sorting, or Summary Rows as needed.
Run or save the report.
Note: The Hypothesis field has been removed from the Fire Investigation data source and will no longer appear in report column selections.
Use Case - A scheduling coordinator builds a report using All Scheduling Data to review staffing adjustments and needs visibility into comments related to time-off requests and shift trades. With the updated Notes field now including this information, the coordinator can easily review scheduling context directly within the report. Similarly, a training or HR administrator can use the Personnel data source to track staff records using the newly available Accrual Start Date, while fire prevention staff can include Occupancy Notes in reports to review operational notes associated with inspected properties.