RSFM_LE_MM_VW

(SQL View)
 Index Back

Team Mbr Mgr Leads (Mobile)

Team Mbr Mgr Leads (Mobile). Used by Mobile Sales.

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

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

13 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

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

Prompt Table: RSF_TERRITORY

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

Prompt Table: RSF_REGION_VW

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

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

Prompt Table: SP_BU_RA_NONVW

21 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

22 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

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

Prompt Table: RSF_INDUSTRY_VW

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

Prompt Table: RSF_CHNL_PRT_VW

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

Prompt Table: RSF_ALLNC_PRT_V

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

Prompt Table: COUNTRY_TBL

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

Prompt Table: %EDIT_STATE

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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