IN_SW_SEL_7_VW

(SQL View)
Index Back

FW: available list of actions

View displaying avaialble list of action for a template id

SELECT TEMPLATE_ID ,IN_TM_CATEGORY ,IN_TM_DFLT_CAT FROM PS_IN_TM_OPR_CAT WHERE IN_TM_CODE = 'SHORT_WRKBENCH'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

Prompt Table: IN_FW_SEL_6_VW

2 IN_TM_CATEGORY Character(15) VARCHAR2(15) NOT NULL Template Category
3 IN_TM_DFLT_CAT Character(1) VARCHAR2(1) NOT NULL Default Category