EPO_TEMPLATE_IDPrompt Table: EPO_TMPL_DFN_VW
EFFDTDefault Value: %date
TABSET_IDPrompt Table: HCSC_TAB_SET_VW
TAB_IDEPO_TABDTL_VW(SQL View) |
Index Back |
|---|---|
Tabs viewThis view selects tabs for EPO template dropdown list. |
| SELECT EPO_TEMPLATE_ID , EFFDT , TABSET_ID , TAB_ID , TAB_LABEL_TEXT FROM PS_EPO_TAB_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EPO_TEMPLATE_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Objectives Template unique identifier
Prompt Table: EPO_TMPL_DFN_VW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | TABSET_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Tab Identifier ID
Prompt Table: HCSC_TAB_SET_VW |
| 4 | TAB_ID |
Character(12) | VARCHAR2(12) NOT NULL | Folder Tab Identifier |
| 5 | TAB_LABEL_TEXT | Character(20) | VARCHAR2(20) NOT NULL | Tab Label Text |