Page 41

WORK REGISTRANT DATA The SNAP general work requirements are described at 7 CFR 273.7(a). Individuals who do not meet a federal exemption from the general work requirements, as listed in 7 CFR 273.7(b)(1), are subject to the general work requirement and must register for work. In accordance with 7 CFR 273.7(c)(10), the State agency must submit to FNS the number of work registrants in the State as of October 1st. This information is submitted on the first quarter E&T Program Activity Report (FNS-583). Describe the process the State agency uses to count all work registrants in the State as of the first day of the new fiscal year (October 1). Utah’s MIS is responsible for all facets of reporting including providing the Work Registrant count for the first quarter E&T Program Activity Report. Provide information about how work registrant data is pulled from the eligibility system, including the date the data is pulled. MIS utilizes SQL to pull data. This is a common language that extracts and organizes data that is stored in eREP’s relational database. The query reviews the entire SNAP caseload found in eREP. The query includes all SNAP recipients receiving SNAP on October 1. The query specifically looks for the total count of all work registrants in the State of Utah on October 1. How are work registrants identified in the eligibility system? Upon removing any SNAP recipients that meet a federal exemption, the SQL query populates the report with all work registrants found in the state’s SNAP caseload on October 1. The report is reviewed and validated to contain only work registrants. The total count is determined from the report. The information is entered into the FNS-583 for the number of work registrants receiving SNAP on October 1 of the new fiscal year. Describe measures taken to prevent duplicate counting of work registrants within the federal fiscal year. Utah’s MIS is responsible for all facets of reporting. MIS utilizes SQL to pull data. This is common language that extracts and organizes data that is stored in eREP’s relational database. The function used to pull back “unduplicated” work registrants is “Select Distinct”. The query uses the particular function to identify the unique number of eREP “integrated cases” and “individuals” that meet the specifications. There are several controls in place to ensure that the query is validated to provide requested results. During query development, the MIS consultant validates against the eREP system. After validation of the results by the MIS consultant, they then send the query for peer review. At peer review, the query is reviewed, tested and validated for accuracy. Finally, once the query and results have been validated and approved by MIS, the results are sent to the Reports Gatekeeper to facilitate testing and validation with the appropriate business individual. In this case, the state’s SNAP program specialists are responsible to review the results and validate against eREP. Once validated and approved, the reports are submitted to FNS. 1/29/26, 10:24 AM State Plan UT FY26 - Original Submission https://dam-fns.usda.gov/sites/default/files/microsite/snapet-utfy26stateplan//index.html 41/56