EOEP_ARBVAL_LVW

(SQL View)
 Index Back

Arbitration Type Values

Arbitration Type Values

SELECT %Substring(FIELDVALUE , 1 , 2) , EFFDT , LANGUAGE_CD , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'EOEP_ARB_TYPE' UNION SELECT %Substring(FIELDVALUE , 1 , 1) %Concat 'F' , EFFDT , LANGUAGE_CD , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'EOEP_ARB_TYPE' AND FIELDVALUE IN ('4','5')

  • Related Language Record for EOEP_ARBVAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEP_ARB_TYPE Character(2) VARCHAR2(2) NOT NULL Arbitration Type
    1=Action Type
    2=Price Type
    3=Decision
    4=Pricing Key
    5=Price Rule
    6=Cascading/Summed
    7=Date Range
    8=Price Rule Source
    9=Price Rule Type
    F=[Folder]
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name