C-840, DataMart

Revision 15-4; Effective October 1, 2015

All Programs

DataMart provides a series of online reports, accessed through the State Portal. The reports are used as monitoring tools for various case action activities within Texas Works.

Instructions for accessing and using the various reports may found at the following Texas Works Policy page on the Loop:

https://oss.txhhsc.txnet.state.tx.us/sites/eo/support/qm/fp/DataMart%20Instructions/Forms/AllItems.aspx

C—841 DataMart Reports

Revision 19-3; Effective July 1, 2019

Number	The Report …
DF-001a	Felony Drug Conviction (FDC) Disqualification for SNAP Provides a monthly count of people previously disqualified for an FDC occurring on or after August 22, 1996 who are now receiving SNAP benefits on an approved SNAP EDG.
DF-001b	EDGs Denied for Parole/Community Supervision Compliance Verification Provides data on SNAP EDGs denied for failure to provide verification of compliance with parole or community supervision.
DF-001c	SNAP FDC Disqualifications Provides data on the number of people who have a two-year or permanent SNAP disqualification related to FDC.
DG-001	Reviews and Recertifications Due by Office Allows managers and appropriate field staff to identify TANF, Texas Works (TW) Medicaid, CHIP and SNAP Redeterminations that are due in a month specified by the user.
DG-002	Pending Applications Allows managers and appropriate field staff to identify pending TANF, SNAP, TW Medicaid, CHIP, CHIP perinatal and Healthy Texas Women (HTW) applications on a daily basis.
DG- 003	Work In Progress (WIP) Allows managers and appropriate field staff to identify open TANF, SNAP, TW Medicaid, CHIP, CHIP perinatal, and HTW actions on a daily basis.
DG-004R	Delinquency Analysis Data Report Provides detailed data that is consolidated to aid in the analysis of causal factors contributing to each delinquency.
DG- 006	Task List Manager (TLM) Task Aging by Past Due Date Allows managers and appropriate field staff to identify all the tasks that are not closed by the TLM task due date.
DG-007	Appointment No Show Gathers all the details for an appointment with a No Show (NS) status to ensure TLM No Show task actions are completed timely.
DG-008	Appointment Slots Utilization Allows managers and appropriate field staff to identify all the appointment slots published for a specific office or group of offices using State Portal Scheduler and the number of appointments slots already scheduled for an interview for a selected office and reporting period.
DG-009	Tickets/Service Request Status Report Provides a consolidated source for viewing all open Remedy and Project and Portfolio Management Center (PPM) tickets or recently closed PPM tickets.
DG-010	Disposition Timeliness Report Assists management to efficiently monitor the timeliness percentage, total dispositions for all applications and redeterminations, timely and untimely dispositions and the number of disposing employees for TANF, SNAP, TW Medicaid, CHIP, CHIP perinatal, and Medicaid for the Elderly and People with Disabilities (MEPD) programs. This report will display the timeliness based on the disposition date. Note: This report provides timeliness for redeterminations disposed timely or untimely. Types of Assistance (TOAs) that have a passive renewal will be included if a recertification package is received and processed.
DG-011	Review Timeliness Report Assists managers to efficiently monitor the number of delinquent reviews, the age of the delinquent reviews and the percentage of the total caseload that is delinquent for the following three types of assistance in TIERS: MA - Parent and Caretaker Relatives TANF Basic TANF State Program Note: This report provides information on past due redeterminations that have not been processed and/or disposed. Timeliness for other programs is monitored through other reporting mechanisms. TOAs that have a passive renewal will not be included on this report.
DG-012	Pending Applications and Redeterminations over 60 Days Assists management to identify and monitor applications and redeterminations pending over 60 days for SNAP, TW Medicaid, CHIP, CHIP perinatal, TANF, and MEPD on a daily basis, and to identify the current employee assigned with pending applications and redeterminations.
DG-014	Merge/Separate (M/S) WIP Report Assist management and Data Integrity staff to identify and monitor pending M/S TLM request tasks on a daily basis.
DG-015	M/S Timeliness Report Assist management to efficiently monitor the number of completed M/S TLM requests, and the number and percentage of timely completed M/S TLM requests.
DG-016	M/S Daily Potential Duplicate Report Provides Data Integrity staff a daily list of potential TIERS duplicate individual IDs created and/or updated on any given day and an individual summary and potential match detailed level reports.
DG-017	Office of Eligibility Services (OES) Community Based Organization (CBO) Data Report Assists with statistics for federal reporting on the Community Partner project. The report provides the number of CBO applications and redeterminations: submitted; pending; disposed; and percentage of total EDGs processed timely.
DG-020	Community Partner Case Action and Status View Report Case Action Summary report provides CBOs with the ability to track the volume of applications, redeterminations, and changes submitted by their organization. Case Status View Activity report tracks the inquiries completed.
DG-021	Request for Review Report Allows managers and appropriate field staff to view the CHIP and CHIP perinatal request for review report by region, status, manager and employees. The report captures the number of requests for review pending, completed, and requests for retro coverage.
DG-022	Automated Electronic Reminders Provides the status of the total number of current subscriptions to electronic reminders at the end of each month and provides the number of electronic reminders sent to people for each reminder type.
DG-038	EDG-Level Processing for Medicaid Renewals Provides EDG-level information for EDGs completed through the automated Medicaid Renewal Process.
DG-039	ACA Periodic Income Check Report Provides EDG-level information for EDGs eligible for the periodic income check.
DF-040	Eligibility Performance Report Provides a method for managers to measure productivity at the Employee and Manager Levels; provides daily and monthly statistics for employees and managers; monitors applications, redeterminations, and changes for SNAP, TANF, Texas Works Medical Assistance (including Children's Medicaid, CHIP and CHIP p), MEPD, and State Paid coverage for a selected time period; and presents the average processing time from the file date to date disposed for applications and redeterminations.
DM-002	Qualified Hospital/Qualified Entity Presumptive Eligibility Report Provides Community Access Services (CAS) staff with statistical data on Presumptive Eligibility (PE) regarding the number of approved and denied PE determinations. It also provides the number of Medicaid-assisted approved or denied applications. Allows CAS staff to determine if an error should be counted toward a qualified hospital based on the accuracy and timely submission of a PE determination.
DM-005	Reasonable Opportunity Report Provides the total number of people receiving a period of reasonable opportunity to provide verification of alien status or citizenship and the number of times a person was given a period of reasonable opportunity to provide verification of alien status or citizenship.
DM-007	HB 839 Reinstatement of Medicaid Provides Centralized Benefit Services (CBS) staff a listing of children whose TP 44 eligibility has been suspended upon notification from Texas Juvenile Justice Department (TJJD)/Juvenile Probation Department (JPD) of placement in a juvenile facility, or reinstated upon notification from TJJD/JPD of release from a juvenile facility.
DM-008	FFCC Ongoing Monitoring Reports Allows management and appropriate staff to track and review various data regarding people who may be eligible for or are currently receiving Former Foster Care Children's (FFCC) Medicaid (TA 82). There are six sub-reports: People Certified for Non-FFCC Program, Lower than FFCC Hierarchy Provides a list of people who are age 18 through 25, received Foster Care - Federal Match - No Cash (TP 93) or Foster Care - Federal Match - With Cash (TP 94) on their 18th birthday or later, and are certified for a Medicaid program that is below TA 82 in the Medicaid hierarchy. People Certified for Non-FFCC Program, Higher than FFCC in Hierarchy Provides a list of people who are age 18 through 25, received TP 93 or TP 94 on their 18th birthday or later, and are certified for a Medicaid program that is above TA 82 in the Medicaid hierarchy. People Terminated Ongoing Medicaid or Denied at Application Provides a list of people who are age 18 through 25, received TP 93 or TP 94 on their 18th birthday or later, applied for non-TA 82 coverage and were denied, or who were on a non-TA 82 Medicaid program and were denied coverage at application or denied on-going Medicaid coverage. Active FFCC Individuals Denied Provides a list of people who received TA 82 and were denied TA 82 coverage in the report month. Active FFCC Individuals Provides a list of all active people on TA 82. TP 93 and TP 94 Denied Provides a list of people age 18 through 20 who were receiving TP 93 or TP 94 in the report month but are not receiving Medicaid in the month following the report month.
DM-011	TP40 Transition Report Identifies enrollment patterns and transitions between TP 40 and other programs. The DM-011 TP 40 Transition Report also allows staff to review cases when women enrolled in TP 40 do not transition to other coverage and when Alert 824s are not processed timely.
DM-012	HB 337 County Jail Reporting Identifies persons suspended, terminated, or reinstated due to county jail confinement or release.