Bookshelf Home | Contents | Index | PDF     

Siebel Marketing Installation and Administration Guide >

Logical Entity Relationships

Table 29 shows the logical entity relationships between marketing objects, business components, and specific columns in the S_SRC table.

Table 29. Logical Entity Relationships for Marketing Objects
Object
Business Component Name
Columns in S_SRC
CAMP_TYPE_CD
PAR_SRC_ID
SUB_TYPE
TEMPLATE_ID
TMPL_ID
ULT_PAR_SRC_ID
Campaign
Campaign
Campaign
Parent Campaign Id
MARKETING_CAMPAIGN
Campaign Template Id
Stage Id
Program Id
Campaign Template
Campaign Template
Campaign
NULL
MARKETING_CAMPAIGN
NULL
Stage Id
Program Tmpl Id
Marketing Plans
Marketing Plans
Marketing Plan
Parent Mktg Plan Id
MARKETING_CAMPAIGN
NULL
NULL
NULL
Program
Program Container
PROGRAM CONTAINER
NULL
MARKETING_CAMPAIGN
Program Template Id
NULL
Program Id
Program Template
Program Template
PROGRAM CONTAINER
NULL
MARKETING_CAMPAIGN
NULL
NULL
Program Tmpl Id
Stage
Program (DBM)
STAGE
NULL
MARKETING_CAMPAIGN
NULL
Program Id
Program Id

  
Siebel Marketing Installation and Administration Guide Copyright © 2006, Oracle. All rights reserved.