BUSPROCNAMEACTIVITYNAMEEVENTNAMEWORKLISTNAMEINSTANCEIDTRANSACTIONIDGEN_MSG_PRIORITY1=High
2=Medium
3=Low
DTTM_CREATEDGEN_MSG_WL |
index back |
|---|---|
Generic Message Worklist |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| GEN_MSG_PRIORITY |
Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=High 2=Medium 3=Low |
| DTTM_CREATED |
DateTime(26) | TIMESTAMP | Datetime Created |
| FROM_ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | From Roleuser |
| EMAIL_SUBJECT | Character(30) | VARCHAR2(30) NOT NULL | Subject of the email |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |