TMPLT_IDY=System Maintained
EM_PV_TMPL_SVW(SQL View) |
Index Back |
|---|
| SELECT TMPLT_ID , DESCR100 , SYSTEM_TEMPLATE FROM PS_PV_TMPL WHERE BATCH_TYPE = 'EMIN' AND TMPLT_ID <> 'PRIM_TMPLT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TMPLT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | SYSTEM_TEMPLATE | Character(1) | VARCHAR2(1) NOT NULL |
Used in ChartField Display Template
Y=System Maintained |