RSF_LEAD_DUP_VW (SQL View)	Index Back
Volume Import Verification This record is a holding table for Leads being imported. This provides the user with an opportunity to verify the Leads moving to the real table RSF_LEAD.

RSF_LEAD_DUP_VW

(SQL View)

Volume Import Verification

This record is a holding table for Leads being imported. This provides the user with an opportunity to verify the Leads moving to the real table RSF_LEAD.

SELECT A.LEAD_ID , A.BUSINESS_UNIT , A.TERRITORY_ID , A.REGION_ID , A.DESCR50 , A.CUST_SETID , A.ROLE_TYPE_ID_CUST , A.BO_ID_CUST , A.NAME1 , A.LEAD_SOURCE_ID , A.BUSINESS_UNIT_RA , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.LEAD_RATING , A.LEAD_TYPE , A.LEAD_STATUS , A.INDUSTRY_ID , A.EST_REVENUE , A.PERSON_ID , A.SALES_USER_NAME , A.CURRENCY_CD , A.REFERRED_DT , A.ACCEPTED_DT , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , C.CONTACT_ID , C.CONTACT_NAME , A.STATE , A.POSTAL , A.FIRST_NAME , A.LAST_NAME , C.FIRST_NAME , C.LAST_NAME , C.COUNTRY_CODE , C.WORK_PHONE , C.EXTENSION , C.HOME_PHONE , C.CELL_PHONE , C.FAX , C.EMAILID , P.PRICE_BASE , N.DESCRLONG , N.RC_SUMMARY , P.PRODUCT_GROUP , P.PRODUCT_ID , P.COST , P.QTY , P.REVENUE_TYPE , P.UNIT_OF_MEASURE FROM PS_RSF_LEAD A , PS_RSF_LE_CONTACTS C , PS_RSF_LE_PRODUCTS P , PS_RSF_LE_NOTE N WHERE A.LEAD_ID = C.LEAD_ID (+) AND A.LEAD_ID = P.LEAD_ID (+) AND A.LEAD_ID = N.LEAD_ID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RSF_NONVW

3 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
Prompt Table: RSF_TER_NODE_VW

4 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
Prompt Table: RSF_REGION_VW

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

6 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid

7 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
Default Value: 2
Prompt Table: RSF_BO_ROLTY_VW

8 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

9 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

10 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

11 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RA_NONVW

12 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

13 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

14 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

15 LEAD_TYPE Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate what type of Lead,
IN=Inquiry
LE=Lead
QU=Qualified Lead
TQ=Turnback Qualified Lead
TU=Turnback Lead

16 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

17 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
Prompt Table: RSF_INDUSTRY_VW

18 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.

19 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RSF_USER_BU_VW

20 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field

21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

22 REFERRED_DT Date(10) DATE Referred Date

23 ACCEPTED_DT Date(10) DATE Accepted Date

24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

25 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

26 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

27 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

28 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

29 CITY Character(30) VARCHAR2(30) NOT NULL City

30 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

31 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

32 STATE Character(6) VARCHAR2(6) NOT NULL State

33 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

34 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

35 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

36 FIRST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL First Name Contact

37 LAST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL Last Name

38 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

39 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone

40 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

41 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone

42 CELL_PHONE Character(24) VARCHAR2(24) NOT NULL Cell Phone

43 FAX Character(24) VARCHAR2(24) NOT NULL This is the fax number field.

44 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

45 PRICE_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

46 DESCRLONG Long Character CLOB Long Description

47 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

48 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

49 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_ITEM

50 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost

51 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

52 REVENUE_TYPE Character(15) VARCHAR2(15) NOT NULL This field is used to store revenue type related to a product sales and used within forecasting.

53 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEAD_ID	Character(15)	VARCHAR2(15) NOT NULL	Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RSF_NONVW
3	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID Prompt Table: RSF_TER_NODE_VW
4	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RSF_REGION_VW
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
7	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer Default Value: 2 Prompt Table: RSF_BO_ROLTY_VW
8	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
9	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
10	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
11	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RA_NONVW
12	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
13	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
14	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
15	LEAD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used by Sales Force Automation to indicate what type of Lead, IN=Inquiry LE=Lead QU=Qualified Lead TQ=Turnback Qualified Lead TU=Turnback Lead
16	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
17	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY_VW
18	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.
19	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_USER_BU_VW
20	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
22	REFERRED_DT	Date(10)	DATE	Referred Date
23	ACCEPTED_DT	Date(10)	DATE	Accepted Date
24	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
25	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
26	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
27	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
28	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
29	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
30	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
31	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
32	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
33	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
34	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
35	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
36	FIRST_NAME_CNCT	Character(30)	VARCHAR2(30) NOT NULL	First Name Contact
37	LAST_NAME_CNCT	Character(30)	VARCHAR2(30) NOT NULL	Last Name
38	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
39	WORK_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Work Phone
40	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
41	HOME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Home Phone
42	CELL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cell Phone
43	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
44	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
45	PRICE_BASE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
46	DESCRLONG	Long Character	CLOB	Long Description
47	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
48	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
49	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_ITEM
50	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
51	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
52	REVENUE_TYPE	Character(15)	VARCHAR2(15) NOT NULL	This field is used to store revenue type related to a product sales and used within forecasting.
53	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage