Commodity Code Navigation in Peoplesoft

Use this query to generate a list of vendors
for a specific commodity code

1. In Peoplesoft go to Reporting Tools> Query> Query Viewer.  In the search field “begins with” type U_FPO_VNDR_SIC_CODES, click search, click the html link.

 

nav1

2. In the SIC Code 1: type the commodity code and click view results. Example: R205-05. Departments may choose three or more vendors from this list to solicit quotes.
However, whenever possible one of the three quotes must be obtained from a certified Minority or Woman-Owned Business Enterprise (MBE/WBE) if one is available.
Both MBE and WBE firms are identified on the above query with the code “MNR” under the column entitled Type. (See sample of results below.)

query
  arrow

3. Additional MBE/WBE’s can be found at the RI Minority Enterprise website at www.mbe.ri.gov, click directory search to search by company name or product/service. Please note that these queries should be generated as needed because vendors are added, deleted and changed as required.