One to One Reconciliation Report FIN022 (Output)

The One to One Reconciliation Report FIN022 (Output) is a report of the individual status of redeemed food instruments and a summary of the number of redeemed food instruments and number per status for non-direct distribution sites. The report is generated when the OK button is clicked on the Generate One to One Reconciliation Report screen.

ReportHeading

Origin of Data Element

The value is pulled from the REPORTHEADING business rule for the client.

Format

The value will print as its literal value.

Check Serial Number

Origin of Data Element

The value comes from the SerialNo column of the Food Instrument table.

Format

The value will print as its literal value.

Paid Amount

Origin of Data Element

The value comes from PaidAmt column of the Food Instrument table.

Format

The value will print as its literal value.

Paid Date

Origin of Data Element

The value comes from PaidDate column of the Food Instrument table.

Format

The value will print as its literal value.

Status

Origin of Data Element

Depending on the status, the value comes from the VoidedDate column of the FoodInstrument table, the ReportedLostDate column of the FoodInstrument table, the ReportedStolenDate column of the FoodInstrument table, the Rejected column of the FoodInstrument table, or the StateWICID column of the FoodInstrumentSet table.

When a food instrument is paid (paid date is not null):

• If the food instrument is voided, then the status is "Voided but still Paid".

• If the food instrument is reported lost, then the status is "Lost but still Paid".

• If the food instrument is reported stolen, then the status is "Stolen but still Paid".

• If the food instrument is rejected, then the status is "Rejected then Paid".

• If the food instrument state WIC ID is blank, then the status is "Unmatched to Issuance".

• All other cases the status is "Validly redeemed".

When a food instrument is not paid (paid date is null):

• If the food instrument is voided, then the status is "Voided".

• If the food instrument is reported lost, then the status is "Lost".

• If the food instrument is reported stolen, then the status is "Stolen".

• If the food instrument LastUseDate + FI_EXPIRATION_DAYS + 1 > today, then the status is "Expired".

• All other cases the status is "Still Valid".

Format

The value will print as its literal value.

Filter Criteria

Participation Month

This report includes all food instruments with a participation month equal to the participation month specified on the Generate One to One Reconciliation Report screen.

Sort Order

Check Number

The report will be sorted by check number.

Control Breaks

Participation Month

A page break will occur at the change in participation month.

Grand Total

At the end of the report, the Number of Checks Issued is displayed. Following the Number of Checks Issued, the number of food instruments unredeemed during the specified participation month is summarized as follows:

• Count of Still Valid

• Count of Lost/Stolen

• Count of Voided

• Count of Expired

• Count of Duplicated

• Total Count Unredeemed

Following the food instruments unredeemed summary, food instruments redeemed during the specified participation month is summarized as follows:

• Count of Validly Redeemed

• Count of Lost/Stolen but still Redeemed

• Count of Unmatched

• Total Count of Redeemed

Following the food instruments redeemed summary, the value of food instruments redeemed for the specified participation month is summarized as follows:

• Total Value of Validly Redeemed

• Total Value of Lost/Stolen but still Redeemed

• Total Value of Voided but still Redeemed

• Total Value of Unmatched

• Total Value