RDH_TELELEAD_VW

(SQL View)
 Index Back

Telemarketing Lead View

This view will provide details from PS_RSF_LEAD for TELEMARKETING Leads and whose Status is in ('N', 'C', 'A')

SELECT BUSINESS_UNIT_RA , RA_CAMPAIGN_ID , RA_CMPGN_WAVE_ID , LEAD_ID , BO_ID_CUST , ROLE_TYPE_ID_CUST FROM PS_RSF_LEAD WHERE RC_PROSPECT_SW = 'Y' AND RC_PROSPECT_STAT IN ('N', 'C', 'A') AND BUSINESS_UNIT_RA <> ' ' AND RA_CAMPAIGN_ID <> ' ' AND RA_CMPGN_WAVE_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit
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 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer