Overcharges Report VND035 (Output)

The Overcharges Report VND035 (Output) includes a listing of all vendors and their food instruments redeemed for an amount higher than 10% over the vendor average price. The report is generated when the OK button is clicked on the Generate Overcharges Report screen.

Report Title

Origin of Data Element

The title is the text "Overcharges". The report has a sub-title that shows the redemption month selected by the user.

Format

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

Redemption Month Of

Origin of Data Element

The user records this value when the report is submitted.

Format

This is a calendar month and year formatted as Month Name CCYY.

Vendor ID

Origin of Data Element

This value comes from the Vendor_ID column of the Food_Instrument table.

Format

This is a three-character value.

Peer Group

Origin of Data Element

This value comes from the Peer_Group column of the Vendor table.

Format

This is a two-character value.

F.I. Number

Origin of Data Element

This value comes from the Serial_No column of the Food_Instrument table.

Format

This is an eight-character value.

First Use Date

Origin of Data Element

This value comes from the First_Use_Date column of the Food_Instrument_Set table.

Format

This is an eight-digit value formatted MM/DD/CCYY.

Paid Date

Origin of Data Element

This value comes from the Paid Date column of the Food_Instrument table.

Format

This is an eight-digit value formatted MM/DD/CCYY.

Paid Amount

Origin of Data Element

This value comes from the Paid_Amt column of the Food_Instrument table.

Format

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

Average Amount

Origin of Data Element

This value is the average price for the peer group's food instrument type. The value comes from the Avg_Price column of the Peer_Group_Food_Inst_Type_Price table.

Format

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

Excess Amount

Origin of Data Element

This value is the difference between the Paid Amount and the Average Amount.

Format

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

Max Amount

Origin of Data Element

This value is the maximum price for the peer group's food instrument type. The value comes from the Price column of the Peer_Group_Food_Inst_Type_Price table.

Format

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

Food Package Contents

Origin of Data Element

This value is the Distribution_Item_ID and Quantity columns of the Food_Instrument_Type_Items table.

Format

The distribution-item is ten-character value and the quantity is a three-digit number.

Filter Criteria

Base of Data

The report is based on the following selection criteria.

• The food instrument paid date must be within the selected month and the paid amount must be greater than 10% above the average price for the peer group food instrument type.

Sort Order

Vendor ID

This report is sorted first by vendor ID.

F.I. Number

This report is sorted by food instrument number within vendor ID.