Contents Show
The Redeemed Food Instruments/Expenditures Report CLD016 (Output) summarizes the redemption and disposition of food instruments for the reported month. The report consists of individual agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Redeemed Food Instruments/Expenditures Report screen and is also generated as part of the month-end process using the selection criteria of "All".
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 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 calculated by totaling the Sum_FI_Redeemed column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code column is equal to the WIC value. The value is rounded to the nearest dollar.
Format
This value is a twelve-digit number.
Origin of Data Element
This value is calculated by totaling the Sum_FI_Redeemed column of the Caseload_Count table where Participation_CYM column is <= to the reported month and >= first month of the fiscal year and the Program_Code column is equal to the WIC value. The value is rounded to the nearest thousand dollars.
Format
This value is a twelve-digit number.
Origin of Data Element
This value is calculated by totaling the Count_FI_Redeemed column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code column is equal to the WIC value.
Format
This value is a ten-digit number.
Origin of Data Element
This value is calculated by dividing the total count of redeemed food instruments by the count of issued food instruments. This column is calculated for closeout months only.
The total count of issued food instruments is the total of the Count_FI_Issued column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code 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 totaling the Count_FI_Issued column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code column is equal to the WIC value.
Format
This value is a ten-digit number.
Origin of Data Element
This value is calculated by totaling the Count_FI_Redeemed column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code column is equal to the WIC value.
Format
This value is a ten-digit number.
Origin of Data Element
This value is calculated by dividing the redeemed number by the food instrument disposition total for the reported month.
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 Count_FI_Voided column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code column is equal to the WIC value.
Format
This value is a ten-digit number.
Origin of Data Element
This value is calculated by dividing the voided number by the food instrument disposition total for the reported month.
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 Count_FI_UnRedeemed_Not_Voided column of the Caseload_Count table where Participation_CYM column is equal to the reported month and the Program_Code column is equal to the WIC value.
Format
This value is a ten-digit number.
Origin of Data Element
This value is calculated by dividing the unredeemed number by the food instrument disposition total for the reported month.
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.
Format
This value is either a ten-digit number or a three-digit number plus one decimal place.
Filter criteria are defined in the data elements section.
If an individual agency is selected, summary data for that agency will be included. If all agencies are selected, summary data for all agencies 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 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.
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