Predictive AnalyticsFor
Program Integrity
Child Care Administration
APHSA – ISM Conference
October 8, 2013
Who Are We ?
Mindy KraussSystems/IT Manager
Child Care Administration
Arizona Dept. of Economic Security
Devon PollardLead Information Tech. Specialist
Child Care Administration
Arizona Dept. of Economic Security
Overview of Presentation
- AzCCATS History- From ASSISTS to AzCCATS
- Data Gathering for Reports- Reports through system
- Einstein Data Warehouse
- Areas of Reporting- Regularly Scheduled Reports
- Forecasting
- Client Beneficial
- Monitored Risk
- Potential: - Monetary Reimbursement
- Fraud
- Questions and Answers
Arizona Child Care Automated Tracking System
(AzCCATS)
Stone and Chisel to Paper and PenASSISTS(Legacy System) Received from Utah – 1989Coded in Natural and DB2, launched for use in 1991Child Protective Services and Child Care Administration
both used this new system1996 CPS split off into their own Front End systemAt same time, ASSISTS became the AzCCATS
Data Gathering for Reports
Data available through: Reports in the AzCCATS
Generated through system scheduled jobs
ADHOC region updated Weekly
Data Warehouse Repository of Data from various systems
Retrieved using Microsoft ACCESS
Data Warehouse updated Monday – Friday
Daily/Weekly/Monthly/Semi-Annual/Annual Regulary Scheduled (120+)
Upon Request from Management
Types of Reports
Regularly Scheduled
Forecasting
Client Beneficial
Monitored Risks
Potential Monetary Reimbursements
Potential Fraud
Regular Scheduled Reports
AS003 -Workload by Case Manager
Caseload Listing – Upcoming Reviews Due
AS200 -Month End Reports
Productivity Report - Authorization Counts
Intakes – Type of Program – What is carried Forward
CP100 -Timeliness
Registration and Determination
PR50 - Provider Inactivity, No Pay/No Auth
Active providers with no current auths or payments
Forecasting Reports
Priority Waiting List (PWL)Who we can help if we had funding to
provide services
Global Information System (GIS)
Allows forecasting for recruitment and need based on # of clients and providers per zip code
Client Beneficial
Priority Waiting List (PL) should be on Transitional Child Care (TCC) or TANF Employment Child Care Assistance (EA)
Cross match our Clients with AZTECS
Open TANF = Potential EA
Closed TANF = Potential TCC
TCC with open TANF
Client has Potential EA eligibility, a program with no Co-pays
Potential Monetary Reimbursements
IV-E Report
- Completed on quarterly basis
- Care needed must be based on Work
- Children in our CPS Child Care Category
- Potential recoupment of over 1 million dollars monthly
Monitored Risks
Fingerprint Report
Informs what providers have fingerprint cards which are about to expire
Potential Fraud
UI Match
- Cross Match All clients to UI Data
- Receiving Child Care but are Unemployed
- UI and CCA both validate inconsistencies
Red Flag Reports
- Paid per Capacity
- Amount Paid
- Number of Children
Red Flag Reports
Paid per Capacity
- What is capacity?- Are they consistently paid for full capacity?
LC Amount Paid
- Provider Payment Range
- Top 10 Consistently in defined range
Number of Children
- How many children paid per month
Certified Group Home –
Average 5 kids paid per month
Certified Home –
Average 2 kids per month
Questions and Answers
Thank You !!