WF_WORKLIST_VW2

index back

Tools Worklist View


SELECT BUSPROCNAME , WORKLISTNAME ,ACTIVITYNAME , INSTANCEID , ACTIONDTTM , OPRID , ORIGINATORTYPE , ORIGINATORID , INSTSTATUS , INSTAVAILABLEDTTM , INSTSELECTEDDTTM , INSTWORKEDDTTM , TIMEDOUT , COMMENTSHORT , TRANSACTIONID , PREVOPRID , DO_REPLICATE_FLAG , URL FROM psworklist

PeopleSoft Field NameField TypeColumn TypeDescription
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST
ACTIONDTTMDateTime(26)TIMESTAMPDatetime action was taken on a worklist
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: ROLEXLATOPR

ORIGINATORTYPENumber(5,0)INTEGER NOT NULLOriginator Type
ORIGINATORIDCharacter(30)VARCHAR2(30) NOT NULLOriginator Identifier
INSTSTATUSNumber(5,0)INTEGER NOT NULLDetermines worklist status, available, selected, worked, cancelled
INSTAVAILABLEDTTMDateTime(26)TIMESTAMPDatetime worklist instance was made available
INSTSELECTEDDTTMDateTime(26)TIMESTAMPDatetime user selected a worklist entry
INSTWORKEDDTTMDateTime(26)TIMESTAMPDatetime worklist instance was worked by a user
TIMEDOUTNumber(5,0)INTEGER NOT NULLTimed Out
COMMENTSHORTCharacter(30)VARCHAR2(30) NOT NULLShort Comment
TRANSACTIONIDNumber(10,0)DECIMAL(10) NOT NULLTransaction Identifier
PREVOPRIDCharacter(30)VARCHAR2(30) NOT NULLPrevious User ID
DO_REPLICATE_FLAGCharacter(1)VARCHAR2(1) NOT NULLDo Replicate Flag
URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19