LEAD_IDRT_CONV_LEAD_VW(SQL View) |
Index Back |
|---|---|
Telemarketing report viewReport view for Telemarketing report of converted leads (prospects) |
| SELECT A.LEAD_ID , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.BUSINESS_UNIT , A.TREE_NAME , A.TERRITORY_ID , A.ACCEPTED_DT , A.REJECTED_DT , A.CONV_FROM_TLM_DTTM , B.SETID_PROV_GRP , B.PROVIDER_GRP_ID , B.ASSIGNED_TO FROM PS_RSF_LEAD A , PS_RC_CALL_RESULT B WHERE A.RC_PROSPECT_SW = 'N' AND A.CONV_FROM_TLM_DTTM IS NOT NULL AND A.LEAD_ID = B.LEAD_ID AND B.RC_FINAL_DISPOSTN <> ' ' AND B.SEQNO = ( SELECT MAX( C.SEQNO) FROM PS_RC_CALL_RESULT C WHERE C.LEAD_ID = B.LEAD_ID) |
| # | 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 | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 6 | TERRITORY_ID | Character(20) | VARCHAR2(20) NOT NULL | Territory ID |
| 7 | ACCEPTED_DT | Date(10) | DATE | Accepted Date |
| 8 | REJECTED_DT | Date(10) | DATE | Rejected Date |
| 9 | CONV_FROM_TLM_DTTM | DateTime(26) | TIMESTAMP | Convert from TeleSales Date and Time |
| 10 | SETID_PROV_GRP | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 11 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 12 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |