Contents Show
The Migrant Participation Report OPR014 (Output) is a count of migrants participating in the WIC program during the reported month. A person is considered migrant if he or she is a member of a household where the migrant flag is the value "Y" at the time the month-end process for the reported month is run. A person is considered participating in the program if they were issued at least one food instrument during the report period. The report is generated when the OK button is clicked on the Generate Migrant Participation 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.
Origin of Data Element
The user records this value when the report is submitted.
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 comes from the Priority column of the CaseloadCount table.
Format
This is a three-character value.
Origin of Data Element
This value is the description associated with the RaceEthnicity column of the CaseloadCountEnrollment table. The description comes from joining the RaceDescription and EthnicityDescription columns of the RaceEthnicity table.
Format
This is a twenty-five-character value.
Origin of Data Element
This value is the count of selected participants where WICStatus column of the CaseloadCount table equals "P", "B", or "N". If a participant has an unknown priority or a priority that is not valid for their status, the participant is included in the 'Unknown' priority count. Valid priorities for each status are defined in the PriorityPerWICStatus table.
Format
The count is a six-digit number.
Origin of Data Element
This value is the count of selected participants where WICStatus column of the CaseloadCount table equals "P". If a participant has an unknown priority or a priority that is not valid for their status, the participant is included in the 'Unknown' priority count. Valid priorities for each status are defined in the PriorityPerWICStatus table.
Format
The count is a six-digit number.
Origin of Data Element
This value is the count of selected participants where WICStatus column of the CaseloadCount table equals "B". If a participant has an unknown priority or a priority that is not valid for their status, the participant is included in the 'Unknown' priority count. Valid priorities for each status are defined in the PriorityPerWICStatus table.
Format
The count is a six-digit number.
Origin of Data Element
This value is the count of selected participants where WICStatus column of the CaseloadCount table equals "N". If a participant has an unknown priority or a priority that is not valid for their status, the participant is included in the 'Unknown' priority count. Valid priorities for each status are defined in the PriorityPerWICStatus table.
Format
The count is a six-digit number.
Origin of Data Element
This value is the count of selected participants where WICStatus column of the CaseloadCount table equals "I". If a participant has an unknown priority or a priority that is not valid for their status, the participant is included in the 'Unknown' priority count. Valid priorities for each status are defined in the PriorityPerWICStatus table.
Format
The count is a six-digit number.
Origin of Data Element
This value is the count of selected participants where WICStatus column of the CaseloadCount table equals "C". If a participant has an unknown priority or a priority that is not valid for their status, the participant is included in the 'Unknown' priority count. Valid priorities for each status are defined in the PriorityPerWICStatus table.
Format
The count is a six-digit number.
Origin of Data Element
This value is calculated by totaling the women, infants and children counts.
Format
This is a six-digit number.
Participants that meet the following selection criteria are included in the report. Data for hidden agencies will not be included.
The ParticipationCYM column of the CaseloadCountEnrollment table equals the reported month.
The ReportedThisMonth column of the CaseloadCount table equals "Y".
The Migrant column of the CaseloadCountEnrollment table equals "Y".
ProgramCode column of the CaseloadCountEnrollment table equals the WIC value.
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.
This report will be sorted by the priority within Agency/state.
This report will be sorted by the race/ethnicity description within priority.
Totals for the Agency will be printed.
State totals will be printed when the state or all option is selected.
|
Software Version: 2.40.00
