PMN_FILTER

index back

Process Monitor Filter

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

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: PMN_OPRID_VW

SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

Prompt Table: SERVERDEFN

PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

Prompt Table: PMN_PRCSTYPE_VW

RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process 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

FILTERVALUE Number(2,0) SMALLINT NOT NULL Filter Value

Default: 1

FILTERUNIT Character(1) VARCHAR2(1) NOT NULL Filter Unit
0=None
1=Days
2=Hours
3=Minutes

Default: 1

WS_OPRID Character(30) VARCHAR2(30) NOT NULL Work user's ID

Prompt Table: PMN_OPRID_VW

PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PMN_PRCSNAME_VW

PMN_SAVE_FLAG Character(1) VARCHAR2(1) NOT NULL save on refresh flag for Process Monitor
N=No
Y=Yes

Default: Y

DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution 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_FILTERTYPE Character(1) VARCHAR2(1) NOT NULL Filter Type
0=Last
1=Date Range

Default: 0

TO_DT Date(10) DATE To Date
FROM_DT Date(10) DATE From Date
PT_FILTERVALUE Number(4,0) SMALLINT NOT NULL Filter Value

Default: 1

PT_FILTERUNIT Character(1) VARCHAR2(1) NOT NULL Filter Unit
0=All
1=Days
2=Hours
3=Minutes
4=Years

Default: 1

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