RSF_FCAST_X_VW

(SQL View)
 Index Back

Opp Status Xlat Descr Vw

Translates opp status code into descr.

SELECT %Substring(A.FIELDVALUE,1,1) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'OPPORTUNITY_STATUS' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: RSF_FCAST_XL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPPORTUNITY_STATUS Character(1) VARCHAR2(1) NOT NULL Opportunity Status. The values are XLat Values
    0=Open
    1=Closed - Lost
    2=Closed - Won
    3=Inactive
    2 OPPSTATUSDESCR Character(30) VARCHAR2(30) NOT NULL Description