Food Instrument Reconciliation Summary Report FIN014 (Output)

The Food Instrument Reconciliation Summary Report FIN014 (Output) is a state summary report of food instruments redeemed in the reported month, food instrument exceptions and compliance-buy food instruments. The report is generated when the OK button is clicked on the Generate Food Instrument Reconciliation Summary Report screen.

Food instrument exceptions are food instruments that have been redeemed by the banking agent, but the redemption data could not be applied to the database.

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.

Number of Food Instruments Redeemed

Origin of Data Element

This value is the count of selected food instrument records where the ComplianceBuy column of the FoodInstrumentSet table equals "N". Totals are grouped by category - women, infants, children, and unknown.

Format

This value is a six-digit number.

Value of Food Instruments Redeemed

Origin of Data Element

This value is the sum of the PaidAmt column of selected food instrument records where the ComplianceBuy column of the FoodInstrumentSet table equals"N". Totals are grouped by category - women, infants, children and unknown.

Format

This value is an eight-digit number plus two decimal places.

Average Value per Food Instrument

Origin of Data Element

This value is calculated by dividing the Value of Food Instruments Redeemed by the Number of Food Instruments Redeemed. The result is rounded to the nearest hundredth.

Format

This value is a three-digit number plus two decimal places.

Number of Compliance Buy Food Instruments

Origin of Data Element

This value is the count of selected food instrument records where the ComplianceBuy column of the FoodInstrumentSet table equals "Y".

Format

This value is a six-digit number.

Value of Compliance Buy Food Instruments

Origin of Data Element

This value is the sum of the PaidAmt column of selected food instrument records where the ComplianceBuy column of the FoodInstrumentSet table equals "Y".

Format

This value is an eight-digit number plus two decimal places.

Total Number of Exception Food Instruments

Origin of Data Element

This value is the count of selected BankException records.

Format

This value is a six-digit number.

Total Value of Exception Food Instruments

Origin of Data Element

This value is the sum of the PaidAmt column of selected BankExceptions records.

Format

This value is an eight-digit number plus two decimal places.

Grand Total Number of Food Instruments

Origin of Data Element

This value is the total of the Number of Food Instruments Redeemed plus the Number of Compliance Buy Food Instruments plus the Number of Exception Food Instruments.

Format

This value is a six-digit number.

Total Value of Food Instruments

Origin of Data Element

This value is the total of the Value of Food Instruments Redeemed plus the Value of Compliance Buy Food Instruments plus the Value of Exception Food Instruments.

Format

This value is an eight-digit number plus two decimal places.

Filter Criteria

Base of Data

Food instruments that meet the following selection criteria are included in the report. Data for hidden agencies will not be included.

• The PaidDate column of the FoodInstrument table is during the selected month.

• The ProgramCode column of the FoodInstrument table is equal to the WIC value.

Bank exceptions that meet the following selection criteria are included in the report.

• The PaidDate column of the BankExceptions table is during the selected month.

• The ProgramCode column of the BankExceptions table is equal to the WIC value.