Contents Show
The Redeemed Participation Priority Summary Report CLD011 (Output) consists of individual agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Redeemed Participation Priority Summary 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 participants by priority who redeemed at least one food instrument that was issued in the reported month. Participants are counted in each month that he or she redeemed a food instrument that was issued in the reported month. Issuance is based on the participation date value, not the date the food instrument is printed. A redeemed food instrument is a food instrument presented for payment. Participants are included in the count even if the bank rejected all redeemed food instruments.
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 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 count of participants where the RdmdThisMonth column of the CaseloadCount table equals "Y" and the ParticipationCYM column of the CaseloadCount table equals the reported month and the 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 the total count of selected participants, grouped by the Priority column of the CaseloadCount 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 category 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 Priority Summary value for the same month. The result is multiplied by 100.
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.
Format
This value is a six-digit number.
All WIC participants that received benefits and presented at least one food instrument for payment 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. Participants must meet the following selection criteria.
RdmdThisMonth column of the CaseloadCount table equals "Y"
ParticipationCYM column of the CaseloadCount table equals the reported month
ProgramCode column of the CaseloadCount table equals the WIC value
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 summary
Agency 02 summary
State summary
This report will be sorted by agency code and state totals, depending on selection criteria of the report.
If more than one agency is selected, the report will be sorted by agency code.
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 priority within agency/state. Data will be reported in the following sequence.
Total redeemed participation
Priority 1
Priority 2
Priority 3
Sub-total of priorities 1, 2 and 3
Priority 4
Priority 5
Priority 6
Unknown priorities
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
