SETIDPrompt Table: SP_SETID_NONVW
TEMPLATE_LIST_IDUSERIDPrompt Table: PSOPRDEFN_SRCH
ROLENAMEPrompt Table: IN_TM_ROLEDF_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
ITM_TML_LST_SEC(SQL Table) |
Index Back |
|---|---|
Template Permissions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | TEMPLATE_LIST_ID |
Character(20) | VARCHAR2(20) NOT NULL | Item Template List ID |
| 3 | USERID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: PSOPRDEFN_SRCH |
| 4 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: IN_TM_ROLEDF_VW |
| 5 | IN_TM_MAINTAIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Maintain Flag
Y/N Table Edit Default Value: N |
| 6 | IN_TM_CHANGE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Change Item
Y/N Table Edit Default Value: N |
| 7 | IN_TM_ADD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Add Item
Y/N Table Edit Default Value: Y |