DISP_TMPL_FAM_CDSETIDEOCF_CONTEXT_IDDISP_TMPL_IDRC_TMPL_ACTN_VW(SQL View) |
Index Back |
|---|---|
Display Template prompt viewDisplay Template prompt view used in Case Display Template AAF action configuration. |
| SELECT DISTINCT b.DISP_TMPL_FAM_CD , c.SETID , d.EOCF_CONTEXT_ID , a.DISP_TMPL_ID , b.DESCR30 FROM PS_BUS_UNIT_RC_RDT a , PS_RDT_TMPL_DEFN b , PS_SET_CNTRL_GROUP c , PS_EOCF_CONTEXT d , PS_RDT_TMPL_COMP e WHERE a.DISP_TMPL_ID = b.DISP_TMPL_ID AND a.BUSINESS_UNIT = c.SETCNTRLVALUE AND c.REC_GROUP_ID = 'EOCF01' AND a.DISP_TMPL_ID = e.DISP_TMPL_ID AND d.PNLGRPNAME = e.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 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |