RSFM_LE_UN_VW

(SQL View)
 Index Back

Unassigned Leads for Mobile

All unassigned Leads for Mobile data distribution rule.

SELECT DISTINCT L.LEAD_ID , L.DESCR50 , L.BUSINESS_UNIT , L.SETID , L.CUST_ID , L.BO_ID_CUST , L.ROLE_TYPE_ID_CUST , L.OPPORTUNITY_ID , L.LEAD_RATING , L.LEAD_STATUS , L.TERRITORY_ID , L.REGION_ID , L.CUST_SETID , L.PROD_SETID , L.PROD_GRP_SETID , L.LEAD_SOURCE_ID , L.BUSINESS_UNIT_RA , L.RA_CAMPAIGN_ID , L.RA_CMPGN_WAVE_ID , L.LEAD_TYPE , L.INDUSTRY_ID , L.EST_REVENUE , L.CHNL_PARTNER_ID , L.ALLIANC_PARTNER_ID , L.REFERRED_DT , L.ACCEPTED_DT , %subrec(ADDRESS_SBR, L) , L.RC_BUS_UNIT , L.CASE_ID , L.RC_PROSPECT_SW , L.RC_PROSPECT_STAT , %subrec(RB_AUDIT_SBR, L) , %subrec(RB_MARKET_SBR , L) FROM PS_RSF_LEAD L WHERE L.RC_PROSPECT_SW = 'N' AND L.ROLE_TYPE_ID_CUST <> 9 AND NOT EXISTS ( SELECT 'X' FROM PS_RSF_LE_SLSREP WHERE LEAD_ID = L.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.

Default Value: NEXT

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

Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT

Prompt Table: SP_BU_RSF_NONVW

4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
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 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
9 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

10 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

Default Value: NE

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

Prompt Table: RSF_TERRITORY

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

Prompt Table: RSF_REGION_VW

13 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid
14 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID
15 PROD_GRP_SETID Character(5) VARCHAR2(5) NOT NULL Product Group SetID
16 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

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

Prompt Table: SP_BU_RA_NONVW

18 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

19 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

20 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
21 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

Prompt Table: RSF_INDUSTRY_VW

22 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.
23 CHNL_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier for a Channel Partner

Prompt Table: RSF_CHNL_PRT_VW

24 ALLIANC_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Alliance Partner

Prompt Table: RSF_ALLNC_PRT_V

25 REFERRED_DT Date(10) DATE Referred Date
26 ACCEPTED_DT Date(10) DATE Accepted Date
27 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

28 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
29 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
30 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
31 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
32 CITY Character(30) VARCHAR2(30) NOT NULL City
33 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
34 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
35 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
36 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
37 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
38 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
39 COUNTY Character(30) VARCHAR2(30) NOT NULL County
40 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

41 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
42 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
43 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

Default Value: Y

44 RC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
45 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
46 RC_PROSPECT_SW Character(1) VARCHAR2(1) NOT NULL Outbound Marketing

Y/N Table Edit

Default Value: N

47 RC_PROSPECT_STAT Character(2) VARCHAR2(2) NOT NULL Prospect Status
A=Assigned
C=Callback
D=Done
N=New
R=Rejected
48 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
49 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
50 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
51 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
52 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.
53 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
54 MARKET Character(3) VARCHAR2(3) NOT NULL Market