creating an interactive a 133 database n.
Skip this Video
Loading SlideShow in 5 Seconds..
Creating an Interactive A-133 Database PowerPoint Presentation
Download Presentation
Creating an Interactive A-133 Database

Loading in 2 Seconds...

play fullscreen
1 / 20

Creating an Interactive A-133 Database - PowerPoint PPT Presentation

  • Uploaded on

Creating an Interactive A-133 Database. AGA Central PA Chapter Joe Kull PwC February, 2011. The project. -Question:

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Creating an Interactive A-133 Database' - harmon

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
creating an interactive a 133 database

Creating an Interactive A-133 Database

AGA Central PA Chapter

Joe Kull PwC

February, 2011

the project
The project


Can eXtensible Business Reporting Language [XBRL] be used to digitally link audit findings in the SF-SAC to the written text of the auditor’s report?


-Make use of 500,000 A-133 audits reports

-Identify trend and root cause problems

-Manage Corrective Action Plans

partners participants and spectators
Partners, Participants and Spectators
  • Anna Miller, AGA Research Director
  • Joe Kull, PwC, project manager
  • Leanne Travers, Allocation Solutions
  • Mike Doane and Paul Norcinni, Marklogic
  • Sheila Conley and Terry Ramsey, HHS
  • Kinney Poynter , Claudia Chebinou, NASACT
  • Federal Audit Clearinghouse
  • OMB [Gil Tran and Marguerite Pridgon]
  • George Strudgeon, Va Auditor of Public Works
the approach
The approach
  • One program across all states
  • Identify links between forms and reports
  • Develop taxonomy based on audit reports
  • Appropriately ‘tag’ the reports using XBRL
  • Digitally search for text of the audit finding
murphy s law prevailed
Murphy’s Law Prevailed
  • Forms were electronic; reports pdf.
  • No reports thru FAC; only half on the Internet
  • Reports used different formats, phrases
  • Shift tactics; try words/phrases to create ‘tags’
  • Shift research from all states, one program to all programs, across 5 states
building on progress
Building on Progress
  • New HHS pilot to exploit AGA project results
  • Focus on more high risk, high dollar auditees
  • Will support HHS analysis across multiple years by auditee and by program
what hhs wants
What HHS Wants
  • Ability to analyze
  • Performance measurement and accountability
  • Identify auditees with repeat findings and inconsistent reporting
  • Recommendations for FAC and A-133 process changes
  • Leverage existing data for high risk auditees at a reasonable cost
what hhs wants con t
What HHS wants, con’t
  • Analytics-root cause, trends
  • Monitor/age Corrective Action Plans
  • Manage risks
      • Concentrate on high dollar, high risk recipients
      • Profile applicants during ‘emergency’ situations
challenges identified by hhs pilot
Challenges Identified by HHS pilot
  • AGA project not as scalable as thought
  • PDF formats (image vs. text) prior to 2008
  • Findings Reference Numbers in SF-SAC form do not match audit reports
  • Inconsistent report formats a detriment to analysis
improving a 133
Improving A-133
  • Define and standardize data structure
  • Tackle redaction issue
  • Act on data, analysis
    • Develop risk management profiles
  • More pilots
  • Take serious look at A-133
  • Invest in FAC
  • Find ownership of grants, A-133
other opportunities
Other Opportunities
  • Open untapped datasets
  • Enable access and visibility
  • Simplify redaction process
  • Develop data and format standards
  • Exploit current technologies