Enhancing Child Support Enforcement Efforts: Summary of Data Warehouse Efforts in Nine States


Prepared by: The Lewin Group: Karen Gardiner, Mike Fishman, Asaph Glosser, Matthew Langley and SRA International, Inc.: David Vennergrund

Prepared for:U.S. Department of Health and Human Services

Office of the Assistant Secretary for Planning and Evaluation

Office of Human Services Policy and Administration for Children and FamiliesOffice of Child Support Enforcement

This report was produced under the direction of Linda Mellgren (ASPE) and Dennis Putze (ACF/OCSE) under ASPE contract 282-98-0016, Task Order 32, Jerry Regier, Principal Deputy/Assistant Secretary for Planning and Evaluation. Any opinions, findings, conclusions, or recommendations expressed in this report are those of the authors and do not necessarily reflect the views of the federal agencies that funded or reviewed this report.


This report provides information about State child support enforcement offices experiences with data warehouses; that is, how they are used to help manage program operations, assess program effectiveness and efficiency, and inform policy development. This report summarizes findings from discussions with staff in nine states about the development, content, and capabilities of their data warehouses. The report indicates that states use their data warehouses for a variety of purposes. Some focus on Federal reporting; others use the data warehouse for specified child support activities (e.g., locate). Some use the data warehouse to manage their programs (e.g., identifying underperforming offices, overstaffed functions), while others use it to explore and assess new policies. Additionally, the data in the warehouse come from a variety of sources. Each state's CSE automated statewide system plays a prominent role. Also, in some states, the data warehouse directly interfaces or feeds into other systems (e.g., welfare). State data warehouses vary in terms of reporting capabilities. Some use them to generate Federal reports for the incentive-related data reliability audits or the annual self-assessments. Others use their data warehouses primarily for ad-hoc reports. State child support programs also grant different levels of access to their data warehouses. For example, in some instances, partner agencies can access limited data; in others, access is highly restricted. Finally, the state respondents had unique perspectives on best practices and advice for other child support programs interested in building data warehouses. Each of these areas is discussed in detailed in the report.


"report.pdf" (pdf, 395.28Kb)

Note: Documents in PDF format require the Adobe Acrobat Reader®. If you experience problems with PDF documents, please download the latest version of the Reader®