Campaign Step Allocation LimitCampaign Step Allocation PctCampaign Step Sequence NumNumber Of ContactsReminder PeriodTimeout Period
| Business Data Model Data Model |
| Description | A marketing activity that defines a single action within a campaign or campaign cell. Campaign steps are combined to form a set of rules for communicating with campaign targets. There is a unique 'communication matrix' for each cell within a campaign. |
| Attributes | |
| Campaign Step Allocation Limit |
|
| Campaign Step Allocation Pct |
|
| Campaign Step Sequence Num |
|
| Number Of Contacts |
|
| Reminder Period |
|
| Timeout Period |
|
| Relationship | |
 Campaign Cell includes Campaign Step |
|
| Party is responsible for Campaign Step |
|
| Generalization | |
 Campaign Step - Marketing Activity |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Campaign Step Allocation Limit
| Description | The maximum number of partys from the target market segment that can be allocated to a campaign step. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Step Allocation Pct
| Description | The percentage of the total target group to be arbitrarily allocated to a campaign step. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Step Sequence Num
| Description | The relative position of the step within the campaign or campaign cell as a whole. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Number Of Contacts
| Description | A count of parties the organization actually approached during the campaign in this campaign step. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Reminder Period
| Description | The number of days after the contact date that a reminder is sent. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Timeout Period
| Description | The number of days after the contact date that the campaign goes to the next step, if not previously advanced by a customer action. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Campaign Cell includes Campaign Step
| Is Identifying Relationship | false |
| Child Table | Campaign Step |
| Child Role Name | is included in |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Campaign Cell |
| Parent Role Name | includes |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Party is responsible for Campaign Step
| Is Identifying Relationship | false |
| Child Table | Campaign Step |
| Child Role Name | has as responsible |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Party |
| Parent Role Name | is responsible for |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Campaign Step - Marketing Activity
| Supertype | Marketing Activity |
| Subtype | Campaign Step |
| Transform As | TABLE |
| Business Data Model Data Model |