FE_WORKLIST_SRC (SQL View)	Index Back
Fed eApps Worklist Search This view is identical to WORKLIST_SEARCH, but used the WORKLIST_EVENT field in place of EVENTNAME. It returns all WORKLISTNAMEs associated with a given bus proc, activity, and event.

FE_WORKLIST_SRC

(SQL View)

Fed eApps Worklist Search

This view is identical to WORKLIST_SEARCH, but used the WORKLIST_EVENT field in place of EVENTNAME. It returns all WORKLISTNAMEs associated with a given bus proc, activity, and event.

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 PeopleSoft Field Type Database Column Type Description

1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN

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

3 WORKLIST_EVENT Character(30) VARCHAR2(30) NOT NULL Worklist Event

4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
Prompt Table: WORKLIST_PRMPT

5 WLRECNAME Character(15) VARCHAR2(15) NOT NULL WorkList Record Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: PSBUSPROCDEFN
2	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN). Prompt Table: PSACTIVITYDEFN
3	WORKLIST_EVENT	Character(30)	VARCHAR2(30) NOT NULL	Worklist Event
4	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name Prompt Table: WORKLIST_PRMPT
5	WLRECNAME	Character(15)	VARCHAR2(15) NOT NULL	WorkList Record Name