RC_OB_CWLIST_VW

(SQL View)
 Index Back

Telemarketing Wave List

Telemarketing application Wave list view

SELECT A.BUSINESS_UNIT_RA , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.LEAD_ID , A.RC_PROSPECT_STAT , %Substring(C.CONTACT_NAME,1,40) , B.PROVIDER_GRP_ID , B.PROVIDER_GRP_NAME , B.ASSIGNED_TO FROM PS_RSF_LEAD A , PS_RT_CWLIST_VW B , PS_RSF_LE_CONTACTS C WHERE RC_PROSPECT_STAT IN ('C', 'N') AND A.LEAD_ID = C.LEAD_ID AND C.SEQNUM = 1 AND A.LEAD_ID = B.LEAD_ID (+)

  • Related Language Record: RC_OB_CWLISTLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT 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 RC_PROSPECT_STAT Character(2) VARCHAR2(2) NOT NULL Prospect Status
    A=Assigned
    C=Callback
    D=Done
    N=New
    R=Rejected
    6 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    7 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    8 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name
    9 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.