index back

Report Security Table

Report Security Table for Report Folders

PeopleSoft Field NameField TypeColumn TypeDescription
PSRF_REPORT_IDNumber(15,0)DECIMAL(15) NOT NULLReport's Unique Identifier
DISTIDTYPECharacter(3)VARCHAR2(3) NOT NULLDistribution ID Type
2=User ID
3=Role Name

Default: 2

DISTIDCharacter(30)VARCHAR2(30) NOT NULLDistribution ID
PSRF_VIEWEDCharacter(1)VARCHAR2(1) NOT NULLIs this report already viewed by the current user?
PSRF_CREATION_DTTMDateTime(26)TIMESTAMPReport Creation Date and Time in the reporting folders tables
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19