PSRF_POPTN_VW (SQL View)	Index Back
Pagelet Options View Pagelet Options View

PSRF_POPTN_VW

(SQL View)

Pagelet Options View

SELECT DISTINCT A.USERID , A.PSRF_PGLT_TIME_NUM , A.PSRF_PGLT_NUM_UNIT , A.PSRF_PGLT_MAXRPTS ,A.PSRF_PGLT_NUM_UNIT ,A.PSRF_PGLT_NUM_UNIT FROM PSRF_POPTN_TBL A

# 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
Default Value: 5

5 PSRF_SAVE_OPTIONS Character(1) VARCHAR2(1) NOT NULL Save Options button on My Reports Pagelet

6 PSRF_CLOSE_OPTIONS Character(1) VARCHAR2(1) NOT NULL Close button on the My Reports 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 Default Value: 5
5	PSRF_SAVE_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Save Options button on My Reports Pagelet
6	PSRF_CLOSE_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Close button on the My Reports Pagelet