1 / 20

Creating an Interactive A-133 Database

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

anila
Download Presentation

Creating an Interactive A-133 Database

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. Creating an Interactive A-133 Database AGA Central PA Chapter Joe Kull PwC February, 2011

  2. The project -Question: 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? -Why? -Make use of 500,000 A-133 audits reports -Identify trend and root cause problems -Manage Corrective Action Plans

  3. 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

  4. 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

  5. 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

  6. 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

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

  8. 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

  9. 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

  10. 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

  11. Other Opportunities • Open untapped datasets • Enable access and visibility • Simplify redaction process • Develop data and format standards • Exploit current technologies

More Related