RA_LANGCODE_VW

(SQL View)
 Index Back

xlat value items

xlat value items for LANGUAGE CODE used by profiles for selecting a values

SELECT %Substring(A.FIELDVALUE,1,3) , A.FIELDNAME , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'LANGUAGE_CD' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PSXLATITEM AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE = AA.FIELDVALUE AND AA.EFFDT <= %CurrentDateIn)

  • Related Language Record: RA_LANGCODE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FIN=Finnish
    FRA=French
    GER=German
    GRK=Greek
    HEB=Hebrew
    HUN=Hungarian
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bahasa Malay
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    TUR=Turkish
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name