Data Reliability Audit Requirements for the Fiscal Year 2012 Reporting Period
DEAR COLLEAGUE LETTER
DATE: August 17, 2012
ATTACHMENT: Data Submission Requirements for the Fiscal Year 2012 Data Reliability Audits
TO: ALL STATE IV-D DIRECTORS
RE: Data Reliability Audit Requirements for the Fiscal Year 2012 Reporting Period
Enclosed with this letter are the data submission requirements for the federal fiscal year (FY) 2012 Office of Child Support Enforcement (OCSE) Data Reliability Audits (DRAs), as required by Section 452(a)(4)(C)(i) of the Social Security Act. Although the required submissions are due by the end of 10 business days after the beginning of calendar year 2013, we are providing the specifications as early as possible to assist states that may need extra time to coordinate and schedule these requirements with their information technology departments.
DCL-04-02, Data Reliability Audit Process for Auditing States Less Frequently than Annually, dated January 21, 2004, describes when a DRA will be conducted. As stated in the DCL, when a state is not subject to a DRA, the Office of Audit will conduct a Data Reliability Review (DRR). Audit staff will follow the DRR process by conducting analytical procedures on Lines 1, 2, 5 and 6, or 8 and 9, 24, 25, 28 and 29, as outlined in DCL 04 02. Also, to review the Cost-Effectiveness performance indicator, we will evaluate whether selected amounts reported on the OCSE-34A and the OCSE-396A could be verified to the first level of state documentation.
As in prior years, the OCSE Office of Audit will continue to evaluate the completeness, reliability and security of performance indicator data reported by the states and the accuracy of the reporting systems used in calculating the performance indicators. This requires electronic files from each state that contain the complete, unduplicated child support case universe as of September 30, 2012, including all open IV-D cases, closed cases and non IV-D cases, and the audit trails for each line on the OCSE-157 used in the computation of performance indicators. The specifications for these files are enclosed.
States must ensure that the universe and the performance indicator audit trails are in accordance with the OCSE-157 reporting instructions and our audit specifications because getting the data in a standard format expedites the audit work. Time spent will be shortened considerably if the audit trails supporting the performance indicator data are submitted uniformly by all 54 states and territories.
Submissions are required for both DRAs and DRRs. To provide assurance about the integrity of the data and in order to safeguard your state’s data, the database file with the universe and audit trails must be encrypted in a self-extracting file and sent to the Area Audit Office on a read-only CD or DVD. Please note that this is different from a read only database file. As an additional safety measure, we strongly suggest that you send the password under a separate correspondence.
I urge all states to provide read-only system access to the auditors. Please have your systems staff contact the auditors to ensure that read only remote system access is provided and functions properly. Read-only remote access to a state’s child support system allows the Office of Audit to review sample cases more efficiently and effectively in the data-testing phase of the audit. It enables a better allocation of scarce resources and results in less disruption of state and local child support operations. Read-only access is a requirement detailed in Objective G-5 of the OCSE State Systems Certification Review Guide, available on the OCSE website.
We trust that you will be able to provide us with the audit trails in the suggested format as early as possible and before the deadlines for data submission. Again, you have until December 31, 2012, to submit the final FY 2012 OCSE-157 report and up to 10 business days after the beginning of calendar year 2013 to provide the associated audit trails. Additionally, corrected OCSE-157 reports for prior periods must also be received within the deadlines stated above. States that are submitting corrected data from prior periods may want to refer to DCL-11-18, Submittal of the OCSE-157 Report for FY 2011 and Resubmission of FY 2010 Data Found to be Incomplete or Unreliable, dated October 17, 2011, for more information on this topic. OCSE-157 reports for both the current and prior periods must be submitted to the OCSE Division of Planning, Research and Evaluation, while the audit trails must be provided to your appropriate Area Audit Office.
Because of the technical nature of the data specifications, it is important that this DCL and the Enclosure be forwarded to the staff developing the programming that will produce the audit trails. The process used by the auditors to validate the audit trails is dependent on the table names, field names and data type agreeing with these specifications. Any deviation can affect the acceptance of the audit trails and the prompt initiation and completion of the audit.
Your timely cooperation is greatly appreciated. Please feel free to consult with our audit staff if you have any questions or need our assistance as you work with systems staff to develop the audit trail file in the suggested format.
Office of Child Support Enforcement