State of Oklahoma Addresses Federal Reporting Requirements With New Child Welfare Reporting System
Company Size
1,000+
Region
- America
Country
- United States
Product
- WebFOCUS
- FOCUS
Tech Stack
- HP-UX platform
- IBM z90 mainframe
- Virtual Linux machine
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Customer Satisfaction
- Productivity Improvements
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Functions
- Human Resources
Use Cases
- Predictive Quality Analytics
- Real-Time Location System (RTLS)
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
About The Customer
The Oklahoma Department of Human Services (OKDHS) is a state agency that provides social services to the residents of Oklahoma. They are responsible for protecting the health and safety of children and adults, helping people secure the basic necessities of life, and promoting the independence and productivity of people with disabilities. The department is also tasked with meeting federal Child and Family Services Review (CFSR) mandates. To keep track of thousands of cases and thoroughly address these federal reporting requirements, OKDHS uses Information Builders’ WebFOCUS software. The software is used by more than 2,000 KIDS users, from directors and supervisors to contractors, caseworkers, and administrative support staff.
The Challenge
The Oklahoma Department of Human Services (OKDHS) was faced with the challenge of sorting, summarizing, and presenting information about thousands of children to help caseworkers provide better family services. They also needed to enable agency directors to meet federal Child and Family Services Review (CFSR) mandates. The data needed to be dynamic, allowing caseworkers to view it in different ways and filter and sort it as they choose. Prior to the mid-1990s, the system used by Child Welfare staff was written in COBOL and the data was stored in a mainframe IMS database. This system provided only skeletal information indicating whether cases were opened or closed and a few sketchy notes, but nothing that allowed them to track cases or provide case-management services like they can do now. If they wanted to sort or filter the data in a different way, they had to ask a programmer to manually produce a special report.
The Solution
In 2003, OKDHS decided to enhance their reporting capabilities to deliver more timely and dynamic reports. They chose to use Information Builders’ WebFOCUS software due to their familiarity with FOCUS and its efficient, server-based architecture. They moved the KIDS database and legacy reports to a virtual Linux machine running on an IBM z90 mainframe, then used WebFOCUS to run the existing reports on the new platform. Information Builders’ Consulting was hired to develop the initial Outcome Measures Reports to provide caseworkers with accurate information about children within the system while also supplying compliance information for federally mandated regulations. They began with three key reports: Time to Reunification Exit, Time to Adoption Exit, and Children Not Reentering Out-of-Home Care. To simplify access to all this information, OKDHS decided to use the WebFOCUS business intelligence dashboard. The dashboard gives users a central location to find and run the reports, allows them to review multiple reports at a single glance, and enables the real-time deployment of new reports.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
IoT Data Analytics Case Study - Packaging Films Manufacturer
The company manufactures packaging films on made to order or configure to order basis. Every order has a different set of requirements from the product characteristics perspective and hence requires machine’s settings to be adjusted accordingly. If the film quality does not meet the required standards, the degraded quality impacts customer delivery causes customer dissatisfaction and results in lower margins. The biggest challenge was to identify the real root cause and devise a remedy for that.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
