PTAFAW_WL_OPRVW

Platform	View Text
Default	SELECT A.BUSPROCNAME ,A.ACTIVITYNAME ,A.EVENTNAME ,A.WORKLISTNAME , B.PTAFPRCS_ID , B.PTAFTHREAD_ID ,A.INSTANCEID , A.TRANSACTIONID , A.OPRID , A.PREVOPRID FROM PSWORKLIST A , PS_PTAFAW_WL 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 AND A.INSTSTATUS IN (0,1)

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
PTAFPRCS_ID	Approval Process ID
PTAFTHREAD_ID	Thread ID
INSTANCEID	For a given worklist the unique number of rows in PSWORKLIST
TRANSACTIONID	Transaction Identifier
OPRID	A user's ID
PREVOPRID	Previous User ID

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