PTAI_LIST_IDPrompt Table: PTAI_LIST
PTAI_MBR_TYPEROLE=Role
USER=User
PTAI_MBR_NAMEPrompt Table: %EDITTABLE
Prompt Table: PTAI_PRIVSETVW
PTAI_LIST_PRVW(SQL View) |
Index Back |
|---|---|
Action Items List PrivilegesAction Items List Privileges View |
| SELECT PTAI_LIST_ID , PTAI_MBR_TYPE , PTAI_MBR_NAME , PTAI_PRIVSET_ID FROM PS_PTAI_LIST_PRIV |
| # | 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_MBR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Action Items - Member Type (Role or User)
ROLE=Role USER=User |
| 3 | PTAI_MBR_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Action Items - Member Name
Prompt Table: %EDITTABLE |
| 4 | PTAI_PRIVSET_ID | Character(30) | VARCHAR2(30) NOT NULL |
Privilege Set ID
Prompt Table: PTAI_PRIVSETVW |