SCC_TM_LIST_IDPrompt Table: SCC_TM_PTAILIST
SCC_TM_PTAIMBRTYPEROLE=Role
USER=User
SCC_TM_PTAIMBRNAMESCC_TM_PTAILPRV(SQL View) |
Index Back |
|---|---|
ptai privilege set |
| SELECT ptai_list_id , ptai_mbr_type , ptai_mbr_name , ptai_privset_id FROM %Table(ptai_list_priv) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TM_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL |
Template ID
Prompt Table: SCC_TM_PTAILIST |
| 2 | SCC_TM_PTAIMBRTYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Member Type
ROLE=Role USER=User |
| 3 | SCC_TM_PTAIMBRNAME |
Character(30) | VARCHAR2(30) NOT NULL | Member Name |
| 4 | SCC_TM_PTAIPRIVID | Character(30) | VARCHAR2(30) NOT NULL | Privilege Set ID |