PSXP_RF_VW

Platform

View Text

Default

SELECT A.USERID , A.PSRF_REPORT_ID , B.PSRF_REPORT_NAME , B.PSRF_REPORT_DESCR , B.PSRF_REPORT_URL , 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_RSCRTY_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.PSRF_REPORT_NAME = 'XMLP' ))

PeopleSoft Field Name	Description
USERID	A user's ID
PSRF_REPORT_ID	Report's Unique Identifier
PSRF_REPORT_NAME	Report Name For Reporting Folders
PSXP_REPORT_DESCR	Report Description for Reporting Folders
PSRF_REPORT_URL	Report's URL
PSRF_CREATION_DTTM	Report Creation Date and Time in the reporting folders tables
EXPIRATION_DATE	Expiration Date
PSRF_FOLDER_ID	Reporting Folder's Unique Identifier
PSRF_FOLDER_NAME	Reporting Folder's Name
PRCSINSTANCE	Process Instance
CONTENTID	Report ID
PRCSTYPE	Process Type
PRCSNAME	Process Name
DBNAME	Database Name

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010