Contents Show
The Actual Enrollment Versus Caseload Assigned Report CLD028 (Output) is a monthly count of enrollment for each county and municipality. The report is generated when the OK button is clicked on the Generate Actual Enrollment versus Caseload Assigned Report screen.
The enrollment is a count of all participants eligible to receive benefits during the reported month. Each participant is counted once in each month that they are eligible to receive benefits.
The count of enrollment is broken down by WIC Category within clinic and is cross-referenced with municipality and county. The enrollee is counted in the county of residence most recently recorded during the month-end process.
Caseload is assigned as of that point in time. If a prior month's report is requested and the caseload assigned data has subsequently been updated, the updated caseload assigned data will be included in the requested report.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
The value is a count of the caseload assigned for state agencies. The state office provides this value. A value should be provided for every clinic. If a value is not provided for a clinic, 'n/a' is used in its place. The state totals are an accumulation of the clinic totals. If a value is not assigned for the county/municipality, 'n/a' is used in its place.
Origin of Data Element
For clinics, The value will come from the Total_Assigned_Caseload column of the Assigned_Caseload table.
Format
The value is an eight-digit number.
The value is a count of the caseload assigned for clinics. The state office provides this value. A value should be provided for every clinic. If a value is not provided for a clinic, 'n/a' is used in its place. The state totals are an accumulation of the clinic totals. If a value is not assigned for the county/municipality, 'n/a' is used in its place.
Origin of Data Element
For the state totals, The value is the summary of the WIC Category from the Assigned_Caseload column of the Status_Assigned_Caseload table.
Format
The value is an eight-digit number.
The following is a description of the active enrolled counts for each category within the clinic for the reported month. The municipality totals are an accumulation of the category totals. The county totals are an accumulation of the municipality totals. The clinic totals are an accumulation of the county totals. The state totals are an accumulation of the clinic totals.
Origin of Data Element
The column is calculated by totaling the number of participants eligible to receive WIC benefits during the reported month. A value of "Y" in the Enrolled_This_Month column of the Caseload_Count_Enrollment table indicates that the participant was eligible to receive WIC benefits during the reported month. Participants are grouped by Clinic, WIC_Status, County and Legal_Municipality columns of the Caseload_Count_Enrollment table.
Format
The value is a six-digit number.
Origin of Data Element
The column is calculated by dividing the actual enrolled amount for this line (WIC Category) by the active enrolled value for this clinic. This calculation is performed for every line item on the report.
Format
The value is a three-digit number plus one decimal place.
Origin of Data Element
The column is calculated by dividing the Caseload Assigned amount for this line by the Caseload Assigned value for this clinic. This calculation is performed for every line item on the report where there is an assigned caseload amount. If an assigned caseload value is not provided, 'n/a' is used in its place.
Format
The value is a three-digit number plus one decimal place.
All participants eligible to receive WIC benefits during the reported month are selected for this report. A value of "Y" in the Enrolled_This_Month column of the Caseload_Count_Enrollment table indicates that the participant was eligible to receive WIC benefits during the reported month.
The report will be sorted by Clinic name within the State.
The report will be sorted by County name within Clinic name.
The report will be sorted by Municipality name within County name.
The report will be sorted by WIC Category within municipality. The following sequence will be used.
Pregnant Women
Breastfeeding Women
Non-Breastfeeding Women
Infant
Children
A total for all Clinics will be printed as state totals.
The data is current as of the previous month-end.
|
Software Version: 2.40.00