PSRF_PGLET_VW

index back

Reports Pagelet View

Reports Pagelet View
SELECT DISTINCT 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 A.DISTIDTYPE = '2' UNION SELECT DISTINCT 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 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
PSRF_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