WF_WORKLIST_VW

Platform	View Text
Default	SELECT a.BUSPROCNAME , a.ACTIVITYNAME , a.EVENTNAME , a.WORKLISTNAME , a.INSTANCEID , a.ACTIONDTTM , a.OPRID , a.ORIGINATORTYPE , a.ORIGINATORID , a.INSTSTATUS , b.instatusdescr , a.INSTAVAILABLEDTTM , a.INSTSELECTEDDTTM , a.INSTWORKEDDTTM , a.TIMEDOUT , a.COMMENTSHORT , a.TRANSACTIONID , a.URL FROM PSWORKLIST a , ps_wf_inststatus b WHERE a.inststatus = b.inststatus

PeopleSoft Field Name	Description
BUSPROCNAME	Business Process Name
ACTIVITYNAME	Name of a Business Process Activity
EVENTNAME	Defines a routing event for PS Workflow
WORKLISTNAME	Worklist Name
INSTANCEID	For a given worklist the unique number of rows in PSWORKLIST
ACTIONDTTM	Datetime action was taken on a worklist
OPRID	A user's ID Prompt Table: OPRDEFN2
ORIGINATORTYPE	Originator Type
ORIGINATORID	Originator Identifier
INSTSTATUS	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
INSTATUSDESCR	Worklist Instance Status
INSTAVAILABLEDTTM	Datetime worklist instance was made available
INSTSELECTEDDTTM	Datetime user selected a worklist entry
INSTWORKEDDTTM	Datetime worklist instance was worked by a user
TIMEDOUT	Timed Out
COMMENTSHORT	Short Comment
TRANSACTIONID	Transaction Identifier
URL	Internet URL (Universal Resource Locator)

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010