Food Instrument Reconciliation Exceptions Report FIN015 (Output)

The Food Instrument Reconciliation Exceptions Report FIN015 (Output) is a state summary report of food instrument exceptions. The report is generated when the OK button is clicked on the Generate Food Instrument Reconciliation Exceptions 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.

Serial #

Origin of Data Element

This value comes from the SerialNo column of the selected BankExceptions records.

Format

This value is an eight-character value.

Paid Date

Origin of Data Element

This value comes from the PaidDate column of the selected BankExceptions records.

Format

This is a date in the format of MM/DD/CCYY.

Redeemed Value

Origin of Data Element

This value comes from the PaidAmt column of the selected BankExceptions records.

Format

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

Exception Reason

Origin of Data Element

This value is the associated text for the ErrorMessageID column of the selected BankExceptions records. The text is found in the Description column of the Reference Dictionary table where the category column equals "BNKEXCPTREASON" and the ExternalID attribute equals the value in the ErrorMessageID column. If a description is not found, "Unknown" will print.

Format

This value is a fifty-character value.

Total Number of Exceptions

Origin of Data Element

This value is the count of selected BankExceptions records.

Format

This value is a six-digit number.

Total Value of Exceptions

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.

Filter Criteria

Base of Data

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.

Sort Order

Serial #

The report will be sorted by serial #.