PTAI_LIST_IDPrompt Table: PTAI_LIST
PTAI_MBR_TYPEROLE=Role
USER=User
PTAI_MBR_NAMEPrompt Table: %EDITTABLE
Prompt Table: PTAI_PRIVSETVW
PTAI_LIST_PRVW |
index back |
|---|---|
Action Items List Privileges |
| SELECT PTAI_LIST_ID , PTAI_MBR_TYPE , PTAI_MBR_NAME , PTAI_PRIVSET_ID FROM PS_PTAI_LIST_PRIV |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTAI_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL |
Action Items - Action Item List ID
Prompt Table: PTAI_LIST |
| PTAI_MBR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Action Items - Member Type (Role or User)
ROLE=Role USER=User |
| PTAI_MBR_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Action Items - Member Name
Prompt Table: %EDITTABLE |
| PTAI_PRIVSET_ID | Character(30) | VARCHAR2(30) NOT NULL |
Privilege Set ID
Prompt Table: PTAI_PRIVSETVW |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |