PTPN_CATEGORY_NAMEPrompt Table: PSPTPN_CAT_TBL
OBJECTOWNERIDPTPN_BUSPROCNAMEPTPN_ACTIVITYNAMEPTPN_EVENTNAME1PTPN_WORKLISTNAMEPTPN_TBE_CFG_1(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPN_CATEGORY_NAME |
Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: PSPTPN_CAT_TBL |
| 2 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 3 | PTPN_BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name |
| 4 | PTPN_ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity |
| 5 | PTPN_EVENTNAME1 |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 6 | PTPN_WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |