OPRIDSETIDPrompt Table: EM_LOCLSETID_VW
VENDOR_IDPrompt Table:
EM_LOCL_VNDR_VW
Set Control Field: OPRID2
EM_VENDORUSR_VW(SQL View) |
Index Back |
|---|---|
User Supplier PermissionsMarketPay Security Scott Birnbaum This SQL view overlays SUPPLIER_USER, and is the controlling record in the grid of the Supplier Security page. This SQL view was used rather than the Supplier User table, to allow us to use our own prompt tables and peoplecode. restore this SELECT DISTINCT A.OPRID ,A.SETID ,A.SUPPLIER_ID FROM PS_SUPPLIER_USER A , PS_SUPPLIER_USER B WHERE A.SETID=B.SETID AND A.SUPPLIER_ID=B.SUPPLIER_ID AND B.OPRID=%OperatorId |
| SELECT A.OPRID ,A.SETID ,A.VENDOR_ID ,B.OPRID FROM PS_VENDOR_USER A , PS_VENDOR_USER B WHERE A.SETID=B.SETID AND A.VENDOR_ID=B.VENDOR_ID |
| # | 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: EM_LOCLSETID_VW |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
EM_LOCL_VNDR_VW
|
| 4 | OPRID_ADJUSTED | Character(30) | VARCHAR2(30) NOT NULL | User Id Adjusted |