BUSINESS_UNITDISP_TMPL_FAM_CDDISP_TMPL_IDRDT_TMPL_DFN2VW(SQL View) |
Index Back |
|---|---|
Display Template Family ViewThis view returns valid Dispaly Template families for a given business unit. |
| SELECT A.BUSINESS_UNIT , A.DISP_TMPL_FAM_CD , B.DISP_TMPL_ID , B.DESCR30 FROM PS_BUS_UNIT_RC_RDT A , PS_RDT_TMPL_DEFN B WHERE B.DISP_TMPL_ID = A.DISP_TMPL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DISP_TMPL_FAM_CD |
Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 3 | DISP_TMPL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |