Contents Show
The Participation vs. Enrollment Monthly Report CLD029 (Output) displays the total number of participants participating, total number of participants enrolled, and the percentage of enrolled who are participating for all WIC categories and then again for each individual WIC category (i.e. infant, child, pregnant, breastfeeding, non-breastfeeding).
The report includes data for the month requested, the month prior, and two months prior. The status of the months at the time the report is requested is also printed as part of the heading. The status of the months is determined by the CurrentMonthEndDt, PriorMonthEndDt, and CloseMonthEndDt columns of the ProcessControl table. The status will be one of the following: Issd, 30Dy, or C/O.
The report is generated when the OK button is clicked on the Generate Participation vs. Enrollment Monthly Report screen.
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.
"CLN029"
Format
The value is included as its literal value.
Origin of Data Element
The value is the current value of the REPORTHEADING business rule.
Format
The value is included as its literal value.
Origin of Data Element
The value is the date on which the report is generated.
Format
The value is included in the following format: MM/DD/CCYY. The value will be the current system date when the report is generated.
Origin of Data Element
The value is the name of the user signed in to the system when the report is generated.
Format
The value is included as its literal value. Because of space constraints, all characters of the user's first and last name may not print within the space allotted.
"Participation vs. Enrollment Monthly"
Format
The value is included as its literal value and center aligned. It is positioned at the top of the report in the center below the Report Title.
Origin of Data Element
The value is the time at which the report is generated.
Format
The value is included in the following format: HH:MM:SS (AM/PM).
Origin of Data Element
This value is the month and year specified by the user when generating the system output.
Format
The value is center aligned and is an accounting month and year in the following format:
"Month of {month name} CCYY"
Origin of Data Element
The value is the current page of the report.
Format
The value is included as its literal value.
Origin of Data Element
This value is the total count of participants that received benefits for the closeout month. Participants must meet the following selection criteria:
RptedThisMonth column of the CaseloadCount table equals "Y".
ParticipationCYM column of the CaseloadCount table equals the closeout month.
ProgramCode column of the CaseloadCount table equals the WIC value.
For the category totals, the count is grouped by the WICStatus and/or the AmountBreastfed columns of the CaseloadCount table
Format
This is a six digit number.
Origin of Data Element
This value is the total count of participants that received benefits for the closeout month. Participants must meet the following selection criteria:
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y".
ParticipationCYM column of the CaseloadCountEnrollment table equals the closeout month.
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value.
For the category totals, the count is grouped by the WICStatus and/or the AmountBreastfed columns of the CaseloadCountEnrollment table
Format
This is a six digit number.
Origin of Data Element
This value is the percent of participants enrolled in the WIC program that are also participating in the program. The values displayed are calculated using the following formula:
(Closeout Participation / Closeout Enrollment) * 100
The result is rounded to the nearest tenth. Values are calculated for each line.
Format
This is a three digit number plus one decimal place.
Origin of Data Element
This value is the total count of participants that received benefits for the 30-day month. Participants must meet the following selection criteria:
RptedThisMonth column of the CaseloadCount table equals "Y".
ParticipationCYM column of the CaseloadCount table equals the 30-day month.
ProgramCode column of the CaseloadCount table equals the WIC value.
For the category totals, the count is grouped by the WICStatus and/or the AmountBreastfed columns of the CaseloadCount table
Format
This is a six digit number.
Origin of Data Element
This value is the total count of participants that received benefits for the 30-day month. Participants must meet the following selection criteria:
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y".
ParticipationCYM column of the CaseloadCountEnrollment table equals the 30-day month.
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value.
For the category totals, the count is grouped by the WICStatus and/or the AmountBreastfed columns of the CaseloadCountEnrollment table
Format
This is a six digit number.
Origin of Data Element
This value is the percent of participants enrolled in the WIC program that are also participating in the program. The values displayed are calculated using the following formula:
(30-Day Participation / 30-Day Enrollment) * 100
The result is rounded to the nearest tenth. Values are calculated for each line.
Format
This is a three digit number plus one decimal place.
Origin of Data Element
This value is the total count of participants that received benefits for the issue month. Participants must meet the following selection criteria"
RptedThisMonth column of the CaseloadCount table equals "Y"
ParticipationCYM column of the CaseloadCount table equals the issue month
ProgramCode column of the CaseloadCount table equals the WIC value
For the category totals, the count is grouped by the WICStatus and/or the AmountBreastfed columns of the CaseloadCount table
Format
This is a six digit number.
Origin of Data Element
This value is the total count of participants that received benefits for the issue month. Participants must meet the following selection criteria:
EnrolledThisMonth column of the CaseloadCountEnrollment table equals "Y".
ParticipationCYM column of the CaseloadCountEnrollment table equals the issue month.
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value.
For the category totals, the count is grouped by the WICStatus and/or the AmountBreastfed columns of the CaseloadCountEnrollment table
Format
This is a six digit number.
Origin of Data Element
This value is the percent of participants enrolled in the WIC program that are also participating in the program. The values displayed are calculated using the following formula:
(Issue Participation / Issue Enrollment) * 100
The result is rounded to the nearest tenth. Values are calculated for each line.
Format
This is a three digit number plus one decimal place.
All WIC Participants that are eligible to receive benefits and all WIC participants that received benefits is the issuance, 30-day or closeout months are included in this report. The Data Elements section provides specific detail. Data for hidden agencies will not be included. If all is selected and the agency and/or clinic do not have any data to report, the agency and/or clinic will not be included.
If an individual clinic is selected, only data for that clinic will 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. If all is selected, data for all sites, agencies and state will be selected in the following sequence. Data for hidden agencies will not be included.
Agency 01, clinic 01
Agency 01, clinic 02
Agency 01 summary
Agency 02, clinic 21
Agency 02, clinic 22
Agency 02 summary
State summary
If report by clinic and one clinic is selected, this part of the sort order does not apply.
If report by clinic and multiple clinics are selected, the report will be sorted by clinic ID.
If report by agency is selected, this part of the sort order does not apply.
If report by grantee is selected, this part of the sort order does not apply.
If state is selected, this part of the sort order does not apply.
The report will be sorted by category and amount breastfed within clinic/agency/grantee/state. Data will be reported in the following sequence:
Total
Total Women (category P, B, and N)
Pregnant (category P)
Breastfeeding (category B)
Women FBF (category B with amount breastfed 1)
Women PBF (category B with amount breastfed 2 or 5)
Women PBF - PBF <= Max (category B with amount breastfed 2)
Women PBF - PBF > Max (category B with amount breastfed 5)
Women FFF (category B with amount breastfed 4)
Non-breastfeeding (category N)
Child (category C)
Infant (category I)
Infant FBF (category I with amount breastfed 1)
Infant PBF (category I with amount breastfed 2 or 5)
Infant PBF - PBF <= Max (category I with amount breastfed 2)
Infant PBF - PBF > Max (category I with amount breastfed 5)
Infant FFF (category I with amount breastfed 4)
A page break will occur on change in clinic, agency or grantee.
Grand totals are not applicable to this report. However if report by state or all is selected, summary totals for the state are printed.
|
Software Version: 2.40.00