CDM_FILTER |
index back |
|---|---|
Process Monitor Filter |
| 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
|
| 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
|
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |