PSOPTNLVLANG_VW

(SQL View)
Index Back

SELECT FIELDVALUE , LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'OPTN_CATEGORY_LVL'

  • Related Language Record for PSOPTNCATLVL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description