Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity HEDIS Relative Resource Use 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) - Encounter (Procedure) - Analytical Classification (Optional - used for measures (RAS), (RCA), (RCO), (RDI) & (RHY))

Attributes

Analytical Classification Dk

Calendar Dk

Encounter Dk

Geographic Area Dk

Number Of Acute Inpatient Medical Days

Number Of Acute Inpatient Medical Discharges

Number Of Acute Inpatient Surgical Days

Number Of Acute Inpatient Surgical Discharges

Number Of CAD Diagnostic Tests Using EBCT/Nuclear Imaging Stress Test

Number Of Cardiac Catheterizations Performed

Number Of Cardiac Computed Tomography Scans Performed

Number Of Carotid Artery Stenosis Diagnostic Tests Performed

Number Of Carotid Endarterectomy Procedures Performed

Number Of Coronary Artery Bypass Grafts (CABG) Performed

Number Of ED Discharges

Number Of Member Months Medical

Number Of Member Months Pharmacy

Number Of Nonacute Inpatient Days

Number Of Nonacute Inpatient Discharges

Number Of Percutaneous Coronary Interventions (PCI) Performed

Patient Dk

Plan Member Dk

Relative Resource Use For People With Asthma (RAS)

Relative Resource Use For People With Cardiovascular Conditions (RCA)

Relative Resource Use For People With COPD (RCO)

Relative Resource Use For People With Diabetes (RDI)

Relative Resource Use For People With Hypertension (RHY)

Standardized Evaluation And Management Inpatient Costs

Standardized Evaluation And Management Outpatient Costs

Standardized Imaging Costs

Standardized Inpatient Facility Costs

Standardized Laboratory Costs

Standardized Pharmacy Costs

Standardized Surgery And Procedure Inpatient Costs

Standardized Surgery And Procedure Outpatient Costs

Relationship

HEDIS Relative Resource Use Analysis_Calendar Dimension_FK

HEDIS Relative Resource Use Analysis_Geographic Area Dimension_FK

HEDIS Relative Resource Use Analysis_Plan Member Dimension_FK

HEDIS Relative Resource Use Analysis_Patient Dimension_FK

HEDIS Relative Resource Use Analysis_Encounter Dimension_FK

HEDIS Relative Resource Use Analysis_Analytical Classification_FK

Primary Key

HEDIS Relative Resource Use 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

---

 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

---

 Encounter 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

---

 Number Of Acute Inpatient Medical Days

Description	The number of days that patients were admitted for acute inpatient medical treatment during the measurement year. This is based on count of all days from admission up to discharge. The last day of stay should not be counted unless the discharge date is the same as the admission date.
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 Acute Inpatient Medical Discharges

Description	The number of patient stays for acute inpatient medical treatment that were discharged 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 Acute Inpatient Surgical Days

Description	The number of days that patients were admitted for acute inpatient surgical treatment during the measurement year. This is based on count of all days from admission up to discharge. The last day of stay should not be counted unless the discharge date is the same as the admission date.
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 Acute Inpatient Surgical Discharges

Description	The number of patient stays for acute inpatient surgical treatment that were discharged 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 CAD Diagnostic Tests Using EBCT/Nuclear Imaging Stress Test

Description	Number Of CAD diagnostic test performed using electron-beam computed tomography (EBCT)/nuclear imaging stress tests 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 Cardiac Catheterizations Performed

Description	The number of cardiac catheterization procedures performed on members 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 Cardiac Computed Tomography Scans Performed

Description	The number of cardiac computed Tomography scans performed on members 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 Carotid Artery Stenosis Diagnostic Tests Performed

Description	The number of carotid artery stenosis diagnostic tests performed on members 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 Carotid Endarterectomy Procedures Performed

Description	The number of carotid endarterectomy procedures performed on members 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 Coronary Artery Bypass Grafts (CABG) Performed

Description	The number of coronary artery bypass graft (CABG) procedures performed on members 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 ED Discharges

Description	The number of patient discharges from emergency departments (ED) 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 Member Months Medical

Description	The total number of months that a member has one or more active memberships, in one or more health benefits plans providing medical benefits, during the measurement year. This may be a point in time calculation of the number of members, at a specific date in every month (e.g. 15th) or it may be rounded sum of the number of months based on each members enrollment dates.
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 Member Months Pharmacy

Description	The total number of months that a member has one or more active memberships, in one or more health benefits plans providing pharmacy benefits, during the measurement year. This may be a point in time calculation of the number of members, at a specific date in every month (e.g. 15th) or it may be rounded sum of the number of months based on each members enrollment dates.
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 Nonacute Inpatient Days

Description	The number of days that patients were admitted for nonacute treatment during the measurement year. This is based on count of all days from admission up to discharge. The last day of stay should not be counted unless the discharge date is the same as the admission date.
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 Nonacute Inpatient Discharges

Description	The number of patient stays for nonacute inpatient treatment that were discharged 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 Percutaneous Coronary Interventions (PCI) Performed

Description	The number of percutaneous coronary intervention (PCI) procedures performed on members 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

---

 Relative Resource Use For People With Asthma (RAS)

Description	The relative resource use by members with persistent asthma 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 or B or C or D or E or F or G or H or I or J or K or L or M or N or O or P or Q] (see dependencies and their labels for measures used in the formula)
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

---

 Relative Resource Use For People With Cardiovascular Conditions (RCA)

Description	The relative resource use by members with cardiovascular conditions 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 or B or C or D or E or F or G or H or I or J or K or L or M or N or O or P or Q or R or S or T or U or V or W or X] (see dependencies and their labels for measures used in the formula)
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

---

 Relative Resource Use For People With COPD (RCO)

Description	The relative resource use by members with COPD 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 or B or C or D or E or F or G or H or I or J or K or L or M or N or O or P or Q] (see dependencies and their labels for measures used in the formula)
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

---

 Relative Resource Use For People With Diabetes (RDI)

Description	The relative resource use by members with diabetes 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 or B or C or D or E or F or G or H or I or J or K or L or M or N or O or P or Q or R or S or T or U or V or W or X] (see dependencies and their labels for measures used in the formula)
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

---

 Relative Resource Use For People With Hypertension (RHY)

Description	The relative resource use by members with hypertension 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 or B or C or D or E or F or G or H or I or J or K or L or M or N or O or P or Q] (see dependencies and their labels for measures used in the formula)
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

---

 Standardized Evaluation And Management Inpatient Costs

Description	The cost of all evaluation and management (E&M) inpatient services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Evaluation And Management Outpatient Costs

Description	The cost of all evaluation and management (E&M) outpatient services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Imaging Costs

Description	The cost of all imaging services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Inpatient Facility Costs

Description	The cost of all services in inpatient facilities during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Laboratory Costs

Description	The cost of all laboratory services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Pharmacy Costs

Description	The cost of all pharmacy services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Surgery And Procedure Inpatient Costs

Description	The cost of all surgery and procedure inpatient services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Standardized Surgery And Procedure Outpatient Costs

Description	The cost of all surgery and procedure outpatient services during the measurement year repriced using standard prices published by NCQA. Note: This measure is to be calculated using standardized costs. It should not use costs from claims or fee schedules. See the HEDIS Volume 2 Measure specifications for Relative Resource Use published by NCQA.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 HEDIS Relative Resource Use Analysis_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	HEDIS Relative Resource Use 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 Relative Resource Use Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Relative Resource Use 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 Relative Resource Use Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Relative Resource Use 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 Relative Resource Use Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Relative Resource Use 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 Relative Resource Use Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	HEDIS Relative Resource Use 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	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 HEDIS Relative Resource Use Analysis_Analytical Classification_FK

Is Identifying Relationship	true
Child Table	HEDIS Relative Resource Use 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 Relative Resource Use Analysis PK

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

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model