Contract/Non-contract Formula Report NUT003 (Output)

The Contract/Non-contract Formula Report NUT003 (Output) lists the number of infant and children participants redeeming food instruments containing formula issued for the reported closeout month. It compares the number of participants with contract and non-contract formula providing breakdowns by formulation (powder/concentrate within milk/soy). The contract/non-contract ready-to-use formulation is combined and shown separately with breakdowns by milk/soy.

The counts are accumulated by clinic. Participants are grouped based on their category at the time the last food instrument was printed for the reported month. If a participant redeems more than one type of formula in the reported month they will be counted in only one category based on the formula issued on the latest printed food instrument for the reported month. The participant is counted only once.

Of the redeemed food instruments with formula for the reported month, if the last food instrument printed for the reported month is a contract formula, the participant is counted in the contract totals. If it is for non-contract formula, the participant is counted in the non-contract total. If it is for special formula, the participant is not counted.

The counts are accumulated in the End of Month process from the FoodInstrument, FoodInstrumentSet, and FoodInstrumentItem tables and updated into the ParticipantFormula table used for this report. The ParticipantFormula table is generated during the month-end processing.

The report is generated when the OK button is clicked on the Generate Contract/Non-contract Formula Report screen.

Closeout Month of

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.

Infants or Children

Origin of Data Element

When this report is requested, a report is produced for infant totals and a report is produced for children totals.

Format

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

Agency/Clinic

Origin of Data Element

These values come from the AgencyID and ServiceSiteID columns of the ParticipantFormula table for the selected participants.

Format

Both are three-character values.

Contract Milk Concentrate

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract, milk based, concentrate formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" (Contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" (Milk)

• The FormulationFormat column of the ParticipantFormula table is equal to "C" (Concentrate)

Format

This value is a six-digit number.

Contract Milk Powder

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract, milk based, powder formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" (Contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" (Milk)

• The FormulationFormat column of the ParticipantFormula table is equal to "P" (Powder)

Format

This value is a six-digit number.

Contract Soy Concentrate

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract, soy based, concentrate formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" (Contract)

• The FormulationBase column of the ParticipantFormula table is equal to "S" (Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "C" (Concentrate)

Format

This value is a six-digit number.

Contract Soy Powder

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract, soy based, powder formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" (Contract)

• The FormulationBase column of the ParticipantFormula table is equal to "S" (Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "P" (Powder)

Format

This value is a six-digit number.

Contract Percent

Origin of Data Element

This value is calculated by dividing the total of the contract numbers (milk concentrate plus milk powder plus soy concentrate plus soy powder) by the total number of contract, non-contract, and ready-to-use. The result is multiplied by 100 and rounded to the nearest tenth.

Format

This value is a three-digit number plus one decimal place.

Non-contract Milk Concentrate

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had non-contract, milk based, concentrate formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "N" (Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" (Milk)

• The FormulationFormat column of the ParticipantFormula table is equal to "C" (Concentrate)

Format

This value is a six-digit number.

Non-contract Milk Powder

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had non-contract, milk based, powder formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "N" (Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" (Milk)

• The FormulationFormat column of the ParticipantFormula table is equal to "P" (Powder)

Format

This value is a six-digit number.

Non-contract Soy Concentrate

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had non-contract, soy based, concentrate formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "N" (Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "S" (Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "C" (Concentrate)

Format

This value is a six-digit number.

Non-contract Soy Powder

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had non-contract, soy based, powder formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "N" (Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "S" (Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "P" (Powder)

Format

This value is a six-digit number.

Non-contract Percent

Origin of Data Element

This value is calculated by dividing the total of the non-contract numbers (milk concentrate plus milk powder plus soy concentrate plus soy powder) by the total number of contract, non-contract, and ready-to-use. The result is multiplied by 100 and rounded to the nearest tenth.

Format

This value is a three-digit number plus one decimal place.

Con/NonCon Milk R-T-U

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract or non-contract, milk based, ready to use formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" or "N" (Contract or Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" (Milk)

• The FormulationFormat column of the ParticipantFormula table is equal to "R" (RTU)

Format

This value is a six-digit number.

Con/NonCon Soy R-T-U

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract or non-contract, milk based, ready to use formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" or "N" (Contract or Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "S" (Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "R" (RTU)

Format

This value is a six-digit number.

Con/Noncon R-T-U Percent

Origin of Data Element

This value is calculated by dividing the total of the ready-to-use numbers (milk plus soy) by the total number of contract, non-contract, and ready-to-use. The result is multiplied by 100 and rounded to the nearest tenth.

Format

This value is a three-digit number plus one decimal place.

Con/Noncon Total

Origin of Data Element

This value is calculated by totaling the numbers for contract milk concentrate, contract milk powder, contract soy concentrate, contract soy powder, non-contract milk concentrate, non-contract milk powder, non-contract soy concentrate, non-contract soy powder, contract or non-contract milk ready-to-use, and contract or non-contract soy ready-to-use.

Format

This value is a six-digit number.

Total Percentages - Contract Conc/Powder Total (number)

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract or non-contract, milk based, ready to use formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" (Contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" or "S" (Milk or Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "C" or "P" (Concentrate or Powder)

Format

This value is a six-digit number.

Total Percentages - Contract Conc/Powder Total (percent)

Origin of Data Element

This value is calculated by dividing the Contract Conc/Powder Total (number) by the Con/NonCon Grand Total (number) for this line. The result is multiplied by 100 and rounded to the nearest tenth.

Format

This value is a three-digit number plus one decimal place.

Total Percentages - Non-contract Conc/Powder Total (number)

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract or non-contract, milk based, ready to use formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "N" (Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to "M" or "S" (Milk or Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "C" or "P" (Concentrate or Powder)

Format

This value is a six-digit number.

Total Percentages - Non-contract Conc/Powder Total (percent)

Origin of Data Element

This value is calculated by dividing the Non-contract Conc/Powder Total (number) by the Con/NonCon Grand Total (number) for this line. The result is multiplied by 100 and rounded to the nearest tenth.

Format

This is a three-digit number plus one decimal place.

Total Percentages - Con/Noncon Ready-to-Use Total (number)

Origin of Data Element

This value is the total count of selected participants, grouped by agency/clinic that meet the following selection criteria. The redeemed food instruments must have had contract or non-contract, milk based, ready to use formula issued on it.

• The FormulaType column of the ParticipantFormula table is equal to "C" or "N" (Contract and Non-contract)

• The FormulationBase column of the ParticipantFormula table is equal to ‘M’ or "S" (Milk or Soy)

• The FormulationFormat column of the ParticipantFormula table is equal to "R" (RTU)

Format

This value is a six-digit number.

Total Percentages - Con/Noncon Ready-to-Use Total (percent)

Origin of Data Element

This value is calculated by dividing the Con/Noncon Ready-To-Use Total (number) by the Con/NonCon Grand Total (number) for this line. The result is multiplied by 100 and rounded to the nearest tenth.

Format

This value is a three-digit number plus one decimal place.

Total Percentages - Con/Noncon Grand Total (number)

Origin of Data Element

This value is calculated by totaling the number for contract concentrate/powder, non-contract concentrate/powder and contract/non-contract ready-to-use.

Format

This value is a six-digit number.

Filter Criteria

Base of Data

Infant and children participants that redeemed food instruments with formula items where the issuance month equals the closeout month are included in the report. Participants are counted in the report if they meet the following selection criteria.

• The ParticipationCYM column of the ParticipantFormula table equals the selected month.

• The ProgramCode column of the ParticipantFormula table equals the WIC value.

• The PaidDate column of the ParticipantFormula table is valued.

• The WICStatus column of the ParticipantFormua table equals Infant or Child.

Participants are counted once per report.

• If they are issued food instrument from multiple agencies/clinics, the participant is counted in the agency/clinic of the food instrument with the greatest value in the IssuedDate column of the ParticipantFormula table for the selected records.

• If they are issued food instrument with multiple WIC status values, the participant is counted in the WIC status of the food instrument with the greatest value in the IssuedDate column of the ParticipantFormula table for the selected records.

Records for the ParticipantFormula table are generated during the month-end process.

Sort Order

Category

This report will be sorted by WICStatus code. Children will print first, then infants.

Agency

This report will be sorted by agency code within WICStatus.

Clinic

This report will be sorted by clinic code within agency code.

Control Breaks

A page break will occur on change in category. A page break will also occur between the Contract/Non-contract/Ready-To-Use section and Total Percentages section.

Grand Total

A total line for all infants and a total line for all children reported will be printed. The totals for infants and children will be totaled as grand totals.