Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Effectiveness Of Care - Behavioral Health 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 (AMM) (ADD) & (FUH))

Attributes
Adherence To Antipsychotic Medications For Individuals With Schizophrenia (SAA)
Analytical Classification Dk
Antidepressant Medication Management (AMM)
Calendar Dk
Cardiovascular Monitoring For People With Cardiovascular Disease And Schizophrenia (SMC)
Diabetes Monitoring For People With Diabetes And Schizophrenia (SMD)
Diabetes Screening For People With Schizophrenia Or Bipolar Disorder Who Are Using Antipsychotic Medications (SSD)
Follow-Up After Hospitalization For Mental Illness (FUH)
Follow-Up Care For Children Prescribed ADHD Medication (ADD)
Geographic Area Dk
Metabolic Monitoring For Children And Adolescents On Antipsychotics (APM)
Number Of Children And Adolescents (APC-d)
Number Of Children And Adolescents On Antipsychotics (APM-d)
Number Of Children And Adolescents On Antipsychotics With Metabolic Monitoring (APM-n)
Number Of Children And Adolescents On Multiple Concurrent Antipsychotics (APC-n)
Number Of Children Continuously Prescribed ADHD Medication Followed Up (ADD-n)
Number Of Children Newly Prescribed ADHD Medication (ADD-d)
Number Of Children Newly Prescribed ADHD Medication Followed Up Initially (ADD-n)
Number Of Individuals With Schizophrenia (SAA-d)
Number Of Individuals With Schizophrenia Adhering To Antipsychotic Medications (SAA-n)
Number Of Members With Depression (AMM-d)
Number Of Members With Depression Continuing Antidepressant Treatment (AMM-n)
Number Of Members With Depression On Antidepressant Treatment (AMM-n)
Number Of Mental Illness Discharges (FUH-d)
Number Of Mental Illness Discharges Followed Up Within 30 Days (FUH-n)
Number Of Mental Illness Discharges Followed Up Within 7 Days (FUH-n)
Number Of People With Cardiovascular Disease And Schizophrenia (SMC-d)
Number Of People With Cardiovascular Disease And Schizophrenia With Cardiovascular Monitoring (SMC-n)
Number Of People With Diabetes And Schizophrenia (SMD-d)
Number Of People With Diabetes And Schizophrenia Monitored For Diabetes (SMD-n)
Number Of People With Schizophrenia Or Bipolar Disorder Who Are Using Antipsychotic Medications (SSD-d)
Number Of People With Schizophrenia Or Bipolar Disorder Who Are Using Antipsychotic Medications Screened For Diabetes (SSD-n)
Patient Dk
Plan Member Dk
Use Of Multiple Concurrent Antipsychotics In Children And Adolescents (APC)

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

Primary Key
HEDIS Effectiveness Of Care - Behavioral Health Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Adherence To Antipsychotic Medications For Individuals With Schizophrenia (SAA)

Description	The percentage of members 19-64 years of age during the measurement year with schizophrenia who were dispensed and remained on an antipsychotic medication for at least 80% of their treatment period. This CMS (Centers for Medicare & Medicaid Services) measure has been adapted for use in HEDIS. 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

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

Antidepressant Medication Management (AMM)

Description	The percentage of members 18 years of age and older with a diagnosis of major depression and were newly treated with antidepressant medication, and who remained on an antidepressant medication treatment. Two rates are reported. - Effective Acute Phase Treatment. The percentage of newly diagnosed and treated members who remained on an antidepressant medication for at least 84 days (12 weeks). - Effective Continuation Phase Treatment. The percentage of newly diagnosed and treated members who remained on an antidepressant medication for at least 180 days (6 months). 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

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

Cardiovascular Monitoring For People With Cardiovascular Disease And Schizophrenia (SMC)

Description	The percentage of members 18-64 years of age with schizophrenia and cardiovascular disease, who had an LDL-C test 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

Diabetes Monitoring For People With Diabetes And Schizophrenia (SMD)

Description	The percentage of members 18-64 years of age with schizophrenia and diabetes, who had both an LDL-C test and an HbA1c test 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

Diabetes Screening For People With Schizophrenia Or Bipolar Disorder Who Are Using Antipsychotic Medications (SSD)

Description	The percentage of members 18-64 years of age with schizophrenia or bipolar disorder, who were dispensed an antipsychotic medication and had a diabetes screening test 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

Follow-Up After Hospitalization For Mental Illness (FUH)

Description	The percentage of discharges for members 6 years of age and older who were hospitalized for treatment of selected mental health disorders and who had an outpatient visit, an intensive outpatient encounter or partial hospitalization with a mental health practitioner. Two rates are reported: - The percentage of discharges for which the member received follow-up within 30 days of discharge. - The percentage of discharges for which the member received follow-up within 7 days of discharge. 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

Follow-Up Care For Children Prescribed ADHD Medication (ADD)

Description	The percentage of children newly prescribed attention-deficit/hyperactivity disorder (ADHD) medication who had at least three follow-up care visits within a 10-month period, one of which was within 30 days of when the first ADHD medication was dispensed. Two rates are reported. - Initiation Phase. The percentage of members 6-12 years of age as of the IPSD with an ambulatory prescription dispensed for ADHD medication, who had one follow-up visit with practitioner with prescribing authority during the 30-day Initiation Phase. - Continuation and Maintenance (C&M) Phase. The percentage of members 6-12 years of age as of the IPSD with an ambulatory prescription dispensed for ADHD medication, who remained on the medication for at least 210 days and who, in addition to the visit in the Initiation Phase, had at least two follow-up visits with a practitioner within 270 days (9 months) after the Initiation Phase ended. 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

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

Metabolic Monitoring For Children And Adolescents On Antipsychotics (APM)

Description	The percentage of children and adolescents 1–17 years of age who had two or more antipsychotic prescriptions and had metabolic 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

Number Of Children And Adolescents (APC-d)

Description	The number of children and adolescents 1–17 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 Children And Adolescents On Antipsychotics (APM-d)

Description	The number of children and adolescents 1–17 years of age who had two or more antipsychotic prescriptions.
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 And Adolescents On Antipsychotics With Metabolic Monitoring (APM-n)

Description	The number of children and adolescents 1–17 years of age who had two or more antipsychotic prescriptions and had metabolic testing.
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 And Adolescents On Multiple Concurrent Antipsychotics (APC-n)

Description	The number of children and adolescents 1–17 years of age who were on two or more concurrent antipsychotic medications.
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 Continuously Prescribed ADHD Medication Followed Up (ADD-n)

Description	The number of children (members 6-12 years of age as of the IPSD) newly prescribed attention-deficit/hyperactivity disorder (ADHD) medication who remained on the medication for at least 210 days and who, in addition to the visit in the Initiation Phase, had at least two follow-up visits with a practitioner within 270 days (9 months) after the Initiation Phase ended.
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 Newly Prescribed ADHD Medication (ADD-d)

Description	The number of children (members 6-12 years of age as of the IPSD) newly prescribed attention-deficit/hyperactivity disorder (ADHD) medication.
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 Newly Prescribed ADHD Medication Followed Up Initially (ADD-n)

Description	The number of children (members 6-12 years of age as of the IPSD) newly prescribed attention-deficit/hyperactivity disorder (ADHD) medication who had one follow-up visit with practitioner with prescribing authority during the 30-day Initiation Phase.
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 Individuals With Schizophrenia (SAA-d)

Description	The number of members 19-64 years of age during the measurement year with schizophrenia.
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 Individuals With Schizophrenia Adhering To Antipsychotic Medications (SAA-n)

Description	The number of members 19-64 years of age during the measurement year with schizophrenia who were dispensed and remained on an antipsychotic medication for at least 80% of their 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 Depression (AMM-d)

Description	The number of members 18 years of age and older with a diagnosis of major depression and were newly treated with antidepressant medication.
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 Depression Continuing Antidepressant Treatment (AMM-n)

Description	The number of members 18 years of age and older with a diagnosis of major depression and were newly treated with antidepressant medication, and who remained on an antidepressant medication for at least 180 days (6 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 Depression On Antidepressant Treatment (AMM-n)

Description	The number of members 18 years of age and older with a diagnosis of major depression and were newly treated with antidepressant medication, and who remained on an antidepressant medication treatment for at least 84 days (12 weeks).
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 Mental Illness Discharges (FUH-d)

Description	The number of discharges for members 6 years of age and older who were hospitalized for treatment of selected mental health 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 Mental Illness Discharges Followed Up Within 30 Days (FUH-n)

Description	The number of discharges for members 6 years of age and older who were hospitalized for treatment of selected mental health disorders and who had an outpatient visit, an intensive outpatient encounter or partial hospitalization with a mental health practitioner within 30 days of discharge.
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 Mental Illness Discharges Followed Up Within 7 Days (FUH-n)

Description	The number of discharges for members 6 years of age and older who were hospitalized for treatment of selected mental health disorders and who had an outpatient visit, an intensive outpatient encounter or partial hospitalization with a mental health practitioner within 7 days of discharge.
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 Cardiovascular Disease And Schizophrenia (SMC-d)

Description	The number of members 18-64 years of age with schizophrenia and cardiovascular 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 Cardiovascular Disease And Schizophrenia With Cardiovascular Monitoring (SMC-n)

Description	The number of members 18-64 years of age with schizophrenia and cardiovascular disease, who had an LDL-C test 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 People With Diabetes And Schizophrenia (SMD-d)

Description	The number of members 18-64 years of age with schizophrenia and 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 Diabetes And Schizophrenia Monitored For Diabetes (SMD-n)

Description	The number of members 18-64 years of age with schizophrenia and diabetes, who had both an LDL-C test and an HbA1c test 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 People With Schizophrenia Or Bipolar Disorder Who Are Using Antipsychotic Medications (SSD-d)

Description	The number of members 18-64 years of age with schizophrenia or bipolar disorder, who were dispensed an antipsychotic medication.
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 Schizophrenia Or Bipolar Disorder Who Are Using Antipsychotic Medications Screened For Diabetes (SSD-n)

Description	The number of members 18-64 years of age with schizophrenia or bipolar disorder, who were dispensed an antipsychotic medication and had a diabetes screening test 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

Use Of Multiple Concurrent Antipsychotics In Children And Adolescents (APC)

Description	The percentage of children and adolescents 1–17 years of age who were on two or more concurrent antipsychotic medications. Note: A lower rate indicates better performance. 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 - Behavioral Health Analysis_Calendar Dimension_FK

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

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

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

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

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