Converging on Standards: Tool Migration Bob Padgett Mark Wagner

1. Converging on Standards: Tool MigrationBob PadgettMark Wagner

2. The purpose and the mission of the Child Support Enforcement Program are derived from title IV-D of the Social Security Act To enhance the well-being of children by assuring that assistance in obtaining support, including financial and medical, is available to children through locating parents, establishing paternity, establishing support obligations, and monitoring and enforcing those obligations Michigan’s child support program operates through the cooperative efforts of three agencies The Department of Human Services Office of Child Support Prosecuting attorneys in each county Friends of the court in each county MiCSES Background

3. DHS Office of Child Support Locate a parent Voluntary paternity establishment A referral to establish a court order for paternity and/or support Referring an existing order for enforcement Recommending action on an interstate case Prosecuting Attorney Obtaining a court order to establish paternity Obtaining court orders for custody, support, and parenting time Locating a parent MiCSES Users

4. Friend of the Court Investigating and make recommendations regarding custody, parenting time, and support Enforcing custody, parenting time, and support orders Modifying custody, parenting time, and support orders Register Michigan orders in other states Initiating income withholding orders Resolving collection problems Providing alternative dispute resolution Locating a parent MiCSES Users

5. The MiCSES system provides data to and utilizes data from the Data Warehouse Maintain an address history from a number of sources in support of the location process Compile statewide case data and manage the interaction with the Federal Case Registry Link New Hire Data to Court Orders and produce Income Withholding Notices Compile Financial Institution Data Match account data for use in enforcement actions Compile Federal Reporting data for use in the OCSE157 and OCSE 34A reports Compile Medical Insurance coverage information for provision to Title XIX MiCSES Data Warehouse

6. Federal Parent Locator System – (SSA, Veteran’s Affairs, DOD, FBI) National Directory of New Hires - (New hire information from employers) Federal Case Registry - (Nation-wide information) Unemployment Agency - (Unemployment claimant benefit) Department of Community Health - (Health insurance and Medicaid data) Department of Natural Resources - (Fishing, hunting licenses) Department of Corrections - (Person, location, parole information) Department of Treasury - (Employee withholding taxes) State Directory of New Hires - (New hire information from employers) Financial Institutions - (Multi-state financial institution data match) State Licensing Agencies - (Professional license data) Department of State - (Drivers license data) Michigan State Police – (Personal protection orders) MiCSES DW Data Sources

7. MiCSES Data WarehouseBI Query • CSES_DW APPLICATION SCREENS: MENUS / QUERY SELECTION • Main Screen(CSES_DW Primary Screen: Menu/Report Selection) • Select by Functional Area: OR Select by Function: • Standard-Locate People & Addresses • Friend of Court-Locate Employment & Income • FIDM / MSFIDM-Locate Assets & Licenses/FIDM • (V3.2.0 Queries)-County Specific Queries • -Friend of Court • -Federal Reporting

8. BI Query Unsupported Version CITRIX Unsupported Version Servers 5 Windows NT Servers Teradata Drivers NOT compliant with WINDOWS NT MiCSES BI Query Environment

9. Analysis of Options Upgrade current Hardware/OS/Application code Deploy access via MiCSES Oracle Forms or J2EE Deploy access via DHS Business Objects Shut down - Discontinue the application MiCSES Potential Solutions

10. Desktop Standard Options Business Intelligence Business Objects XI R2 Reporting Tools Crystal Reports XI R2 http://www.michigan.gov/documents/dit/Swr_DtopOptions_7-5-2007_201488_7.pdf State Standards –Business Objects

11. MiCSES User Requirements and Functional Design MOU with DIT-Agency Services-DHS SOW - Business Objects Consultant Review/Analyze overall reporting requirements Review/Analyze database structures/views Design/Create Business Objects universe(s) based on reporting requirements and underlying structures Provide full testing of all universes Provide documentation on universes as required Layout overall plan for report creation in Business Objects Interface with DHS BO development staff Assist MiCSES development staff in aligning to DHS Business Objects processes and standards MiCSES How We Got There

12. Five Servers DHS has four servers MiCSES purchased a new server Data encryption Load Balancing Determine number of concurrent users Server weight calculation for load balancing Communication Between Organizations and Upgrades Have to adapt to different organizational goals and policies DHS - Business Objects Server Cluster

13. Repository Statistics Universes DHS – 34 MiCSES – 2 Reports DHS – 628 MiCSES – 82 Users DHS – 7,846 MiCSES – 1,060 Queries DHS – July-59,000 Aug-67,000 Sep-22,000 Oct-39,000 MiCSES - July-32,000 Aug-40,000 Sep-15,000 Oct-20,000 DHS and MiCSES Statistical Information

14. Business Objects XI R2 Plan to upgrade to XI R2 in 2008 Test/Development and DR Investigate and plan to develop a test/development & DR Environment Enterprise Business Objects Licenses Investigate an enterprise license strategy The Future

15. Q & A The End