PSRF_RFLTER_TBL

index back

Report Chron View Filter

Work Record For Report Chron View Filter

PeopleSoft Field NameField TypeColumn TypeDescription
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

Prompt Table: PSRF_FVIEW_VW
Set Control Field: PSRF_FOLDER_NAME

PSRF_REPORT_NAMECharacter(254)VARCHAR2(254) NOT NULLReport Name For Reporting Folders
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

PSRF_CREATION_DTTMDateTime(26)TIMESTAMPReport Creation Date and Time in the reporting folders tables
PSRF_CREATED_ONDate(10)DATEReport Created Date
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
TO_PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLUpper Limit of the filter option in report list view
PT_FILTERTYPECharacter(1)VARCHAR2(1) NOT NULLFilter Type
0=Last
1=Date Range

Default: 0

PT_FILTERVALUENumber(4,0)SMALLINT NOT NULLFilter Value

Default: 1

FROM_DTDate(10)DATEFrom Date
TO_DTDate(10)DATETo Date
PT_FILTERUNITCharacter(1)VARCHAR2(1) NOT NULLFilter Unit
0=All
1=Days
2=Hours
3=Minutes
4=Years

Default: 1

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