PSUSROPTLIST_VW

(SQL View)
 Index Back

Personalization Option List

Administrator table for defining lists of personalizations. A USEROPTN can only be in one list.

SELECT DISTINCT A.OPRID , C.OPTN_CATEGORY_LVL , C.USEROPTN , C.OPTN_CATEGORY , C.OPTN_CATEGORY_GRP , C.USER_OPTION_VALUE FROM PSOPRCLS A , PSAUTHOPTN B , PSUSEROPTNDEFN C WHERE A.OPRCLASS = B.CLASSID AND B.USEROPTN = C.USEROPTN AND C.USEROPTN_TYPE = 'S'

  • Parent record: PSOPTNCAT_VW

    • # 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 OPTN_CATEGORY_LVL Character(4) VARCHAR2(4) NOT NULL Option Category Level
    CRM=Customer Relationship Mgmt
    CSTM=Custom
    EPM=Enterprise Performance Mgmt
    FIN=Financials
    HRMS=Human Resources Management
    LS=Learning Solutions
    PPTL=PeopleTools
    SCM=Supply Chain Management
    3 USEROPTN Character(12) VARCHAR2(12) NOT NULL User Option

    Prompt Table: PSUSEROPTN_SRCH

    4 OPTN_CATEGORY Character(12) VARCHAR2(12) NOT NULL Option Category
    5 OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group
    6 USER_OPTION_VALUE Character(30) VARCHAR2(30) NOT NULL User personalization option override value.

    Prompt Table: USRXLATTABLE_VW