Dimensional Warehouse Model Data Model

Entity

Entity American Community Survey Analysis

Description

Analysis of information received from the American Community 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 including selected indicators of basic health and concerns.

Attributes
Calendar Dk
Demographic Profile Dk
Geographic Area Dk
Number Of People Surveyed
Number Of People With Ambulatory Difficulty
Number Of People With Cognitive Difficulty
Number Of People With Employment Based Health Insurance
Number Of People With Health Insurance
Number Of People With Hearing Difficulty
Number Of People With Independent Living Difficulty
Number Of People With Indian Health Service Cover
Number Of People With Medicaid Health Insurance
Number Of People With Medicare Health Insurance
Number Of People With Personally Acquired Health Insurance
Number Of People With Private Health Insurance
Number Of People With Public Health Insurance
Number Of People With Recent Child Birth
Number Of People With TRICARE Health Insurance
Number Of People With VA Health Insurance
Number Of People With Vision Difficulty
Percentage Of People Without Health Insurance
Percentage Of People With Private Health Insurance
Survey Respondent Dk
Weighted Number Of People Surveyed

Relationship
American Community Survey Analysis_Calendar Dimension_FK
American Community Survey Analysis_Geographic Area Dimension_FK
American Community Survey Analysis_Survey Respondent Dimension_FK
American Community Survey Analysis_Demographic Profile Dimension_FK

Primary Key
American Community 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 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 With Ambulatory Difficulty

Description	The number of people whose mobility is compromised to the extent that they have difficulty moving around their environment without 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 With Cognitive Difficulty

Description	The number of people who suffer from some form of cognitive impairment whereby they may have poor short term memory, they may have difficulty recognizing family or friends and may easily become confused.
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 Employment Based Health Insurance

Description	The number of people who acquired their health insurance cover through a current or former employer or union.
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 Hearing Difficulty

Description	The number of people who suffer from complete or partial hearing loss.
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 Independent Living Difficulty

Description	The number of people who are unable to live independent lives without significant assistance from family members or other care providers.
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 Indian Health Service Cover

Description	The number of people whose health insurance cover is provided by the Indian Health Service.
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 Medicaid Health Insurance

Description	The number of people whose health insurance cover is provided by Medicaid, Medical Assistance, or any kind of government assistance plan for those with low incomes or a disability.
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 Medicare Health Insurance

Description	The number of people whose health insurance cover is provided by Medicare. (for people 65 and older or people with certain disabilities)
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 Personally Acquired Health Insurance

Description	The number of people who acquired their health insurance cover directly from an insurer.
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 Private Health Insurance

Description	The number of people who have private health insurance coverage.
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 Public Health Insurance

Description	The number of people who have public health insurance coverage.
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 Recent Child Birth

Description	The number of people who have given birth within the last 12 months.
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 TRICARE Health Insurance

Description	The number of people whose health insurance cover is provided by TRICARE or other military health care.
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 VA Health Insurance

Description	The number of people whose health insurance cover is provided by the Veterans Association (VA) including those who have ever used or enrolled for VA health care.
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 Vision Difficulty

Description	The number of people who suffer from complete or partial sight loss.
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

Percentage Of People With Private Health Insurance

Description	The number of people with private health cover expressed as a percentage of the number of people in the survey. Formula: [(A/B)*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

American Community Survey Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	American Community 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

American Community Survey Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	American Community 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

American Community Survey Analysis_Survey Respondent Dimension_FK

Is Identifying Relationship	true
Child Table	American Community 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

American Community Survey Analysis_Demographic Profile Dimension_FK

Is Identifying Relationship	true
Child Table	American Community 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

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