Run FEMA Report

To access the FEMA Reports area:

  1. Go to the Main Navigation area and click Reports.
  2. Click FEMA report.
  3. Enter the date range in the From and Through fields to show all fixed or finalized work code records contained within the date range supplied in the Selected Items area.
  4. In Selected Items, choose the FEMA related Regular Duty and Overtime work code records. If the work code contains data in the account code field the corresponding account code will show in the Regular Duty Account Code or Overtime Account Code menu box respectively.

    Data filter options in the Selected Items pane are inclusive this means the data must exist within the date range supplied to show relevant menu boxes and selectable items within.

  5. Click Run Report to run the report in Excel (.xslm).

    Depending on your Excel settings you may see a security warning if macros have been disabled. If so, click Enable Content to enable macros.

    The FEMA report generates three sheets, Seed Data, Summary Data, and the 009-0-1231.

  6. Review the Seed Data Sheet from the application, if needed modify the data and when ready open the Summary Data sheet.
  7. In the Summary Data sheet, click Refresh to pull in Seed Data.
  8. In the FEMA Form 009-0-123 sheet, click Reload Data to auto populate and complete the form. When ready submit the FEMA form for reimbursement.
1 FEMA Form 009-0-123 available as of application version 7.1.2 replaces FEMA Form 90-123R1.