WORKLIST_SEARCH

index back

SELECT A.OBJNAME , A.COMPNAME , B.EVENTNAME , B.ROUTENAME , B.WLRECNAME FROM PSBUSPROCITEM A , PSEVENTROUTE B WHERE A.COMPNAME = B.ACTIVITYNAME AND A.OBJTYPE = 0 AND B.ROUTETYPE = 3

PeopleSoft Field NameField TypeColumn TypeDescription
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).

Prompt Table: PSBUSPROCDEFN

ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).

Prompt Table: PSACTIVITYDEFN

EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow

Prompt Table: PSEVENTDEFN

WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name

Prompt Table: WORKLIST_PRMPT

WLRECNAMECharacter(15)VARCHAR2(15) NOT NULLWorkList Record Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19