Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Effectiveness Of Care - Respiratory Conditions 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)
- Medication
- Analytical Classification (Optional - used for measure (MMA))

Attributes
Analytical Classification Dk
Appropriate Testing For Children With Pharyngitis (CWP)
Appropriate Treatment For Children With Upper Respiratory Infection (URI)
Asthma Medication Ratio (AMR)
Avoidance Of Antibiotic Treatment In Adults With Acute Bronchitis (AAB)
Calendar Dk
Geographic Area Dk
Medication Dk
Medication Management for People With Asthma (MMA)
Number Of Adults With Acute Bronchitis (AAB-d)
Number Of Adults With Acute Bronchitis Dispensed Antibiotic (AAB-n)
Number Of Children With Pharyngitis (CWP-d)
Number Of Children With Pharyngitis Appropriately Tested (CWP-n)
Number Of Children With Upper Respiratory Infection (URI-d)
Number Of Children With Upper Respiratory Infection Dispensed AntiBiotic (URI-n)
Number Of COPD Exacerbations (PCE-d)
Number Of COPD Exacerbations Dispensed Bronchodilator (PCE-n)
Number Of COPD Exacerbations Dispensed Systemic Corticosteroid (PCE-n)
Number Of Members With Asthma (AMR-d)
Number Of Members With Asthma (ASM-d)
Number Of Members With Asthma (MMA-d)
Number Of Members With Asthma And 50 Percent Control Medication (MMA-n)
Number Of Members With Asthma And 75 Percent Control Medication (MMA-n)
Number Of Members With Asthma Appropriately Medicated (ASM-n)
Number Of Members With Asthma On Control Medication (AMR-n)
Number Of Members With COPD (SPR-d)
Number Of Members With COPD Given Spirometry Test (SPR-n)
Patient Dk
Pharmacotherapy Management Of COPD Exacerbation (PCE)
Plan Member Dk
Use Of Appropriate Medications For People With Asthma (ASM)
Use Of Spirometry Testing In The Assessment And Diagnosis Of COPD (SPR)

Relationship
HEDIS Effectiveness Of Care - Respiratory Conditions Analysis_Calendar Dimension_FK
HEDIS Effectiveness Of Care - Respiratory Conditions Analysis_Geographic Area Dimension_FK
HEDIS Effectiveness Of Care - Respiratory Conditions Analysis_Plan Member Dimension_FK
HEDIS Effectiveness Of Care - Respiratory Conditions Analysis_Patient Dimension_FK
HEDIS Effectiveness Of Care - Respiratory Conditions Analysis_Medication Dimension_FK
HEDIS Effectiveness Of Care - Respiratory Conditions Analysis_Analytical Classification_FK

Primary Key
HEDIS Effectiveness Of Care - Respiratory Conditions 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

Appropriate Testing For Children With Pharyngitis (CWP)

Description	The percentage of children 2-18 years of age who were diagnosed with pharyngitis, dispensed an antibiotic and received a group A streptococcus (strep) test for the episode. A higher rate represents better performance (i.e., appropriate testing). 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

Appropriate Treatment For Children With Upper Respiratory Infection (URI)

Description	The percentage of children 3 months-18 years of age who were given a diagnosis of upper respiratory infection (URI) and were not dispensed an antibiotic prescription. The measure is reported as an inverted rate [1 - (numerator/eligible population)]. A higher rate indicates appropriate treatment of children with URI (i.e., the proportion for whom antibiotics were not prescribed). 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: [(1-(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

Asthma Medication Ratio (AMR)

Description	The percentage of members 5-64 years of age who were identified as having persistent asthma and had a ratio of controller medications to total asthma medications of 0.50 or greater 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/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

Avoidance Of Antibiotic Treatment In Adults With Acute Bronchitis (AAB)

Description	The percentage of adults 18-64 years of age with a diagnosis of acute bronchitis who were not dispensed an antibiotic prescription. The measure is reported as an inverted rate [1 - (numerator/eligible population)]. A higher rate indicates appropriate treatment of adults with acute bronchitis (i.e., the proportion for whom antibiotics were not prescribed). 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: [(1-(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

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

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

Medication 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

Medication Management for People With Asthma (MMA)

Description	The percentage of members 5-64 years of age during the measurement year who were identified as having persistent asthma and were dispensed appropriate medications that they remained on during the treatment period. Two rates are reported: 1. The percentage of members who remained on an asthma controller medication for at least 50% of their treatment period. 2. The percentage of members who remained on an asthma controller medication for at least 75% of their treatment period. 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

Number Of Adults With Acute Bronchitis (AAB-d)

Description	The number of adults 18-64 years of age with a diagnosis of acute 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 Adults With Acute Bronchitis Dispensed Antibiotic (AAB-n)

Description	The number of adults 18-64 years of age with a diagnosis of acute bronchitis who were dispensed an antibiotic prescription.
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 Children With Pharyngitis (CWP-d)

Description	The number of children 2-18 years of age who were diagnosed with pharyngitis.
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 Children With Pharyngitis Appropriately Tested (CWP-n)

Description	The number of children 2-18 years of age who were diagnosed with pharyngitis, dispensed an antibiotic and received a group A streptococcus (strep) test for the episode.
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 Children With Upper Respiratory Infection (URI-d)

Description	The number of children 3 months-18 years of age who were given a diagnosis of upper respiratory infection (URI).
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 Children With Upper Respiratory Infection Dispensed AntiBiotic (URI-n)

Description	The number of children 3 months-18 years of age who were given a diagnosis of upper respiratory infection (URI) and were dispensed an antibiotic prescription.
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 COPD Exacerbations (PCE-d)

Description	The number of COPD exacerbations for members 40 years of age and older who had an acute inpatient discharge or ED encounter on or between January 1-November 30 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 COPD Exacerbations Dispensed Bronchodilator (PCE-n)

Description	The number of COPD exacerbations for members 40 years of age and older who had an acute inpatient discharge or ED encounter on or between January 1-November 30 of the measurement year and who were dispensed a bronchodilator within 30 days of the event.
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 COPD Exacerbations Dispensed Systemic Corticosteroid (PCE-n)

Description	The number of COPD exacerbations for members 40 years of age and older who had an acute inpatient discharge or ED encounter on or between January 1-November 30 of the measurement year and who were dispensed a systemic corticosteroid within 14 days of the event.
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 Asthma (AMR-d)

Description	The number of members 5-64 years of age who were identified as having persistent 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 Members With Asthma (ASM-d)

Description	The number of members 5-64 years of age during the measurement year who were identified as having persistent 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 Members With Asthma (MMA-d)

Description	The number of members 5-64 years of age during the measurement year who were identified as having persistent 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 Members With Asthma And 50 Percent Control Medication (MMA-n)

Description	The number of members 5-64 years of age during the measurement year who were identified as having persistent asthma and were dispensed appropriate medications that they remained on for at least 50 percent of the treatment 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 Members With Asthma And 75 Percent Control Medication (MMA-n)

Description	The number of members 5-64 years of age during the measurement year who were identified as having persistent asthma and were dispensed appropriate medications that they remained on for at least 75 percent of the treatment 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 Members With Asthma Appropriately Medicated (ASM-n)

Description	The number of members 5-64 years of age during the measurement year who were identified as having persistent asthma and who were appropriately prescribed medication 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 Members With Asthma On Control Medication (AMR-n)

Description	The number of members 5-64 years of age who were identified as having persistent asthma and had a ratio of controller medications to total asthma medications of 0.50 or greater 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 Members With COPD (SPR-d)

Description	The number of members 40 years of age and older with a new diagnosis of chronic obstructive pulmonary disease (COPD) or newly active COPD.
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 COPD Given Spirometry Test (SPR-n)

Description	The number of members 40 years of age and older with a new diagnosis of chronic obstructive pulmonary disease (COPD) or newly active COPD, who received appropriate spirometry testing to confirm the diagnosis.
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

Pharmacotherapy Management Of COPD Exacerbation (PCE)

Description	The percentage of COPD exacerbations for members 40 years of age and older who had an acute inpatient discharge or ED encounter on or between January 1-November 30 of the measurement year and who were dispensed appropriate medications. Two rates are reported: 1. Dispensed a systemic corticosteroid within 14 days of the event. 2. Dispensed a bronchodilator within 30 days of the event. Note: The eligible population for this measure is based on acute inpatient discharges and ED visits, not on members. It is possible for the denominator to include multiple events for the same individual. 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

Use Of Appropriate Medications For People With Asthma (ASM)

Description	The percentage of members 5-64 years of age during the measurement year who were identified as having persistent asthma and who were appropriately prescribed medication 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/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

Use Of Spirometry Testing In The Assessment And Diagnosis Of COPD (SPR)

Description	The percentage of members 40 years of age and older with a new diagnosis of COPD or newly active COPD, who received appropriate spirometry testing to confirm the diagnosis. 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 - Respiratory Conditions Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Respiratory Conditions 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 - Respiratory Conditions Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Respiratory Conditions 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 - Respiratory Conditions Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Respiratory Conditions 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 - Respiratory Conditions Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Respiratory Conditions 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 - Respiratory Conditions Analysis_Medication Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Respiratory Conditions 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	Medication 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 - Respiratory Conditions Analysis_Analytical Classification_FK

Is Identifying Relationship	true
Child Table	HEDIS Effectiveness Of Care - Respiratory Conditions 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 - Respiratory Conditions Analysis PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model