Enrollment Unduplicated - Yearly Report CLD006 (Output)

Contents Show

The Enrollment Unduplicated - Yearly Report CLD006 (Output) consists of individual agency summaries and the state summary. The report is generated when the OK button is clicked on the Generate Enrollment 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 people who are eligible to receive WIC benefits throughout the reported year. If an individual is in a valid certification period, he or she is eligible to receive WIC benefits. If a participant is eligible to receive WIC benefits during the month of October, he or she is included in the count for October. All participants that become eligible and have not been included in a previous month's count are included in the count for the subsequent month that he or she becomes eligible. Unduplicated means the participant is counted only once during the specified year type.

Data Elements

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.

Month of

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.

Agency / State Total

Origin of Data Element

The selection criteria and information being reported determine this value.

Format

This is a fifty-character text column. The format is determined by the information being reported.

Total Unduplicated Enrollment (Monthly Count)

Origin of Data Element

This value is the total count of selected enrollees, grouped by reported month.

Format

This value is a six-digit number.

Category Total (Monthly Count)

Origin of Data Element

This value is the total count of selected enrollees, grouped by the WICStatus column of the Caseload_Count_Undup_Federal table for each reported month.

Format

This value is a six-digit number.

Cum Total

Origin of Data Element

This value is the sum of the reported month columns.

Format

This value is a six-digit number.

Filter Criteria

Base of Data

All WIC enrollees eligible to receive benefits during the reported year are included in the report totals. Enrollees must meet the following selection criteria. Each enrollee is counted once for the reported year.

Agency, State, All

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.

Sort Order

Agency / State Total

This report will be sorted by agency code and state totals, depending on selection criteria of the report.

Category

This report will be sorted by category within agency/state. Data will be reported in the following sequence.

Control Breaks

Agency

A page break will occur on change in Agency.

Grand Total

State totals will be printed when the state or all option is selected.

Frequency and Distribution

This system output is generated on demand. If selected by the state, this system output is also generated during the month-end process.

|

State Office