Outstanding Applications Report VND001 (Output)

Contents Show

The Outstanding Applications Report VND001 (Output) lists the vendor applications that have not been approved, denied or added to the Waiting List. A vendor is included in this report if the current status of the vendor is Applicant. Also included in The report is vendor applications from current vendors who are reapplying. The report is generated when the OK button is clicked on the Generate Outstanding Applications Report screen.

Data Elements

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.

Report Title

The title of the report is the text "Outstanding Applications". There is no sub-title for this report.

Origin of Data Element

The value is a literal value.

Format

The value prints as its literal value.

Municipality/County Code

This value is a combination of the municipality code and the County code of the vendor.

Origin of Data Element

The value is taken from the Municipality and County columns of the VENDOR table.

Format

The value prints as one combined element. The County code prints as its literal value as the first 4 characters of the combined element. The municipality code prints as its literal value as the last 4 characters of the combined element. There is no spaces in between the two codes.

Vendor ID

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.

Vendor Name

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.

Contact Person

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 Vendor-WIC-Contact-Person-Salutation-Title, Vendor-WIC-Contact-Person-First-Name, and WIC-Contact-Person-Last-Name columns of the VENDOR table.

Format

The value prints in salutation/title, first name, last name order.

Telephone Number

This value is the telephone number of the vendor.

Origin of Data Element

The value is taken from the Telephone column of the VENDOR table.

Format

The value prints in ###-###-#### format.

Current Status

This value is the current status of the vendor.

Origin of Data Element

The value is taken from the Current-Status column of the VENDOR table.

Format

The value prints as the textual description of the vendor status.

Application Sent

This value is the date on which the application was sent to the vendor.

Origin of Data Element

The value is taken from the Application-Sent-Date column of the APPLICANT table.

Format

The value prints in MM/DD/CCYY format.

Application Received

This value is the date on which the returned application was received by WIC from the vendor.

Origin of Data Element

The value is taken from the Application-Received-Date column of the APPLICATION-RECEIVED table.

Format

The value prints in MM/DD/CCYY format.

Filter Criteria

Applicants

Only vendors whose current status is Applicant or are currently in the WIC program and reapplying for application is included in the report.

Sort Order

Municipality

The report is sorted first by municipality.

County

The report is sorted by County within municipality.

Vendor ID

The report is sorted by vendor ID within County.

Control Breaks

No control breaks are defined for this system output.

Grand Total

No grand totals are defined for this system output.

Frequency and Distribution

This document is generated on demand.

The data is current as of the current date.

The output type is: Screen, Paper, or PDF.

The Report Level is: State.

|

Vendor