| Business Data Model Data Model |
| Description | A marketing activity that the healthcare organization undertakes to achieve a specific business objective. In particular, this covers coordinated communication with the marketplace in order to acquire, retain and develop business. |
| Relationship | |
 Person manages Campaign |
|
| Generalization | |
 Campaign - Marketing Activity |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Campaign Agreement Sales
| Description | The number of agreements (for example: policies) sold for a product targeted by the campaign. |
| 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 Category
| Description | Campaign Category classifies campaigns according to how the campaign is run. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Code
| Description | An alphanumeric label indicating a particular campaign. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Maximum Target Num
| Description | The upper limit of the number of targets, typically existing or potential customers, to be included in the campaign. A zero or null value indicates the campaign has no upper limit for targets. |
| 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 Targeted Num
| Description | The number of parties the organization actually approached during the campaign. |
| 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 |
Cross-sell Strategy
| Description | A word or phrase used to identify the cross-selling strategy. For example: Basic Cover Upgrade Include Dental |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Number Of New Groups Enrolled
| Description | A count of new groups the healthcare insurer actually enrolled as a result of the campaign. |
| 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 |
Number Of New Members Gained
| Description | A count of new members enrolled as a result of the campaign. |
| 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 |
Number Of New Subscribers Enrolled
| Description | A count of new paying subscribers enrolled as a result of the campaign. |
| 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 |
Premium Income From Groups
| Description | The monetary value of premiums from health benefits plan groups enrolled or retained as a result of the campaign. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Premium Income From Individuals
| Description | The monetary value of premiums from new persons enrolled as a result of the campaign. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Premium Profit From Groups
| Description | The monetary value of profit generated by premiums from health benefits plan groups enrolled or retained as a result of the campaign. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Premium Profit From Individuals
| Description | The monetary value of profit generated by premiums from new persons enrolled as a result of the campaign. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Result End Date
| Description | The last date on which results are recorded for the campaign. Derived from the status related information. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Person manages Campaign
| Is Identifying Relationship | false |
| Child Table | Campaign |
| Child Role Name | is managed by |
| 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 | Person |
| Parent Role Name | manages |
| 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 - Marketing Activity
| Supertype | Marketing Activity |
| Subtype | Campaign |
| Transform As | TABLE |
| Business Data Model Data Model |