RSF_LE_STAT_VW

(SQL View)
 Index Back

Lead Status View - Translate

Retrieves the translate values of the Lead Status field.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEAD_STATUS Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to keep the status of a Sales Lead.
AC=Accepted
CD=Closed - Duplicate
CL=Closed - Won
CO=Converted to Opportunity
DE=Deferred
IM=Imported
LO=Closed - Lost
NE=New
OP=Open
RE=Referred
RJ=Rejected
TB=Turnback
WO=Working

Default Value: NE

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50