OPRIDPNLNAMEPrompt Table: RSF_PNLDEFN_VW
A=Ascending
D=Descending
RB_USER_MEMORY(SQL Table) |
Index Back |
|---|---|
Remembers User State on a pageParent Record for RSF_USER_FILTER, and also for RSF_USER_SECTION. For any given page, we want to remember what sections on that page were collapsed or expanded, so the next time the user visits the page, the page will appear the same. Also, for any pages which filter a scroll area, we want to remember the user's filter choice. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: RSF_PNLDEFN_VW |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | SORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Sort Type (Asc or Desc)
A=Ascending D=Descending |
| 5 | FLD_A | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 6 | FLD_B | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 7 | FLD_C | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 8 | FLD_D | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 9 | FLD_E | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 10 | FLD_F | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 11 | FLD_G | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 12 | FLD_H | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 13 | FLD_I | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |
| 14 | FLD_J | Character(1) | VARCHAR2(1) NOT NULL | Show Description....................................... |