1 / 15

The American Recovery and Reinvestment Act of 2009 Reporting Overview

The American Recovery and Reinvestment Act of 2009 Reporting Overview. Federal Highway Administration August, 2009. Accountability and Transparency.

julinka
Download Presentation

The American Recovery and Reinvestment Act of 2009 Reporting Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The American Recovery and Reinvestment Act of 2009Reporting Overview Federal Highway Administration August, 2009

  2. Accountability and Transparency “Every American will be able to hold Washington accountable for these decisions by going online to see how and where their tax dollars are being spent.” - President Barack Obama

  3. Reports Produced by FHWA • Weekly report on projects with notice to proceed • Weekly report on obligated projects • Monthly report on jobs • Quarterly NEPA report to President’s Council on Environmental Quality (CEQ) – 1609 • Quarterly report for States – 1512 • Quarterly performance reports • Periodic reports to Congress – 1201(c) • Periodic reports to GAO • Miscellaneous – EDA, DBE, “Green Projects”, SBA etc

  4. Reporting Challenges • Implementation • Tight schedule • Changing requirements • Non-sequential development • Data quality and consistency • Approach has changed • Initially Excel forms submitted via e-mail to FHWA • Evolved into web based application • Second generation currently being developed

  5. New Reporting Requirements Added additional OMB required data Reorganized to minimize redundant data Monthly data down to 10 data items (5 are reference data i.e. State, month, project numbers etc) Comma delimited format, no Excel option New screens in RADS will allow for mass editing, similar to Excel or Access 5

  6. RADS - Recovery Act Data System • Used for ARRA related: • Data submittal • Reports • Analysis • Reviews • Independent system that interfaces with other data systems • Developed as a secure web application with a robust SQL Server database • Integrated GIS interface for spatial analysis and mapping

  7. Data ModelConceptual Overview Jobs, Awards& ProjectInformation Finance Data – FMIS DELPHI Other Data - Bid Tab DUNS EDA Reports, Maps, and Charts - State reported data RADS - Data Integration,Analysis, &Reporting - Existing FHWA data - New FHWA database - FHWA generated reports

  8. Information Flow Diagram 1201(c)1609 Congress OST Recovery.gov Collect, Compile, & Report FHWA HQ 1512 State DOT RADS Virginia Division Texas Division Compliance Review Virginia DOT Texas DOT Review, Report, & Summarize Contractor A Local B Contractor C Local D Filing employment data Contractor B Contractor D

  9. Reports Produced by FHWA • Weekly report on projects with notice to proceed • Weekly report on obligated projects • Monthly report on jobs • Quarterly NEPA report to President’s Council on Environmental Quality (CEQ) – 1609 • Quarterly report for States – 1512 • Quarterly performance reports • Periodic reports to Congress – 1201(c) • Periodic reports to GAO • Miscellaneous – EDA, DBE, “Green Projects”, SBA etc

  10. Latest Data • Obligations • 50 States, Federal Lands, District of Columbia, Puerto Rico, Guam, Northern Marianas and the Virgin Islands • 6,144 projects • $17.331 Billion • Notice to proceed • 50 States, Federal Lands, District of Columbia, and Puerto Rico • 2,534 projects • $7.941 Billion

  11. Obligations

  12. Notice to Proceed

  13. Preliminary Jobs

  14. Current Activities • Adjusting RADS to comply with June 22nd OMB guidance • Redesigning database • Developing new data input/editing screens • Revising Reporting Requirements document • Conducting 6 webinars over 4 weeks for States and Divisions • Recently submitted 3 year OMB Paperwork Reduction Act (PRA) review and waiver request • Gearing up for next round of reports • CEQ, Performance Measures, and 1201(c)

  15. Questions?

More Related