RA_RSF_LEAD_ORG

(SQL View)
 Index Back

Sales Leads profile view

Sales Leads profile source view for Organization Leads

SELECT L.BO_ID_CUST , L.LEAD_ID , L.DESCR50 , L.BUSINESS_UNIT , L.PERSON_ID , L.SALES_USER_NAME , L.LEAD_RATING , L.LEAD_STATUS , L.TREE_NAME , L.TERRITORY_ID , L.REGION_ID , L.LEAD_SOURCE_ID , CASE WHEN (L.LEAD_SOURCE_ID = 'MARKETING' OR L.LEAD_SOURCE_ID = 'ONLINEMARKETING') THEN (CASE WHEN L.RC_PROSPECT_SW = 'Y' THEN 'TELM' ELSE 'SFA' END) ELSE ' ' END RA_CHANNEL_TYPE , L.RC_PROSPECT_SW , L.BUSINESS_UNIT_RA , L.RA_CAMPAIGN_ID , %Sql(RA_COALESCE,C.RA_CMPGN_NAME,' ') , L.RA_CMPGN_WAVE_ID , %Sql(RA_COALESCE,W.RA_WAVE_NAME,' ') , %Sql(RA_COALESCE,W.RA_PROMOTION_CODE,' ') , %Sql(RA_COALESCE,D.DIALOG_ID,0) , %Sql(RA_COALESCE,D.RY_DIALOG_NAME,' ') , L.SALES_PRIORITY , L.BO_ID_CUST , L.ROLE_TYPE_ID_CUST , L.BO_ID_CONTACT , L.BO_ID_PARTNER , L.EST_REVENUE , L.CURRENCY_CD , %DatePart(L.ROW_ADDED_DTTM) FROM PS_RSF_LEAD L , PS_RA_CAMPAIGN C , PS_RA_CMPGN_WAVE W , PS_RA_LE_DIALOG_VW D WHERE C.BUSINESS_UNIT(+) = L.BUSINESS_UNIT_RA AND C.RA_CAMPAIGN_ID(+) = L.RA_CAMPAIGN_ID AND W.BUSINESS_UNIT(+) = L.BUSINESS_UNIT_RA AND W.RA_CAMPAIGN_ID(+) = L.RA_CAMPAIGN_ID AND W.RA_CMPGN_WAVE_ID(+) = L.RA_CMPGN_WAVE_ID AND D.LEAD_ID(+) = L.LEAD_ID AND L.ROLE_TYPE_ID_CUST IN ( SELECT ROLE_TYPE_ID FROM PS_BO_ROLE_TYPE WHERE BO_TYPE_ID = 2)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

Prompt Table: RSF_LEAD

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RSF_NONVW

5 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_USER_BU_VW

6 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
7 LEAD_RATING Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead.

Prompt Table: RSF_LE_RATE_VW
Set Control Field: BUSINESS_UNIT

8 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
9 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: RSF_OPR_TREE_VW

10 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID

Prompt Table: RSF_TER_NODE_VW

11 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

Prompt Table: RSF_REGION_VW

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

Prompt Table: RSF_LE_SRC_VW

13 RA_CHANNEL_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing Channel Types
14 RC_PROSPECT_SW Character(1) VARCHAR2(1) NOT NULL Outbound Marketing

Y/N Table Edit

15 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RA_NONVW

16 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.

Prompt Table: RSF_CAMPAIGN_VW

17 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
18 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

Prompt Table: RSF_CMPGN_WA_VW

19 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
20 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code

Prompt Table: RA_LB_PROMO_VW

21 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
22 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
23 SALES_PRIORITY Character(3) VARCHAR2(3) NOT NULL Priority of sales lead and opportunity
1=1-One
2=2-Two
3=3-Three
4=4-Four
5=5-Five
6=6-Six
7=7-Seven
8=8-Eight
9=9-Nine
24 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
25 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

Prompt Table: RSF_BO_ROLTY_VW

26 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
27 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
28 EST_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: CURRENCY_CD_TBL

30 CREATE_DATE Date(10) DATE Creation Date