CONTENTIDPRCSINSTANCEOPRID2=User ID
3=Role Name
CDM_AUTH_R_VW |
index back |
|---|---|
Content Dist Mgr - Role Access |
| SELECT DISTINCT A.CONTENTID , A.PRCSINSTANCE , B.OPRID , ' ' , ' ' FROM PS_CDM_AUTH A , PS_ROLEUSER_VW B WHERE A.DISTIDTYPE = '3' AND A.DISTID = B.ROLENAME |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| CONTENTID |
Number(15,0) | DECIMAL(15) NOT NULL | Report ID |
| PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| DISTID | Character(30) | VARCHAR2(30) NOT NULL | Distribution ID |
| DISTIDTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Distribution ID Type
2=User ID 3=Role Name |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |