EM_LOCLSETID_VW (SQL View)	Index Back
Local Adm. SETID Permissions MarketPay Security This SQL view is used as a prompt table for SETIDs in the Seller Security Page. It returns a list of authorized SETIDs for a Seller Administrator. This list is retreived from PS_SUPPLIER_USER, where the Host or System Administrator has entered the Seller Administrator's SETIDs from Maintain Suppliers, Use, Supplier User. RSR Replaced ROWSECCLASS w/ OPRID

EM_LOCLSETID_VW

(SQL View)

Local Adm. SETID Permissions

MarketPay Security This SQL view is used as a prompt table for SETIDs in the Seller Security Page. It returns a list of authorized SETIDs for a Seller Administrator. This list is retreived from PS_SUPPLIER_USER, where the Host or System Administrator has entered the Seller Administrator's SETIDs from Maintain Suppliers, Use, Supplier User. RSR Replaced ROWSECCLASS w/ OPRID

SELECT DISTINCT A.OPRID ,A.SETID ,B.DESCR FROM PS_VENDOR_USER A ,PS_SETID_TBL B WHERE A.SETID = B.SETID

Related Language Record: EM_LOCLSETID_LG

# 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
Prompt Table: SETID_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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 Prompt Table: SETID_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description