CDM_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

DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name

Prompt Table: CDM_DIST_NODE

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

Prompt Table: PMN_PRCSTYPE_VW

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

Prompt Table: CDM_DISTSTATUS
Set Control Field: DISTSTATUSDESCR

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

PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

WS_OPRID Character(30) VARCHAR2(30) NOT NULL Work user's ID
PT_FILTERTYPE Character(1) VARCHAR2(1) NOT NULL Filter Type
0=Last
1=Date Range

Default: 0

PT_FILTERVALUE Number(4,0) SMALLINT NOT NULL Filter Value

Default: 1

FROM_DT Date(10) DATE From Date
TO_DT Date(10) DATE To Date
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