CP_OPER_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 = 'OPER_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_OPER_XLAT_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPER_INTL_CD Character(2) VARCHAR2(2) NOT NULL International Operand Code
    01=Equal to
    02=Less than
    03=Less than or Equal to
    04=Greater than
    05=Greater than or Equal to
    06=If
    07=Or
    08=And
    09=Not Equal To
    10=Concate
    11=Substring After
    12=Substring Before
    13=Exist on Multiple Option
    14=Exist on Value List
    15=Sin
    16=Cosine
    17=Tangent
    18=Power
    19=Mod
    20=Add
    21=Subtract
    22=Multiply
    23=Divide
    24=Round Down
    25=Round Up
    26=Calculate Date
    27=Exist on Component Array
    28=Calculate Price
    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