Caseload Assigned Comparison - Enrollment CLD024 (Output)

Contents ShowHide

The Caseload Assigned Comparison - Enrollment CLD024 (Output) is a month-by-month count of participants by priority who were eligible to receive WIC benefits during the reported month. The report is generated when the OK button is clicked on the Generate Caseload Assigned Comparison - Enrollment Report screen.

Participants are counted in every month that he or she is eligible to receive WIC benefits. Totals are printed by priority for all WIC categories combined. Within the priority totals, high-risk priorities are subtotaled. High-risk priorities are priorities one, two, and three. If a participant has an unknown priority or a priority that is not valid for their category, the participant is included in the 'Unknown' priority count. The totals for each WIC category are also printed.

The state business rule CASELOAD_BY_SERVICESITE determines whether caseload assigned counts are available for the individual agencies or individual clinics. If the value is "Y", the caseload assigned counts are available for clinics. If the value is "N", the caseload assigned counts are available for agencies. In both cases, caseload assigned counts may also be available for individual WIC categories.

If the state business rule CASELOAD_BY_SERVICESITE is "Y", this report will list counts of participants and the associated caseload assigned data for all clinics. If the state business rule value is "N", this report will list counts of participants and the associated caseload assigned data for all agencies. In both cases a state total will be printed.

Caseload assigned counts are provided by the state quarterly and are based on the previous quarter's funding, weight, and timing for the number of people eligible to be served. 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.

Data Elements

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.

Month of

Agency / Clinic / State Total

This is a fifty-character text value. The format is determined by the information being reported.

Caseload Assigned (Priority)

If the state business rule CASELOAD_BY_SERVICESITE equals "Y", this value will come from the sum of the TotalAssignedCaseload column of the AssignedCaseloadSS table for the corresponding agency/clinic. The state total is an accumulation of the clinic totals. If the state business rule value is "N", value will come from the sum of the TotalAssignedCaseload column of the AssignedCaseload table for the corresponding agency. The state total is an accumulation of the agency totals. Data for hidden agencies will not be included in either case.

Caseload Assigned (per WIC Category)

If the state business rule CASELOAD_BY_SERVICESITE equals "Y", this value will come from the sum of the AssignedCaseload column of the StatusAssignedCaseloadSS table for the corresponding agency/clinic. The state total is an accumulation of the clinic totals. If the state business rule value is "N", value will come from the sum of the AssignedCaseload column of the StatusAssignedCaseload table for the corresponding agency. The state total is an accumulation of the agency totals. Data for hidden agencies will not be included in either case.

The caseload assigned value is printed for the following lines: women total, pregnant, postpartum, infants and children. For the women line, values are totaled when the WICStatus column equals "P", "B" or "N". For the pregnant line, values are totaled when the WICStatus column equals "P". For the postpartum line, values are totaled when the WICStatus column equals"B" or "N". For the infant line, values are totaled when the WICStatus column equals "I". For the pregnant line, values are totaled when the WICStatus column equals "C".

Priority Summary Total (Monthly Count)

Priority (Monthly Count)

This value is the total count of selected participants, grouped by the Priority column of the CaseloadCountEnrollment table for each reported month. If a participant's priority value is unknown or is a value that is not valid for the WIC Category, the count is accumulated in the 'UNKNOWN' priority. Valid priorities for each status are defined in the PriorityPerWICStatus table.

Priority Sub Total (Monthly Count)

This value is the total count of selected participants for priorities 1, 2 & 3 for each reported month.

Women Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "P", "B" or "N".

Pregnant Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "P".

Postpartum Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "B" or "N".

Breastfeeding Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "B".

Non-Breastfeeding Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "N".

Infants Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "I".

Children Total (Monthly Count)

This value is the total count of selected participants for each reported month where the WICStatus column of the CaseloadCountEnrollment table equals "C".

Percent (Monthly per Priority)

The value is calculated by dividing the applicable line total for the month by the total Caseload Assigned count for the agency/clinic/state. The result is multiplied by 100 and rounded to the nearest decimal. If no Caseload Assigned amount was given by the State a value of zero will be shown on the report.

Percent (Monthly per WIC Category)

The value is calculated by dividing the applicable line total for the month by the total Caseload Assigned count for the agency/clinic/state and applicable WIC category. The result is multiplied by 100 and rounded to the nearest decimal. If no Caseload Assigned amount was given by the State a value of zero will be shown on the report.

C/O Avg

The value is calculated by totaling the values in the row for closeout months and dividing the accumulated total by the number of closeout months included. For the participant count lines, the result is rounded to the nearest whole number. For the percent lines, the result is rounded to the nearest tenth.

For the participant count lines, the value is a six-digit number. For the percent lines, the value is a three-digit number plus one decimal place. (If the calculated value exceeds 999.9, the system assigns a default value of 999.9.)

Filter Criteria

All participants who were eligible to receive WIC benefits during the reported months are included in the counts for the reported months. Data is reported for all months from the start of the fiscal year to the month selected. Data for hidden agencies will not be included. Participants must meet the following selection criteria.

If the state business rule CASELOAD_BY_SERVICESITE equals "Y", the participant count values will be grouped by clinic. If the state business rule value is "N", participant count values will be grouped by agency.

The state office will provide the caseload assigned values. If the state business rule CASELOAD_BY_SERVICESITE equals "Y", the values are recorded for clinics. If the state business rule value is "N", the values are recorded for agencies. A value should be provided for every agency/clinic. If a value is not provided for an agency/clinic, zero is used in its place.

Sort Order

If the state business rule CASELOAD_BY_SERVICESITE equals "Y", the report will be sorted by the agency identifier, then clinic identifier. If the state business rule value is "N", the report will be sorted by agency identifier.

Control Breaks

If the state business rule CASELOAD_BY_SERVICESITE equals "Y", a page break will occur on a change of agency/clinic identifier. If the state business rule value is "N", a page break will occur on a change of agency identifier.