WORKLIST_VW2

index back

Worklist Entry View


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.PREVOPRID, 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

  • Parent record: PSBUSPROCDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    INSTANCEID_A Number(10,0) DECIMAL(10) NOT NULL WL Instance ID
    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
    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
    ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    ORIGINATORTYPE Number(5,0) INTEGER NOT NULL Originator Type
    ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
    INSTAVAILABLEDTTM DateTime(26) TIMESTAMP NOT NULL Datetime worklist instance was made available
    INSTSELECTEDDTTM DateTime(26) TIMESTAMP Datetime user selected a worklist entry
    INSTWORKEDDTTM DateTime(26) TIMESTAMP Datetime worklist instance was worked by a user
    INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out
    TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
    PREVOPRID Character(30) VARCHAR2(30) NOT NULL Previous User ID
    COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    WLDAYSTOSELECT Number(16,7) DECIMAL(15,7) NOT NULL Number of days to select a worklist instance
    WLDAYSTOWORK Number(16,7) DECIMAL(15,7) NOT NULL Number of days to work a worklist instance
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19