PSUSROPTLIST_VW

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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    OPTN_CATEGORY_LVLCharacter(4)VARCHAR2(4) NOT NULLOption Category Level
    CRM=Customer Relationship Mgmt
    CSTM=Custom
    EPM=Enterprise Performance Mgmt
    FIN=Financials
    HRMS=Human Capital Management
    LS=Enterprise Learning Management
    PPTL=PeopleTools
    SCM=Supply Chain Management
    USEROPTNCharacter(12)VARCHAR2(12) NOT NULLUser Option

    Prompt Table: PSUSEROPTN_SRCH

    OPTN_CATEGORYCharacter(12)VARCHAR2(12) NOT NULLOption Category
    OPTN_CATEGORY_GRPCharacter(12)VARCHAR2(12) NOT NULLOption Category Group
    USER_OPTION_VALUECharacter(30)VARCHAR2(30) NOT NULLUser personalization option override value.

    Prompt Table: USRXLATTABLE_VW

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19