PTPN_CATEGORY_NAMEPrompt Table: PSPTPN_CAT_TBL
OBJECTOWNERIDPTPN_BUSPROCNAMEPTPN_ACTIVITYNAMEPTPN_EVENTNAME1PTPN_WORKLISTNAMEPTPN_TBE_CFG_1 |
index back |
|---|---|
TBE Configuration View |
| SELECT DISTINCT E.PTPN_CATEGORY_NAME AS PTPN_CATEGORY_NAME , E.OBJECTOWNERID AS OBJECTOWNERID , B.OBJNAME AS ptpn_busprocname , B.compname AS ptpn_activityname , R.eventname AS ptpn_eventname1 , R.ROUTENAME AS ptpn_worklistname FROM PSACTIVITYDEFN A , psbusprocitem B , PSEVENTROUTE R , PS_PTPN_PDT_OWNERV E WHERE A.ACTIVITYNAME = B.COMPNAME AND R.ACTIVITYNAME = B.COMPNAME AND B.OBJTYPE=0 AND (E.objectownerid = A.objectownerid) AND R.ROUTETYPE=3 AND A.ACTVALID != 9 |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTPN_CATEGORY_NAME |
Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: PSPTPN_CAT_TBL |
| OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier translate values |
| PTPN_BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name |
| PTPN_ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity |
| PTPN_EVENTNAME1 |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| PTPN_WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |