OPRIDM=Member Users
Z=All Users
PTAI_ASSGN_VW(SQL View) |
Index Back |
|---|---|
Action Items Assign to SearchAction Items Lists Assign to Search View |
| 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 4 | PTAI_USER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Items - User Type
M=Member Users Z=All Users |