Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Effectiveness Of Care - Musculoskeletal 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)

Attributes
Calendar Dk
Disease-Modifying Anti-Rheumatic Drug Therapy For Rheumatoid Arthritis (ART)
Geographic Area Dk
Number Of Members With Low Back Pain (LBP-d)
Number Of Members With Low Back Pain And Imaging Study (LBP-n)
Number Of Members With Rheumatoid Arthritis (ART-d)
Number Of Members With Rheumatoid Arthritis On DMARD Therapy (ART-n)
Number Of Women With A Fracture (OMW-d)
Number Of Women With A Fracture And Osteoporosis Management (OMW-n)
Osteoporosis Management In Women Who Had A Fracture (OMW)
Patient Dk
Plan Member Dk
Use Of Imaging Studies For Low Back Pain (LBP)

Relationship
HEDIS Effectiveness Of Care - Musculoskeletal Analysis_Calendar Dimension_FK
HEDIS Effectiveness Of Care - Musculoskeletal Analysis_Geographic Area Dimension_FK
HEDIS Effectiveness Of Care - Musculoskeletal Analysis_Plan Member Dimension_FK
HEDIS Effectiveness Of Care - Musculoskeletal Analysis_Patient Dimension_FK

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

Disease-Modifying Anti-Rheumatic Drug Therapy For Rheumatoid Arthritis (ART)

Description	The percentage of members who were diagnosed with rheumatoid arthritis and who were dispensed at least one ambulatory prescription for a disease-modifying anti-rheumatic drug (DMARD). 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

Number Of Members With Low Back Pain (LBP-d)

Description	The number of members with a primary diagnosis of low back pain.
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 Low Back Pain And Imaging Study (LBP-n)

Description	The number of members with a primary diagnosis of low back pain and who had an imaging study (plain X-ray, MRI, CT scan) within 28 days of 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

Number Of Members With Rheumatoid Arthritis (ART-d)

Description	The number of members who were diagnosed with rheumatoid 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 Members With Rheumatoid Arthritis On DMARD Therapy (ART-n)

Description	The number of members who were diagnosed with rheumatoid arthritis and who were dispensed at least one ambulatory prescription for a disease-modifying anti-rheumatic drug (DMARD).
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 With A Fracture (OMW-d)

Description	The number of women 67 years of age and older who suffered a fracture.
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 With A Fracture And Osteoporosis Management (OMW-n)

Description	The number of women 67 years of age and older who suffered a fracture and who had either a bone mineral density (BMD) test or prescription for a drug to treat or prevent osteoporosis in the six months after the fracture.
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 Management In Women Who Had A Fracture (OMW)

Description	The percentage of women 67 years of age and older who suffered a fracture and who had either a bone mineral density (BMD) test or prescription for a drug to treat or prevent osteoporosis in the six months after the fracture. 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

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 Imaging Studies For Low Back Pain (LBP)

Description	The percentage of members with a primary diagnosis of low back pain who did not have an imaging study (plain X-ray, MRI, CT scan) within 28 days of the diagnosis. The measure is reported as an inverted rate [1 - (numerator/eligible population)]. A higher score indicates appropriate treatment of low back pain (i.e., the proportion for whom imaging studies did not occur). 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

Relationship Details

HEDIS Effectiveness Of Care - Musculoskeletal Analysis_Calendar Dimension_FK

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

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

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

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

Primary Key Details

HEDIS Effectiveness Of Care - Musculoskeletal Analysis PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model