CDM_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

DISTNODENAMECharacter(15)VARCHAR2(15) NOT NULLReport Distribution Node Name

Prompt Table: CDM_DIST_NODE

PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

Prompt Table: PMN_PRCSTYPE_VW

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

Prompt Table: CDM_DISTSTATUS
Set Control Field: DISTSTATUSDESCR

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

PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

WS_OPRIDCharacter(30)VARCHAR2(30) NOT NULLWork user's ID
PT_FILTERTYPECharacter(1)VARCHAR2(1) NOT NULLFilter Type
0=Last
1=Date Range

Default: 0

PT_FILTERVALUENumber(4,0)SMALLINT NOT NULLFilter Value

Default: 1

FROM_DTDate(10)DATEFrom Date
TO_DTDate(10)DATETo Date
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