Dimensional Warehouse Model Data Model

Entity

Entity Medical Expenditure Panel Survey Analysis

Description

Analysis of information received from the Medical Expenditure Panel Survey in the form of de-identified responses to survey questions. This allows the organization to understand the size of the insured and uninsured populations and their attitudes to medical insurance and associated costs. The analysis includes indicators of selected chronic conditions and other basic healthcare matters.

Attributes
Calendar Dk
Demographic Profile Dk
Geographic Area Dk
Number Of People Likely To Take Risk
Number Of People Surveyed
Number Of People Who Believe Insurance Not Worth Cost
Number Of People Who Believe They Can Overcome Illness
Number Of People Who Do Not Need Health Insurance
Number Of People With ADHD
Number Of People With Angina
Number Of People With Arthritis
Number Of People With Asthma
Number Of People With Cancer
Number Of People With Diabetes
Number Of People With Emphysema
Number Of People With Health Insurance
Number Of People With Heart Disease
Number Of People With High Cholesterol
Number Of People With Stroke
Number Of Respondents Pregnant
Percentage Of People Without Health Insurance
Survey Respondent Dk
Weighted Number Of People Surveyed

Relationship
Medical Expenditure Panel Survey Analysis_Calendar Dimension_FK
Medical Expenditure Panel Survey Analysis_Geographic Area Dimension_FK
Medical Expenditure Panel Survey Analysis_Survey Respondent Dimension_FK
Medical Expenditure Panel Survey Analysis_Demographic Profile Dimension_FK

Primary Key
Medical Expenditure Panel Survey Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

Demographic Profile 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	false

Geographic Area 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	false

Number Of People Likely To Take Risk

Description	The count of respondents who indicated that they were more likely to take risks in relation to health care costs.
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 People Surveyed

Description	The count of actual respondents to the survey.
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 People Who Believe Insurance Not Worth Cost

Description	The count of respondents who indicated that they believed the cost of health insurance exceeded the benefit.
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 People Who Believe They Can Overcome Illness

Description	The count of respondents who indicated that they could overcome illnesses without medical assistance.
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 People Who Do Not Need Health Insurance

Description	The count of respondents who indicated that they do not require health insurance.
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 People With ADHD

Description	The count of respondents who indicated that they had a diagnosis of attention deficit hyperactivity disorder (ADHD). This measure relates to children in the 5 to 17 years of age range.
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 People With Angina

Description	The count of respondents who indicated that they had a diagnosis of arthritis. This measure relates to adults.
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 People With Arthritis

Description	The count of respondents who indicated that they had a diagnosis of arthritis. This measure relates to adults.
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 People With Asthma

Description	The count of respondents who indicated that they had a diagnosis of asthma. This measure relates to adults.
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 People With Cancer

Description	The count of respondents who indicated that they had a diagnosis of cancer. This measure relates to adults.
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 People With Diabetes

Description	The count of respondents who indicated that they had a diagnosis of diabetes. This measure relates to adults.
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 People With Emphysema

Description	The count of respondents who indicated that they had a diagnosis of emphysema. This measure relates to adults.
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 People With Health Insurance

Description	The number of people who have some form of health insurance.
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 People With Heart Disease

Description	The count of respondents who indicated that they had a diagnosis of heat disease. This measure relates to adults.
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 People With High Cholesterol

Description	The count of respondents who indicated that they had a diagnosis of high cholesterol (hyperlipidemia). This measure relates to adults.
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 People With Stroke

Description	The count of respondents who indicated that they had a diagnosis of stroke disease. This measure relates to adults.
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 Respondents Pregnant

Description	The count of respondents who indicated that they were pregnant at some stage during the reference period of the survey.
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

Percentage Of People Without Health Insurance

Description	The number of people without health cover expressed as a percentage of the number of people surveyed. Formula: [((A-B)/A)*100] (see dependencies and their labels for measures used in the formula)
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

Survey Respondent 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	false

Weighted Number Of People Surveyed

Description	The count of respondents to the survey extrapolated by the statistical weightings associated with those respondents.
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

Relationship Details

Medical Expenditure Panel Survey Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Medical Expenditure Panel Survey Analysis
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medical Expenditure Panel Survey Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Medical Expenditure Panel Survey Analysis
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	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medical Expenditure Panel Survey Analysis_Survey Respondent Dimension_FK

Is Identifying Relationship	true
Child Table	Medical Expenditure Panel Survey Analysis
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	Survey Respondent Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Medical Expenditure Panel Survey Analysis_Demographic Profile Dimension_FK

Is Identifying Relationship	true
Child Table	Medical Expenditure Panel Survey Analysis
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	Demographic Profile Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Medical Expenditure Panel Survey Analysis PK

Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Survey Respondent Dk
Key Attribute	Demographic Profile Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model