PSXP_RF_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
2 PSRF_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Report's Unique Identifier
3 PSRF_REPORT_NAME Character(254) VARCHAR2(254) NOT NULL Report Name For Reporting Folders
4 PSXP_REPORT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description for Reporting Folders
5 PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables
6 EXPIRATION_DATE Date(10) DATE Expiration Date
7 PSRF_FOLDER_ID Number(12,0) DECIMAL(12) NOT NULL Reporting Folder's Unique Identifier
8 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
9 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
11 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
12 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
13 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name