PSRF_RFLTER_TBL

index back

Report Chron View Filter

Work Record For Report Chron View Filter

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

Prompt Table: PSRF_FVIEW_VW
Set Control Field: PSRF_FOLDER_NAME

PSRF_REPORT_NAME Character(254) VARCHAR2(254) NOT NULL Report Name For Reporting Folders
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

PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables
PSRF_CREATED_ON Date(10) DATE Report Created Date
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
TO_PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Upper Limit of the filter option in report list view
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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19