ARCHIVE_DTPrompt Table: CDM_ARCH_DT_VW
0=All
1=Days
2=Hours
3=Minutes
4=Years
Default: 1
Default: 1
Prompt Table: PMN_PRCSTYPE_VW
Default: 0
0=None
1=Days
2=Hours
3=Minutes
Default: 1
0=Last
1=Date Range
Default: 0
CDM_FILTER_ARCH |
index back |
|---|---|
Rpt Dist - Archived rpt filter |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| ARCHIVE_DT |
Date(10) | DATE |
Archive Date
Prompt Table: CDM_ARCH_DT_VW |
| PT_FILTERUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Filter Unit
0=All 1=Days 2=Hours 3=Minutes 4=Years Default: 1 |
| PT_FILTERVALUE | Number(4,0) | SMALLINT NOT NULL |
Filter Value
Default: 1 |
| PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PMN_PRCSTYPE_VW |
| RPTDIR | Character(150) | VARCHAR2(150) NOT NULL | Report Directory |
| FILTERVALUE | Number(2,0) | SMALLINT NOT NULL |
Filter Value
Default: 0 |
| FILTERUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Filter Unit
0=None 1=Days 2=Hours 3=Minutes Default: 1 |
| FROM_DT | Date(10) | DATE | From Date |
| TO_DT | Date(10) | DATE | To Date |
| PT_FILTERTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Filter Type
0=Last 1=Date Range Default: 0 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |