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 NameField TypeColumn TypeDescription
PSRF_FOLDER_IDNumber(12,0)DECIMAL(12) NOT NULLReporting Folder's Unique Identifier
PSRF_REPORT_IDNumber(15,0)DECIMAL(15) NOT NULLReport's Unique Identifier
PSRF_REPORT_NAMECharacter(254)VARCHAR2(254) NOT NULLReport Name For Reporting Folders
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
EXPIRATION_DATEDate(10)DATEExpiration Date
PSRF_CREATION_DTTMDateTime(26)TIMESTAMPReport Creation Date and Time in the reporting folders tables
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19