PSUSEROPTNLSRCH

 index back

User Option View Lang


SELECT A.OPTN_CATEGORY_LVL , B.OPTN_CATEGORY_GRP , A.USEROPTN , A.LANGUAGE_CD , A.DESCR FROM PSUSEROPTNLANG A , PSUSEROPTNDEFN B WHERE A.OPTN_CATEGORY_LVL = B.OPTN_CATEGORY_LVL AND A.USEROPTN = B.USEROPTN

  • Related language record for PSUSEROPTN_SRCH

    • PeopleSoft Field Name Field Type Column Type Description
    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
    OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group
    USEROPTN Character(12) VARCHAR2(12) NOT NULL User Option
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20