USF_VND_PUEI_VW (SQL View)	Index Back
SAM Immediate Parent Vendor Used to determine if SAM Entity's Parent UEID has been created as a Vendor Also used by the following AE programs: AP_SAM_LOAD AP_USF_VBLD to represent the relationship in Component Interface PeopleCode

USF_VND_PUEI_VW

(SQL View)

SAM Immediate Parent Vendor

Used to determine if SAM Entity's Parent UEID has been created as a Vendor Also used by the following AE programs: AP_SAM_LOAD AP_USF_VBLD to represent the relationship in Component Interface PeopleCode

SELECT %TrimSubstr(I.STD_ID_NUM,1,12) , I.SETID , I.VENDOR_ID FROM PS_VNDR_VALCORP_VW V , PS_VENDOR_ID_NBRS I WHERE I.SETID = V.CORPORATE_SETID AND I.VENDOR_ID = V.CORPORATE_VENDOR AND I.STD_ID_NUM_QUAL = 'UEI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USF_UEID	Character(12)	VARCHAR2(12) NOT NULL	Unique Entity Identifier
2	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier