PROVIDER_GRP_IDRA_CAMPAIGN_IDRA_CMPGN_WAVE_IDLEAD_IDRC_OM_CALLBK_V2(SQL View) |
Index Back |
|---|---|
OM Result ViewOutbound Marketing View of callback records by AGENT |
| SELECT ' ' , B.RA_CAMPAIGN_ID , B.RA_CMPGN_WAVE_ID , A.LEAD_ID , B.BO_ID_CUST , A.SETID_PROV_GRP FROM PS_RC_CALL_RESULT A , PS_RSF_LEAD B , PS_RC_AGT_ASGMNT C WHERE A.DONE_FLAG <> 'Y' AND A.LEAD_ID = B.LEAD_ID AND (A.RC_CALLBACK_DATE < %CurrentDateIn OR (A.RC_CALLBACK_DATE = %CurrentDateIn AND A.RC_CALLBACK_TIME < %CurrentTimeIn )) AND B.BUSINESS_UNIT_RA = C.BUSINESS_UNIT AND B.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID AND B.RA_CMPGN_WAVE_ID = C.RA_CMPGN_WAVE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROVIDER_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 2 | 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. |
| 3 | RA_CMPGN_WAVE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 4 | LEAD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
| 5 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 6 | SETID_PROV_GRP | Character(5) | VARCHAR2(5) NOT NULL | SetID |