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 NameField TypeColumn TypeDescription
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
PTAFTHREAD_IDNumber(10,0)DECIMAL(10) NOT NULLThread ID
INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST
TRANSACTIONIDNumber(10,0)DECIMAL(10) NOT NULLTransaction Identifier
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PREVOPRIDCharacter(30)VARCHAR2(30) NOT NULLPrevious User ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19