Contents Show
The High Risk Report VND009 (Output) is a monthly list of vendors considered a high risk during the month and year specified by the user. This report is used to provide quarterly and annual data, to identify vendors for compliance buys, and to provide information for hearings. The report is generated when the OK button is clicked on the Generate High Risk Report screen.
Number of Complaints - VENDORHIGHRISK.NUMCOMPLAINTS - Count the number of complaints from the COMPLAINT and EVENT tables for the specified vendor and reporting month where the Event type = 3 (COMPLAINT) and the Complaint was recorded for the reporting Month
Total Vendor Redemption Amount for the reporting month - The amount of FI redeemed is summed into the REDEMPTIONHISTORY table by vendor and reporting month.
Vol Score - The Vol Score or Volume Score is user defined and maintained in the HIGHRISKVOLSCORE table. The Vol Score is set to provide a number that indicates a specific range of redemptions for vendors. For example, a score of 1 might be set for all vendors who redeem between $1000.00 and $3000.00 for the reported month. A vol score of 6 might be set for all vendors who redeem between $50,000.00 and $60,000.00 for the reported month. When the High Risk report is generated, the vendor redemption for the month is compared to the HIGHRISKVOLSCORE table values and assigns the Vol Score value retrieved for all vendors reported.
Risk Score Factor - The value is calculated. Calculation is 1 point for each item in a flagged column excluding complaints from this sum. Take the sum of High Risk indicators then add the number complaints for the vendor for the reported month where the High Risk indicator is set to "Y" (which adds a point for every complaint).
For example:
If the HighAvg value is set to "Y", add 1 to the risk score factor.
If the HighCost value is set to "Y", add 1 to the risk score factor.
If the LoVar value is set to "Y", add 1 to the risk score factor.
Add the count of high risk complaints the vendor had in the month to the risk score factor. If the vendor has 2 high risk complaints in this scenario, then the high risk score would be 5.
Risk Score - The Risk Score Factor is multiplied by the Vol Score to get the Risk Score Value.
Rank - The vendors are then included in order from highest to lowest score.
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 "High Risk Report". A subtitle indicates the month and year selected for the report.
Origin of Data Element
The month and year is selected by the user on the Generate High Risk Report screen.
Format
The values prints in MM/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 numeric rank assigned to the vendor.
Origin of Data Element
The value is derived during the creation of the report. Each vendor is assigned one risk point for each high risk indicator and one risk point for each high risk complaint. That sum is multiplied by the volume score (Vol Score) from the High Risk Vol Score table and the result is assigned to the vendor. The vendor with the highest result within the peer group is assigned a rank of 1. The vendor with the second highest result within the peer group is assigned a rank of 2, etc. until all vendors have been ranked within the peer group.
Format
The value prints in ### format.
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 Trade 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.
Origin of Data Element
The value is taken from the LoVar column out of the VendorHighRisk table.
Format
The value prints in # format. The control contains a "Y" if the vendor was identified as having low variance. Otherwise, the control contains an "N".
Origin of Data Element
The value is taken from the HighAvg column out of the VendorHighRisk table.
Format
The value prints in # format. The control contains a "Y" if the vendor was identified as having high average cost. Otherwise, the control contains an "N".
Origin of Data Element
The value is taken from the HighCost column out of the VendorHighRisk table.
Format
The value prints in # format. The control contains a "Y" if the vendor was identified as having high cost food instruments. Otherwise, the control contains an "N".
This value is the number of complaints recorded against the vendor during the user-specified month.
Origin of Data Element
The value is the accumulated total number of Complaint events recorded against the vendor where the Complaint-High-Risk flag of the COMPLAINT table indicates a high-risk complaint and the value of the Received-Date column of the COMPLAINT table falls within the user-specified month.
Format
The value prints in ## format.
This value indicates that the vendor is redeeming too many food instruments above 10% of the peer group average.
Origin of Data Element
The value is taken from the 10Percent column out of the VendorHighRisk table.
Format
The value prints in # format. The value is "Y" when the vendor is considered above the 10 percent of the peer group average. The value is "N" when the vendor is not considered above the 10 percent of the peer group average.
This value indicates that the vendor is redeeming too many food instruments within five dollars of the peer group average.
Origin of Data Element
The value is taken from the Five_Dollar column out of the VendorHighRisk table.
Format
The value prints in # format. The value is "Y" when the vendor is considered within five dollars of the peer group average. The value is "N" when the vendor is not within five dollars of the peer group average.
This value indicates that the vendor is redeeming too many food instruments at 85% of the peer group average.
Origin of Data Element
The value is taken from the 85_Percent column out of the VendorHighRisk table.
Format
The value prints in # format. The value is "Y" when the vendor is considered at the 85 percent of the peer group average. The value is "N" when the vendor is not considered above the 85 percent of the peer group average.
This value indicates that the vendor had an increase in a percent of the value of the food instruments redeemed.
Origin of Data Element
The value is taken from the PCT_Increase column out of the VendorHighRisk table.
Format
The value prints in # format. The value is "Y" when the vendor is considered to have an increase in the value of food instruments redeemed. The value is "N" when the vendor does not increase in the value of food instruments redeemed.
Origin of Data Element
The value is calculated during the generation of the report. The Vol Score is user defined and maintained in the HIGHRISKVOLSCORE table. For High Risk, a Vol Score value is retrieved from the table where the vendor's redemption history amount for the specified month is equal to or greater than the low amount for high risk and less than or equal to the high amount for high risk.
Format
The value prints in ## format.
Origin of Data Element
The value is calculated during the generation of the report. Calculation is 1 point for each item in the column except for complaints, which is a point for every complaint. The sum of this is multiplied by the Vol Scale to get the Risk Score Value. The risk score is used to list vendors in order from highest risk to lowest risk.
Format
The value prints in ## format.
All vendors who were considered high risk during the month and year selected by the user is included in the report.
The report is sorted by rank within peer group.
The data is current as of End of Month.
The output type is: screen, Paper, or PDF.
The Report Level is: State.
|
Software Version: 2.40.00