RSF_OSTAT_LG_VW

(SQL View)
 Index Back

Opp Status - Language VW

Opportunity status as a view (language)

SELECT %Substring(FIELDVALUE,1,1) , EFFDT , LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'OPPORTUNITY_STATUS'

  • Related Language Record for RSF_OSTAT_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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description