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

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 , A.STATE , A.POSTAL , A.FIRST_NAME , A.LAST_NAME FROM PS_RSF_LEAD A

# 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 STATE Character(6) VARCHAR2(6) NOT NULL State
31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
32 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
33 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name