RSFD_OP_STAT_VW

(SQL View)
 Index Back

Dash Opportunity Status

Dashboard translate for field opportunity status

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

# 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
3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
4 STATUS_CAT_SDESCR Character(10) VARCHAR2(10) NOT NULL Used for contact center dashboard to display status category short description.