RSF_USER_MEMORY

(SQL Table)
 Index Back

Remembers User State on a page

Parent 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.

  • Parent Record Of RSF_USER_FILTER

    • # 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 PB_MY_LEADS Character(1) VARCHAR2(1) NOT NULL My Leads Push Button
    N=No
    Y=Yes
    6 PB_UNAS_LEADS Character(1) VARCHAR2(1) NOT NULL Unassigned Leads Push Button
    N=No
    Y=Yes
    7 PB_TEAM_LEADS Character(1) VARCHAR2(1) NOT NULL Team Leads Push Button
    N=No
    Y=Yes
    8 PB_SHOW_CONV Character(1) VARCHAR2(1) NOT NULL Show Converted Push Button
    N=No
    Y=Yes
    9 PB_TASK_ASSIGNEE Character(1) VARCHAR2(1) NOT NULL View Leads/Opportunity as task assignee
    N=No
    Y=Yes