Contents Show
The Participation Processing Statistics Report CLD015 (Output) consists of individual clinics, agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Participation Processing Statistics Report screen and is also generated as part of the month-end process using the selection criteria of "All".
The Participation Processing Statistics is a statistical summary of enrollment totals, reported participation and redeemed participation.
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, agency description, 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 calculated by dividing the total WIC reported participation by the total enrollment and multiplying the result by 100. This column is calculated for closeout months only.
The total WIC reported participation is the count of participants from the CaseloadCount table that meet the following selection criteria.
ParticipationCYM column is equal to the reported month
RptedThisMonth column is equal to "Y"
ProgramCode column is equal to the WIC value
The total WIC enrollment is the count of participants from the CaseloadCountEnrollment table that meet the following selection criteria.
ParticipationCYM column is equal to the reported month
EnrolledThisMonth column is equal to "Y"
ProgramCode column is equal to the WIC value
Format
This value is a three-digit number plus one decimal place.
Origin of Data Element
This value is calculated by dividing the total WIC redeemed participation by the total WIC enrollment and multiplying the result by 100. This column is calculated for closeout months only.
The total WIC redeemed participation is the count of participants from the CaseloadCount table that meet the following selection criteria.
ParticipationCYM column is equal to the reported month
RdmdThisMonth column is equal to "Y"
ProgramCode column is equal to the WIC value.
The total WIC enrollment is the count of participants from the CaseloadCountEnrollment table that meet the following selection criteria.
ParticipationCYM column is equal to the reported month
EnrolledThisMonth column is equal to "Y"
ProgramCode column is equal to the WIC value
Format
This value is a three-digit number plus one decimal place.
Origin of Data Element
This value is calculated by dividing the total WIC redeemed participation by the total WIC reported participation and multiplying the result by 100. This column is calculated for closeout months only.
The total WIC redeemed participation is the count of participants from the CaseloadCount table that meet the following selection criteria.
ParticipationCYM column is equal to the reported month
RdmdThisMonth column is equal to "Y"
ProgramCode column is equal to the WIC value.
The total WIC reported participation is the count of participants from the CaseloadCount table that meet the following selection criteria.
ParticipationCYM column is equal to the reported month
RptedThisMonth column is equal to "Y"
ProgramCode column is equal to the WIC value
Format
This value is a three-digit number plus one decimal place.
Origin of Data Element
This value is the total count of enrolled participants whose certification period ended during the reported month and they did not subsequently certify. Participants must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
CurrentEndDate column of the CaseloadCountEnrollment table equals the reported month
CurrentEffectiveDate column of the CaseloadCountEnrollment < CurrentEndDate column of the CaseloadCountEnrollment table
CategoricallyIneligibleDate column of the CaseloadCountEnrollment table > the reported month
TerminationDate column of the CaseloadCountEnrollment table is zero
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is calculated by subtracting the Overdue Re-Certs value from the Re-Certs Due. The difference is divided by the Re-Certs Due value and multiplied by 100. This column is calculated for closeout months only. The closeout average column does not apply to this line.
Format
This 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.)
Origin of Data Element
This value is the count of enrolled participants new to WIC during the reported month. A participant is counted once in their lifetime. Participants must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
OrigEnrollmentDate column of the CaseloadCountEnrollment table equals the reported month
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the count of participants who were terminated during the reported month. Participants must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
TerminationDate column of the CaseloadCountEnrollment table equals the reported month
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the count of participants that are categorically ineligible for WIC benefits during the reported month. A value is printed for all months during the fiscal year. When reporting future months, the total represents the number of participants expected to be categorically ineligible for the future month. The closeout average column does not apply to this line. Participants must meet the following selection criteria.
For 30-day and closeout months
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
CategoricallyIneligibleDate column of the CaseloadCountEnrollment table equals the ParticipationCYM column of the CaseloadCountEnrollment table
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
For issuance and future months
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month (Month of value).
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
CategoricallyIneligibleDate column of the CaseloadCountEnrollment table equals the reported month or a future month within the range of the report (CategoricallyIneligibleDate will be used to group data into appropriate months)
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the total count of enrolled participants who were subsequently certified during the reported month. This count includes the Re-Certs-Prior Mo total. Participants must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
CurrentEffectiveDate column of the CaseloadCountEnrollment = the reported month
OrigEnrollmentDate column of the CaseloadCountEnrollment table < CurrentEffectiveDate column of the CaseloadCountEnrollment table
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the total count of enrolled participants who were subsequently certified during the reported month but their certification was due in a prior month. Participants must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month
CurrentEffectiveDate column of the CaseloadCountEnrollment = the reported month
OrigEnrollmentDate column of the CaseloadCountEnrollment table < CurrentEffectiveDate column of the CaseloadCountEnrollment table
PreviousEndDateCYM column of the CaseloadCountEnrollment table > zero and < CurrentEffectiveDate column of the CaseloadCountEnrollment table
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the total count of enrolled participants whose certification end date falls within the reported month. A value is printed for all months during the fiscal year. When reporting future months, the total represents the number of participants whose certification end date is in the future month. The closeout average does not apply to this line. Participants must meet the following selection criteria.
For 30-day and closeout months
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table is one of the reported months
CurrentEndDate column of the CaseloadCountEnrollment table equals the reported month (certification ended in reported month)
CurrentEffectiveDate column of the CaseloadCountEnrollment table is not equal to PreviousEndDateCYM column of CaseloadCountEnrollment table (participant did not recertify in same month as last certification ended)
TerminationDate column of the CaseloadCountEnrollment table equals zero
CategoricallyIneligibleDate column of the CaseloadCountEnrollment table > CurrentEndDate column of the CaseloadCountEnrollment table
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
For issuance and future months
ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month (Month of value).
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
CurrentEndDate column of the CaseloadCountEnrollment table equals the reported month or a future month within the range of the report (CurrentEndDate will be used to group data into appropriate months)
CurrentEndDate column of the CaseloadCountEnrollment table >= the issuance month
CurrentEffectiveDate column of the CaseloadCountEnrollment table is not equal to the issuance month (participant did not recertify during the issuance month)
TerminationDate column of the CaseloadCountEnrollment table equals zero
CategoricallyIneligibleDate column of the CaseloadCountEnrollment table > CurrentEndDate column of the CaseloadCountEnrollment table
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the count of participants that were on a waiting list as of the end of the reported month. A total is calculated for each priority. 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. Valid priorities for each category are defined in the PriorityPerWICStatus table. Participants must meet the following selection criteria.
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y"
ParticipationCYM column of the CaseloadCountEnrollment table is one of the reported months
WaitListStatus column of the CaseloadCountEnrollment table equals "Y"
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is the count of participants that who have at least one food instrument not redeemed as of the end of the closeout month (i.e. at least one food instrument that was not presented to the bank and was not voided). This column is calculated for closeout months only. Participants must meet the following selection criteria.
RptedThisMonth column of the CaseloadCount table equals "Y"
ParticipationCYM column of the CaseloadCount table is one of the reported months
CountFIIssued minus CountFIPresented minus CountFIVoided > 0. All columns are from the CaseloadCount table.
ProgramCode column of the CaseloadCount table equals the WIC value
Format
This value is a six-digit number.
Origin of Data Element
This value is calculated by dividing the No of ID Unused Checks by the total reported participation for the closeout month. The result is multiplied by 100 and rounded to the nearest tenth. This column is calculated for closeout months only.
The total reported participation is the count of participants from the CaseloadCount table where the ParticipationCYM column is equal to the reported month column, the RptedThisMonth column is equal to "Y", and the ProgramCode column equals the WIC value.
Format
This 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.)
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 or tenth, depending on the format of the applicable line.
Format
This value is formatted the same as the other data for the applicable line.
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. Additional filter criteria are defined in the data elements section.
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 clinic is selected, this part of the sort order does not apply.
If agency 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.
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
