PV_TEMPL_PER_V2(SQL View) |
Index Back |
|---|---|
Template ViewTemplate View |
| SELECT DISTINCT A.PV_TEMPLATE , A.DESCR254_MIXED ,'PER' , A.REQUESTOR_ID , A.ITM_SETID , B.DESCRIPTION FROM PS_PV_TEMPL_ITEMS A , PS_PV_TEMPLATES B WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND A.PV_TEMPLATE = B.PV_TEMPLATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEMPLATE_DESC | Character(30) | VARCHAR2(30) NOT NULL | Template Description |
| 2 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 3 | PV_TEMPL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
KIT=Company Templates PER=Templates |
| 4 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | DESCRIPTION | Character(35) | VARCHAR2(35) NOT NULL | DESCRIPTION |