PSRF_POPTN_VW |
index back |
---|---|
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 |
---|---|---|---|
![]() |
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |