DISP_TMPL_FAM_CDSETIDEOCF_CONTEXT_IDDISP_TMPL_IDLANGUAGE_CDRC_TMPL_ACT_LNG(SQL View) |
Index Back |
|---|---|
Display Template prompt viewRelated Language Display Template prompt view used in Case Display Template AAF action configuration. |
| SELECT DISTINCT b.DISP_TMPL_FAM_CD , c.SETID , e.EOCF_CONTEXT_ID , a.DISP_TMPL_ID , d.LANGUAGE_CD , d.DESCR30 FROM PS_BUS_UNIT_RC_RDT a , PS_RDT_TMPL_DEFN b , PS_SET_CNTRL_GROUP c , PS_RDT_TMPL_DEFN_L d , PS_EOCF_CONTEXT e , PS_RDT_TMPL_COMP f WHERE a.DISP_TMPL_ID = b.DISP_TMPL_ID AND b.DISP_TMPL_ID = d.DISP_TMPL_ID AND a.BUSINESS_UNIT = c.SETCNTRLVALUE AND c.REC_GROUP_ID = 'EOCF01' AND a.DISP_TMPL_ID = f.DISP_TMPL_ID AND e.PNLGRPNAME = f.PNLGRPNAME |
| # | 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 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | EOCF_CONTEXT_ID |
Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context |
| 4 | DISP_TMPL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |