Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Experience of Care 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)
- Survey Answer (Responses to specific questions for each HEDIS measure)

Attributes
CAHPS Health Plan Survey 5.0H, Adult Version (CPA)
CAHPS Health Plan Survey 5.0H, Child Version (CPC)
Calendar Dk
Children With Chronic Conditions (CCC)
Geographic Area Dk
Number Of Surveyed Members Responding (CPA-d)
Number Of Surveyed Members Responding Satisfied (CPA-n)
Number Of Surveyed Parents Of Children With Chronic Condition Responding (CCC-d)
Number Of Surveyed Parents Of Children With Chronic Condition Responding Satisfied (CCC-n)
Number Of Surveyed Parents Responding (CPC-d)
Number Of Surveyed Parents Responding Satisfied (CPC-n)
Patient Dk
Plan Member Dk
Survey Answer Dk

Relationship
HEDIS Experience of Care Analysis_Calendar Dimension_FK
HEDIS Experience of Care Analysis_Geographic Area Dimension_FK
HEDIS Experience of Care Analysis_Plan Member Dimension_FK
HEDIS Experience of Care Analysis_Patient Dimension_FK
HEDIS Experience of Care Analysis_Survey Answer Dimension_FK

Primary Key
HEDIS Experience of Care Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

CAHPS Health Plan Survey 5.0H, Adult Version (CPA)

Description	This measure provides information on the experiences of commercial and Medicaid members with the organization and gives a general indication of how well the organization meets members' expectations. Results summarize member experiences through ratings, composites and question summary rates. Four global rating questions reflect overall satisfaction: 1. Rating of All Health Care. 2. Rating of Health Plan. 3. Rating of Personal Doctor. 4. Rating of Specialist Seen Most Often. Seven composite scores summarize responses in key areas: 1. Claims Processing (commercial only). 2. Customer Service. 3. Getting Care Quickly. 4. Getting Needed Care. 5. How Well Doctors Communicate. 6. Shared Decision Making. 7. Plan Information on Costs (commercial only). Item-specific question summary rates are reported for the rating questions and each composite question. Question Summary Rates are also reported individually for two items summarizing the following concepts: 1. Health Promotion and Education. 2. Coordination of Care. Note: Medicare member experience with the organization is assessed through the Medicare CAHPS survey. This measure is administered by the Centers for Medicare & Medicaid Services (CMS) on behalf of Medicare Advantage (MA) plans. 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

CAHPS Health Plan Survey 5.0H, Child Version (CPC)

Description	This measure provides information on parents' experience with their child's commercial or Medicaid organization. Results summarize member experiences through ratings, composites and individual question summary rates. Four global rating questions reflect overall satisfaction: 1. Rating of All Health Care. 2. Rating of Health Plan. 3. Rating of Personal Doctor. 4. Rating of Specialist Seen Most Often. Five composite scores summarize responses in key areas: 1. Customer Service. 2. Getting Care Quickly. 3. Getting Needed Care. 4. How Well Doctors Communicate. 5. Shared Decision Making. Item-specific question summary rates are reported for the rating questions and each composite question. Question Summary Rates are also reported individually for two items summarizing the following concepts: 1. Health Promotion and Education. 2. Coordination of Care. 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

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

Children With Chronic Conditions (CCC)

Description	This measure provides information on parents' experience with their child's commercial or Medicaid organization for the population of children with chronic conditions. Three composites summarize satisfaction with basic components of care essential for successful treatment, management and support of children with chronic conditions: 1. Access to Specialized Services. 2. Family Centered Care: Personal Doctor Who Knows Child. 3. Coordination of Care for Children With Chronic Conditions. Item-specific question summary rates are reported for each composite question. Question summary rates are also reported individually for two items summarizing the following concepts: 1. Access to Prescription Medicines. 2. Family Centered Care: Getting Needed Information. 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 Surveyed Members Responding (CPA-d)

Description	The number of members who were surveyed on a specific question and who responded.
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 Surveyed Members Responding Satisfied (CPA-n)

Description	The number of members who were surveyed on a specific question who responded that they were satisfied with the service or their experience of it.
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 Surveyed Parents Of Children With Chronic Condition Responding (CCC-d)

Description	The number of parents of child members with chronic conditions who were surveyed on a specific question and who responded.
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 Surveyed Parents Of Children With Chronic Condition Responding Satisfied (CCC-n)

Description	The number of parents of child members with chronic conditions who were surveyed on a specific question and who responded that they were satisfied with the service their child received or their experience of it.
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 Surveyed Parents Responding (CPC-d)

Description	The number of parents of child members who were surveyed on a specific question and who responded.
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 Surveyed Parents Responding Satisfied (CPC-n)

Description	The number of parents of child members who were surveyed on a specific question and who responded that they were satisfied with the service their child received or their experience of it.
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

Survey Answer 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 Experience of Care Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Experience of Care 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 Experience of Care Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Experience of Care 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 Experience of Care Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Experience of Care 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 Experience of Care Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Experience of Care 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 Experience of Care Analysis_Survey Answer Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Experience of Care 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	Survey Answer 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 Experience of Care Analysis PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model