PSRF_RLIST_VW

index back

Report List View

Report List View used in Report Folders
SELECT A.PSRF_FOLDER_ID , A.PSRF_REPORT_ID , A.PSRF_REPORT_NAME , B.DISTID , A.EXPIRATION_DATE , A.PSRF_CREATION_DTTM FROM PSRF_RINFO_TBL A , PSRF_RAUTH_TBL B WHERE (A.PSRF_REPORT_ID = B.PSRF_REPORT_ID AND B.DISTIDTYPE = '2') UNION SELECT A.PSRF_FOLDER_ID , A.PSRF_REPORT_ID , A.PSRF_REPORT_NAME , C.OPRID , A.EXPIRATION_DATE , A.PSRF_CREATION_DTTM FROM PSRF_RINFO_TBL A , PSRF_RAUTH_TBL B , PS_ROLEUSER_VW C WHERE (A.PSRF_REPORT_ID = B.PSRF_REPORT_ID AND B.DISTIDTYPE = '3' AND B.DISTID = C.ROLENAME)

PeopleSoft Field Name Field Type Column Type Description
PSRF_FOLDER_ID Number(12,0) DECIMAL(12) NOT NULL Reporting Folder's Unique Identifier
PSRF_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Report's Unique Identifier
PSRF_REPORT_NAME Character(254) VARCHAR2(254) NOT NULL Report Name For Reporting Folders
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
EXPIRATION_DATE Date(10) DATE Expiration Date
PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19