PSEVENTROUTE

(SQL Table)
Index Back

Event Routing

  • 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 REASSIGNABLE Number(5,0) INTEGER NOT NULL Reassignable
    12 WLRECNAME Character(15) VARCHAR2(15) NOT NULL WorkList Record Name
    13 WORKEDBYBUSPROC Character(30) VARCHAR2(30) NOT NULL Worked By Business Process
    14 WORKEDBYACTIVITY Character(30) VARCHAR2(30) NOT NULL Worked By Activity
    15 TIMEOUTACTIVE Number(5,0) INTEGER NOT NULL Time Out Active
    16 TIMEOUTEMAILSUPR Number(5,0) INTEGER NOT NULL Time Out Email Supr
    17 TIMEOUTEMAILOPR Number(5,0) INTEGER NOT NULL Time Out Email Opr
    18 TIMEOUTWLOPR Number(5,0) INTEGER NOT NULL Time Out Wl Opr
    19 TIMEOUTMAXDAYS Number(5,0) INTEGER NOT NULL Time Out Max Days
    20 TIMEOUTMAXHRS Number(5,0) INTEGER NOT NULL Time Out Max Hours
    21 TIMEOUTMAXMINS Number(5,0) INTEGER NOT NULL Time Out Max Minutes
    22 MAPFIELDCNT Number(5,0) INTEGER NOT NULL Mapping Field Count
    23 MAPEXPRCNT Number(5,0) INTEGER NOT NULL Mapping Expression Count
    24 MAPRECFIELDCNT Number(5,0) INTEGER NOT NULL Mapping Record Field Count
    25 MAPROLENAMECNT Number(5,0) INTEGER NOT NULL Mapping Role Name Count
    26 MAPLEVELCNT Number(5,0) INTEGER NOT NULL Mapping Level Count