PSRF_RSCRTY_TBL (SQL Table)	Index Back
Report Security Table Report Security Table for Report Folders

PSRF_RSCRTY_TBL

(SQL Table)

Report Security Table

Report Security Table for Report Folders

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

2 PSRF_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Report's Unique Identifier

3 PSRF_VIEWED Character(1) VARCHAR2(1) NOT NULL Is this report already viewed by the current user?

4 PSRF_CREATION_DTTM DateTime(26) TIMESTAMP Report Creation Date and Time in the reporting folders tables

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
2	PSRF_REPORT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Report's Unique Identifier
3	PSRF_VIEWED	Character(1)	VARCHAR2(1) NOT NULL	Is this report already viewed by the current user?
4	PSRF_CREATION_DTTM	DateTime(26)	TIMESTAMP	Report Creation Date and Time in the reporting folders tables