CDM_FILTER_ARCH

index back

Rpt Dist - Archived rpt filter

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

PeopleSoft Field NameField TypeColumn TypeDescription
ARCHIVE_DTDate(10)DATEArchive Date

Prompt Table: CDM_ARCH_DT_VW

PT_FILTERUNITCharacter(1)VARCHAR2(1) NOT NULLFilter Unit
0=All
1=Days
2=Hours
3=Minutes
4=Years

Default: 1

PT_FILTERVALUENumber(4,0)SMALLINT NOT NULLFilter Value

Default: 1

PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

Prompt Table: PMN_PRCSTYPE_VW

RPTDIRCharacter(150)VARCHAR2(150) NOT NULLReport Directory
FILTERVALUENumber(2,0)SMALLINT NOT NULLFilter Value

Default: 0

FILTERUNITCharacter(1)VARCHAR2(1) NOT NULLFilter Unit
0=None
1=Days
2=Hours
3=Minutes

Default: 1

FROM_DTDate(10)DATEFrom Date
TO_DTDate(10)DATETo Date
PT_FILTERTYPECharacter(1)VARCHAR2(1) NOT NULLFilter Type
0=Last
1=Date Range

Default: 0

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19