RC_OB_CWTEAM_VW

(SQL View)
 Index Back

Telemarketing Campaign Team

Telemarketing Campaign Wave Team view

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , B.PROVIDER_GRP_ID , B.SETID , B.NAME1 , B.STATUS FROM PS_RA_CMPGN_WAVE A , PS_RF_PROVIDER_GRP B , PS_SET_CNTRL_REC C , PS_RA_UD_CHNL_TYPE D , PS_SET_CNTRL_REC SC WHERE A.RA_CMPGN_STATUS_CD = 'EXEC' AND SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.RECNAME = 'RA_UD_CHNL_TYPE' AND D.SETID = SC.SETID AND A.RA_CHANNEL_TYPE = D.RA_CHANNEL_TYPE AND D.RA_CHNL_EXECUTION = '010' AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'RF_PROVIDER_GRP' AND C.SETID = B.SETID

  • Related Language Record: RC_OB_CWTEAMLVW

    • # 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 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    6 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive