Contents Show
The Average Actual Price Comparison Report VND052 (Output) lists the average actual price for all food instruments redeemed during the past three months for each vendor peer group and food instrument type. The report also lists the percentage of food instruments for each vendor that exceeds the average actual price.
The report is generated when the OK button is clicked on the Generate Average Actual Price Comparison Report screen.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
The title of the report is the text of "Average Actual Price Comparison Report". A subtitle indicates the month and year when the report was printed.
Origin of Data Element
The month and year is taken from the current system date.
Format
The values prints in "{Textual Month} {CCYY}" format.
This value is the description of the peer group of the Vendor.
Origin of Data Element
The value is taken from the Description column of the PEER GROUP table.
Format
The value prints as its literal value.
This value is the code for the food instrument type.
Origin of Data Element
This value is taken from the Food Instrument Type table.
Format
This is a five-digit number.
This value is the description for the food instrument type.
Origin of Data Element
This value is taken from the Food Instrument Type table.
Format
This is a three-digit number.
This value is the quantity of the food item on the food instrument type.
Origin of Data Element
This value is taken from the Food Instrument Type Items table.
Format
The values print as their literal values.
This value is the description of the food item on the food instrument type.
Origin of Data Element
This value is taken from the Food Instrument Type Items table.
Format
The value prints as its literal value.
This value is the average of the actual price for the food instrument type within the vendor peer group over the last three months.
Origin of Data Element
This value is calculated by dividing the Current Month Dollar Value by the Current Month Number of FI.
Format
This is a five-digit number with two decimal places.
This value is the ID of the Vendor.
Origin of Data Element
The value is taken from the Vendor-ID column of the VENDOR table.
Format
The value prints as its literal value.
This value is the name of the Vendor.
Origin of Data Element
The value is taken from the Trade-Name column of the VENDOR table.
Format
The value prints as its literal value.
This value is the number of food instruments redeemed during the last three months.
Origin of Data Element
This value is the count of the number of food instruments redeemed during the last three months for this combination of vendor and food instrument type.
Format
This is a six-digit number.
This value is the number of food instruments redeemed during the last three months for an amount greater than the average actual price for the food instrument type within the vendor peer group over the last three months.
Origin of Data Element
This value is the count of the number of food instruments redeemed during the last three months for an amount greater than the average actual price for this combination of vendor and food instrument type.
Format
This is a six-digit number.
This value is the percent of food instruments redeemed during the last three months for an amount greater than the average actual price for the food instrument type within the vendor peer group over the last three months.
Origin of Data Element
This value is calculated by dividing the Total Redeemed Over Average by the Total Redeemed and multiplying the resulting value by 100 and rounding to the nearest whole number.
Format
This is a three-digit number.
All Vendors who redeemed a food instrument within the last three months is included in the report.
The report is sorted first by the Vendor peer group.
The report is sorted by Food Instrument Type ID within Vendor peer group.
The report is sorted by Vendor ID within Food Instrument Type ID.
A page break occurs at the change of Food Instrument Type ID.
A page break occurs at the change of Vendor peer group.
This document is generated on demand.
The data is current as of the current date.
The output type is: Screen, Paper, or PDF.
The Report Level is: State.
|
Software Version: 2.40.00