Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis

Description

This Analytical Requirement includes measures developed by the National Committee for Quality Assurance (NCQA) and published as part of the Healthcare Effectiveness Data and Information Set (HEDIS) 2015 Volume 2 specification.

Dimensions (and sample axes of analysis):
- Time Period (Reporting Year)
- Geographic Area (Region, State)
- Plan Member (Plan, Line of Business(Medicare, Medicaid, Commercial))
- Patient (Age range, Gender, Language, Race)
- Analytical Classification (Optional - used for measures (HOS) (FRM) (MUI) & (PAO))

Attributes
Analytical Classification Dk
Calendar Dk
Fall Risk Management (FRM)
Geographic Area Dk
Management of Urinary Incontinence in Older Adults (MUI)
Medicare Health Outcomes Survey (HOS)
Number Of Members Better Than Expected (HOS-n)
Number Of Members Discussing Fall Risk (FRM-n)
Number Of Members Discussing Urinary Incontinence (MUI-n)
Number Of Members Managing Fall Risk (FRM-n)
Number Of Members Receiving Urinary Incontinence Treatment (MUI-n)
Number Of Members Same As Expected (HOS-n)
Number Of Members Surveyed (HOS-d)
Number Of Members Who Should Be Discussing Fall Risk (FRM-d)
Number Of Members Who Should Be Managing Fall Risk (FRM-d)
Number Of Members With Urine Leakage Problem (MUI-d)
Number Of Members Worse Than Expected (HOS-n)
Number Of Older Adults (PAO-d)
Number Of Older Adults Advised On Physical Activity (PAO-n)
Number Of Older Adults Discussing Physical Activity (PAO-n)
Number Of Women 65 Years And Older (OTO-d)
Number Of Women Tested For Osteoporosis (OTO-n)
Osteoporosis Testing in Older Women (OTO)
Patient Dk
Physical Activity in Older Adults (PAO)
Plan Member Dk

Relationship
HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Calendar Dimension_FK
HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Geographic Area Dimension_FK
HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Plan Member Dimension_FK
HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Patient Dimension_FK
HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Analytical Classification_FK

Primary Key
HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

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

Fall Risk Management (FRM)

Description	The two components of this measure assess different facets of fall risk management. - Discussing Fall Risk. The percentage of Medicare members 75 years of age and older or 65-74 years of age with balance or walking problems or a fall in the past 12 months, who were seen by a practitioner in the past 12 months and who discussed falls or problems with balance or walking with their current practitioner. - Managing Fall Risk. The percentage of Medicare members 65 years of age and older who had a fall or had problems with balance or walking in the past 12 months, who were seen by a practitioner in the past 12 months and who received fall risk intervention from their current practitioner. This definition is included with the permission of the National Committee for Quality Assurance (NCQA) and is an extract from the full measure definition published by NCQA. Refer to NCQA's HEDIS vol 2 measures for the complete measure definition. Formula: [((A/B) or (C/D)) *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

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

Management of Urinary Incontinence in Older Adults (MUI)

Description	The two components of this measure assess the management of urinary incontinence in older adults. - Discussing Urinary Incontinence. The percentage of Medicare members 65 years of age and older who reported having a problem with urine leakage in the past six months and who discussed their urine leakage problem with their current practitioner. - Receiving Urinary Incontinence Treatment. The percentage of Medicare members 65 years of age and older who reported having a urine leakage problem in the past six months and who received treatment for their current urine leakage problem. This definition is included with the permission of the National Committee for Quality Assurance (NCQA) and is an extract from the full measure definition published by NCQA. Refer to NCQA's HEDIS vol 2 measures for the complete measure definition. Formula: [((A/C) or (B/C)) *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

Medicare Health Outcomes Survey (HOS)

Description	This measure provides a general indication of how well a Medicare organization manages the physical and mental health of its members. The survey measures each member's physical and mental health status at the beginning and the end of a two-year period. A two-year change score is calculated and each member's physical and mental health status is categorized as better, the same or worse than expected, considering risk adjustment factors. Organization-specific results are assigned as percentages of members whose health status was better, the same or worse than expected. This definition is included with the permission of the National Committee for Quality Assurance (NCQA) and is an extract from the full measure definition published by NCQA. Refer to NCQA's HEDIS vol 2 measures for the complete measure definition. Formula: [((A/D) or (B/D) or (C/D)) *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

Number Of Members Better Than Expected (HOS-n)

Description	The of members surveyed whose health status was better than expected.
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 Members Discussing Fall Risk (FRM-n)

Description	The number of Medicare members 75 years of age and older or 65-74 years of age with balance or walking problems or a fall in the past 12 months, who were seen by a practitioner in the past 12 months and who discussed falls or problems with balance or walking with their current 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 Members Discussing Urinary Incontinence (MUI-n)

Description	The number of Medicare members 65 years of age and older who reported having a problem with urine leakage in the past six months and who discussed their urine leakage problem with their current 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 Members Managing Fall Risk (FRM-n)

Description	The number of Medicare members 65 years of age and older who had a fall or had problems with balance or walking in the past 12 months, who were seen by a practitioner in the past 12 months and who received fall risk intervention from their current 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 Members Receiving Urinary Incontinence Treatment (MUI-n)

Description	The number of Medicare members 65 years of age and older who reported having a urine leakage problem in the past six months and who received treatment for their current urine leakage problem.
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 Members Same As Expected (HOS-n)

Description	The of members surveyed whose health status was the same as expected.
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 Members Surveyed (HOS-d)

Description	The of members surveyed.
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 Members Who Should Be Discussing Fall Risk (FRM-d)

Description	The number of Medicare members 75 years of age and older or 65-74 years of age with balance or walking problems or a fall in the past 12 months, who were seen by a practitioner in the past 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 Members Who Should Be Managing Fall Risk (FRM-d)

Description	The number of Medicare members 65 years of age and older who had a fall or had problems with balance or walking in the past 12 months, who were seen by a practitioner in the past 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 Members With Urine Leakage Problem (MUI-d)

Description	The number of Medicare members 65 years of age and older who reported having a urine leakage problem in the past six 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 Members Worse Than Expected (HOS-n)

Description	The of members surveyed whose health status was worse than expected.
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 Older Adults (PAO-d)

Description	The number of Medicare members 65 years of age and older who had a doctor's visit in the past 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 Older Adults Advised On Physical Activity (PAO-n)

Description	The number of Medicare members 65 years of age and older who had a doctor's visit in the past 12 months and who received advice to start, increase or maintain their level exercise or physical 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

Number Of Older Adults Discussing Physical Activity (PAO-n)

Description	The number of Medicare members 65 years of age and older who had a doctor's visit in the past 12 months and who spoke with a doctor or other health provider about their level of exercise or physical 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

Number Of Women 65 Years And Older (OTO-d)

Description	The number of Medicare women 65 years of age and older.
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 Women Tested For Osteoporosis (OTO-n)

Description	The number of Medicare women 65 years of age and older who report ever having received a bone density test to check for osteoporosis.
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

Osteoporosis Testing in Older Women (OTO)

Description	The percentage of Medicare women 65 years of age and older who report ever having received a bone density test to check for osteoporosis. This definition is included with the permission of the National Committee for Quality Assurance (NCQA) and is an extract from the full measure definition published by NCQA. Refer to NCQA's HEDIS vol 2 measures for the complete measure definition. 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

Patient 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

Physical Activity in Older Adults (PAO)

Description	The two components of this measure assess different facets of promoting physical activity in older adults. - Discussing Physical Activity. The percentage of Medicare members 65 years of age and older who had a doctor's visit in the past 12 months and who spoke with a doctor or other health provider about their level of exercise or physical activity. - Advising Physical Activity. The percentage of Medicare members 65 years of age and older who had a doctor's visit in the past 12 months and who received advice to start, increase or maintain their level exercise or physical activity. This definition is included with the permission of the National Committee for Quality Assurance (NCQA) and is an extract from the full measure definition published by NCQA. Refer to NCQA's HEDIS vol 2 measures for the complete measure definition. Formula: [((A/C) or (B/C)) *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

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

Relationship Details

HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Medicare Health Outcomes 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

HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Medicare Health Outcomes 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

HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Medicare Health Outcomes 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	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Medicare Health Outcomes 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	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis_Analytical Classification_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Medicare Health Outcomes 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	Common Code 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

HEDIS Effectiveness Of Care - Medicare Health Outcomes Survey Analysis PK

Key Attribute	Plan Member Dk
Key Attribute	Patient Dk
Key Attribute	Analytical Classification Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model