RSF_OSTAT_VW

(SQL View)
Index Back

Opp Status VW

Opportunity status field extracted as a view

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

  • Related Language Record: RSF_OSTAT_LG_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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description