RSF_IMP_RSL2_VW

(SQL View)
 Index Back

Used in Imports Config Search

View used in Imports Config Search

SELECT R.SYNCID , V.ROW_NUMBER , V.LEAD_IMP_STATUS , V.BUSINESS_UNIT , V.TERRITORY_ID , V.REGION_ID , V.DESCR50 , V.NAME1 , V.LEAD_SOURCE_ID , V.BUSINESS_UNIT_RA , V.RA_CAMPAIGN_ID , V.RA_CMPGN_WAVE_ID , V.LEAD_RATING , V.LEAD_TYPE , V.LEAD_STATUS , V.CURRENCY_CD , V.EST_REVENUE , V.PERSON_ID , V.SALES_USER_NAME , V.COUNTRY , V.ADDRESS1 , V.CITY , V.STATE , V.POSTAL , V.FIRST_NAME , V.LAST_NAME , V.FIRST_NAME_CNCT , V.LAST_NAME_CNCT , V.WORK_PHONE , V.HOME_PHONE , V.CELL_PHONE , V.EMAILID , V.PRODUCT_GROUP , V.PRODUCT_ID , V.RC_SUMMARY , V.LAST_IMPORTED_DTTM , V.DESCRLONG FROM PS_RB_IMP_RUN R , PS_RSF_LEAD_VIV V WHERE R.OPRID = V.OPRID AND R.DTTM_IMPORTED = V.DTTM_IMPORTED AND R.SYNCID <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2 ROW_NUMBER Number(10,0) DECIMAL(10) NOT NULL Row Number
3 LEAD_IMP_STATUS Character(2) VARCHAR2(2) NOT NULL Status of the Lead Import
CD=Not Imported -- Customer Data
DP=Duplicate
E1=Failed Edit Checks
E2=Not Imported -- Errors Found
IM=Imported
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RSF_NONVW

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

Prompt Table: RSF_TER_NODE_VW

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

Prompt Table: RSF_REGION_VW

7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
8 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
9 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

10 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit
11 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.
12 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
13 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

14 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
15 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
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
17 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.
18 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_USER_BU_VW

19 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
22 CITY Character(30) VARCHAR2(30) NOT NULL City
23 STATE Character(6) VARCHAR2(6) NOT NULL State
24 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
25 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
26 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
27 FIRST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL First Name Contact
28 LAST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL Last Name
29 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone
30 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone
31 CELL_PHONE Character(24) VARCHAR2(24) NOT NULL Cell Phone
32 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
33 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
34 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

35 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
36 LAST_IMPORTED_DTTM DateTime(26) TIMESTAMP Last Import Attempt made on this date and time
37 DESCRLONG Long Character CLOB Long Description