PMN_FILTER

index back

Process Monitor Filter

This record is used by the Process Monitor to filter process requests.

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: PMN_OPRID_VW

SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name

Prompt Table: SERVERDEFN

PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

Prompt Table: PMN_PRCSTYPE_VW

RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success

Prompt Table: PMN_RUNSTATUS
Set Control Field: RUNSTATUSDESCR

FILTERVALUENumber(2,0)SMALLINT NOT NULLFilter Value

Default: 1

FILTERUNITCharacter(1)VARCHAR2(1) NOT NULLFilter Unit
0=None
1=Days
2=Hours
3=Minutes

Default: 1

WS_OPRIDCharacter(30)VARCHAR2(30) NOT NULLWork user's ID

Prompt Table: PMN_OPRID_VW

PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name

Prompt Table: PMN_PRCSNAME_VW

PMN_SAVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLsave on refresh flag for Process Monitor
N=No
Y=Yes

Default: Y

DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval
PT_FILTERTYPECharacter(1)VARCHAR2(1) NOT NULLFilter Type
0=Last
1=Date Range

Default: 0

TO_DTDate(10)DATETo Date
FROM_DTDate(10)DATEFrom Date
PT_FILTERVALUENumber(4,0)SMALLINT NOT NULLFilter Value

Default: 1

PT_FILTERUNITCharacter(1)VARCHAR2(1) NOT NULLFilter Unit
0=All
1=Days
2=Hours
3=Minutes
4=Years

Default: 1

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