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 Name Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

Prompt Table: PSBUSPROCDEFN

ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

Prompt Table: PSACTIVITYDEFN

EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

Prompt Table: PSEVENTDEFN

WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

Prompt Table: WORKLIST_PRMPT

WLRECNAME Character(15) VARCHAR2(15) NOT NULL WorkList Record Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19