PSWORKLIST

index back

Worklist Entry


  • Parent record: PSBUSPROCDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

    Prompt Table: PSBUSPROCDEFN

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

    Prompt Table: ACTIVITY_PROMPT

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

    Prompt Table: PSEVENTDEFN

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

    Prompt Table: WORKLIST_PRMPT

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

    Default: 999999999

    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).

    Prompt Table: PSOPRDEFN

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

    Prompt Table: PSOPRDEFN

    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
    URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    DO_REPLICATE_FLAG Character(1) VARCHAR2(1) NOT NULL Do Replicate Flag
    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.
    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.
    WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
    1=1-High
    2=2-Medium
    3=3-Low
    DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20