150 likes | 242 Views
The American Recovery and Reinvestment Act of 2009 Reporting Overview. Federal Highway Administration August, 2009. Accountability and Transparency.
E N D
The American Recovery and Reinvestment Act of 2009Reporting Overview Federal Highway Administration August, 2009
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
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
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
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
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
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
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
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
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
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)