EP_TABDTL_VW

(SQL View)
Index Back

Tab Label Prompt View

Tab Label Prompt View which is used in Template Section Level

SELECT EP_REVIEW_TYPE , EP_TEMPLATE_ID , EFFDT , TABSET_ID , TAB_ID , TAB_LABEL_TEXT FROM PS_EP_TAB_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type
2 EP_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 TABSET_ID Character(18) VARCHAR2(18) NOT NULL Tab Identifier ID
5 TAB_ID Character(12) VARCHAR2(12) NOT NULL Folder Tab Identifier
6 TAB_LABEL_TEXT Character(20) VARCHAR2(20) NOT NULL Tab Label Text