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 NameField TypeColumn TypeDescription
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
PSRF_PGLT_TIME_NUMSigned Number(4,0)DECIMAL(3) NOT NULLHow much time the user want to go back to fetch the reports onto the pagelet.
PSRF_PGLT_NUM_UNITCharacter(1)VARCHAR2(1) NOT NULLUser option to indicate if he want to go back in Days Or Hous.
D=DAYS
H=HOURS
PSRF_PGLT_MAXRPTSSigned Number(4,0)DECIMAL(3) NOT NULLMaximum Number Of Reports User want to see in the repoting Pagelet

Default: 5

PSRF_SAVE_OPTIONSCharacter(1)VARCHAR2(1) NOT NULLSave Options button on My Reports Pagelet
PSRF_CLOSE_OPTIONSCharacter(1)VARCHAR2(1) NOT NULLClose button on the My Reports Pagelet
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19