CP_OPER_XLAT_VW

(SQL View)
 Index Back

Operand Code XLAT View

This record is used to translate Operand International Code

SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'OPER_INTL_CD' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

  • Related Language Record: CP_OPER_XVW_LNG

    • # 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name