Contents Show
The Vendor Violation Report (Output) displays the vendors that received violations during a specified date range by the selected reporting criterion.
The report is generated when the OK button is clicked on the Generate Vendor Violation 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 "Vendor Violation Report".
Origin of Data Element
The value is a constant.
Format
No special formatting is applied to the value.
The date range is displayed as the From date and the To date from the report generation screen.
Origin of Data Element
The value is a variable specified on the generation screen.
Format
The value is formatted as follows: "dd/mm/ccyy - dd/mm/ccyy"".
The selection in the Criterion drop-down list box on the report generation screen.
Origin of Data Element
The value is a variable specified on the generation screen.
Format
No special formatting is applied to the value.
The selection(s) in the Criterion Items list box on the report generation screen.
Origin of Data Element
The value is a variable specified on the generation screen.
Format
If the Criterion selected on the generate screen is vendor, the value is omitted.
For all other Criterion selections, the value is formatted as follows: ": <criterion item>" The value changes with each control break.
The stamp number assigned to each vendor included in the report.
Origin of Data Element
The value is pulled from the StampNumber column of the Vendor table.
Format
No special formatting is applied to the value.
The ID number assigned to each vendor included in the report.
Origin of Data Element
The value is pulled from the VendorID column of the Vendor table.
Format
No special formatting is applied to the value.
The name of each vendor included in the report.
Origin of Data Element
The value is pulled from the TradeName column of the Vendor table.
Format
No special formatting is applied to the value.
The class code of each violation included in the report.
Origin of Data Element
The value is pulled from the Classification column of the ViolationType table where the value in the ViolationID column is equal to the value in the ViolationID column of the Violation table.
Format
No special formatting is applied to the value.
The type code of each violation included in the report.
Origin of Data Element
The value is pulled from the ViolationTypeID column of the Violation table.
Format
No special formatting is applied to the value.
The date on which each violation in the report occurred.
Origin of Data Element
The value is pulled from the OccurredDate column of the Violation table.
Format
No special formatting is applied to the value.
The name of the activity (event/follow-up activity) that resulted in each violation in the report.
Origin of Data Element
The value is pulled from the Description column of the Reference Dictionary table where the value in the category column is equal to 'EVENTTYPE' and the value in the ExternalID column is equal to the value in the Type column of the Event or FollowupActivity table for the event or follow-up activity that generated the violation.
Format
No special formatting is applied to the value.
The amount of the fine assessed for the violation.
Origin of Data Element
The value will be pulled from the table(s) created to handle Fines, Rescissions, and the Violations to which they're associated.
Format
No special formatting is applied to the value.
The number of sanction points assessed for the violation.
Origin of Data Element
The value is pulled from the SanctionPoints column of the Violation table.
Format
No special formatting is applied to the value.
This section describes the data elements that print on the final summary page of the document.
The title of the report is the text "Vendor Violation Report".
Origin of Data Element
The value is a constant.
Format
No special formatting is applied to the value.
The sub-title of the report is the text "Violation Totals".
Origin of Data Element
The value is a constant.
Format
No special formatting is applied to the value.
The date range is displayed as the From date and the To date from the report generation screen.
Origin of Data Element
The value is a variable specified on the generation screen.
Format
The value is formatted as follows: "dd/mm/ccyy - dd/mm/ccyy"".
The selection in the Criterion drop-down list box on the report generation screen.
Origin of Data Element
The value is a variable specified on the generation screen.
Format
No special formatting is applied to the value.
The selection(s) in the Criterion Items list box on the report generation screen.
Origin of Data Element
The value is a variable specified on the generation screen.
Format
If the Criterion selected on the generate screen is Vendor, the value is omitted.
For all other Criterion selections, the value is formatted as follows: ": <criterion item>" The value changes with each control break.
The class code of each violation included in the report.
Origin of Data Element
The value is pulled from the Classification column of the ViolationType table where the value in the ViolationID column is equal to the value in the ViolationID column of the Violation table.
Format
No special formatting is applied to the value.
The type code of each violation included in the report.
Origin of Data Element
The value is pulled from the ViolationTypeID column of the Violation table.
Format
No special formatting is applied to the value.
The number of instances the violation class and type occurred for the vendors included in the report.
Origin of Data Element
The value is calculated by summing the number of times the violation class and type combination occurred for the vendors included in the report over the time period reported.
Format
No special formatting is applied to the value.
The filter criteria applied are the Report by data and the date range specified for the report.
The vendors are sorted first in ascending order by the Criterion selected on the generate screen.
The vendors are sorted in ascending order by stamp number.
The violations are sorted within each vendor stamp number grouping in descending order by violation date.
The violations are sorted within each violation date grouping in ascending order by violation class.
The violations are sorted within each violation class grouping in ascending order by violation type.
When more than one selection is made in the Criterion Item list box on the generate screen, a control break occurs with each change in criterion item.
Corporate Parent
When Corporate Parent is selected as the Criterion and more than one peer group is selected in the Criterion Items list box, a page break occurs with each change in corporate parent.
Peer Group
When Peer Group is selected as the Criterion and more than one peer group is selected in the Criterion Items list box, a page break occurs with each change in peer group.
County
When County is selected as the Criterion and more than one county is selected in the Criterion Items list box, a page break occurs with each change in county.
ZIP Code
When ZIP Code is selected as the Criterion and more than one ZIP code is selected in the Criterion Items list box, a page break occurs with each change in ZIP code.
Geographic Area
When Geographic Area is selected as the Criterion and more than one geographic area is selected in the Criterion Items list box, a page break occurs with each change in geographic area.
Staff Member
When Staff Member is selected as the Criterion and more than one staff member is selected in the Criterion Items list box, a page break occurs with each change in staff member.
|
Software Version: 2.40.00
