RSFD_LE_SRCE_VW (SQL View)	Index Back
Lead Source for Dashboard Dashboard lookup for the sources of Sales Leads

RSFD_LE_SRCE_VW

(SQL View)

Lead Source for Dashboard

Dashboard lookup for the sources of Sales Leads

SELECT A.LEAD_SOURCE_ID , A.DESCR50 , A.STATUS , B.XLATSHORTNAME FROM PS_RSF_LE_SRC_TBL A , PSXLATITEM B WHERE A.STATUS = B.FIELDVALUE AND B.FIELDNAME = 'STATUS' AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.

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

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_SOURCE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation to identify the source of a Sales Lead.
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
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.