The american recovery and reinvestment act of 2009 reporting overview l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 15

The American Recovery and Reinvestment Act of 2009 Reporting Overview PowerPoint PPT Presentation


  • 48 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


The american recovery and reinvestment act of 2009 reporting overview l.jpg

The American Recovery and Reinvestment Act of 2009Reporting Overview

Federal Highway Administration

August, 2009


Accountability and transparency l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 model conceptual overview l.jpg

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


Slide8 l.jpg

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 fhwa9 l.jpg

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 l.jpg

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


Obligations l.jpg

Obligations


Notice to proceed l.jpg

Notice to Proceed


Preliminary jobs l.jpg

Preliminary Jobs


Current activities l.jpg

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)


Questions l.jpg

Questions?


  • Login