Contents Show
The Caseload Management Projection System Report CLD018 (Output) consists of individual agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Caseload Management Projection System Report screen and is also generated as part of the month-end process using the selection criteria of "All".
The report summarizes enrollment, participation, and redemption totals at the end of the issuance month. Once the month has been reported in this section, the values will not be adjusted to reflect additional data received in the 30-day and closeout months. The following Management Information Summary reports provide input into this report and must be run during the month-end process before this report is requested.
Enrollment Monthly
Reported Participation Monthly
Monthly Redemption Unduplicated
Redeemed Food Instrument/Expenditures
Food Instrument Package Cost
Redeemed Food Instrument/Expenditures
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 the abbreviation for the reported month. The reported month value comes from the Report_Month column of the Caseload_Management_Projection table.
Format
This value is a three-character value.
Origin of Data Element
This value comes from the Report_Year column of the Caseload_Management_Projection table.
Format
This value is a three-character value.
Origin of Data Element
This value comes from the Enrollment_Count_Iss column of the Caseload_Management_Projection table where the Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a ten-digit number.
Origin of Data Element
This value comes from the Rptd_Partic_Iss column of the Caseload_Management_Projection table where the Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a ten-digit number.
Origin of Data Element
This value comes from the Rdmd_Part_30D column of the Caseload_Management_Projection table where the Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a ten-digit number.
Origin of Data Element
This value comes from the Rdmd_Partic_CO column of the Caseload_Management_Projection table where the Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a ten-digit number.
Origin of Data Element
This value comes from the Rdmd_Check_30D column of the Caseload_Management_Projection table where the Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a twelve-digit number.
Origin of Data Element
This value comes from the Rdmd_Check_CO column of the Caseload_Management_Projection table where the Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a twelve-digit number.
Origin of Data Element
This value comes from the Avg_Rdmd_Check_Cost_CO column of the Caseload_Management_Projection table where Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value comes from the Avg_Rdmd_Check_Cost_30D column of the Caseload_Management_Projection table where Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value comes from the Avg_Recon_Check_Cost_Iss column of the Caseload_Management_Projection table where Report_Year and Report_Month concatenated value is equal to the reported month for the selected agency/state.
Format
This value is a three-digit number plus two decimal places.
Origin of Data Element
This value comes from the Food_Exp_CO column of the Caseload_Management_Projection table where Report_Year and Report_Month concatenated value is equal to the reported month for the selected service agency/state.
Format
This value is a twelve-digit number.
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