PTAI_LIST_IDPTAI_USER_TYPEM=Member Users
Z=All Users
OPRIDPTAI_ASSGN_PVW |
index back |
|---|---|
Action Items Assignee Search |
| SELECT A.PTAI_LIST_ID , A.PTAI_USER_TYPE , A.OPRID , A.OPRDEFNDESC FROM PS_PTAI_ASSGN_VW A WHERE A.PTAI_USER_TYPE = 'Z' OR (A.PTAI_USER_TYPE = 'M' AND EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV B WHERE B.PTAI_LIST_ID = A.PTAI_LIST_ID AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = A.OPRID AND ((B.PTAI_MBR_TYPE = 'USER' AND B.PTAI_MBR_NAME = X.ROLEUSER) OR (B.PTAI_MBR_TYPE = 'ROLE' AND B.PTAI_MBR_NAME = X.ROLENAME))))) |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTAI_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| PTAI_USER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Action Items - User Type
M=Member Users Z=All Users |
| OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |