PTAI_ASSIGN_ROLEPTAI_UROLE_VW(SQL View) |
Index Back |
|---|
| SELECT PLP.PTAI_MBR_NAME ,R.DESCR ,PLP.PTAI_LIST_ID FROM PS_PTAI_LIST_PRIV PLP ,PS_PTAI_LIST PL , PSROLEDEFN R WHERE PLP.PTAI_MBR_TYPE = 'ROLE' AND PLP.PTAI_PRIVSET_ID = 'PTAI_CONTRIBUTOR' AND PLP.PTAI_LIST_ID=PL.PTAI_LIST_ID AND PLP.PTAI_MBR_NAME=R.ROLENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_ASSIGN_ROLE |
Character(30) | VARCHAR2(30) NOT NULL | Role |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |