WORKLIST_VW

(SQL View)
Index Back

Worklist View


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

  • Parent record: PSEVENTDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    2 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    3 ROUTENAME Character(30) VARCHAR2(30) NOT NULL Routing Name
    4 ROUTETYPE Number(5,0) INTEGER NOT NULL Routing Type
    5 MAILATTRS Number(10,0) DECIMAL(10) NOT NULL Mail Attributes
    6 POOLEDLIST Number(5,0) INTEGER NOT NULL Pooled List
    7 ALLOWMULTIUNWRKD Number(5,0) INTEGER NOT NULL Allow Multi Unworked Entries?
    8 SHOWENTRIES Number(5,0) INTEGER NOT NULL Show Entries
    9 CACHEWORKLIST Number(5,0) INTEGER NOT NULL Cache WorkLists
    10 WORKEDWHEN Number(5,0) INTEGER NOT NULL Mark Worked When
    11 WLRECNAME Character(15) VARCHAR2(15) NOT NULL WorkList Record Name
    12 WORKEDBYACTIVITY Character(30) VARCHAR2(30) NOT NULL Worked By Activity
    13 TIMEOUTACTIVE Number(5,0) INTEGER NOT NULL Time Out Active
    14 TIMEOUTEMAILSUPR Number(5,0) INTEGER NOT NULL Time Out Email Supr
    15 TIMEOUTEMAILOPR Number(5,0) INTEGER NOT NULL Time Out Email Opr
    16 TIMEOUTWLOPR Number(5,0) INTEGER NOT NULL Time Out Wl Opr
    17 TIMEOUTMAXDAYS Number(5,0) INTEGER NOT NULL Time Out Max Days
    18 TIMEOUTMAXHRS Number(5,0) INTEGER NOT NULL Time Out Max Hours
    19 TIMEOUTMAXMINS Number(5,0) INTEGER NOT NULL Time Out Max Minutes
    20 MAPFIELDCNT Number(5,0) INTEGER NOT NULL Mapping Field Count
    21 MAPEXPRCNT Number(5,0) INTEGER NOT NULL Mapping Expression Count
    22 MAPRECFIELDCNT Number(5,0) INTEGER NOT NULL Mapping Record Field Count
    23 MAPROLENAMECNT Number(5,0) INTEGER NOT NULL Mapping Role Name Count
    24 MAPLEVELCNT Number(5,0) INTEGER NOT NULL Mapping Level Count