PSRF_POPTN_VW

index back

Pagelet Options 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 Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
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.
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
PSRF_PGLT_MAXRPTS Signed Number(4,0) DECIMAL(3) NOT NULL Maximum Number Of Reports User want to see in the repoting Pagelet

Default: 5

PSRF_SAVE_OPTIONS Character(1) VARCHAR2(1) NOT NULL Save Options button on My Reports Pagelet
PSRF_CLOSE_OPTIONS Character(1) VARCHAR2(1) NOT NULL Close button on the My Reports Pagelet
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19