Contents Show
The Vendor Activity Summary Report VND030 (Output) includes history and informational data for all vendors with redemption activity within the current fiscal year. The report is generated when the OK button is clicked on the Generate Vendor Activity Summary 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.
Origin of Data Element
The value is the text "Vendor Activity Summary". The report has a sub-title that indicates the redemption month chosen by the user.
Format
The title prints as a literal value.
The sub-title prints in the format "Redemption Month {Textual Month} {CCYY}".
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.
Origin of Data Element
This value comes from the Vendor_ID column of the Food_Instrument table.
Format
This is a six-character value.
Origin of Data Element
These values come from the Trade_Name, Physical_City, Physical_State and Physical_ZIP columns of the Vendor table.
Format
The name is a 50-character value that is truncated to 40-characters. The city is a 30-character value that is truncated to 25-characters. The state code is a two-character value. The zip code is a nine-character value.
Origin of Data Element
This value comes from the Date_Inititial_Contract column of the Vendor table.
Format
This is an eight-digit date that prints in MM/DD/CCYY format.
Origin of Data Element
This value comes from the Date_Of_Change column of the vendor Status_History table.
Format
This is an eight-digit date that prints in MM/DD/CCYY format.
Origin of Data Element
This value comes from the Reinstatement_Date column of the Vendor table.
Format
This is an eight-digit date that prints in MM/DD/CCYY format.
Origin of Data Element
This value is the total count of food instruments redeemed by this vendor during the reported month and the eleven months prior.
Format
This is a seven-digit number.
Origin of Data Element
This value is the sum of the dollars paid and the dollars rejected.
Format
This is a seven-digit number plus two decimal points.
Origin of Data Element
This value is the sum of the Paid_Amt column from the Food_Instrument table for all of the vendor's food instruments with a paid date during the selected period.
Current month is the month selected when the report was submitted. Fiscal year is the year-to-date value from the start of the current fiscal year to the current month. If the month of July 2002 were selected, the fiscal year value would include months from October 2001 to July 2002, inclusive.
Format
This is a seven-digit number plus two decimal places.
Origin of Data Element
This value is the sum of the Presentment_Amt column from the Food_Instrument table for all of the vendor's non-paid food instruments with a rejected date during the selected period.
Current month is the month selected when the report was submitted. Fiscal year is the year-to-date value from the start of the fiscal year of the selected month to the current month. If the month of July 2002 were selected, the fiscal year value would include months from October 2001 to July 2002, inclusive.
Format
This is a seven-digit number plus two decimal points.
The report is based on the following selection criteria.
All paid and rejected food instruments with paid/rejected dates during the report period are totaled. For current month, that is the month selected when the report was submitted. For fiscal year, it is the months from the start of the fiscal year of the selected month to the selected month. If the month of July 2002 were selected, the fiscal year value would include months from October 2001 to July 2002, inclusive.
All vendors with a paid or rejected food instrument during the reported period are included on the report.
This report is sorted by vendor ID.
|
Software Version: 2.40.00