PTAFAW_WL_OPRVW

index back

Active Approval Worklist View

Where status is not "Cancelled" or "Worked"
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 Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
PTAFTHREAD_ID Number(10,0) DECIMAL(10) NOT NULL Thread ID
INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PREVOPRID Character(30) VARCHAR2(30) NOT NULL Previous User ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19