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 NameField TypeColumn TypeDescription
DISTIDCharacter(30)VARCHAR2(30) NOT NULLDistribution 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
PSRF_REPORT_DESCRCharacter(254)VARCHAR2(254) NOT NULLReport Description for Reporting Folders
PSRF_FOLDER_IDNumber(12,0)DECIMAL(12) NOT NULLReporting Folder's Unique Identifier
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
PSRF_CREATION_DTTMDateTime(26)TIMESTAMPReport Creation Date and Time in the reporting folders tables
EXPIRATION_DATEDate(10)DATEExpiration Date
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

Default: PSRF_REPORTLIST.DBNAME

Prompt Table: PSRF_DB_INFO
Set Control Field: DBNAME

URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19