Atomic Warehouse Model Data Model

Entity

Entity Marketing Activity Detail

Description

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

Attributes
Actual End Dt
Actual Labor Hours
Actual Marketing Planning Cost
Actual Market Research Cost
Actual Start Dt
Actual Time Spent
Amount Determination Method Code Sk
Before Tax Ind
Comment Txt
Delay Reason Code Sk
Effective From Dt
Effective To Dt
End Date Determination Method Code Sk
External Reference
Keyword Txt
Load Info Sk
Marketing Activity Sk
Marketing Budget
Marketing Costs
Marketing Objective Amt
Marketing Objective Descr
Marketing Objective Qty
Name
Personnel Utilization
Planned Duration
Planned End Dt
Planned Manpower
Planned Marketing Planning Cost
Planned Market Research Cost
Planned Start Dt
Recognition Rating Code Sk
Rival Comment Txt
Sample Size
Source Code Sk
Start Date Determination Method Code Sk
Start Dt
Target Qualification Code Sk
Tenant Sk
Type Code Sk
Utilization Unit Of Measure Code Sk
Valid From Ts
Valid To Ts

Relationship
Marketing Activity Detail_Marketing Activity_FK

Primary Key
Marketing Activity Detail 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 Marketing Planning Cost

Description	Actual portion of the marketing costs that is allocated to planning.
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

Actual Market Research Cost

Description	Actual portion of the marketing costs that is allocated to market research.
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

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 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

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 survey.
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

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

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 Code Sk

Description	Date determination method used to identify how the end date for the marketing objective has been established.
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 which the participant associates with the subject of the survey.
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

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

Marketing Activity Sk

Description	Surrogate key for the anchor entity.
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	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 Costs

Description	Total of all expenses incurred in the overall marketing process including research, planning and execution.
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	Name of the 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 describes elapsed time rather than effort so a 4 hour task may be planned for completion 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

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 anticipated manpower required for the activity typically expressed in 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 Marketing Planning Cost

Description	The monetary value of the portion of the budgeted marketing costs that is allocated to planning.
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

Planned Market Research Cost

Description	The monetary value of the portion of the budgeted marketing costs that is allocated to market research.
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

Planned Start Dt

Description	Date upon which the activity is planned to commence.
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 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 to the subject of the survey.
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 sample size as applicable to the method applied to indicate 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 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 Code Sk

Description	Date determination method used to identify how the start date for the marketing objective has been established.
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 on 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 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 Code Sk

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business 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 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	true
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

Relationship Details

Marketing Activity Detail_Marketing Activity_FK

Is Identifying Relationship	false
Child Table	Marketing Activity Detail
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 Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Marketing Activity Detail PK

Key Attribute	Marketing Activity Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model