RDT_TXN_PAGE_VW

(SQL View)
 Index Back

View on RDT_TMPL_PAGE record.

This view is used for the structure to cache the display templates.

SELECT A.DISP_TMPL_ID , A.PNLGRPNAME , A.MARKET , A.PNLNAME , B.HIDDEN_FLG , B.SECONDARY_FLG , A.VISIBLE_FLG , A.DEF_ADD_PAGE_FLG , A.DEF_UPD_PAGE_FLG , B.CONFIG_SEARCH_FLG , B.CFG_SRCH_PNLNAME , A.CFG_SRCH_RECNAME , A.CFG_SRCH_SEQ_NUM FROM PS_RDT_TMPL_PAGE A , PS_RDT_CFG_PAGE B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.PNLNAME = B.PNLNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
4 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
5 HIDDEN_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether something should be hidden
6 SECONDARY_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether something should be hidden
7 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

8 DEF_ADD_PAGE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine if this page is the default for add mode.
N=No
Y=Yes
9 DEF_UPD_PAGE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine if this page is the default for Update mode.
N=No
Y=Yes
10 CONFIG_SEARCH_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether Configurable Search is applicable for the configurable component.

Y/N Table Edit

Default Value: N

11 CFG_SRCH_PNLNAME Character(30) VARCHAR2(30) NOT NULL This field holds the page name associated with the configurable search page.
12 CFG_SRCH_RECNAME Character(15) VARCHAR2(15) NOT NULL This fields holds the record name associated with the configurable search definition.
13 CFG_SRCH_SEQ_NUM Number(3,0) SMALLINT NOT NULL This fields holds the sequence number associated with the configurable search definition.