OPRIDOPRID2EM_VNDR_USR_SRC(SQL View) |
Index Back |
|---|---|
Local Admin Auth. UsersMarketPay Security This SQL view will limit access by a local administrator only to user profiles that share his/her supplier permissions. Since it is returning a list of User OPRIDs, the SQL view must use the Local Administrator's ROWSECCLASS. Caveat: The Local Administrator's ROWSECCLASS must contain a value equal to his/her USERID. This SQL View is used as the controlling record in the grid of the Seller Security Inquiry Page. This is the MarketPay version of a Search Record. |
| SELECT DISTINCT A.OPRID ,C.OPRDEFNDESC , B.OPRID FROM PS_VENDOR_USER A , PS_VENDOR_USER 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.OPRID 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 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | OPRID2 |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |