EOEP_ARBVAL_VW

(SQL View)
 Index Back

Arbitration Type Values

Arbitration Type Values

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

  • Related Language Record: EOEP_ARBVAL_LVW

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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