PSUSROPTLISTLVW

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 , B.OPTN_CATEGORY , C.LANGUAGE_CD , B.USEROPTN FROM PSOPRCLS A , PSUSEROPTNDEFN B , PSUSEROPTNLANG C WHERE B.OPTN_CATEGORY_LVL = C.OPTN_CATEGORY_LVL AND B.USEROPTN = C.USEROPTN

  • Parent record: PSOPTNCAT_VW
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    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 Capital Management
    LS=Enterprise Learning Management
    PPTL=PeopleTools
    SCM=Supply Chain Management
    USEROPTN Character(12) VARCHAR2(12) NOT NULL User Option

    Prompt Table: PSUSEROPTNLSRCH

    OPTN_CATEGORY Character(12) VARCHAR2(12) NOT NULL Option Category
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19