Contents Show
The Food Instrument Package Cost Report CLD017 (Output) consists of individual agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Food Instrument Package Cost Report screen and is also generated as part of the month-end process using the selection criteria of "All".
The report summarizes the costs associated with food packages using the reported participation method, redeemed participation method, and reconciliation method.
The reported participation method is based on the count of participants issued a food instrument. Participants are counted in each month that they are issued a food instrument. Issuance is based on the participation date value, not the date the food instrument is printed. Dollar amounts are a summary of the dollars redeemed for the issuance month.
The redeemed participation method is based on the 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. Dollar amounts are a summary of the dollars redeemed for the issuance month.
The reconciliation method is based on the date the food instrument was redeemed, not the issuance month. Participants are counted in each month that he or she redeemed a food instrument, based on. The PaidDate column of the FoodInstrument table is used during the month-end process to update the RedemptionReconciliation table.
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 calculated by dividing the total dollars redeemed for the issue month for each category by the reported participation for the issue month for that category. This value is calculated for the total of all participants, women-total, women-pregnant, women-breastfeeding, women-non breastfeeding, infants, and children.
The total dollars redeemed is the sum of the SumFIRedeemed column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value. The total reported participation is the count of participants from the CaseloadCount table where the ParticipationCYM column is equal to the reported month, the RptedThisMonth column is equal to "Y" and the ProgramCode column is equal to the WIC value.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the total dollars redeemed for non-rebate items for the issue month by the reported participation for the issue month.
The total non-rebate dollars redeemed is the sum of the SumFIRedeemed column from the CaseloadCount table month minus the SumFIRedeemedRebate column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value.
The total 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
The RptedThisMonth column is equal to "Y"
The CountFIIssued column minus the CountFIIssuedRebate column is greater than zero
The ProgramCode column is equal to the WIC value
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the number of redeemed food instruments for the issue month by the reported participation for the issue month.
The number of redeemed food instruments is the sum of the CountFIRedeemed column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value. The total reported participation is the count of participants from the CaseloadCount table where the ParticipationCYM column is equal to the reported month, the RptedThisMonth column is equal to "Y" and the ProgramCode column is equal to the WIC value.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the total dollars redeemed for the issue month for each category by the redeemed participation for the issue month for that category. This value is calculated for the total of all participants, women-total, women-pregnant, women-breastfeeding, women-non breastfeeding, infants, and children.
The total dollars redeemed is the sum of the SumFIRedeemed column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value. The total redeemed participation is the count of participants from the CaseloadCount table where the ParticipationCYM column is equal to the reported month, the RdmdThisMonth column is equal to "Y" and the ProgramCode column is equal to the WIC value.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the total dollars redeemed for the issue month for each category by the number of redeemed food instruments for the issue month for that category. This value is calculated for the total of all participants, women-total, women-pregnant, women-breastfeeding, women-non-breastfeeding, infants, and children.
The total dollars redeemed is the sum of the SumFIRedeemed column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value. The number of redeemed food instruments is the sum of the CountFIRedeemed column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the number of redeemed food instruments for the issue month for each category by the redeemed participation for the issue month for that category. This value is calculated for the total of all participants, women-total, women-pregnant, women-breastfeeding, women-non-breastfeeding, infants, and children.
The number of redeemed food instruments is the sum of the CountFIRedeemed column from the CaseloadCount table where the ParticipationCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value. The total redeemed participation is the count of participants from the CaseloadCount table where the ParticipationCYM column is equal to the reported month, the RdmdThisMonth column is equal to "Y" and the ProgramCode column is equal to the WIC value.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the total dollars redeemed for the month for each category by the redeemed participation for the month for that category. This value is calculated for the total of all participants, women-total, women-pregnant, women-breastfeeding, women-non breastfeeding, infants, and children.
The total dollars redeemed and redeemed participation are based on paid date rather than issuance month.
The total dollars redeemed is the sum of the SumFIRedeemed column of the RedemptionReconciliation table where the ProgramCode column of the RedemptionReconciliation table is equal to the WIC value and the RedemptionCYM column of the RedemptionReconciliation table is equal to the reported month.
The total redeemed participation is the sum of the CountParticipantsRedeemed column of the RedemptionReconciliation table where the RedemptionCYM column is equal to the reported month and the ProgramCode column is equal to the WIC value.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value is calculated by dividing the total dollars redeemed for the month for each category by the number of redeemed food instruments for the month for that category. This value is calculated for the total of all participants, women-total, women-pregnant, women-breastfeeding, women-non-breastfeeding, infants, and children.
The total dollars redeemed and number of redeemed food instruments is based on paid date rather than issuance month.
The total dollars redeemed is the sum of the SumFIRedeemed column of the RedemptionReconciliation table where the ProgramCode column of the RedemptionReconciliation table is equal to the WIC value and the RedemptionCYM column of the RedemptionReconciliation table is equal to the reported month.
The number of redeemed food instruments is the sum of the CountFIRedeemed column of the RedemptionReconciliation table where the ProgramCode column of the RedemptionReconciliation table is equal to the WIC value and the RedemptionCYM column of the RedemptionReconciliation table is equal to the reported month.
Format
This value is a three-digit number plus two decimal places.
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.
Format
This value is a three-digit number plus two decimal places.
Filter criteria are defined in the data elements section. Data for hidden agencies will not 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 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 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.
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
