PSWORKLIST_HST

(SQL Table)
 Index Back

Worklist Entry

Worklist history records keyed by archive id and batch number, as well as business process name, activity name, event name, worklist name and instance id

  • Parent record: PSBUSPROCDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

    Prompt Table: PSBUSPROCDEFN

    4 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: ACTIVITY_PROMPT

    5 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

    Prompt Table: PSEVENTDEFN

    6 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

    Prompt Table: WORKLIST_PRMPT

    7 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

    Default Value: 999999999

    8 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    9 ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN

    11 ORIGINATORTYPE Number(5,0) INTEGER NOT NULL Originator Type
    12 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

    Prompt Table: PSOPRDEFN

    13 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
    0=Selected
    1=Open
    2=Worked
    3=Cancelled
    14 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP NOT NULL Datetime worklist instance was made available
    15 INSTSELECTEDDTTM DateTime(26) TIMESTAMP Datetime user selected a worklist entry
    16 INSTWORKEDDTTM DateTime(26) TIMESTAMP Datetime worklist instance was worked by a user
    17 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out
    18 TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
    19 PREVOPRID Character(30) VARCHAR2(30) NOT NULL Previous User ID
    20 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    21 WLDAYSTOSELECT Number(16,7) DECIMAL(15,7) NOT NULL Number of days to select a worklist instance
    22 WLDAYSTOWORK Number(16,7) DECIMAL(15,7) NOT NULL Number of days to work a worklist instance
    23 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    24 DO_REPLICATE_FLAG Character(1) VARCHAR2(1) NOT NULL Do Replicate Flag
    25 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    26 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    27 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
    1=1-High
    2=2-Medium
    3=3-Low