Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Effectiveness Of Care - CAHPS Health Plan 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)
- Analytical Classification (Optional - used for measures (ASP) & (MSC))

Attributes
Analytical Classification Dk
Aspirin Use And Discussion (ASP)
Calendar Dk
Flu Shots For Adults Ages 50-64 (FSA)
Flu Shots for Older Adults (FSO)
Geographic Area Dk
Medical Assistance With Smoking And Tobacco Use Cessation (MSC)
Number Of Adults Who Had Flu Shots (FSA-n)
Number Of Adults Who Should Have Flu Shots (FSA-d)
Number Of Members Discussing Aspirin Use (ASP-n)
Number Of Members Using Aspirin (ASP-n)
Number Of Members Who Received Pneumococcal Vaccine (PNU-n)
Number Of Members Who Should Be Discussing Aspirin Use (ASP-d)
Number Of Members Who Should Be Using Aspirin (ASP-d)
Number Of Members Who Should Have Received Pneumococcal Vaccine (PNU-d)
Number Of Older Adults Who Had Flu Shots (FSO-n)
Number Of Older Adults Who Should Have Flu Shots (FSO-d)
Number Of Smokers (MSC-d)
Number Of Smokers Advised To Quit (MSC-n)
Number Of Smokers Discussing Cessation Medications (MSC-n)
Number Of Smokers Discussing Cessation Strategies (MSC-n)
Patient Dk
Plan Member Dk
Pneumococcal Vaccination Status for Older Adults (PNU)

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

Primary Key
HEDIS Effectiveness Of Care - CAHPS Health Plan 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

Aspirin Use And Discussion (ASP)

Description	The two components of this measure assess different facets of aspirin use management. - Aspirin Use. A rolling average represents the percentage of members who are currently taking aspirin. A single rate is reported for which the denominator includes: - Women 56-79 years of age with at least two risk factors for cardiovascular disease. - Men 46-65 years of age with at least one risk factor for cardiovascular disease. - Men 66-79 years of age, regardless of risk factors. - Discussing Aspirin Risks and Benefits. A rolling average represents the percentage of members who discussed the risks and benefits of using aspirin with a doctor or other health provider. A single rate is reported for which the denominator includes: - Women 56-79 years of age. - Men 46-79 years of age. 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

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

Flu Shots For Adults Ages 50-64 (FSA)

Description	A rolling average represents the percentage of commercial members 50-64 years of age who received an influenza vaccination between September 1 of the measurement year and the date when the CAHPS 5.0H survey was completed. 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

Flu Shots for Older Adults (FSO)

Description	The percentage of Medicare members 65 years of age and older as of January 1 of the measurement year who received an influenza vaccination between September 1 of the measurement year and the date when the Medicare CAHPS survey was completed. 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

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

Medical Assistance With Smoking And Tobacco Use Cessation (MSC)

Description	The three components of this measure assess different facets of providing medical assistance with smoking and tobacco use cessation. - Advising Smokers and Tobacco Users to Quit. A rolling average represents the percentage of members 18 years of age and older who are current smokers or tobacco users and who received cessation advice during the measurement year. - Discussing Cessation Medications. A rolling average represents the percentage of members 18 years of age and older who are current smokers or tobacco users and who discussed or were recommended cessation medications during the measurement year. - Discussing Cessation Strategies. A rolling average represents the percentage of members 18 years of age and older who are current smokers or tobacco users who discussed or were provided cessation methods or strategies during the measurement year. 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 Adults Who Had Flu Shots (FSA-n)

Description	The number of commercial members 50-64 years of age who received an influenza vaccination between September 1 of the measurement year and the date when the CAHPS 5.0H survey was completed.
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 Adults Who Should Have Flu Shots (FSA-d)

Description	The number of commercial members 50-64 years of age.
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 Aspirin Use (ASP-n)

Description	The number of members who should be discussing aspirin use and who have discussed the risks and benefits of using aspirin with a doctor or other health provider. The population of those who should be discussing aspirin use is based on the following selection: - Women 56-79 years of age. - Men 46-79 years of age.
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 Using Aspirin (ASP-n)

Description	The number of members who should be taking aspirin and that are currently taking aspirin. The population of those who should be taking aspirin is based on the following selections: - Women 56-79 years of age with at least two risk factors for cardiovascular disease. - Men 46-65 years of age with at least one risk factor for cardiovascular disease. - Men 66-79 years of age, regardless of risk factors.
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 Received Pneumococcal Vaccine (PNU-n)

Description	The number of Medicare members 65 years of age and older as of January 1 of the measurement year who have ever received a pneumococcal vaccine.
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 Aspirin Use (ASP-d)

Description	The number of members who should be discussing aspirin use based on the following selection: - Women 56-79 years of age. - Men 46-79 years of age.
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 Using Aspirin (ASP-d)

Description	The number of members who should be taking aspirin based on the following population selections: - Women 56-79 years of age with at least two risk factors for cardiovascular disease. - Men 46-65 years of age with at least one risk factor for cardiovascular disease. - Men 66-79 years of age, regardless of risk factors.
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 Have Received Pneumococcal Vaccine (PNU-d)

Description	The number of Medicare members 65 years of age and older as of January 1 of the measurement year.
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 Who Had Flu Shots (FSO-n)

Description	The number of Medicare members 65 years of age and older as of January 1 of the measurement year who received an influenza vaccination between September 1 of the measurement year and the date when the Medicare CAHPS survey was completed.
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 Who Should Have Flu Shots (FSO-d)

Description	The number of Medicare members 65 years of age and older as of January 1 of the measurement year.
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 Smokers (MSC-d)

Description	The number of members 18 years of age and older who are current smokers.
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 Smokers Advised To Quit (MSC-n)

Description	The number of members 18 years of age and older who are current smokers or tobacco users and who received cessation advice during the measurement year.
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 Smokers Discussing Cessation Medications (MSC-n)

Description	The number of members 18 years of age and older who are current smokers or tobacco users and who discussed or were recommended cessation medications during the measurement year.
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 Smokers Discussing Cessation Strategies (MSC-n)

Description	The number of members 18 years of age and older who are current smokers or tobacco users who discussed or were provided cessation methods or strategies during the measurement year.
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

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

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

Pneumococcal Vaccination Status for Older Adults (PNU)

Description	The percentage of Medicare members 65 years of age and older as of January 1 of the measurement year who have ever received a pneumococcal vaccine. 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

Relationship Details

HEDIS Effectiveness Of Care - CAHPS Health Plan Survey Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - CAHPS Health Plan 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 - CAHPS Health Plan Survey Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - CAHPS Health Plan 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 - CAHPS Health Plan Survey Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - CAHPS Health Plan 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 - CAHPS Health Plan Survey Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - CAHPS Health Plan 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 - CAHPS Health Plan Survey Analysis_Analytical Classification_FK

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