PSRF_REPORTLIST

index back

SELECT DISTINCT A.DISTID , A.PSRF_REPORT_ID , B.PSRF_REPORT_NAME , B.PSRF_REPORT_DESCR , B.PSRF_FOLDER_ID ,F.PSRF_FOLDER_NAME , B.PSRF_CREATION_DTTM , B.EXPIRATION_DATE , B.PRCSINSTANCE , B.CONTENTID , B.PRCSTYPE , B.PRCSNAME , B.DBNAME , B.URL , B.FILENAME FROM PSRF_RAUTH_TBL A , PSRF_RINFO_TBL B , PSRF_FINFO_TBL F WHERE(A.PSRF_REPORT_ID = B.PSRF_REPORT_ID) AND (B.PSRF_FOLDER_ID = F.PSRF_FOLDER_ID) AND A.DISTIDTYPE = '2' UNION SELECT DISTINCT F.OPRID , A.PSRF_REPORT_ID , B.PSRF_REPORT_NAME , B.PSRF_REPORT_DESCR , B.PSRF_FOLDER_ID ,G.PSRF_FOLDER_NAME , B.PSRF_CREATION_DTTM , B.EXPIRATION_DATE , B.PRCSINSTANCE , B.CONTENTID , B.PRCSTYPE , B.PRCSNAME , B.DBNAME , B.URL , B.FILENAME FROM PSRF_RAUTH_TBL A , PSRF_RINFO_TBL B , PS_ROLEUSER_VW F , PSRF_FINFO_TBL G WHERE(A.PSRF_REPORT_ID = B.PSRF_REPORT_ID) AND (B.PSRF_FOLDER_ID = G.PSRF_FOLDER_ID) AND A.DISTIDTYPE = '3' AND A.DISTID = F.ROLENAME

PeopleSoft Field Name Field Type Column Type Description
DISTID Character(30) VARCHAR2(30) NOT NULL Distribution 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_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
PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables
EXPIRATION_DATE Date(10) DATE Expiration Date
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

Default: PSRF_REPORTLIST.DBNAME

Prompt Table: PSRF_DB_INFO
Set Control Field: DBNAME

URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20