Contents Show
The Monthly Redemption Unduplicated Report CLD009 (Output) consists of individual agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Monthly Redemption Unduplicated Report screen.
The report is a month-by-month count of participants 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.
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.
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 total count of selected participants, grouped by reported month.
Format
This value is a six-digit number.
Origin of Data Element
This value is the total count of selected participants, grouped by the WICStatus column of the CaseloadCount 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 participants, grouped by the WICStatus and Priority columns 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 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 redeemed participation (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 participants that received benefits and redeemed at least one food instrument 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. If all is selected, data for all agencies and state will be selected in the following sequence.
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 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. The state summary will print at the end.
This report will be sorted by category and priority within agency/state. Data will be reported in the following sequence.
Total participation
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
State totals will be printed when the state or all option is selected.
|
Software Version: 2.40.00
