VENDOR_PROV_VW (SQL View)	Index Back
Vendor Provider View Returns only those Vendors that are classed as Providers.

VENDOR_PROV_VW

(SQL View)

Vendor Provider View

Returns only those Vendors that are classed as Providers.

SELECT setid , vendor_id , vendor_name_short FROM PS_VENDOR WHERE hrms_class IN ('P', 'I', 'H')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name