PSXP_RF_VW

index back

Reports Pagelet View

Reports Pagelet View
SELECT A.DISTID , A.PSRF_REPORT_ID , B.PSRF_REPORT_NAME , B.PSRF_REPORT_DESCR , B.PSRF_CREATION_DTTM , B.EXPIRATION_DATE , B.PSRF_FOLDER_ID , C.PSRF_FOLDER_NAME , B.PRCSINSTANCE , B.CONTENTID , B.PRCSTYPE , B.PRCSNAME , B.DBNAME FROM PSRF_RAUTH_TBL A , PSRF_RINFO_TBL B , PSRF_FINFO_TBL C WHERE((A.PSRF_REPORT_ID = B.PSRF_REPORT_ID) AND (B.PSRF_FOLDER_ID = C.PSRF_FOLDER_ID) AND (B.PRCSTYPE = 'XML Publisher' ) AND A.DISTIDTYPE = '2') UNION SELECT D.OPRID , A.PSRF_REPORT_ID , B.PSRF_REPORT_NAME , B.PSRF_REPORT_DESCR , B.PSRF_CREATION_DTTM , B.EXPIRATION_DATE , B.PSRF_FOLDER_ID , C.PSRF_FOLDER_NAME , B.PRCSINSTANCE , B.CONTENTID , B.PRCSTYPE , B.PRCSNAME , B.DBNAME FROM PSRF_RAUTH_TBL A , PSRF_RINFO_TBL B , PSRF_FINFO_TBL C , PS_ROLEUSER_VW D WHERE((A.PSRF_REPORT_ID = B.PSRF_REPORT_ID) AND (B.PSRF_FOLDER_ID = C.PSRF_FOLDER_ID) AND (B.PRCSTYPE = 'XML Publisher' ) AND A.DISTIDTYPE = '3' AND A.DISTID = D.ROLENAME)

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
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
PSXP_REPORT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description for Reporting Folders
PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables
EXPIRATION_DATE Date(10) DATE Expiration Date
PSRF_FOLDER_ID Number(12,0) DECIMAL(12) NOT NULL Reporting Folder's Unique Identifier
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19