PSRF_RINFO_VW

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.PSRF_REPORT_URL ,A.EXPIRATION_DATE ,A.PSRF_CREATION_DTTM , B.USERID FROM PSRF_RINFO_TBL A , PSRF_RSCRTY_TBL B WHERE A.PSRF_REPORT_ID = B.PSRF_REPORT_ID

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
PSRF_REPORT_URL Long Character CLOB Report's URL
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