RDT_TMPLCMPVW3L(SQL View) |
Index Back |
|---|---|
Configured Components ViewThis view is the search view for the Display Template Details component. |
| SELECT B.DISP_TMPL_ID , B.PNLGRPNAME , B.MARKET , A.LANGUAGE_CD , A.DESCR30 FROM PS_RDT_TMPL_DEFN_L A , PS_RDT_TMPL_COMP B , PS_RDT_TMPL_DEFN D WHERE D.DISP_TMPL_ID = A.DISP_TMPL_ID AND B.DISP_TMPL_ID = A.DISP_TMPL_ID |
| # | 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 | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: RDT_CFG_COMP_VW |
|
| 3 | Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
|
| 4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 5 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |