SDB_TMPL_DEF_VW

(SQL View)
Index Back

Display Template View

used to load display template description to contact center dashboard.

SELECT A.DISP_TMPL_ID , A.DESCR30 , B.LIC_PROD_CD FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_OPT B WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID AND B.PNLGRPNAME = 'RC_CASE'

# 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 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
3 LIC_PROD_CD Character(18) VARCHAR2(18) NOT NULL Licensed product code for the configurable component.