RA_CAMPAIGN_IDRA_CMPGN_WAVE_IDLEAD_IDRC_OMPR_ASGMT_V(SQL View) |
Index Back |
|---|---|
Assignment ViewTelemarketing, this view contains all prospects ordered by campaign wave that are not assigned (no person id or team id), prospect switch is a Y and PROSPECT STATUS is NEW |
| SELECT L.RA_CAMPAIGN_ID , L.RA_CMPGN_WAVE_ID , L.LEAD_ID , L.BO_ID_CUST , L.ROLE_TYPE_ID_CUST , C.BO_ID_CONTACT FROM PS_RSF_LEAD L , PS_RSF_LE_CONTACTS C WHERE L.RC_PROSPECT_SW = 'Y' AND L.RC_PROSPECT_STAT = 'N' AND L.LEAD_ID = C.LEAD_ID AND C.SEQNUM = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | RA_CMPGN_WAVE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 3 | LEAD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
| 4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 5 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 6 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |