|
|
NOTE: If the High Cost Food Instruments Report VND041 (Output) is not applicable to your state, this report is unavailable in the application. |
Contents Show
|
|
NOTE: If the High Cost Food Instruments Report VND041 (Output) is not applicable to your state, this report is unavailable in the application. |
The High Cost Food Instruments Report VND041 (Output) lists food instruments that are redeemed for an amount that is within 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 High Cost Food Instruments Report screen. The report is also generated as part of the month-end process and is available at the state level only.
During the End of Month processing, vendors that are included on the report are also flagged with the high cost food instruments indicator on the High Risk report.
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 of the title text is "High Cost Food Instruments". The report has a sub-title to show the month previously selected by the user.
Format
The report title prints as a literal value. The sub-title prints in the format "Month of {Textual Month} {CCYY}".
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.
Origin of Data Element
The code value comes from the Peer-Group column of the Food-Instrument table. The description comes from the Description column of the Peer-Group table for the associated value.
Format
The code is a two-character value. The description is a fifty-character value.
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.
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.
Origin of Data Element
This value comes from the Serial-No column of the Food-Instrument table.
Format
This is an eight-character value.
Origin of Data Element
This value comes from the Food-Instrument-Type column of the Food-Instrument table.
Format
This is a five-character value.
Origin of Data Element
This value comes from the Price column of the Peer-Group-Food-Inst-Type-Price table for the associated food instrument type and peer group.
Format
This is a six-digit number plus two decimal places.
Origin of Data Element
This value comes from the Avg-Price column of the Peer-Group-Food-Inst-Type-Price table for the associated food instrument type and peer group.
Format
This is a six-digit number plus two decimal places.
Origin of Data Element
This value comes from the Paid-Amt column of the Food-Instrument table.
Format
This is a seven-digit number plus two decimal places.
Origin of Data Element
This value is calculated by subtracting the peer group average from the paid amount.
Format
This is a seven-digit number plus two decimal places.
Origin of Data Element
This value is calculated by subtracting the peer group average from the paid amount. The difference is divided by the peer group average, multiplied by 100 and rounded.
Format
This is a three-character number plus two decimal places.
Origin of Data Element
This value is the count of food instruments included on the report for the vendor.
Format
This is a nine-character number.
Vendors with food instruments that meet the following selection criteria are included in the report.
The food instrument was redeemed during the reported month.
The paid amount is divided by the peer group maximum. This value is multiplied by 100 and rounded. If the result is greater than or equal to the state defined percentage, the food instrument is included in the report. The state defined percentage is found in the value column of the StateBusinessRules table where the categoryID equals VNDR_HICOST_FI_PERCENT_MAX_AMT.
Once the first two criteria have been met and the count of food instruments to be printed for the vendor determined, there is one additional edit. If the count of food instruments to be printed is less than the threshold (a number determined by the state), that vendor will not appear on the report. The state defined threshold number of food instruments is found in the value column of the StateBusinessRules table where the categoryID equals VNDR_HICOST_FI_MIN_NO_FI_PER_VNDR. This additional filter criterion reduces the number of food instruments reported by eliminating vendors who have only a minimal number of food instruments redeemed for an amount over the peer group average price.
The report is sorted by food instrument check number within vendor ID.
On a change of vendor ID, the vendor total number of food instruments prints.
The total number of vendors included on the report prints as grand totals.
This system output is generated on demand. If selected by the state, this system output is also generated during the month-end process.
|
Software Version: 2.40.00
