Dimensional Warehouse Model Data Model

Entity

Entity HEDIS Effectiveness Of Care - Prevention And Screening 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 measures (CIS), (WCC), (COA) & (IMA))

Attributes
Adult BMI Assessment (ABA)
Analytical Classification Dk
Breast Cancer Screening (BCS)
Calendar Dk
Care for Older Adults (COA)
Cervical Cancer Screening (CCS)
Childhood Immunization Status (CIS)
Chlamydia Screening In Women (CHL)
Colorectal Cancer Screening (COL)
Geographic Area Dk
Glaucoma Screening In Older Adults (GSO)
Human Papillomavirus Vaccine For Female Adolescents (HPV)
Immunizations for Adolescents (IMA)
Lead Screening In Children (LSC)
Medication Dk
Non-Recommended Cervical Cancer Screening In Adolescent Females (NCS)
Non-Recommended PSA-Based Screening In Older Men (PSA)
Number Of Adolescents For Immunization (IMA-d)
Number Of Adolescents With DTaP/TD Vaccine (IMA-n)
Number Of Adolescents With Meningococcal And DTaP/TD Vaccine (IMA-n)
Number Of Adolescents With Meningococcal Vaccine (IMA-n)
Number Of Adults With An Outpatient Visit (ABA-d)
Number Of Adults With BMI Assessed (ABA-n)
Number Of Children/Adolescents (WCC-d)
Number Of Children/Adolescents Counseled For Nutrition (WCC-n)
Number Of Children/Adolescents Counseled On Physical Activity (WCC-n)
Number Of Children/Adolescents With Weight Assessment (WCC-n)
Number Of Children (LSC-d)
Number Of Children For Immunization (CIS-d)
Number Of Children Screened For Lead Poisoning (LSC-n)
Number Of Children With Chicken Pox Vaccination (CIS-n)
Number Of Children With DTaP Vaccination (CIS-n)
Number Of Children With HepA Vaccination (CIS-n)
Number Of Children With HepB Vaccination (CIS-n)
Number Of Children With HiB Vaccination (CIS-n)
Number Of Children With Influenza Vaccination (CIS-n)
Number Of Children With MMR Vaccination (CIS-n)
Number Of Children With Pneumococcal Conjugate Vaccination (CIS-n)
Number Of Children With Polio Vaccination (CIS-n)
Number Of Children With Rotavirus Vaccination (CIS-n)
Number Of Children With Vaccination Combination (CIS-n)
Number Of Female Adolescents (HPV-d)
Number Of Female Adolescents (NCS-d)
Number Of Female Adolescents Unnecessarily Screened For Cervical Cancer (NCS-n)
Number Of Female Adolescents With Human Papillomavirus Vaccine (HPV-n)
Number Of Members Screened For Colorectal Cancer (COL-n)
Number Of Members Who Should Be Screened For Colorectal Cancer (COL-d)
Number Of Older Adults (COA-d)
Number Of Older Adults (GSO-d)
Number Of Older Adults Screened For Glaucoma (GSO-n)
Number Of Older Adults With Advance Care Planning (COA-n)
Number Of Older Adults With A Functional Status Assessment (COA-n)
Number Of Older Adults With A Medication Review (COA-n)
Number Of Older Adults With Pain Screening (COA-n)
Number Of Older Men (PSA-d)
Number Of Older Men Unnecessarily Screened For Prostate Cancer (PSA-n)
Number Of Women Screened For Breast Cancer (BCS-n)
Number Of Women Screened For Cervical Cancer (CCS-n)
Number Of Women Screened For Chlamydia (CHL-n)
Number Of Women Who Should Be Screened For Breast Cancer (BCS-d)
Number Of Women Who Should Be Screened For Cervical Cancer (CCS-d)
Number Of Women Who Should Be Screened For Chlamydia (CHL-d)
Patient Dk
Plan Member Dk
Weight Assessment And Counseling For Nutrition And Physical Activity For Children/Adolescents (WCC)

Relationship
HEDIS Effectiveness Of Care - Prevention And Screening Analysis_Calendar Dimension_FK
HEDIS Effectiveness Of Care - Prevention And Screening Analysis_Geographic Area Dimension_FK
HEDIS Effectiveness Of Care - Prevention And Screening Analysis_Plan Member Dimension_FK
HEDIS Effectiveness Of Care - Prevention And Screening Analysis_Patient Dimension_FK
HEDIS Effectiveness Of Care - Prevention And Screening Analysis_Medication Dimension_FK
HEDIS Effectiveness Of Care - Prevention And Screening Analysis_Analytical Classification_FK

Primary Key
HEDIS Effectiveness Of Care - Prevention And Screening Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Adult BMI Assessment (ABA)

Description	The percentage of members 18-74 years of age who had an outpatient visit and whose body mass index (BMI) was documented during the measurement year or the year prior to 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

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

Breast Cancer Screening (BCS)

Description	The percentage of women 40-69 years of age who had a mammogram to screen for breast cancer. 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

Care for Older Adults (COA)

Description	The percentage of adults 66 years and older who had each of the following during the measurement year: - Advance care planning. - Medication review. - Functional status assessment. - Pain screening. 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/E) OR (B/E) OR (C/E) OR (D/E)) *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

Cervical Cancer Screening (CCS)

Description	The percentage of women 21-64 years of age who received one or more Pap tests to screen for cervical cancer. 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

Childhood Immunization Status (CIS)

Description	The percentage of children 2 years of age who had four diphtheria, tetanus and acellular pertussis (DTaP); three polio (IPV); one measles, mumps and rubella (MMR); three H influenza type B (HiB); three hepatitis B (HepB), one chicken pox (VZV); four pneumococcal conjugate (PCV); one hepatitis A (HepA); two or three rotavirus (RV); and two influenza (flu) vaccines by their second birthday. The measure calculates a rate for each vaccine and nine separate combination rates. 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/L) or (B/L) or (C/L) or (D/L) or (E/L) or (F/L) or (G/L)or (H/L) or (I/L) or (J/L) or (K/L))*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

Chlamydia Screening In Women (CHL)

Description	The percentage of women 16-24 years of age who were identified as sexually active and who had at least one test for chlamydia 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

Colorectal Cancer Screening (COL)

Description	The percentage of members 50-75 years of age who had appropriate screening for colorectal cancer. 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

Glaucoma Screening In Older Adults (GSO)

Description	The percentage of Medicare members 65 years and older who received a glaucoma eye exam by an eye care professional for early identification of glaucomatous conditions. 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. Please note this measure has been retired by NCQA in the 2015 specification but is retained in the model to support historic reporting. 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

Human Papillomavirus Vaccine For Female Adolescents (HPV)

Description	The percentage of female adolescents 13 years of age who had three doses of the human papillomavirus (HPV) vaccine by their 13th birthday. 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

Immunizations for Adolescents (IMA)

Description	The percentage of adolescents 13 years of age who had one dose of meningococcal vaccine and one tetanus, diphtheria toxoids and acellular pertussis vaccine (Tdap) or one tetanus, diphtheria toxoids vaccine (Td) by their 13th birthday. The measure calculates a rate for each vaccine and one combination rate. 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/D) or (B/D) or (C/D))*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

Lead Screening In Children (LSC)

Description	The percentage of children 2 years of age who had one or more capillary or venous lead blood test for lead poisoning by their second birthday. 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

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

Description	The percentage of adolescent females 16–20 years of age who were screened unnecessarily for cervical cancer. 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

Description	The percentage of men 70 years and older who were screened unnecessarily for prostate cancer using prostate-specific antigen (PSA)-based screening. 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

Number Of Adolescents For Immunization (IMA-d)

Description	The number of adolescents 13 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 Adolescents With DTaP/TD Vaccine (IMA-n)

Description	The number of adolescents 13 years of age who had one tetanus, diphtheria toxoids and acellular pertussis vaccine (Tdap) or one tetanus, diphtheria toxoids vaccine (Td) by their 13th birthday.
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 Adolescents With Meningococcal And DTaP/TD Vaccine (IMA-n)

Description	The number of adolescents 13 years of age who had one dose of meningococcal vaccine and one tetanus, diphtheria toxoids and acellular pertussis vaccine (Tdap) or one tetanus, diphtheria toxoids vaccine (Td) by their 13th birthday.
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 Adolescents With Meningococcal Vaccine (IMA-n)

Description	The number of adolescents 13 years of age who had one dose of meningococcal vaccine by their 13th birthday.
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 An Outpatient Visit (ABA-d)

Description	The number of members 18-74 years of age who had an outpatient visit.
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 BMI Assessed (ABA-n)

Description	The number of members 18-74 years of age who had an outpatient visit and whose body mass index (BMI) was documented during the measurement year or the year prior to 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 Children/Adolescents (WCC-d)

Description	The number of members 3-17 years of age who had an outpatient visit with a PCP or OB/GYN 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 Children/Adolescents Counseled For Nutrition (WCC-n)

Description	The number of members 3-17 years of age who had an outpatient visit with a PCP or OB/GYN and who were counseled for nutrition 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 Children/Adolescents Counseled On Physical Activity (WCC-n)

Description	The number of members 3-17 years of age who had an outpatient visit with a PCP or OB/GYN and who were counseled on physical activity 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 Children/Adolescents With Weight Assessment (WCC-n)

Description	The number of members 3-17 years of age who had an outpatient visit with a PCP or OB/GYN and who had evidence of BMI percentile documentation* during the measurement year. * Because BMI norms for youth vary with age and gender, this measure evaluates whether BMI percentile is assessed rather than an absolute BMI value.
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 (LSC-d)

Description	The number of children 2 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 For Immunization (CIS-d)

Description	The number of children 2 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 Screened For Lead Poisoning (LSC-n)

Description	The number of children 2 years of age who had one or more capillary or venous lead blood test for lead poisoning by their second birthday.
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 Chicken Pox Vaccination (CIS-n)

Description	The number of children 2 years of age who had one chicken pox (VZV) vaccine by their second birthday.
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 DTaP Vaccination (CIS-n)

Description	The number of children 2 years of age who had four diphtheria, tetanus and acellular pertussis (DTaP) vaccines by their second birthday.
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 HepA Vaccination (CIS-n)

Description	The number of children 2 years of age who had one hepatitis A (HepA) vaccine by their second birthday.
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 HepB Vaccination (CIS-n)

Description	The number of children 2 years of age who had three hepatitis B (HepB) vaccines by their second birthday.
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 HiB Vaccination (CIS-n)

Description	The number of children 2 years of age who had three H influenza type B (HiB) vaccines by their second birthday.
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 Influenza Vaccination (CIS-n)

Description	The number of children 2 years of age who had two influenza (flu) vaccines by their second birthday.
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 MMR Vaccination (CIS-n)

Description	The number of children 2 years of age who had one measles, mumps and rubella (MMR) vaccine by their second birthday.
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 Pneumococcal Conjugate Vaccination (CIS-n)

Description	The number of children 2 years of age who had four pneumococcal conjugate (PCV) vaccines by their second birthday.
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 Polio Vaccination (CIS-n)

Description	The number of children 2 years of age who had three polio (IPV) vaccines by their second birthday.
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 Rotavirus Vaccination (CIS-n)

Description	The number of children 2 years of age who had two or three rotavirus (RV) vaccines by their second birthday.
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 Vaccination Combination (CIS-n)

Description	The number of children 2 years of age who had four diphtheria, tetanus and acellular pertussis (DTaP); three polio (IPV); one measles, mumps and rubella (MMR); three H influenza type B (HiB); three hepatitis B (HepB), one chicken pox (VZV) vaccines by their second birthday alone or in combination with; four pneumococcal conjugate (PCV) and/or one hepatitis A (HepA) and/or two or three rotavirus (RV) and/or two influenza (flu) vaccines.
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 Female Adolescents (HPV-d)

Description	The number of female adolescents 13 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 Female Adolescents (NCS-d)

Description	The number of adolescent females 16–20 years as of December 31 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 Female Adolescents Unnecessarily Screened For Cervical Cancer (NCS-n)

Description	The number of adolescent females 16–20 years of age who were screened unnecessarily for cervical cancer. Cervical cytology (Cervical Cytology Value Set) or an HPV test (HPV Tests Value Set) performed 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 Female Adolescents With Human Papillomavirus Vaccine (HPV-n)

Description	The number of female adolescents 13 years of age who had three doses of the human papillomavirus (HPV) vaccine by their 13th birthday.
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 Screened For Colorectal Cancer (COL-n)

Description	The number of members 50-75 years of age who had appropriate screening for colorectal cancer.
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 Who Should Be Screened For Colorectal Cancer (COL-d)

Description	The number of members 50-75 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 Older Adults (COA-d)

Description	The number of adults 66 years and older.
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 Older Adults (GSO-d)

Description	The number of Medicare members 65 years and older.
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 Older Adults Screened For Glaucoma (GSO-n)

Description	The number of Medicare members 65 years and older who received a glaucoma eye exam by an eye care professional for early identification of glaucomatous conditions.
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 Older Adults With Advance Care Planning (COA-n)

Description	The number of adults 66 years and older who had advance care planning 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 Older Adults With A Functional Status Assessment (COA-n)

Description	The number of adults 66 years and older who had their functional status assessed 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 Older Adults With A Medication Review (COA-n)

Description	The number of adults 66 years and older who had their medication reviewed 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 Older Adults With Pain Screening (COA-n)

Description	The number of adults 66 years and older who were screened for pain 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 Older Men (PSA-d)

Description	The number of male members 70 years and older.
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 Older Men Unnecessarily Screened For Prostate Cancer (PSA-n)

Description	The number of men 70 years and older who were screened unnecessarily for prostate cancer using prostate-specific antigen (PSA)-based screening.
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 Screened For Breast Cancer (BCS-n)

Description	The number of women 40-69 years of age who had a mammogram to screen for breast cancer.
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 Screened For Cervical Cancer (CCS-n)

Description	The number of women 21-64 years of age who received one or more Pap tests to screen for cervical cancer.
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 Screened For Chlamydia (CHL-n)

Description	The number of women 16-24 years of age who were identified as sexually active and who had at least one test for chlamydia 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 Women Who Should Be Screened For Breast Cancer (BCS-d)

Description	The number of women 40-69 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 Women Who Should Be Screened For Cervical Cancer (CCS-d)

Description	The number of women 21-64 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 Women Who Should Be Screened For Chlamydia (CHL-d)

Description	The number of women 16-24 years of age who were identified as sexually active.
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

Weight Assessment And Counseling For Nutrition And Physical Activity For Children/Adolescents (WCC)

Description	The percentage of members 3-17 years of age who had an outpatient visit with a PCP or OB/GYN and who had evidence of the following during the measurement year. - BMI percentile documentation. - Counseling for nutrition. - Counseling for physical activity. Because BMI norms for youth vary with age and gender, this measure evaluates whether BMI percentile is assessed rather than an absolute BMI value. 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/D) OR (B/D) OR (C/D)) *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 - Prevention And Screening Analysis_Calendar Dimension_FK

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

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

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

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

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

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