CP_VAR_XVW_LNG

(SQL View)
 Index Back

International Code XLAT Lng

This record is used to translate languages for Variable International Code that are used in the Variable Search Page (CP_VAR_IN2)

SELECT X.FIELDVALUE , L.LANGUAGE_CD , L.XLATSHORTNAME , L.XLATLONGNAME FROM PSXLATITEM X , PSXLATITEMLANG L WHERE X.FIELDNAME = 'VAR_INTL_CD' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND %Join(COMMON_KEYS, PSXLATITEM X, PSXLATITEMLANG L, EFFDT)

  • Related Language Record for CP_VAR_XLAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VAR_INTL_CD Character(2) VARCHAR2(2) NOT NULL International Variable Type
    01=Option
    02=Secondary
    03=Global
    04=Matrix
    05=Internal
    06=Multiple Option
    07=Value List
    08=External Program
    09=Character
    10=Number
    11=Literal
    12=Boolean
    14=Constant
    15=Expression
    16=Message
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name