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 NameField TypeColumn TypeDescription
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLItem Name
PANELITEMNAMECharacter(30)VARCHAR2(30) NOT NULLPanel Item Name
DFLTACTIONNumber(5,0)INTEGER NOT NULLDefault srch action-internet
WLRECNAMECharacter(15)VARCHAR2(15) NOT NULLWorkList Record Name
POOLEDLISTNumber(5,0)INTEGER NOT NULLPooled List
ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
WORKEDBYACTIVITYCharacter(30)VARCHAR2(30) NOT NULLWorked By Activity
EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19