WF_WL_DEFN_VW

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 Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
DFLTACTION Number(5,0) INTEGER NOT NULL Default srch action-internet
WLRECNAME Character(15) VARCHAR2(15) NOT NULL WorkList Record Name
POOLEDLIST Number(5,0) INTEGER NOT NULL Pooled List
ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
WORKEDBYACTIVITY Character(30) VARCHAR2(30) NOT NULL Worked By Activity
EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19