Contents Show
The Redeemed Participation Unduplicated - Yearly Report CLD010 (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 Unduplicated - Yearly 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 who received WIC benefits and redeemed at least one food instrument throughout the reported year. If a participant was issued a food instrument during the month of October and redeemed that food instrument, he or she is included in the count for October. All participants that had not been included in a previous month's count are included in the count for subsequent months for the month that he or she was first issued a food instrument and redeemed the food instrument. Unduplicated means the participant is counted only once during the specified year type.
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.
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 Current_Month_End_Dt column of the Process_Control 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 county data, the county code and 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 column. 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 Caseload_Count_Undup_Federal table for each reported month.
Format
This value is a six-digit number.
Origin of Data Element
This value is the sum of the reported month columns.
Format
This value is a six-digit number.
All WIC participants that received benefits during the reported year and redeemed at least one food instrument are included in the report totals. Participants must meet the following selection criteria. Each participant is counted once for the reported year.
Redeemed_Part_CYM column of the Caseload_Count_Undup_Federal table equals the reported month
If an individual agency is selected, summary data for each county within the agency and summary data for that agency will be included. If all agencies are selected, summary data for all agencies and summary data for each county within the 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.
County 01 summary
County 02 summary
Agency 01 summary
County 03 summary
County 04 summary
Agency 02 summary
State summary
This report will be sorted by agency code and county code and state totals, depending on selection criteria of the report.
County will be sorted within agency code.
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.
This report will be sorted by category within agency/state. Data will be reported in the following sequence.
Total redeemed participation
Woman total (category P, B and N)
Pregnant women total (category P)
Breastfeeding women total (category B)
Non-breastfeeding women total (category N)
Infant total (category I)
Child total (category C)
State totals will be printed when the state or all option is selected.
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