PSRF_RINFO_VW2

index back

Report Info Table

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