BUSPROCNAMEWF_WL_DEFN_VW(SQL View) |
Index Back |
|---|---|
Worklist Defn View |
| SELECT C.OBJNAME , B.ROUTENAME , A.MENUNAME , A.BARNAME , A.ITEMNAME , A.PANELITEMNAME , A.DFLTACTION , B.WLRECNAME , B.POOLEDLIST , B.ACTIVITYNAME , B.WORKEDBYACTIVITY , B.EVENTNAME FROM PSSTEPDEFN A , PSEVENTROUTE B , PSBUSPROCITEM C WHERE A.ACTIVITYNAME = B.WORKEDBYACTIVITY AND A.STEPNO = 1 AND A.PATHNO = 1 AND C.OBJTYPE = 0 AND C.COMPTYPE = 5 AND B.ROUTETYPE = 3 AND C.COMPNAME = B.ACTIVITYNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 2 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 3 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 4 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 5 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 6 | PANELITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |
| 7 | DFLTACTION | Number(5,0) | INTEGER NOT NULL | Default srch action-internet |
| 8 | WLRECNAME | Character(15) | VARCHAR2(15) NOT NULL | WorkList Record Name |
| 9 | POOLEDLIST | Number(5,0) | INTEGER NOT NULL | Pooled List |
| 10 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 11 | WORKEDBYACTIVITY | Character(30) | VARCHAR2(30) NOT NULL | Worked By Activity |
| 12 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |