Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Marketing Activity Dimension

Description

An activity that the healthcare organization undertakes in order to acquire, retain, and develop business.

Attributes

Actual End Dt

Actual Labor Hours

Actual Start Dt

Actual Time Spent

Amount Determination Method Cd

Amount Determination Method Code Descr

Amount Determination Method Code Sk

AWM Load Info Sk

Before Tax Ind

Comment Txt

Current Ind

Delay Reason Cd

Delay Reason Code Descr

Delay Reason Code Sk

DWM Load Info Sk

Effective From Dt

Effective To Dt

End Date Determination Method Cd

End Date Determination Method Code Descr

End Date Determination Method Code Sk

External Reference

Keyword Txt

Marketing Activity Dimension Bk

Marketing Activity Dimension Dk

Marketing Activity Dimension Sk

Marketing Budget

Marketing Objective Amt

Marketing Objective Descr

Marketing Objective Qty

Name

Personnel Utilization

Planned Duration

Planned End Dt

Planned Manpower

Planned Start Dt

Recognition Rating Cd

Recognition Rating Code Descr

Recognition Rating Code Sk

Rival Comment Txt

Sample Size

Source Cd

Source Code Descr

Source Code Sk

Start Date Determination Method Cd

Start Date Determination Method Code Descr

Start Date Determination Method Code Sk

Start Dt

Target Qualification Cd

Target Qualification Code Descr

Target Qualification Code Sk

Tenant Sk

Type Cd

Type Code Descr

Type Code Sk

Utilization Unit Of Measure Cd

Utilization Unit Of Measure Code Descr

Utilization Unit Of Measure Code Sk

Valid From Ts

Valid To Ts

Primary Key

Marketing Activity Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

 Actual End Dt

Description	Actual date upon which the activity was completed.
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

---

 Actual Labor Hours

Description	A count of hours taken to perform the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Actual Start Dt

Description	Actual date upon which the activity commenced.
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

---

 Actual Time Spent

Description	The actual time spent performing the activity. This describes elapsed time rather than effort so a 4 hour task may have been completed over a period of 3 days.
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

---

 Amount Determination Method Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Amount Determination Method Code Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Amount Determination Method Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 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

---

 Comment Txt

Description	Free text comment made by the party about the subject of the market research.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Delay Reason Cd

Description	Indicates the cause of any discrepancy between planned and actual end dates.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Delay Reason Code Descr

Description	Indicates the cause of any discrepancy between planned and actual end dates.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Delay Reason Code Sk

Description	Indicates the cause of any discrepancy between planned and actual end dates.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Effective To Dt

Description	Ends a period of effectivity.
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

---

 End Date Determination Method Cd

Description	Identifies the method used to determine the end date for the marketing objective.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 End Date Determination Method Code Descr

Description	Identifies the method used to determine the end date for the marketing objective.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 End Date Determination Method Code Sk

Description	Identifies the method used to determine the end date for the marketing objective.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 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

---

 Keyword Txt

Description	Key words the participant associates with the subject of the market research.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Marketing Activity Dimension Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Marketing Activity Dimension Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

---

 Marketing Activity Dimension Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Marketing Budget

Description	The monetary provision made for planned marketing activities during a defined period.
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 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 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 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

---

 Name

Description	A word or phrase identifying the Marketing Activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Personnel Utilization

Description	Actual utilization of human resources for the marketing activity. This would typically be the number of labor hours or day expended on the activity.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Planned Duration

Description	The time planned for the performing of the activity. This is the total elapsed time over which the activity is expected to be performed and not the planned labor hours.
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

---

 Planned End Dt

Description	Date upon which the activity is planned to finish.
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

---

 Planned Manpower

Description	The planned labor hours required for the activity.
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

---

 Planned Start Dt

Description	Date upon which the activity is planned to start.
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

---

 Recognition Rating Cd

Description	A rating of the degree to which a party recognizes a subject presented to them. For example: Well known Heard of it Unknown
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Recognition Rating Code Descr

Description	A rating of the degree to which a party recognizes a subject presented to them. For example: Well known Heard of it Unknown
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Recognition Rating Code Sk

Description	A rating of the degree to which a party recognizes a subject presented to them. For example: Well known Heard of it Unknown
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Rival Comment Txt

Description	Free text comment made by the party about a rival offering related to the market research.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Sample Size

Description	The number of participants in a market research activity.
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

---

 Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Start Date Determination Method Cd

Description	Identifies the method used to determine the start date for the marketing objective.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Start Date Determination Method Code Descr

Description	Identifies the method used to determine the start date for the marketing objective.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Start Date Determination Method Code Sk

Description	Identifies the method used to determine the start date for the marketing objective.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Start Dt

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

---

 Target Qualification Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Target Qualification Code Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Target Qualification Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Type Cd

Description	The code that corresponds to the Type Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Type Code Descr

Description	The description that corresponds to the Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Type Code Sk

Description	The code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Utilization Unit Of Measure Cd

Description	Identifies the units in which the marketing activity personnel utilization is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Utilization Unit Of Measure Code Descr

Description	Identifies the units in which the marketing activity personnel utilization is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Utilization Unit Of Measure Code Sk

Description	Identifies the units in which the marketing activity personnel utilization is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Primary Key Details

 Marketing Activity Dimension PK

Key Attribute

Marketing Activity Dimension Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model