WF_MON_SETUP

index back

Workflow Monitor Query Setup


PeopleSoft Field NameField TypeColumn TypeDescription
WF_MON_SETUP_IDCharacter(30)VARCHAR2(30) NOT NULLWorkflow Monitor Setup ID
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).

Prompt Table: BUSPROCNAME_VW

WF_TO_DTTMDateTime(26)TIMESTAMPTo Datetime
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name

Prompt Table: WORKLISTNAME_VW

INSTSTATUSNumber(5,0)INTEGER NOT NULLDetermines worklist status, available, selected, worked, cancelled

Default: 0

Prompt Table: WF_INSTSTATUS

WF_FROM_DTTMDateTime(26)TIMESTAMPFrom Datetime
WF_BY_OPRID_SWCharacter(1)VARCHAR2(1) NOT NULLTotal by Individual

Y/N Table Edit

Default: N

WF_NOTIFY_TRIGGERNumber(8,0)INTEGER NOT NULLNotify When Total Exceeds
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.

Default: 107

Prompt Table: MESSAGE_SET_VW

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

Default: 9

Prompt Table: MSG_CAT_VW

WF_NOTIFY_EMAILCharacter(1)VARCHAR2(1) NOT NULLNotify by Email

Y/N Table Edit

Default: N

WF_NOTIFY_WLCharacter(1)VARCHAR2(1) NOT NULLNotify by Worklist

Y/N Table Edit

Default: Y

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