SCC_TMPL_IDSCC_TMPL_OBJ_ID10=Editable
20=Display Only
30=Invisible
40=Label Only
SCC_TMPL_ERR_VW(SQL View) |
Index Back |
|---|
| SELECT A.SCC_TMPL_ID , B.SCC_TMPL_OBJ_ID , B.SCC_TMPL_SECT_ID , B.SCC_TMPL_PAGE_ID , A.SCC_TMPL_PAGE_NAME , B.SCC_TMPL_DSPSTATUS , C.SCC_TMPL_LBL , D.LBLTEXT , B.SCC_TMPL_LBL , E.LBLTEXT FROM PS_SCC_TMPL_PAGE A , PS_SCC_TML_PSC_FLD B , PS_SCC_TML_PG_SECT C , PS_SCC_TML_TP_SECT D , PS_SCC_TMPL_TP_OBJ E , PS_SCC_TMPL G WHERE A.SCC_TMPL_PAGE_ID=C.SCC_TMPL_PAGE_ID AND A.SCC_TMPL_PAGE_ID=B.SCC_TMPL_PAGE_ID AND B.SCC_TMPL_SECT_ID=C.SCC_TMPL_SECT_ID AND A.SCC_TMPL_TP_PG_ID=D.SCC_TMPL_TP_PG_ID AND C.SCC_TMPL_SECT_ID=D.SCC_TMPL_SECT_ID AND B.SCC_TMPL_OBJ_ID=E.SCC_TMPL_OBJ_ID AND B.SCC_TMPL_SECT_ID=E.SCC_TMPL_SECT_ID AND A.SCC_TMPL_TP_PG_ID=E.SCC_TMPL_TP_PG_ID AND A.SCC_TMPL_ID=G.SCC_TMPL_ID AND G.SCC_TMPL_TYPE_ID=D.SCC_TMPL_TYPE_ID AND G.SCC_TMPL_TYPE_ID=E.SCC_TMPL_TYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TMPL_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Template ID |
| 2 | SCC_TMPL_OBJ_ID |
Character(34) | VARCHAR2(34) NOT NULL | Template Object |
| 3 | SCC_TMPL_SECT_ID | Character(34) | VARCHAR2(34) NOT NULL | Template Section |
| 4 | SCC_TMPL_PAGE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Page ID |
| 5 | SCC_TMPL_PAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name |
| 6 | SCC_TMPL_DSPSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Display Status
10=Editable 20=Display Only 30=Invisible 40=Label Only |
| 7 | SCC_TMPL_SECT_LBL1 | Character(60) | VARCHAR2(60) NOT NULL | Section Label |
| 8 | SCC_TMPL_SECT_LBL2 | Character(60) | VARCHAR2(60) NOT NULL | Section Label |
| 9 | SCC_TMPL_LBL | Character(60) | VARCHAR2(60) NOT NULL | New Label |
| 10 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |