WORKLIST_VW2

Platform

View Text

Default

SELECT A.INSTANCEID, B.BUSPROCNAME, B.ACTIVITYNAME, B.EVENTNAME, B.WORKLISTNAME, B.INSTANCEID, B.TRANSACTIONID, B.ACTIONDTTM, B.OPRID, B.ORIGINATORTYPE, B.ORIGINATORID, B.INSTSTATUS, B.IN STAVAILABLEDTTM, B.INSTSELECTEDDTTM, B.INSTWORKEDDTTM, B.INSTTIMEOUTDTTM, B.TIMEDOUT, B.PREVOPR ID, B.COMMENTSHORT, B.WLDAYSTOSELECT, B.WLDAYSTOWORK FROM PSWORKLIST A, PSWORKLIST B WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID <> B.INSTANCEID

PeopleSoft Field Name	Description
INSTANCEID_A	WL Instance ID
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
TRANSACTIONID	Transaction Identifier
ACTIONDTTM	Datetime action was taken on a worklist
OPRID	A user's ID
ORIGINATORTYPE	Originator Type
ORIGINATORID	Originator Identifier
INSTSTATUS	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
INSTAVAILABLEDTTM	Datetime worklist instance was made available
INSTSELECTEDDTTM	Datetime user selected a worklist entry
INSTWORKEDDTTM	Datetime worklist instance was worked by a user
INSTTIMEOUTDTTM	Datetime that a worklist times out
TIMEDOUT	Timed Out
PREVOPRID	Previous User ID
COMMENTSHORT	Short Comment
WLDAYSTOSELECT	Number of days to select a worklist instance
WLDAYSTOWORK	Number of days to work a worklist instance

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