Contents Show
The Enrollment Monthly Report CLD005 (Output) consists of individual clinics, agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Enrollment Monthly Report screen and is also generated as part of the month-end process using the selection criteria of "All".
The report is a month-by-month count of people who are eligible to receive WIC benefits. If an individual is in a valid certification period, he or she is eligible to receive WIC benefits and is included in the totals for each month that he or she is eligible.
Within each category, totals are accumulated for applicable priorities. 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.
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.
Origin of Data Element
The user records this value when the report is submitted. During the month-end process this is the CCYYMM value from the CurrentMonthEndDt column of the ProcessControl table.
Format
This is an accounting month and year formatted as Month Name CCYY.
Origin of Data Element
The selection criteria and information being reported determine this value.
When reporting clinic data, the agency code, clinic code and clinic description will be printed.
When reporting agency data, the agency code and description will be printed.
When reporting state data, the text description of "State Total" will be printed.
Format
This is a fifty-character text value. The format is determined by the information being reported.
Origin of Data Element
This value is the total count of selected enrollees, grouped by reported month.
Format
This value is a six-digit number.
Origin of Data Element
This value is the total count of selected enrollees, grouped by the WICStatus column of the CaseloadCountEnrollment table for each reported month.
Format
This value is a six-digit number.
Origin of Data Element
This value is the total count of selected enrollees, grouped by the WICStatus and Priority columns 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.
Format
This value is a six-digit number.
Origin of Data Element
This value is calculated by dividing the applicable line total for the month by the total enrollment (monthly count) for the same month. The result is multiplied by 100 and rounded to the nearest tenth.
Format
This value is a three-digit number plus one decimal place.
Origin of Data Element
This 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. The result is rounded to the nearest whole number.
Format
This value is a six-digit number.
All WIC enrollees eligible to receive benefits are included in the report totals. 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. Enrollees must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
If an individual clinic is selected, only data for that clinic will be included. If an individual agency is selected, summary data for that agency will be included. If the state is selected, summary data for the state level will be included. During the month-end process when all is selected, data for all clinics, agencies and state will be selected in the following sequence. Data for hidden agencies will not be included.
Agency 01, clinic 01
Agency 01, clinic 02
Agency 01 summary
Agency 02, clinic 21
Agency 02, clinic 22
Agency 02 summary
State summary
This report will be sorted by clinic code, agency code and state totals, depending on selection criteria of the report.
If the clinic total is selected, this part of the sort order does not apply.
If the agency total is selected, this part of the sort order does not apply.
If the state total is selected, this part of the sort order does not apply.
If all is selected, the report will be sorted by agency code then clinic code. The state summary will print at the end.
This report will be sorted by category and priority within clinic/agency/state. Data will be reported in the following sequence.
Total enrollment
Woman total (category P, B and N)
Women by priority
Pregnant women total (category P)
Pregnant women by priority
Breastfeeding women total (category B)
Breastfeeding women by priority
Non-breastfeeding women total (category N)
Non-breastfeeding women by priority
Infant total (category I)
Infants by priority
Child total (category C)
Children by priority
A page break will occur on change in clinic/agency.
This system output is generated on demand. If selected by the state, this system output is also generated during the month-end process.
|
Software Version: 2.40.00
