9Logical Entity Relationships

Logical Entity Relationships

This appendix lists the logical entity relationships between marketing objects, business components, and specific columns in the S_SRC table. It includes the following topic:

Logical Entity Relationships for Marketing Objects

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

Table 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