RSFM_LE_MGR_VW

(SQL View)
 Index Back

Owner Manager Leads (Mobile)

Owner Manager Leads (Mobile). Used by Mobile Sales.

SELECT DISTINCT L.LEAD_ID , L.DESCR50 , L.BUSINESS_UNIT , M.PERSON_ID_MANAGER , L.PERSON_ID , 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 , PS_RSF_ACC_MGR_VW M WHERE L.ROLE_TYPE_ID_CUST <> 9 AND L.PERSON_ID = M.PERSON_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 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
5 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
6 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
7 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
8 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
9 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

10 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
11 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

12 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

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

Prompt Table: RSF_TERRITORY

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

Prompt Table: RSF_REGION_VW

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

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

Prompt Table: SP_BU_RA_NONVW

20 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

21 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

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

Prompt Table: RSF_INDUSTRY_VW

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

Prompt Table: RSF_CHNL_PRT_VW

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

Prompt Table: RSF_ALLNC_PRT_V

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

Prompt Table: COUNTRY_TBL

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

Prompt Table: %EDIT_STATE

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

Y/N Table Edit

Default Value: Y

46 RC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
47 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.
48 RC_PROSPECT_SW Character(1) VARCHAR2(1) NOT NULL Outbound Marketing

Y/N Table Edit

Default Value: N

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