Vendor Profile VND023 (Output)

The Vendor Profile VND023 (Output) is a summary of vendor data including Redemption History and Event / Follow-up Activity information for the selected time period. The report is generated when the Print Profile button is clicked on the Vendor Folder.

Report Title

The title of the report is the text "Vendor Profile". A subtitle indicates the vendor selected for the report.

Origin of Data Element

The vendor is selected by the user on the Vendor Folder, Demographics tab, page 1.

Format

The value prints as its literal value.

Vendor Trade Name

This value is the Vendor's Trade Name.

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.

Vendor Address

This value is the Vendor's Address.

Origin of Data Element

The value is taken from the Address1 and Address2 columns of the ADDRESS table. The AddressID value for a given vendor is retrieved from the ADDRESSCROSSREF table, with criteria set as below in the Reference Dictionary:

• TableKey = [VendorID]

• TableName = "Vendor"

• AddressType = "Phys"

• Active = "Y"

Format

The value prints as its literal value. If applicable, two lines of the address prints.

Vendor City, ST ZIP

This value is the vendor's physical City, State and ZIP.

Origin of Data Element

The value is taken from the City, StateCd, and ZIPCode columns of the ADDRESS table. The AddressID value for a given vendor is retrieved from ADDRESSCROSSREF table, with criteria set as below in the Reference Dictionary:

• TableKey = [VendorID]

• TableName = "Vendor"

• AddressType = "Phys"

• Active = "Y"

Format

The values print as their literal values in City, State and ZIP order.

E-mail

This value is the e-mail address of the vendor.

Origin of Data Element

The value is taken from the Vendor-Email-Address column of the VENDOR table.

Format

The values prints its literal value.

Contact

This value is the name of the WIC Contact for the vendor.

Origin of Data Element

The value is taken from the FirstName and LastName columns of the CONTACT table. The ContactID value for a given vendor is retrieved from the FIRST contact reference in the CONTACTCROSSREF table, with criteria set as below in the Reference Dictionary:

• TableKey = [VendorID]

• TableName = "Vendor"

• AddressType = "Phys"

• Active = "Y"

Format

The values prints as their literal values in first name last name order.

Telephone Number

This value is the vendor's telephone number.

Origin of Data Element

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

Format

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

Authorized Agent

This value is the name of the vendor's Authorized Agent.

Origin of Data Element

The value is taken from the Authorized-Agent-First-Name and Authorized-Agent-Last-Name columns of the VENDOR table.

Format

The values prints as their literal values in first name last name order.

Owner

This value is the name/s of the vendor's Owner/s.

Origin of Data Element

All owners are listed. All owners information is retrieved from following 3 tables:

• CONTACT - The value is taken from the FirstName and LastName columns of the CONTACT table. The ContactID value for a given vendor is retrieved from the FIRST contact reference in the CONTACTCROSSREF table, with criteria set as below in the Reference Dictionary:

• TableKey = [VendorID]

• TableName = "Vendor"

• ContactType = "Owner"

• CORPORATEPARENT - The value is taken from the Name column of the CORPORATEPARENT table, for a given CorporateParentID from VENDOR table.

• OTHEROWNERSHIPSTRUCTURE - The value is taken from the Description column of the OTHEROWNERSHIPSTRUCTURE table, for a given OtherOwnershipStructureID from VENDOR table.

Format

The values print as their literal values in first name last name order.

Fax Number

This value is the vendor's telephone number for their facsimile machine.

Origin of Data Element

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

Format

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

Business Hours

This value is the vendor's Business Hours.

Origin of Data Element

The value is taken from the {Day of week}-Open/Close columns of the STORE HOURS table. Only days that have an Open/Close time specified are listed.

Format

The values prints as 00:00am - 00:00pm format. Each time period is preceded with the abbreviated day of week.

Vendor Mail to Address

This value is the vendor's Mailing Address.

Origin of Data Element

The value is taken from the Mailing-Address column of the VENDOR table.

Format

The value prints as its literal value. If applicable, two lines of the address prints.

Vendor Mailing City, ST ZIP

This value is the vendor's Mailing City, State and ZIP.

Origin of Data Element

The value is taken from the Mailing-City, Mailing-State and Mailing-ZIP columns of the VENDOR table.

Format

The values prints as their literal values in City, State and ZIP order.

Original Enrollment

This value is the vendor 's enrollment date.

Origin of Data Element

The value is taken from the Date-Init-Contract column of the VENDOR table.

Format

The value prints in MM/DD/CCYY format.

Contract Effective

This value is the vendor's contract effective date.

Origin of Data Element

The value is taken from the Contract-Start-Date column of the VENDOR table.

Format

The value prints in MM/DD/CCYY format.

Status

This value indicates the vendor's current status.

Origin of Data Element

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

Format

The value prints as its literal value

Stamp Number

This value is the vendor's primary stamp number.

Origin of Data Element

The value is taken from the Stamp-Number column of the VENDOR table.

Format

The value prints as its literal value

Farmers Markets

This value is not included at this time.

Census Tract

This value is the vendor's census tract number.

Origin of Data Element

The value is taken from the Census-Tract column of the VENDOR table.

Format

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

County

This value is the vendor's County.

Origin of Data Element

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

Format

The value prints as its literal value.

Total Points

This value is the vendor's total of all event and follow-up Activity sanction points.

Origin of Data Element

The value is taken from the Sanction-Points column of the EVENT and FOLLOWUPACTIVITY entities.

Format

The value prints as a sum of both event and follow-up activity sanction points.

Peer Group

This value is the vendor's Peer Group.

Origin of Data Element

The value is taken from the Peer-Group column of the VENDOR table.

Format

The value prints as its literal value.

Store Type

This value is the vendor's Store Type.

Origin of Data Element

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

Format

The value prints as its literal value.

Ownership Type

This value is the vendor's Ownership Type.

Origin of Data Element

The value is taken from the Ownership-Structure column of the VENDOR table.

Format

The value prints as its literal value.

Cash Registers

This value is the vendor's number of cash registers.

Origin of Data Element

The value is taken from the Check-Out-Registers column of the VENDOR table.

Format

The value prints as its literal value.

Cashiers

This value is the vendor's number of cashiers.

Origin of Data Element

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

Format

The value prints as its literal value.

Scanners

This value indicates if the vendor has scanners.

Origin of Data Element

The value is taken from the Electronic-Scanners column of the VENDOR table.

Format

The value prints Yes or No.

Square Footage

This value is the vendor's Square Footage.

Origin of Data Element

The value is taken from the Square-Footage column of the VENDOR table.

Format

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

Tax ID

This value is the vendor's Federal Tax ID.

Origin of Data Element

The value is taken from the Federal-Tax-Number column of the VENDOR table.

Format

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

State Sales Tax #

This value is the vendor's State Sales Tax Number.

Origin of Data Element

The value is taken from the State-Sales-Tax-Number column of the VENDOR table.

Format

The value prints as its literal value.

Annual Food Sales

This value is the vendor's Annual Food Sales.

Origin of Data Element

The value is taken from the Annual-Food-Sales column of the VENDOR table.

Format

The value prints in ##,###.## format.

Annual Non-Food Sales

This value is the vendor's Annual Non Food Sales.

Origin of Data Element

The value is taken from the Annual-Non-Food-Sales column of the VENDOR table.

Format

The value prints in ##,###.## format.

Annual Total Sales

This value is the vendor's Annual Total Sales.

Origin of Data Element

The value is taken from the Annual-Gross-Sales column of the VENDOR table.

Format

The value prints in ##,###.## format.

Kosher Foods

This value indicates if the vendor offers Kosher Foods.

Origin of Data Element

The value is taken from the Kosher-Foods column of the VENDOR table.

Format

The value is translated and prints "Some", "Primarily" or "None".

Bank

This value is the vendor's Bank Name.

Origin of Data Element

The value is taken from the Bank-Name column of the VENDOR table.

Format

The value prints as its literal value.

Transit #

This value is the vendor's Bank Transit Number.

Origin of Data Element

The value is taken from the Bank-Transit-Number column of the VENDOR table.

Format

The value prints as its literal value.

Account Number

This value is the vendor's Account Number.

Origin of Data Element

The value is taken from the Account-Number column of the VENDOR table.

Format

The value prints as its literal value.

Primary Grocery Wholesaler

This value is the vendor's Primary Grocery Wholesaler Name.

Origin of Data Element

The value is taken from the Grocery-Supplier-ID column of the VENDOR table and the Grocery-Supplier-Name column of the GROCERYSUPPLIER table where the SupplierType = value for the Grocery Wholesaler.

Format

The value printed is the GrocerySupplier.Name.

Pharmacy/Milk Wholesaler

This value is the vendor's secondary Wholesaler Name. The wholesaler can be a Pharmacy or Milk Wholesaler depending on the business rule set by the State.

Origin of Data Element

The value is taken from the applicable Grocery-Supplier-ID or Wholesaler-ID column of the VENDOR table and the applicable Name column of the GROCERYSUPPLIER table where the SupplierType = value for the Pharmacy or Milk Wholesaler where applicable.

Format

Depending on the state business rule, the value printed is the GrocerySupplier.Name.

Formula Wholesaler

This value is the vendor's Formula Wholesaler.

Origin of Data Element

The value is taken from the FormulaWholesalerID column of the VENDOR table and the applicable Name column of the GROCERYSUPPLIER table where the SupplierType = value for FormulaWholesaler.

Format

The value printed is the GrocerySupplier.Name.

Staff Member

This value is the ID of the primary Staff Member assigned to the vendor.

Origin of Data Element

The value is taken from the UserID column of the vendor table and the First-Name, Last-Name columns of the USERPROFILE table.

Format

The value prints in first name last name order.

Shared Clinics

This is all shared clinics for the vendor.

Origin of Data Element

The value is taken from the ServiceSiteID of the VENDOR SS ASSOCIATION table and the Name column of the ServiceSite table.

Format

All Clinics for the vendor are listed.

Other WIC Programs Served

This includes the other WIC programs that the vendor serves. The list is printed if the OTHERWICPROGRAMSSERVED business rule is active.

Origin of Data Element

The value is taken from the OtherWICProgramID of the OTHERWICPROGRAMSSERVED table and the Name column of the OTHERWICPROGRAM table.

Format

All other WIC programs for the vendor are listed.

Directions to Store

This value is the vendor's directions to the store.

Origin of Data Element

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

Format

The value prints as its literal value.

Event Log

This lists a vendor's events and follow-up activities for the date range specified on the Generate Vendor Profile screen.

Origin of Data Element

The value is taken from the Events and FollowupActivities entities.

Format

The Events/Follow-up Activities prints in an indented format to show the Event and Follow-up relationship.

If an Event or Follow-up Activity fall within the date range, then the whole tree list branch is displayed on the report.

The Events is printed out in ascending or descending order, according to your State.

Redemption History

This lists the vendors Redemption History for the date range specified on the Generate Vendor Profile screen. Each Year displays the month(s) and value(s) consecutively.

Origin of Data Element

The value is taken from the Month of Redemption and Value of FI Redeemed columns of the REDEMPTION HISTORY table.

Format

The year prints in CCYY format. The month value prints as its literal value. The amount prints as its literal value.

Vendor Notes

This lists the vendors Notes for the date range specified on the Generate Vendor Profile screen.

Origin of Data Element

The value is taken from the CreateDate, UserID and Text columns of the VENDORNOTE table.

Format

The value prints as a literal value.

Filter Criteria

All demographic, event logs, redemption history and vendor notes for the selected vendor, occurring between the user's specified begin and end dates is included in the report.

Control Totals

Redemption History

If Redemption History is included in the report, a subtotal prints for:

• Total dollar amount for all checks redeemed within the year.

• Total dollar amount for all checks redeemed for all years included in the report.

The data is current as of the date range specified.

The Output Type is: screen, Paper, or PDF.

The Report Level is: State.