PSWORKLIST

index back

Worklist Entry


  • Parent record: PSBUSPROCDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).

    Prompt Table: PSBUSPROCDEFN

    ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: ACTIVITY_PROMPT

    EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow

    Prompt Table: PSEVENTDEFN

    WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name

    Prompt Table: WORKLIST_PRMPT

    INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST

    Default: 999999999

    TRANSACTIONIDNumber(10,0)DECIMAL(10) NOT NULLTransaction Identifier
    ACTIONDTTMDateTime(26)TIMESTAMPDatetime action was taken on a worklist
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN

    ORIGINATORTYPENumber(5,0)INTEGER NOT NULLOriginator Type
    ORIGINATORIDCharacter(30)VARCHAR2(30) NOT NULLOriginator Identifier

    Prompt Table: PSOPRDEFN

    INSTSTATUSNumber(5,0)INTEGER NOT NULLDetermines worklist status, available, selected, worked, cancelled
    INSTAVAILABLEDTTMDateTime(26)TIMESTAMP NOT NULLDatetime worklist instance was made available
    INSTSELECTEDDTTMDateTime(26)TIMESTAMPDatetime user selected a worklist entry
    INSTWORKEDDTTMDateTime(26)TIMESTAMPDatetime worklist instance was worked by a user
    INSTTIMEOUTDTTMDateTime(26)TIMESTAMPDatetime that a worklist times out
    TIMEDOUTNumber(5,0)INTEGER NOT NULLTimed Out
    PREVOPRIDCharacter(30)VARCHAR2(30) NOT NULLPrevious User ID
    COMMENTSHORTCharacter(30)VARCHAR2(30) NOT NULLShort Comment
    WLDAYSTOSELECTNumber(16,7)DECIMAL(15,7) NOT NULLNumber of days to select a worklist instance
    WLDAYSTOWORKNumber(16,7)DECIMAL(15,7) NOT NULLNumber of days to work a worklist instance
    URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
    DO_REPLICATE_FLAGCharacter(1)VARCHAR2(1) NOT NULLDo Replicate Flag
    SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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_PRIORITYCharacter(1)VARCHAR2(1) NOT NULLWorklist Priority
    1=1-High
    2=2-Medium
    3=3-Low
    DESCR254_MIXEDCharacter(254)VARCHAR2(254) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19