PTAI_NOTIFY_USERPTAI_RUSER_VW(SQL View) |
Index Back |
|---|
| SELECT PLP.PTAI_MBR_NAME ,U.OPRDEFNDESC ,PLP.PTAI_LIST_ID FROM PS_PTAI_LIST_PRIV PLP ,PS_PTAI_LIST PL , PSOPRDEFN U WHERE PLP.PTAI_MBR_TYPE = 'USER' AND PLP.PTAI_PRIVSET_ID = 'PTAI_CONTRIBUTOR' AND PLP.PTAI_LIST_ID=PL.PTAI_LIST_ID AND PLP.PTAI_MBR_NAME=U.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_NOTIFY_USER |
Character(30) | VARCHAR2(30) NOT NULL | User |
| 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 |