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 | 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. |