Business Data Model Data Model

Entity

Entity Health Plan Product

Description

A product offering of healthcare coverages for a health benefits plan group or person. A health plan is offered or administered by a healthcare insurer that provides financing or delivery of healthcare services to, or on behalf of, members. The health plan product is developed by the healthcare insurer as a marketable offering.

Attributes
Brand
Brand Name Fee
Concept Development Cost
Concept Development Support Cost
Creation Cost Amt
Deductible Carryover Ind
Development Cost Amt
End Date
Exposure Basis Unit Of Measure
Individual Group Ind
Launch Cost Amt
Line Of Business
Marketing Budget
Marketing Execution Cost
Marketing Planning Cost
Market Pos
Market Research Cost
Market Share
Product Code
Product Code Qualifier
Product Status
Product Time To Market Range
Profitability
Risk Type
Selling General And Administration SGA Cost
Start Date
Total Marketing Cost

Relationship
Health Plan Product_Health Plan Product_FK
Brand includes Product
Health Plan Product_Party_FK

Generalization
Health Plan Product_Health Plan_Gen

Dependencies
NONE

Reverse Dependencies

Attribute Details

Brand

Description	A name, logo, trademark, or service mark that is associated with the product.
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

Brand Name Fee

Description	Fee charged to a member on top of the usual co-payment amount for selecting the brand name drug when a generic drug is available.
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

Concept Development Cost

Description	Total cost of developing the product concept.
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

Concept Development Support Cost

Description	Total costs for providing support to the concept development activities.
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

Creation Cost Amt

Description	The expense amount involved in creation of the product between the concept development and the launch.
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

Deductible Carryover Ind

Description	Indicating whether or not a deductible amount can be carried over from another policy.
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

Development Cost Amt

Description	The expense amount involved in development of the product.
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

End Date

Description	The date upon which the product is deemed to have ceased to exist.
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

Exposure Basis Unit Of Measure

Description	Indicates the basis used for an insured exposure based on units, number of employees, predicted healthcare costs etc.
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

Individual Group Ind

Description	Indicates whether the health plan product is designed to cater to the needs of persons or health benefits plan groups. For example: G = Group P = Person
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Launch Cost Amt

Description	The expense amount involved in the launch of the product.
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

Line Of Business

Description	Indicates the nature of commercial enterprise to which this health plan product is directed or associated.
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 Budget

Description	The marketing budget for planned marketing activities for promotion of sales during the period covered by the market information: campaigns, marketing events, advertisement, etc.
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 Execution Cost

Description	Total of component expenses required for the execution of marketing.
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 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

Market Pos

Description	Positioning of the product relative to rival Products in the targeted market segment. For example: Market Leader Second Third
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

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

Market Share

Description	Percentage of a given market that has adopted, or is expected to adopt, this health plan product.
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

Product Code

Description	An alphanumeric code assigned to the product.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Code Qualifier

Description	Designates the format of the product code.
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

Product Status

Description	Indicates the status of the health plan product.
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

Product Time To Market Range

Description	The total cycle-time range to bring the health plan product to market, which is the total time that elapses between the introduction of a product idea and its first availability in the market.
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

Profitability

Description	The target profit for the specified product as cash amount.
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

Risk Type

Description	Indicates the types of risk or financial exposure to the health plan.
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

Selling General And Administration SGA Cost

Description	The selling, general and administration (SGA) expenses of the product.
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

Start Date

Description	The date upon which the product 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

Total Marketing Cost

Description	Total of component expenses required for the overall marketing process.
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

Relationship Details

Health Plan Product_Health Plan Product_FK

Is Identifying Relationship	false
Child Table	Health Plan Product
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	Health Plan Product
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Brand includes Product

Is Identifying Relationship	false
Child Table	Health Plan Product
Child Role Name	is marketed under
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	Brand
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

Health Plan Product_Party_FK

Is Identifying Relationship	false
Child Table	Health Plan Product
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 Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Generalization Details

Health Plan Product_Health Plan_Gen

Supertype	Insurance Plan
Subtype	Health Plan Product
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model