WORKLIST_VW

index back

Worklist View


SELECT ACTIVITYNAME, EVENTNAME, ROUTENAME, ROUTETYPE, MAILATTRS, POOLEDLIST, ALLOWMULTIUNWRKD, SHOWENTRIES, CACHEWORKLIST, WORKEDWHEN, WLRECNAME, WORKEDBYACTIVITY, TIMEOUTACTIVE, TIMEOUT EMAILSUPR, TIMEOUTEMAILOPR, TIMEOUTWLOPR, TIMEOUTMAXDAYS, TIMEOUTMAXHRS, TIMEOUTMAXMINS, MAPFIELDCNT, MAPEXPRCNT, MAPRECFIELDCNT, MAPROLENAMECNT, MAPLEVELCNT FROM PSEVENTROUTE WHERE ROUTETYPE = 3

  • Parent record: PSEVENTDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
    EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
    ROUTENAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
    ROUTETYPENumber(5,0)INTEGER NOT NULLRouting Type
    MAILATTRSNumber(10,0)DECIMAL(10) NOT NULLMail Attributes
    POOLEDLISTNumber(5,0)INTEGER NOT NULLPooled List
    ALLOWMULTIUNWRKDNumber(5,0)INTEGER NOT NULLAllow Multi Unworked Entries?
    SHOWENTRIESNumber(5,0)INTEGER NOT NULLShow Entries
    CACHEWORKLISTNumber(5,0)INTEGER NOT NULLCache WorkLists
    WORKEDWHENNumber(5,0)INTEGER NOT NULLMark Worked When
    WLRECNAMECharacter(15)VARCHAR2(15) NOT NULLWorkList Record Name
    WORKEDBYACTIVITYCharacter(30)VARCHAR2(30) NOT NULLWorked By Activity
    TIMEOUTACTIVENumber(5,0)INTEGER NOT NULLTime Out Active
    TIMEOUTEMAILSUPRNumber(5,0)INTEGER NOT NULLTime Out Email Supr
    TIMEOUTEMAILOPRNumber(5,0)INTEGER NOT NULLTime Out Email Opr
    TIMEOUTWLOPRNumber(5,0)INTEGER NOT NULLTime Out Wl Opr
    TIMEOUTMAXDAYSNumber(5,0)INTEGER NOT NULLTime Out Max Days
    TIMEOUTMAXHRSNumber(5,0)INTEGER NOT NULLTime Out Max Hours
    TIMEOUTMAXMINSNumber(5,0)INTEGER NOT NULLTime Out Max Minutes
    MAPFIELDCNTNumber(5,0)INTEGER NOT NULLMapping Field Count
    MAPEXPRCNTNumber(5,0)INTEGER NOT NULLMapping Expression Count
    MAPRECFIELDCNTNumber(5,0)INTEGER NOT NULLMapping Record Field Count
    MAPROLENAMECNTNumber(5,0)INTEGER NOT NULLMapping Role Name Count
    MAPLEVELCNTNumber(5,0)INTEGER NOT NULLMapping Level Count
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19