Small Volume Vendors Report VND046 (Output)

The Small Volume Vendors Report VND046 (Output) lists all vendors that had redemptions from fewer than the state-defined minimum number of different participants during the report month. The purpose of the report is to identify low volume vendors that may not be needed on the program. If a vendor changes peer groups within a reported month, the vendor appears on the report under both groups. The total number of vendors includes the vendor twice. The report is generated when the OK button is clicked on the Generate Small Volume Vendors 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 "Small Volume Vendors". The report has two sub-headings. The first shows the threshold number of participants. The second shows the month being reported

Format

The report title prints as a literal value. The first sub-title prints in the format "Less than {XX} Participants per Month". The second sub-title prints in the format "Month of {Textual Month} {CCYY}".

Number of Participants

Origin of Data Element

The state defined minimum number of different participants per vendor from the State-Business-Rules table having the category column equal to VNDR_SMALLVOL_THRESHOLD.

Format

This is a two-digit number.

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.

Peer Group

Origin of Data Element

The code value comes from the PeerGroup column of the FoodInstrument table.

Format

The code is a two-character value.

Vendor Code

Origin of Data Element

The code value comes from the VendorID column of the FoodInstrument table.

Format

This is a six-character value.

Vendor Name and Address

Origin of Data Element

The name comes from the TradeName column of the Vendor table for the associated value. The address comes from the PhysicalAddress1, PhysicalAddress2, PhysicalCity, PhysicalZIP columns of the Vendor table for the associated value

Format

TradeName is a fifty-character value.

PhysicalAddress1 is a fifty-character value.

PhysicalAddress2 is a fifty-character value.

PhysicalCity is a thirty-character value.

PhysicalZIP is a nine-character value

# Participants

Origin of Data Element

This value comes from counting the number of participants selected for reporting for this vendor.

Format

This is a two-digit number.

# FI

Origin of Data Element

This value is the count of the number of food instruments redeemed within the reporting month - PaidDt from the FoodInstrument table within the reporting month for this vendor.

Format

This is a three-digit number.

Redeemed Amount

Origin of Data Element

This value comes from summing the PaidAmt column of the FoodInstrument table for the selected food instruments for this vendor.

This control appears on the report based on the business rule in the State-Business-Rule table having category-ID column equal to VNDR_SMALLVOL_TOTALREDEEM. If the Value column is "Y", the column appears on the report. If the Value column is "N", the report column is suppressed.

Format

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

Peer Group Total # Vendors

Origin of Data Element

This value comes from counting the number of vendors within this peer group that appear on the report.

Format

This is a four-digit number with no decimal places.

Grand Total # Vendors

Origin of Data Element

This value comes counting all the number of vendors in all peer groups appearing on the report.

Format

This is a five-digit 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.

• Only vendors who had less than the state-specified number of participants redeeming food instruments within the reporting month are selected for the report.

Control Breaks

Peer Group

On a change of peer group, the peer group total number of vendors prints.

Grand Total

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