| Business Data Model Data Model |
| Description | A business goal that the healthcare organization expects to achieve. For example: Making a total financial gain of USD 150,000 as a result of a marketing campaign. Selling 5,000 new policies as a result of a cross-selling marketing campaign. Generating 500 new patient contacts through an advertised wellness assessment program. |
| Relationship | |
 Marketing Activity has for objective Marketing Objective |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Marketing Objective Amount Determination Method
| Description | Indicates how the amount of this marketing objective has been established. For example: As estimated by an expert As estimated by the party through the use of the healthcare insurer's scoring model. As specified by the party Highest possible loss |
| 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 |
Marketing Objective Amt
| Description | The amount of money this marketing objective is expecting. For example: 20,000 EUR (total premium) 35,000 EUR (profit) EUR 20,000 (total premium) EUR 35,000 (profit) |
| 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 |
Marketing Objective Before Tax Ind
| Description | Indicates whether the amount for this marketing objective is to be considered as estimated before tax (True) or after tax (False). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Marketing Objective Descr
| Description | The textual description of the objectives or business goals. For example: Sell 20,000 new policies of the Victoria Health Plus product. The objective for the campaign for Universal life product launch has for objective an overall sum insured of 50,000,000 USD. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Marketing Objective End Date Determination Method
| Description | Identifies the method used to determine the end date for the marketing objective. |
| 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 |
Marketing Objective External Reference
| Description | The number or code allocated to a marketing objective for identification and communication purposes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Marketing Objective Qty
| Description | The number of units the marketing objective is expecting. For example: 5,000 (new policies) 2,000 (new members) |
| 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 |
Marketing Objective Start Date
| Description | The date upon which the marketing objective is deemed to have come into existence. |
| 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 |
Marketing Objective Start Date Determination Method
| Description | Identifies the method used to determine the start date for the marketing objective. |
| 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 |
Target Qualification
| Description | Identifies the type of marketing amount or quantity that defines the marketing objective. For example: Customers. Policies. Premium. Profit. Revenue. |
| 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 |
| Relationship Details |
Marketing Activity has for objective Marketing Objective
| Description | The identification of an objective or business goal expected to be achieved as the result of a marketing activity. |
| Is Identifying Relationship | false |
| Child Table | Marketing Objective |
| Child Role Name | is objective for |
| 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 | Marketing Activity |
| Parent Role Name | has for objective |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |