WF_MON_SETUP(SQL Table) |
Index Back |
|---|---|
Workflow Monitor Query Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  WF_MON_SETUP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Workflow Monitor Setup ID |
| 2 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 3 | WF_TO_DTTM | DateTime(26) | TIMESTAMP | To Datetime |
| 4 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: WORKLISTNAME_VW |
| 5 | INSTSTATUS | Number(5,0) | INTEGER NOT NULL |
Determines worklist status, available, selected, worked, cancelled
Default Value: 0 Prompt Table: WF_INSTSTATUS |
| 6 | WF_FROM_DTTM | DateTime(26) | TIMESTAMP | From Datetime |
| 7 | WF_BY_OPRID_SW | Character(1) | VARCHAR2(1) NOT NULL |
Total by Individual
Y/N Table Edit Default Value: N |
| 8 | WF_NOTIFY_TRIGGER | Number(8,0) | INTEGER NOT NULL | Notify When Total Exceeds |
| 9 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Default Value: 107 Prompt Table: MESSAGE_SET_VW |
| 10 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 9 Prompt Table: MSG_CAT_VW |
| 11 | WF_NOTIFY_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Notify by Email
Y/N Table Edit Default Value: N |
| 12 | WF_NOTIFY_WL | Character(1) | VARCHAR2(1) NOT NULL |
Notify by Worklist
Y/N Table Edit Default Value: Y |