RT_SALE_EFFC_VW(SQL View) |
Index Back |
---|---|
Sales Effectiveness ViewView to get data on Telemarketing Sales Effectiveness |
SELECT A.LEAD_ID , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.BUSINESS_UNIT , B.RC_BS_STATUS , B.ROW_LASTMANT_DTTM , B.SETID_PROV_GRP , B.PROVIDER_GRP_ID , B.ASSIGNED_TO FROM PS_RSF_LEAD A , PS_RC_CALL_RESULT B , PS_RA_CMPGN_WAVE C WHERE (A.RC_PROSPECT_SW = 'Y' OR CONV_FROM_TLM_DTTM IS NOT NULL) AND B.LEAD_ID = A.LEAD_ID AND B.RC_CALL_STATUS = 'CL' AND B.SEQNO = ( SELECT MAX( C.SEQNO) FROM PS_RC_CALL_RESULT C WHERE C.LEAD_ID = B.LEAD_ID) AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.RA_CAMPAIGN_ID = A.RA_CAMPAIGN_ID AND C.RA_CMPGN_WAVE_ID = A.RA_CMPGN_WAVE_ID AND C.RA_SCRIPT_ID_OTBN <> 0 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 | RC_BS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Branch Script Status. It is ether Valid or Invalid.
C=Completed P=Processing S=Started |
6 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
7 | SETID_PROV_GRP | Character(5) | VARCHAR2(5) NOT NULL | SetID |
8 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
9 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |