VENDOR_NHS_VW (SQL View)	Index Back
Vendor NHS View Vendor National Health Service View.

VENDOR_NHS_VW

(SQL View)

Vendor NHS View

Vendor National Health Service View.

SELECT SETID ,VENDOR_ID ,VENDOR_NAME_SHORT FROM PS_VENDOR WHERE HRMS_CLASS = '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