PSXP_RF_VW

index back

Reports Pagelet View

Reports Pagelet View
SELECT 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 (B.PRCSTYPE = 'XML Publisher' ) AND A.DISTIDTYPE = '2') UNION SELECT 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 (B.PRCSTYPE = 'XML Publisher' ) AND A.DISTIDTYPE = '3' AND A.DISTID = D.ROLENAME)

PeopleSoft Field NameField TypeColumn TypeDescription
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
PSRF_REPORT_IDNumber(15,0)DECIMAL(15) NOT NULLReport's Unique Identifier
PSRF_REPORT_NAMECharacter(254)VARCHAR2(254) NOT NULLReport Name For Reporting Folders
PSXP_REPORT_DESCRCharacter(254)VARCHAR2(254) NOT NULLReport Description for Reporting Folders
PSRF_CREATION_DTTMDateTime(26)TIMESTAMPReport Creation Date and Time in the reporting folders tables
EXPIRATION_DATEDate(10)DATEExpiration Date
PSRF_FOLDER_IDNumber(12,0)DECIMAL(12) NOT NULLReporting Folder's Unique Identifier
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19