WF_MON_SETUP

index back

Workflow Monitor Query Setup


PeopleSoft Field Name Field Type Column Type Description
WF_MON_SETUP_ID Character(30) VARCHAR2(30) NOT NULL Workflow Monitor Setup ID
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

Prompt Table: BUSPROCNAME_VW

WF_TO_DTTM DateTime(26) TIMESTAMP To Datetime
WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

Prompt Table: WORKLISTNAME_VW

INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled

Default: 0

Prompt Table: WF_INSTSTATUS

WF_FROM_DTTM DateTime(26) TIMESTAMP From Datetime
WF_BY_OPRID_SW Character(1) VARCHAR2(1) NOT NULL Total by Individual

Y/N Table Edit

Default: N

WF_NOTIFY_TRIGGER Number(8,0) INTEGER NOT NULL Notify When Total Exceeds
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: 107

Prompt Table: MESSAGE_SET_VW

MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

Default: 9

Prompt Table: MSG_CAT_VW

WF_NOTIFY_EMAIL Character(1) VARCHAR2(1) NOT NULL Notify by Email

Y/N Table Edit

Default: N

WF_NOTIFY_WL Character(1) VARCHAR2(1) NOT NULL Notify by Worklist

Y/N Table Edit

Default: Y

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19