RDT_TMPLDFNCVWL(SQL View) |
Index Back |
---|---|
Display Template ViewThis related language view returns all display templates assigned to a particular family. |
SELECT A.DISP_TMPL_FAM_CD , A.DISP_TMPL_ID , B.LANGUAGE_CD , B.DESCR30 FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_DEFN_L B WHERE B.DISP_TMPL_ID = A.DISP_TMPL_ID |
# | 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 | DISP_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |