RDT_TMPL_VW

(SQL View)
 Index Back

View for diplay template

View used by display template processing of page name, display template family and display template

SELECT A.PNLNAME , C.DISP_TMPL_FAM_CD , D.DISP_TMPL_ID FROM PS_RDT_TMPL_DEFN C , PS_RDT_TMPL_COMP D , PS_RDT_TMPL_PAGE A WHERE D.DISP_TMPL_ID = C.DISP_TMPL_ID AND D.MARKET = 'GBL' AND A.DISP_TMPL_ID = D.DISP_TMPL_ID AND A.PNLGRPNAME = D.PNLGRPNAME AND A.MARKET = D.MARKET AND D.DEFAULT_FLAG = 'Y' AND A.DEF_UPD_PAGE_FLG ='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
2 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
3 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.