Report 2009-037 Recommendation 2 Responses

Report 2009-037: Department of Housing and Community Development: Housing Bond Funds Generally Have Been Awarded Promptly and in Compliance With Law, but Monitoring Continues to Need Improvement (Release Date: November 2009)

Recommendation #2 To: Housing and Community Development, Department of

HCD should ensure that its cleanup efforts are thoroughly documented and retained for future reference.

Annual Follow-Up Agency Response From October 2014

HCD thoroughly documented the cleanup effort for future reference. HCD Admin Division staff recorded all activities during the entire process and have retained all relevant documentation (e.g., CAPES and reconciliation reports, source documents, accounting logs, multiple program reports, process and procedural steps, etc.) for this process. Both hard copy and electronic copies have been stored appropriately for future reference. Copies of this documentation will also be retained by HCD's Audit and Evaluation Division. Further, a document outlining the specific clean-up process, as well as summary reconciliation reports have been provided in this annual follow-up response; see Attachment A "CAPES data conversion clean-up process-Oct2014", Attachment B "CBR prop 46 06-30-14 Draft 9-29-14", and Attachment C "CAPES Cumulative Prop 46 Bond Awards through 06-30-2014".

California State Auditor's Assessment of Annual Follow-Up Status: Fully Implemented

Annual Follow-Up Agency Response From November 2013

The current remediation plan continues to move forward after some unexpected redirection of staff to other HCD mission critical priorities, during 2013. Reconciliation and validation of CAPES data elements is on-going, and will continue for another 3-6 months. The expected remediation timeframe has been adjusted to April 30, 2014.

California State Auditor's Assessment of Annual Follow-Up Status: Not Fully Implemented

Annual Follow-Up Agency Response From September 2012

Complete the documentation of identified critical field clean up by making hard copies of:

• screen shots of identified critical database fields, and

• business rules for these fields

By ensuring staff and/or managers initial and date the hard copy documentation after verification and by storing these hard copy documents in an organized manner.

California State Auditor's Assessment of Annual Follow-Up Status: Not Fully Implemented

All Recommendations in 2009-037

Agency responses received after June 2013 are posted verbatim.