RSF_WM_CONT_VW (SQL View)	Index Back
Lead Contacts Stores all the contacts for a lead.

RSF_WM_CONT_VW

(SQL View)

Lead Contacts

Stores all the contacts for a lead.

SELECT C.LEAD_ID , C.CONTACT_ID , L.BO_ID_CONTACT , C.CONTACT_NAME , C.FIRST_NAME , C.LAST_NAME , C.PRIMARY_FLAG , C.COUNTRY_CODE , C.WORK_PHONE , C.EXTENSION , C.HOME_PHONE , C.CELL_PHONE , C.FAX , C.EMAILID FROM PS_RSF_LE_CONTACTS C , PS_RSF_LEAD L WHERE C.LEAD_ID = L.LEAD_ID AND CONTACT_NAME <> ' ' AND PRIMARY_FLAG = 'Y'

# 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 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RD_PERSON
Set Control Field: PERSON_ID

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

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

5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

7 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary
Y/N Table Edit

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

9 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone
Prompt Table: RSF_PER_W_PH_VW

10 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

11 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone
Prompt Table: RSF_PER_H_PH_VW

12 CELL_PHONE Character(24) VARCHAR2(24) NOT NULL Cell Phone
Prompt Table: RSF_PER_C_PH_VW

13 FAX Character(24) VARCHAR2(24) NOT NULL This is the fax number field.
Prompt Table: RSF_PER_FAX_VW

14 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
Prompt Table: RSF_PER_EMAILVW

#	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	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RD_PERSON Set Control Field: PERSON_ID
3	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
4	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	PRIMARY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Primary Y/N Table Edit
8	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
9	WORK_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Work Phone Prompt Table: RSF_PER_W_PH_VW
10	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
11	HOME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Home Phone Prompt Table: RSF_PER_H_PH_VW
12	CELL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cell Phone Prompt Table: RSF_PER_C_PH_VW
13	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field. Prompt Table: RSF_PER_FAX_VW
14	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address Prompt Table: RSF_PER_EMAILVW