RC_OM_CMPGRP_VW

(SQL View)
 Index Back

Telemarketing Campaign Group

Telemarketing Campaign Group View

SELECT A.BUSINESS_UNIT ,A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , B.PROVIDER_GRP_ID , A.RA_WAVE_NAME , B.SETID , C.NAME1 FROM PS_RA_CMPGN_WAVE A , PS_RC_GRP_ASGMNT B , PS_RF_PROVIDER_GRP C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = B.RA_CMPGN_WAVE_ID AND B.SETID = C.SETID AND B.PROVIDER_GRP_ID = C.PROVIDER_GRP_ID

  • Related Language Record: RC_OM_CMPGRPLVW

    • # 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 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
    6 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    7 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.