Contents Show
The Vendor Complaint Report VND002 (Output) lists vendors who had a complaint filed against them during the selected date range. The report is generated when the OK button is clicked on the Generate Vendor Complaint 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 "Vendor Complaint Report". A subtitle indicates the date range selected for the report.
Origin of Data Element
The date range is selected by the user on the Generate Vendor Complaint Report screen.
Format
The values prints in MM/DD/CCYY format.
This value is the ID of the WIC staff person who is primarily responsible for this vendor.
Origin of Data Element
The value is taken from the UserID column of the VENDOR table.
Format
The value prints as its literal value.
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 salutation, title and name of the WIC contact person for the vendor.
Origin of Data Element
The value is taken from the WIC-Contact-Title, WIC-Contact-Salutation, WIC-Contact-First-Name, and WIC-Contact-Last-Name columns of the VENDOR table.
Format
The value prints in salutation/title, first name, last name order.
This value is the description of the type of complaint that was filed against the vendor.
Origin of Data Element
The value is taken from the Description column in the Complaint Type table.
Format
The value prints as its literal value.
This value is the date on which a WIC staff person was informed of the complaint.
Origin of Data Element
The value is taken from the Received-Date column of the COMPLAINT table.
Format
The value prints in MM/DD/CCYY format.
This value is the follow-up activity that was taken in response to the Complaint.
Origin of Data Element
The value is taken from the Description column of the EVENT table for the associated Follow-Up-Activity-ID column of the FOLLOW UP ACTIVITY table.
Format
The value prints as its literal value.
This value is the date on which the Follow-up Action was taken.
Origin of Data Element
The value is taken from the StartDate column of the FollowupActivity table.
Format
The value prints in MM/DD/CCYY format.
This tells the user if the complaint was resolved or not.
Origin of Data Element
If the complaint was resolved the value is "Y" and if not it is "N". This is taken from the ResolvedComplaint table if this is a follow-up to the associated Complaint.
Format
The value prints as its literal value.
This value is the date on which the complaint was resolved.
Origin of Data Element
The value is taken from the ResolvedDate column of the ResolvedComplaint table.
Format
The value prints in MM/DD/CCYY format.
All vendors with complaints filed against them with a received date occurring between the user-specified begin and end date is included in the report.
The report is sorted first by UserID of the WIC staff person primarily responsible for the vendor.
The report is sorted by vendor ID within WIC staff person UserID.
A page break occurs at the change of vendor ID.
The data is current as of the date range is compared to the date the complaint was received.
The Output Type is: screen, Paper, or PDF.
The Report Level is: State.
|
Software Version: 2.40.00