OPRIDM=Member Users
Z=All Users
PTAI_ASSGN_VW |
index back |
|---|---|
Action Items Assign to Search |
| SELECT B.OPRID , B.OPRDEFNDESC , C.PTAI_LIST_ID , %Substring(A.FIELDVALUE, 1, 1) FROM PSXLATITEM A , PSOPRDEFN B , PS_PTAI_LIST C WHERE A.FIELDNAME = 'PTAI_USER_TYPE' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| 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 |
| 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 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |