RIM_LEAD_VW (SQL View)	Index Back
RIM Lead List Serach Record Used by Sales Force Automation to retrieve Lead from database.

RIM_LEAD_VW

(SQL View)

RIM Lead List Serach Record

Used by Sales Force Automation to retrieve Lead from database.

SELECT L.LEAD_ID ,L.BUSINESS_UNIT ,L.TREE_NAME ,L.TERRITORY_ID ,L.REGION_ID ,L.DESCR50 ,L.BO_ID_SITE ,L.CUST_SETID ,L.PRODUCT_ID ,L.PROD_SETID ,L.FULFILL_SETID ,L.NAME1 ,L.OPPORTUNITY_ID ,L.LEAD_SOURCE_ID ,L.BUSINESS_UNIT_RA ,L.RA_CAMPAIGN_ID ,L.RA_CMPGN_WAVE_ID ,L.LEAD_RATING ,L.LEAD_TYPE ,L.LEAD_STATUS ,L.INDUSTRY_ID ,L.EST_REVENUE ,L.PERSON_ID ,L.SALES_USER_NAME ,L.CURRENCY_CD ,L.CHNL_PARTNER_ID ,L.ALLIANC_PARTNER_ID ,L.REFERRED_DT ,L.ACCEPTED_DT ,L.NEXT_ACTIVITY_DT ,L.COUNTRY ,L.CITY ,L.STATE ,L.POSTAL ,L.BO_ID_CUST ,L.ROLE_TYPE_ID_CUST ,L.LEAD_REJECT_CD ,L.REJECTION_COMMENTS ,L.SALES_PRIORITY ,' ' ,' ' ,' ' ,' ' ,' ' ,L.BO_ID_CONTACT ,L.RC_BUS_UNIT ,L.CASE_ID ,L.AGREEMENT_CODE ,L.AGR_RENEWAL_NUM ,L.BO_ID_REFERRED_BY ,L.REFERRAL_FLG ,L.BO_ID_PARTNER ,L.BO_ID_PART_CONT ,L.PERSON_ID_PARTNER ,%subrec(RB_AUDIT_SBR, L) FROM PS_RSF_LEAD L WHERE L.RC_PROSPECT_SW = 'N'

# 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 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: RSF_OPR_TREE_VW

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

5 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
Prompt Table: RSF_TREE_VW

6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

7 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

8 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid

9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

10 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID

11 FULFILL_SETID Character(5) VARCHAR2(5) NOT NULL FULFIL

12 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

13 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

14 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_TBL

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

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

17 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

18 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

19 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

20 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

21 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
Prompt Table: RSF_INDUSTRY

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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RSF_USER_BU_VW

24 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field

25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

26 CHNL_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier for a Channel Partner

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

28 REFERRED_DT Date(10) DATE Referred Date

29 ACCEPTED_DT Date(10) DATE Accepted Date

30 NEXT_ACTIVITY_DT Date(10) DATE Next Activity Date

31 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

32 CITY Character(30) VARCHAR2(30) NOT NULL City

33 STATE Character(6) VARCHAR2(6) NOT NULL State

34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

35 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

36 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
Prompt Table: RSF_BO_ROLTY_VW

37 LEAD_REJECT_CD Character(10) VARCHAR2(10) NOT NULL LEAD_REJECT_CD
Prompt Table: RSF_LE_RJCT_A_V

38 REJECTION_COMMENTS Long Character CLOB Rejection/Turnback Comments

39 SALES_PRIORITY Character(3) VARCHAR2(3) NOT NULL Priority of sales lead and opportunity
1=1-One
2=2-Two
3=3-Three
4=4-Four
5=5-Five
6=6-Six
7=7-Seven
8=8-Eight
9=9-Nine
Default Value: 5

40 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

41 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

42 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

43 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

44 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

45 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

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 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

49 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)

50 BO_ID_REFERRED_BY Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Referred By (for Partners).

51 REFERRAL_FLG Character(1) VARCHAR2(1) NOT NULL Field used as an indicator for identifying referral type of leads.
Y/N Table Edit
Default Value: N

52 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.

53 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.

54 PERSON_ID_PARTNER Character(15) VARCHAR2(15) NOT NULL Partner Rep

55 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

56 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

57 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

58 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

60 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: RSF_OPR_TREE_VW
4	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID
5	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RSF_TREE_VW
6	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
7	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
8	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
9	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
10	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SET ID
11	FULFILL_SETID	Character(5)	VARCHAR2(5) NOT NULL	FULFIL
12	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
13	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
14	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_TBL
15	BUSINESS_UNIT_RA	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
16	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.
17	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
18	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
19	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
20	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
21	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY
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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_USER_BU_VW
24	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
26	CHNL_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier for a Channel Partner
27	ALLIANC_PARTNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Alliance Partner
28	REFERRED_DT	Date(10)	DATE	Referred Date
29	ACCEPTED_DT	Date(10)	DATE	Accepted Date
30	NEXT_ACTIVITY_DT	Date(10)	DATE	Next Activity Date
31	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
32	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
33	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
34	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
35	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
36	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer Prompt Table: RSF_BO_ROLTY_VW
37	LEAD_REJECT_CD	Character(10)	VARCHAR2(10) NOT NULL	LEAD_REJECT_CD Prompt Table: RSF_LE_RJCT_A_V
38	REJECTION_COMMENTS	Long Character	CLOB	Rejection/Turnback Comments
39	SALES_PRIORITY	Character(3)	VARCHAR2(3) NOT NULL	Priority of sales lead and opportunity 1=1-One 2=2-Two 3=3-Three 4=4-Four 5=5-Five 6=6-Six 7=7-Seven 8=8-Eight 9=9-Nine Default Value: 5
40	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
41	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
42	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
43	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
44	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
45	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
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	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
49	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
50	BO_ID_REFERRED_BY	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Referred By (for Partners).
51	REFERRAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field used as an indicator for identifying referral type of leads. Y/N Table Edit Default Value: N
52	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
53	BO_ID_PART_CONT	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the business object identifier for the partner contact.
54	PERSON_ID_PARTNER	Character(15)	VARCHAR2(15) NOT NULL	Partner Rep
55	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
56	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
57	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
58	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
59	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.
60	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time