DISP_TMPL_FAM_CDPNLGRPNAMERC_BU_COMP_VW(SQL View) |
Index Back |
|---|---|
Call Center Case ComponentsThis is a display template view of all industries for Case component. |
| SELECT DISTINCT B.DISP_TMPL_FAM_CD , A.PNLGRPNAME FROM PS_RDT_TMPL_COMP A , PS_RDT_TMPL_DEFN B WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID AND A.PNLGRPNAME IN ('RC_CASE','RC_CASE_HD', 'RC_CASE_HD_SS', 'RC_CASE_HD_SS_RPT', 'RC_CASE_SW', 'RC_CASE_SW_SS', 'RC_CASE_SW_SS_RPT', 'RC_CASE_SS','RC_SS_CCASE_FL','RC_SS_MCASE_HHD_FL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISP_TMPL_FAM_CD |
Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 2 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |