SETIDEOCM_ACCESS_IDOPRIDEOCM_TPM_USR_VW(SQL View) |
Index Back |
|---|---|
Trading Partner usersCatalog Management - trading partner users filtered by trading partner |
| SELECT DISTINCT A.SETID , A.EOCM_ACCESS_ID , B.OPRID , C.OPRDEFNDESC FROM PS_EOCM_TRDPARTNER A , PS_EOTP_PARTUSRSVC B , PSOPRDEFN C , PS_EOTP_SVCPROC D WHERE B.SETID = A.SETID AND B.EOTP_PARTNERID = A.EOCM_ACCESS_ID AND C.OPRID = B.OPRID AND B.SETID = D.SETID AND B.EOTP_SERVICEID = D.EOTP_SERVICEID AND (D.EOTP_PROCESS = 'P' OR D.EOTP_PROCESS = 'R') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EOCM_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |