NFIRS Web Reporting Development NFIC Training December 2007.ppt

National Fire Incident Reporting System (NFIRS) Version 5.0

NFIRS Web Reporting Development NFIC Training December 2007.ppt

OMB: 1660-0069

Document [ppt]
Download: ppt | pdf
Company Confidential

 
  1.  

 
  1.  

  1. Rationale for New Reporting Framework

  • Replacing an aging, expensive, proprietary system based on Actuate with newer, cheaper open source tools 

    • Licensing costs for Actuate were prohibitive 

    • Adding new reports was difficult and error prone 

  • Current closed architecture was not flexible 

    • Portions of the current reports and SQL behind the reports was tailored to the capabilities of Actuate rather than streamlined for NFIRS 

    • Open source report generator (JasperReports) is embedded in an application that is much more “NFIRS-aware” 

  • Moving to new, faster hardware to which the current licenses will not transfer 

 
  1.  

  • There are screenshots of this demo in the appendix of this handout 

 
  1.  

  • Retrieve, change, and re-submit previous reports 

    • Will be live when the system is released 

  • Online Analytical Processing (OLAP) Cubes 

    • Currently, the reporting database is almost a mirror of production, but going forward, it will be optimized on the server side for reporting  

    • Data cubes (dimensions) 

      • Better organization for reporting 

        • Data ordered by day, month, quarter, year 

        • FDID, groups and states 

    • Develop pivot tables and “measures” for commonly derived data 

      • Pre-compute items such as day of week, individual arrival (elapsed) time, average arrival times, incident key fields (as an aggregate) 

 
  1.  

  • Many more module fields available for filters 

    • Almost all module fields available for most reports such as zip codes, street names, personnel names, person involved names, shift, alarms, etc.  

    • Any module field can be made available as a filter so long as it doesn’t otherwise invalidate the report (e.g., Won’t be able to select mutual aid types for the Mutual Aid Incidents report) 

    • Additional “fields” such as last-saved date and created-by name 

       

 
  1.  

  • More options for the filter fields 

    • OR-ing allows for multiple text line input (for making lists of names, streets, zip codes, coded-fields, etc.)  

    • Wildcarding” of text fields (starts with, ends with and contains) 

    • Case sensitive and case insensitive searches 

    • AND-ing and OR-ing of most filters as well as NOT 

  • Saving of partial templates of reports and report filters 

  • Textual explanation of the ad-hoc filters and groups as they are being constructed 

 
  1.  

  • New reports (partial list):  

    • Fire Dept’s identified by vendor software used. 

    • Wildland fire report summarizing acres burned from both fire and wildland modules. 

    • Reporting on same FDID activity over multiple years. (Essentially a “same-store sales” report, but for fire dept’s - compares activity to the same month of previous year to indicate trends.) 

    • Statewide reporting status level (which is currently available only at the US level) to show amount of data reported and released in the national DB by FDID 

    • Various data quality reports (e.g., large dollar loss, response time) 

 
  1.  

  • Exporting/Sharing report templates & filters 

    • Initial implementation may be a simple export to file/import from file scheme 

    • Online sharing with library of templates and filters published by NFIRS program office, state program office and on down to a dept 

  • Scheduled reports 

    • Reports can be scheduled to run daily, weekly, monthly and yearly with parameterized date fields for from/to dates. 

    • Parameterization of other fields such as a list of FDIDs or groups (or lists of lists)  

 
  1.  

  • We would like to hear from you concerning: 

    • Reports that you and your departments need that are currently not available to you 

    • Which fields you and your departments need most (or other data in the national DB you would like to be able to select incidents on) 

    • Any other concerns regarding the new reporting system 

 
  1.  

 
  1.  

 
  1.  

 
  1.  

 
  1.  

 
  1.  

 
  1.  

 
File Typeapplication/vnd.ms-powerpoint
File TitlePresentation title slide - 42 pt Times New Roman, White
Subject2004 FDIC Presentation
AuthorWilliam Troup
Last Modified ByAdministrator
File Modified2007-11-28
File Created2003-08-19

© 2024 OMB.report | Privacy Policy