RSPD_STATUS_VW (SQL View)	Index Back
Dashboard Opportunity status Dashboard translate for field account plan status

RSPD_STATUS_VW

(SQL View)

Dashboard Opportunity status

Dashboard translate for field account plan status

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSP_STATUS Character(2) VARCHAR2(2) NOT NULL Status of a Strategic Plan or Template
10=Draft
20=Active
30=Inactive
40=Completed
50=Cancelled

2 STATUS_CAT_SDESCR Character(10) VARCHAR2(10) NOT NULL Used for contact center dashboard to display status category short description.

3 OPPSTATUSDESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSP_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Status of a Strategic Plan or Template 10=Draft 20=Active 30=Inactive 40=Completed 50=Cancelled
2	STATUS_CAT_SDESCR	Character(10)	VARCHAR2(10) NOT NULL	Used for contact center dashboard to display status category short description.
3	OPPSTATUSDESCR	Character(30)	VARCHAR2(30) NOT NULL	Description