EM_VNDR_USR_SR3

(SQL View)
Index Back

eS Supplier UserIDs

Returns list of OPRIDs that are mapped to an eS Role via the EM_ROLE_CONFIG page/component. OPRID must be configured/mapped to eS Supplier role type (excludes System Administrator in result set. Add a Supplier Role to System Administrators User Profile to include).

SELECT DISTINCT A.OPRID , A.SETID , B.OPRID2 , C.OPRDEFNDESC , C.EMAILID FROM PS_VENDOR_USER A , PS_VENDOR_USER_V B , PSOPRDEFN C , PSROLEUSER D , PS_EM_ROLE_CONFIG E WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.OPRID <> B.OPRID2 AND A.OPRID = C.OPRID AND A.OPRID = D.ROLEUSER AND D.ROLENAME = E.EM_ROLENAME AND E.EM_ROLETYPE IN ('25', '30')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
4 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address