CDM_FILTER_ARCH

index back

Rpt Dist - Archived rpt filter

This record is used by the report distribution to filter archived reports.

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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19