PTAI_LIST_IDPrompt Table: PTAI_LIST
PTAI_MBR_TYPEROLE=Role
USER=User
PTAI_MBR_NAMEPrompt Table: %EDITTABLE
Prompt Table: PTAI_PRIVSETVW
PTAI_ITEM_PRIV(SQL Table) |
Index Back |
|---|---|
Action Items List Privileges |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL |
Action Items - Action Item List ID
Prompt Table: PTAI_LIST |
| 2 | PTAI_ITEM_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 3 | PTAI_MBR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Action Items - Member Type (Role or User)
ROLE=Role USER=User |
| 4 | PTAI_MBR_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Action Items - Member Name
Prompt Table: %EDITTABLE |
| 5 | PTAI_PRIVSET_ID | Character(30) | VARCHAR2(30) NOT NULL |
Privilege Set ID
Prompt Table: PTAI_PRIVSETVW |