index back

Report Security Table

Report Security Table for Report Folders

PeopleSoft Field Name Field Type Column Type Description
PSRF_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Report's Unique Identifier
DISTIDTYPE Character(3) VARCHAR2(3) NOT NULL Distribution ID Type
2=User ID
3=Role Name

Default: 2

DISTID Character(30) VARCHAR2(30) NOT NULL Distribution ID
PSRF_VIEWED Character(1) VARCHAR2(1) NOT NULL Is this report already viewed by the current user?
PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20