PSRF_POPTN_TBL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PSRF_PGLT_TIME_NUM Signed Number(4,0) DECIMAL(3) NOT NULL How much time the user want to go back to fetch the reports onto the pagelet.

3 PSRF_PGLT_NUM_UNIT Character(1) VARCHAR2(1) NOT NULL User option to indicate if he want to go back in Days Or Hous.
D=DAYS
H=HOURS

4 PSRF_PGLT_MAXRPTS Signed Number(4,0) DECIMAL(3) NOT NULL Maximum Number Of Reports User want to see in the repoting Pagelet

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
2	PSRF_PGLT_TIME_NUM	Signed Number(4,0)	DECIMAL(3) NOT NULL	How much time the user want to go back to fetch the reports onto the pagelet.
3	PSRF_PGLT_NUM_UNIT	Character(1)	VARCHAR2(1) NOT NULL	User option to indicate if he want to go back in Days Or Hous. D=DAYS H=HOURS
4	PSRF_PGLT_MAXRPTS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Maximum Number Of Reports User want to see in the repoting Pagelet