PSEVENTROUTE(SQL Table) |
Index Back |
---|---|
Event Routing |
# | 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 |