Redemption Change Report VND045 (Output)

The Redemption Change Report VND045 (Output) lists all food instruments that are redeemed for an amount that is outside the state defined percentage of the maximum value of the food instrument type for the peer group. The purpose of the report is to provide the State with information used to identify potential overcharging errors or redemption of non-eligible food items. The report is generated when the OK button is clicked on the Generate Redemption Change Report screen. The report is also generated as part of the month-end process and is available at the state level only.

Report Title

Origin of Data Element

The report title text is "Redemption Change {XX%}". The report has a sub-title to reflect the month being reported.

Format

The report title prints as a literal value. The sub-title prints in the format "Month of {Textual Month} {CCYY}".

Month of

Origin of Data Element

The user records this value when the report is submitted. During the month-end process this is the CCYYMM value from the Current-Month-End-Dt column of the Process-Control table.

Format

This is an accounting month and year formatted as Month Name CCYY.

Percent Change (XX)

Origin of Data Element

The percentage threshold as defined by the state that must be exceeded by the vendor for inclusion on this report. The state defined percent comes from the State-Business-Rules table for the category column = VNDR_REDEMPCHANGE_LIMIT.

Format

This is a two-character value.

Agency

Origin of Data Element

The AgencyID column for this vendor from the VendorLAAssociation table if the PrimaryAgency column is not blank.

Format

The code is a three-character value.

Agency Name

Origin of Data Element

The name value comes from the Name column of the Agency table.

Format

This is a fifty-character value.

Vendor ID

Origin of Data Element

The code value comes from the Vendor-ID column of the Food-Instrument table.

Format

This is a six-character value.

Vendor Name

Origin of Data Element

The name comes from the Trade-Name column of the Vendor table for the associated value.

Format

This is a fifty-character value.

Peer Group

Origin of Data Element

The name comes from the Peer-Group column of the Vendor table for the associated value.

Format

This is a two-character value.

Number of FI MM/YY (where MM/YY is the report month and year)

Origin of Data Element

This value is a count of the number of food instruments redeemed by the vendor within the agency during the reporting month.

Format

This is a six-character value.

Number of FI MM/YY (where MM/YY is the month/year three months prior to the reporting month)

Origin of Data Element

This value is a count of the number of food instruments redeemed by the vendor within the agency during that month.

Format

This is a six-character value.

Diff

Origin of Data Element

This percent value is calculated by subtracting the three months prior count from the current month count, dividing by the three months prior count, and multiplying by 100. The result is rounded.

Format

This is a four-digit number plus two decimal places.

Value of FI MM/YY (where MM/YY is the reporting month/year)

Origin of Data Element

This value comes from summing the redeemed dollar value of the food instruments redeemed by the vendor during that month.

Format

This is a seven-digit number plus two decimal places.

Value of FI MM/YY (where MM/YY is three months prior to the reporting month/year)

Origin of Data Element

This value comes from summing the redeemed dollar value of the food instruments redeemed by the vendor during that month.

Format

This is a seven-digit number plus two decimal places.

Diff

Origin of Data Element

This percentage value is calculated by subtracting the three months prior value from the current value, dividing by the three months prior value, and multiplying by 100. The result is rounded.

Format

This is a four-digit number plus two decimal places.

Agency # Vendors

Origin of Data Element

This value comes from counting the number of vendors appearing on the report for this agency.

Format

This is an eight-digit number with no decimal places.

State # Vendors

Origin of Data Element

This value is a count of the number of vendors appearing on the report for the entire state.

Format

This is an eight-character number with no decimal places.

Filter Criteria

Base of Data

Vendors with food instruments that meet the following selection criteria are included in the report.

• The food instrument was redeemed during the reported month - PaidDate from the FoodInstrument table within the reported month.

• If the result of both percentage calculations is greater than or equal to the state defined percentage, the food instrument is included in the report. Any terminated vendors or vendors initially authorized within six months of the run date is excluded from the report.

Vendor ID

The report is sorted by vendor ID within agency.

Peer Group

The report is sorted by peer group within vendor ID.

Control Breaks

Agency ID

On a change of agency ID, the agency total number of vendors prints.

Vendor

On a change of vendor, the vendor total number of food instruments prints.

Grand Total

The total number of vendors included on the report prints as grand totals.