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