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 |