USERIDD=DAYS
H=HOURS
Default: 5
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 |
|---|---|---|---|
| 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 |