SDB_TMPL_DEF_VW(SQL View) |
Index Back |
---|---|
Display Template Viewused 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. |