Dimensional Warehouse Model Data Model

Entity

Entity BRFSS Analysis

Description

Analysis of information received from the Behavioral Risk Factor Surveillance System (BRFSS) 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 declared state of physical and mental health. The analysis includes indicators of selected chronic conditions and tests for those conditions as well as some other basic healthcare indicators relating to diet and smoking status.

Attributes
Calendar Dk
Demographic Profile Dk
Geographic Area Dk
Number Of Days Mental Health Not Good
Number Of Days Physical Health Not Good
Number Of People On BP Medication
Number Of People Regularly Drinking Fruit Juice
Number Of People Regularly Eating Beans Or Lentils
Number Of People Regularly Eating Fruit
Number Of People Smoking
Number Of People Surveyed
Number Of People Using Smokeless Tobacco Product
Number of People Who Did Not See Doctor Due To Cost
Number Of People Who Stopped Smoking Recently
Number Of People With Angina Or CHD Ever
Number Of People With Arthritis Ever
Number Of People With Asthma Ever
Number Of People With Asthma Now
Number Of People With COPD Ever
Number Of People With Depression Ever
Number Of People With Diabetes Ever
Number Of People With Health Insurance
Number Of People With Heart Attack Ever
Number Of People With High Blood Pressure
Number Of People With High Cholesterol Ever
Number Of People With Kidney Disease Ever
Number Of People With Multiple Healthcare Professionals
Number Of People With Other Cancer Ever
Number Of People With Skin Cancer Ever
Number Of People With Stroke Ever
Number Of People With Vision Disorder Ever
Number Of Respondents Pregnant
Percentage Of People Without Health Insurance
Survey Respondent Dk
Weighted Number Of People Surveyed

Relationship
BRFSS Analysis_Calendar Dimension_FK
BRFSS Analysis_Geographic Area Dimension_FK
BRFSS Analysis_Survey Respondent Dimension_FK
BRFSS Analysis_Demographic Profile Dimension_FK

Primary Key
BRFSS 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 Days Mental Health Not Good

Description	A count of days during the reference period of the survey that the respondent had poor mental health.
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 Days Physical Health Not Good

Description	A count of days during the reference period of the survey that the respondent had poor physical health.
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 On BP Medication

Description	The number of people who are currently taking medication to control their blood pressure.
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 Regularly Drinking Fruit Juice

Description	The count of respondents who indicated that they drank 100% pure fruit juice on a regular basis during a reference period.
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 Regularly Eating Beans Or Lentils

Description	The count of respondents who indicated that they ate beans or lentils on a regular basis during a reference period.
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 Regularly Eating Fruit

Description	The count of respondents who indicated that they ate fruit on a regular basis during a reference period.
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 Smoking

Description	The count of respondents who indicated that they have smoked at least 100 cigarettes.
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 Using Smokeless Tobacco Product

Description	The count of respondents who indicated that they use a smokeless tobacco product.
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 Did Not See Doctor Due To Cost

Description	The number of people who did not attend a medical practitioner because of the cost of the 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 Who Stopped Smoking Recently

Description	The count of respondents who indicated that they have stopped smoking 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 Angina Or CHD Ever

Description	The count of respondents who indicated that they ever had a diagnosis of angina or coronary heart disease.
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 Ever

Description	The count of respondents who indicated that they have ever been told they had arthritis.
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 Ever

Description	The count of respondents who indicated that they ever had a diagnosis of asthma.
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 Now

Description	The count of respondents who indicated that they currently have a diagnosis of asthma.
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 COPD Ever

Description	The count of respondents who indicated that they have ever been told they had chronic obstructive pulmonary disease, emphysema or chronic bronchitis.
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 Depression Ever

Description	The count of respondents who indicated that they have ever been told they had a depressive disorder.
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 Ever

Description	The count of respondents who indicated that they have ever been told they had diabetes.
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 Attack Ever

Description	The count of respondents who indicated that they ever had a diagnosis of heart attack.
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 Blood Pressure

Description	The number of people who have ever been told they had high blood pressure.
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 Ever

Description	The count of respondents who indicated that they ever had a diagnosis of high cholesterol (hyperlipidemia).
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 Kidney Disease Ever

Description	The count of respondents who indicated that they have ever been told they had kidney disease.
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 Multiple Healthcare Professionals

Description	The number of people who access more than one healthcare practitioner.
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 Other Cancer Ever

Description	The count of respondents who indicated that they ever had a diagnosis of cancer other than skin cancer.
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 Skin Cancer Ever

Description	The count of respondents who indicated that they ever had a diagnosis of skin cancer.
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 Ever

Description	The count of respondents who indicated that they ever had a diagnosis of stroke.
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 Disorder Ever

Description	The count of respondents who indicated that they have ever been told they had vision or sight disorders.
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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

BRFSS Analysis_Calendar Dimension_FK

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

BRFSS Analysis_Geographic Area Dimension_FK

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

BRFSS Analysis_Survey Respondent Dimension_FK

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

BRFSS Analysis_Demographic Profile Dimension_FK

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

BRFSS 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