RSF_LE_CNTCT_V2(SQL View) |
Index Back |
|---|---|
Lead Contacts ViewView of all Sales Lead Contacts |
| SELECT C.LEAD_ID , CASE WHEN C.BO_ID_CONTACT > 0 THEN B.BO_NAME ELSE C.CONTACT_NAME END , CASE WHEN C.BO_ID_CONTACT > 0 THEN B.BO_NAME_DISPLAY ELSE CASE WHEN C.FIRST_NAME > ' ' THEN %Sql(RA_RTRIM, C.FIRST_NAME) %Concat ' ' %Concat %Sql(RA_RTRIM, C.LAST_NAME) ELSE %Sql(RA_RTRIM, C.LAST_NAME) END END , CASE WHEN C.BO_ID_CONTACT > 0 THEN B.NAME_AC ELSE ' ' END , C.BO_ID_CONTACT ,C.CONTACT_ID ,C.COUNTRY_CODE ,C.WORK_PHONE ,C.EMAILID , 8 , C.PRIMARY_FLAG FROM PS_RSF_LE_CONTACTS C , PS_BO_NAME B WHERE B.PRIMARY_IND = 'Y' AND (( B.BO_ID = C.BO_ID_CONTACT) OR (C.BO_ID_CONTACT = 0 AND B.BO_ID = ( SELECT MIN(BO_ID) FROM PS_BO))) |
| # | 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_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 4 | BO_NAME_CONTACT_AC | Character(50) | VARCHAR2(50) NOT NULL | Alt-Char Contact Name |
| 5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 6 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 7 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 8 | WORK_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Work Phone |
| 9 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 10 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 11 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Primary |