- ACH
- county
- age group
- gender
- race/ethnicity
- language
The Healthier Washington (HW) Measures Dashboard is a set of interactive dashboards that allow users to explore Medicaid data on populations and measures for Washington State, and is intended to support regional assessment, planning, and performance monitoring. The HW Dashboard integrates data from multiple sources, including Medicaid claims and enrollment data, immunization data, vital statistics, and administrative data. The HW Dashboard will be updated or "refreshed" with the latest data and a new "release" of its dashboards on a quarterly basis. Each update is called a "release" and is available online. Each release contains a collection of updates to the data, bug fixes, and feature enhancements. Over time, the HW Dashboard will evolve to include more data sources, measures, and dashboard views, such as trends over time. Version histories of the releases are tracked in the Version history tab of the HW Dashboard.
The HW Dashboard was developed by the Providence Center for Outcomes Research and Education (CORE) in partnership with the Washington Health Care Authority (HCA). Input and collaboration were also received from the Department of Social and Health Services (DSHS) and the Department of Health (DOH). The HW Dashboard supports Accountable Communities of Health (ACHs), Local Health Jurisdictions, and communities by providing data and information to assess regional health needs, engage in planning for health improvement, and monitor outcomes over time.The Dashboard can be viewed in any internet browser, though it is best viewed in the newest version of Chrome. See the section on troubleshooting display settings if the dashboard is too small or information is displaying poorly.
If you have any issues accessing the Dashboard, please contact the ARM team.
The Medicaid Population Explorer dashboard shows the number of Medicaid members living in the state of Washington. You can filter by:
The Measure Explorer dashboard shows measure rates for Medicaid beneficiaries. Select a measure and then filter by:
The Measure Maps dashboard allows you to explore and compare measure rates for Medicaid Beneficiaries by different geographic regions (ACH, county, or zip code).
The Measure Maps dashboard provides a drop-down menu to select the geographic level of the maps, and two different drop-down menus for selecting measures to compare. Selecting a new geographic level will change both maps in the dashboard. Geographic areas are bucketed into quintiles based on their measure rates. Quintiles divide geographic regions into five ranked, equal-sized groups. Below the maps are stacked dot plots, called jitter plots, which show the values for geographic areas (dots) in relation to the statewide rate (vertical line).
Hovering your cursor over the map will:
Hovering your cursor over a dot in the jitter plot does the following:
The area magnifier allows the user to click and drag over a map region to magnify the area.
The selection tools (Free form, Radial, and Rectangle) allow you to select a map area to filter the map. Using one of these tools has the following effects:
The Trends dashboard enables you to visually compare state, ACH, and county performance over time. Rates are presented quarterly for Medicaid claims-based measures, and each date marks the end of a rolling 12-month measurement period. Users can view up to eight rolling 12-month time periods in the dashboard. The map to the left highlights regions that have been selected in the dashboard.
The Transformation Measures dashboard enables you to look at an ACH's performance for groups of pay-for-performance (P4P) measures associated with Medicaid Transformation Project areas. Rates are updated quarterly, and P4P improvement targets are included as a reference point. Clicking on a measure allows the user to see a break out of county and demographic rates.
The measures included in the HW Dashboard are calculated using a number of data sources, including administrative data (ProviderOne Claims and Enrollment, ACES) and other records. Some measures draw solely from administrative or other sources, while others use multiple data sources to calculate measure rates. This section provides an overview of the data sources included in the dashboards and the resulting population, measures, and time periods of analysis for each source.
Title | Description |
---|---|
ProviderOne Medicaid claims and enrollment data (a.k.a. Medicaid Management Information System or MMIS) | The MMIS data includes all health care claims and encounters for Medicaid beneficiaries, enrollment periods, and demographic and address information. In order to represent the most complete data set for the performance period, the state observes a six-month claims lag to account for data maturity and processing time. Example measures: Antidepressant Medication Management; Comprehensive Diabetes Care: Hemoglobin A1c Testing |
Washington State Identification System (WASIS) arrest database | The Washington State Identification System (WASIS) arrest database is maintained by the Washington State Patrol. The database is comprised of arrest charges for offenses resulting in fingerprint identification. The database provides a relatively complete record of felony and gross misdemeanor charges, but excludes some arrest charges for misdemeanor offenses that are not required to be reported. Updated information from the WASIS arrest database is available quarterly with a six-month reporting lag. Example measure: Percent Arrested |
Automated Client Eligibility System (ACES) data system | The DSHS Economic Services Administration’s Automated Client Eligibility System (ACES) is used by caseworkers to record information about client self‐reported living arrangements and shelter expenses. This information is used when determining eligibility for cash, food, and medical assistance. Updated information from the ACES data system is available quarterly. Example measure: Percent Homeless |
OFM population estimates | Total county populations displayed in Medicaid Population Explorer are derived from Washington Office of Financial Management population estimates . The population estimates are developed as accurately as possible from standard and tested methods. The population figures represent the resident population of an area as defined by the federal Census Bureau. The figures include all persons usually residing in an area including military personnel and dependents, persons living in correctional institutions, and persons living in nursing homes or other care facilities. College students are considered residents of the place where they live while attending school. Seasonal populations, such as vacationers or migrant farm workers, are considered residents of the place they consider their usual residence. Persons with no usual residence are counted where they are on April 1. |
The HW Dashboard includes a number of dimensions and filters. These filters, including age group, gender, race/ethnicity, and language, are derived from member information in the Medicaid enrollment files.
The Medicaid population included in the HW Dashboard and measures is limited to the specific pay-for-performance eligibility criteria. There are three general eligible-population criteria applied to all of the Project P4P metrics:
Mixed and limited coverage (second and third bullets above) impacts the accuracy of measure reporting because there is either a non-comprehensive picture of health care encounters for the beneficiary, or the health care encounters being measured would not exist within the available data because the beneficiary isn’t covered for that service by Medicaid or CHIP.
Individual measures have additional eligibility criteria. Some metrics are population-based and report outcomes for all Medicaid beneficiaries that meet the basic eligibility criteria (e.g. arrests and homelessness). Other measures may apply any of the following criteria for eligibility:1
The Population Explorer dashboard includes anyone with eligible Medicaid coverage in the given 12-month measurement year who isn’t excluded by the criteria above. Information about the population (demographic and geographic location) is a “snapshot” of this information from the Medicaid enrollment files using the latest information on record for each eligible member within the measurement year. Member age is determined as the age of the member as of the last day of the measurement year. For example, for measurement year 2017, age would reflect a member’s age as of December 31, 2017. This means that when filtering on age, you are seeing the population in that age category as of that date.
Measures are presented as rates over a specific time period (usually 12 months) for the population included in the specific measure. This is referred to as a measurement period, and measures with different data sources may report different measurement years. Each HW Dashboard refresh will include the latest available information for each data source.
Claims-based measures generally have a six- to nine-month lag from the end of the measurement year to reporting in the HW Dashboard. The 12-month measurement period for the current release is displayed in the Dashboard. The 12-month rolling measurement window will depend on the release month of the Dashboard, and will include a minimum six-month claims lag to account for processing time in the billing data in order to represent the most complete data set for the 12-month window. Likewise, all claims-based population and measure information will be “refreshed” and updated to the latest information with each release.
The HW Dashboard aggregates (or combines) individuals into a set of age groups in order to provide more focused reporting, and the user can filter by age group for most measures. As measures have different clinical-, policy-, and benefit-structure considerations, the age groups vary and are not standardized across measures. Age for the age group filter is calculated based on date of birth as of the last day of the measurement year.
Some measures also include predefined sub-metric age groups that are part of the official definition. For these measures, the age group filter will be designed in accordance with the submetrics, so as to avoid conflicts.
Gender is based on self-reporting at the time of enrollment. Field values include: male and female. Although currently limited to sex-assigned-at-birth options, beneficiaries can choose a gender, and work is underway to incorporate gender identity into applications and other processes.
Race and ethnicity are also derived from ProviderOne enrollment files and based on self-reporting by the individual. In order to describe populations in ways that are most reflective of how individuals identify, the HW Dashboard includes two different approaches to racial and ethnic categorization. These approaches can be summarized as inclusive and exclusive categories.
Individuals are counted towards each race/ethnicity category they select, which promotes a more informed understanding of community needs, health disparities, and opportunities. Because individuals can be in multiple categories, the category counts will not add up to 100 percent. With this approach there are the following groups:
Individuals are counted in a single race category, using the race selection entered in the first race field in ProviderOne. This approach allows for an easy snapshot of individuals who identify as any minority group, and that category counts will always add up to 100 percent. However, this does not capture how individuals may identify with multiple race/ethnicity groups. With this approach there are three groups:
Language is derived from self-reported preferred spoken language. The HW Dashboard language filter includes five language categories: the top four most common languages are displayed, and all other languages are grouped into the “other” category.
Geographic area member counts and measure rates (e.g. zip code, county, ACH) are derived from residential addresses provided by the Medicaid enrollment files. Geographic information displayed in the Medicaid Population Explorer uses the latest physical address available in the measurement window to map a given member's address to a county and ACH. Geocoded most recent addresses are further used to associate a member with a single zip code, school district and state legislative district. School district associations are independent of school enrollment. Due to limitations in geocoding methods, estimated member counts in these geographies may be smaller than actual member counts.
Note: Beneficiaries enrolled in the Washington State Address Confidentiality Program (ACP) who use the ACP address as their physical address (as permitted by law) will be included in the Thurston County counts at the zip code, county, and ACH levels. This is due to protections afforded to confirmed ACP participants who are also Medicaid beneficiaries, which protections limit ACP participants’ actual physical address information from being captured in the data. These beneficiaries can opt to use the generic ACP address with an associated zip code of 98507, in lieu of providing an actual physical address. See https://hca.wa.gov/health-care-services-supports/program-administration/address-confidentiality-program-acp for more details about this program.
For statewide, ACH, and county regional attribution for measures, individuals must have a minimum period of residence in the state and in the ACH region in order to be counted in the measure rate for that region. For most measures, a member needs to have lived in a region for 11 out of the 12 months in the measurement period to count in the measure rate. For some measures, this requirement was too rigid and resulted in a large (> 15%) percentage of members dropping out as unattributed. For these measures the attribution requirement was lowered to 7 out of 12 months. The unattributed populations are included in category 2 data products for the ACHs, but are not visualized on the HW Dashboard. Some other measures have no regional attribution requirement and members are assigned to geographic regions based on their most recent Washington address. The following tables list measures with no attribution requirement or a 7 of 12 months attribution requirement; all other measures have an 11 of 12 months attribution requirement:
Measure | Attribution (months) |
---|---|
Acute Hospital Utilization per 1000 Members | 11 out of 12 |
All-Cause Emergency Department (ED) Visits per 1000 Member Months | 7 out of 12 |
Antidepressant Medication Management | 11 out of 12 |
Asthma Medication Ratio | 11 out of 12 |
Children's and Adolescent's Access to Primary Care Practitioners | 11 out of 12 |
Comprehensive Diabetes Care: Eye Exam (Retinal) Performed | 11 out of 12 |
Comprehensive Diabetes Care: Hemoglobin A1c Testing | 11 out of 12 |
Comprehensive Diabetes Care: Medical Attention for Nephropathy | 11 out of 12 |
Follow-up After Emergency Department (ED) Visit for Alcohol and Other Drug Abuse or Dependence | 11 out of 12 |
Follow-up After Emergency Department (ED) Visit for Mental Illness | 11 out of 12 |
Follow-up After Hospitalization for Mental Illness | 11 out of 12 |
Medication Management for People with Asthma: Medication Compliance 75% | 11 out of 12 |
Mental Health Treatment Penetration (Broad Version) | 11 out of 12 |
Patients Prescribed Chronic Concurrent Opioids and Sedatives Prescriptions | 11 out of 12 |
Patients Prescribed High-Dose Chronic Opioid Therapy | 11 out of 12 |
Percent Arrested | 7 out of 12 |
Percent Homeless (Narrow Definition) | 7 out of 12 |
Periodontal Evaluation in Adults with Chronic Periodontitis | 7 out of 12 |
Plan All-Cause Hospital Readmission Rate (30 Days) | 11 out of 12 |
Primary Caries Prevention Intervention as Offered by Medical Provider | 7 out of 12 |
Statin Therapy for Patients with Cardiovascular Disease (Prescribed) | 11 out of 12 |
Substance Use Disorder Treatment Penetration | 11 out of 12 |
Substance Use Disorder Treatment Penetration (Opioid) | 11 out of 12 |
Well-Child Visits in the 3rd, 4th, 5th, and 6th Years of Life | 11 out of 12 |
An individual may have multiple addresses in the state while still meeting the attribution requirement. Members will be considered unattributed at the state level if they failed to meet attribution requirements while their most recent address was still within the state of Washington.
To be attributed to an ACH, the residential address (or addresses) on file in the Medicaid enrollment files must consistently be within the ACH’s geographic boundaries for the relevant measurement period. This methodology attributes a Medicaid beneficiary experience to a single ACH for a given measurement period. In effect, this limits the population for performance measurement purposes to a relatively stable group of beneficiaries. This approach ensures the ACH is accountable for a population that was likely living in the region for the majority of the measurement period, based on the best available data, and likely to experience impacts from Medicaid Transformation Project activities. The objective is to establish an accountability structure that is fair and sets a reasonable performance expectation.
For most metrics, the residential address on file in the Medicaid enrollment files is required to be within the ACH geographic boundaries for 11 out of 12 months of the measurement period. However, a subset of metrics will use the less restrictive 7 out of 12 months. A member may have multiple addresses in a single ACH region within a measurement period and still meet the attribution requirement. Members will be considered unattributed for an ACH if they failed to meet attribution requirements, but their most recent address was still within the geographic boundaries of the ACH.2
The HW Dashboard contains more than 100 measures and sub-metrics, which are grouped into six domains: access, coordination, quality, social, surveillance, and utilization. Users can select a measure domain in the HW Dashboard to view all of the measures associated with that domain. HW Dashboard measure domains are intended to align with HEDIS® and DSHS categories.
Domain | Measures |
---|---|
Access | Children's and Adolescents' Access to Primary Care Practitioners Mental Health Treatment Penetration (Broad Version) Primary Caries Prevention Intervention as Offered by Medical Provider Substance Use Disorder Treatment Penetration Substance Use Disorder Treatment Penetration (Opioid) Well-child Visits in the 3rd, 4th, 5th, and 6th Years of Life |
Coordination | Follow-up After ED Visit for Alcohol and Other Drug Abuse or Dependence Follow-Up after ED visit for Mental Illness: 7 Days Follow-up After ED Visit for Mental Illness: 30 Days Follow-up After Hospitalization for Mental Illness: 7 Days Follow-up After Hospitalization for Mental Illness: 30 Days Statin Therapy for Patients with Cardiovascular Disease (Prescribed) |
Quality | Antidepressant Medication Management Asthma Medication Ratio Comprehensive Diabetes Care: Eye Exam (Retinal) Performed Comprehensive Diabetes Care: Hemoglobin A1c Testing Comprehensive Diabetes Care: Medical Attention for Nephropathy Medication Management for People with Asthma: Medication Compliance (75%) Periodontal Evaluation in Adults with Chronic Periodontitis Plan All-Cause Hospital Readmissions Rate (30 Days) |
Social | Percent Arrested Percent Homeless (Narrow Definition) |
Surveillance |
Patients Prescribed Chronic Concurrent Opioids and Sedatives Prescriptions |
Utilization | Acute Hospital Utilization, per 1000 Members All-Cause ED Visits, per 1000 MM Patients Prescribed High-Dose Chronic Opioid Therapy Utilization of Dental Services |
Confidence Intervals (CI) provide a range of uncertainty around an estimated number. They include the lower and upper limit numbers for that range where the average of that data point is likely to fall within, generally with 95% accuracy. They are often used with survey data to indicate how the sample drawn for the survey might differ from the underlying population. In the HW Dashboard, however, most measures use the entire population either of Medicaid claimants (excluding those claimants who were also eligible for Medicare) or of Washington State, and so there is no sampling error. In this case, the CI is used to account for uncertainty that arises from random variation that could be largely due to the relatively small sizes of some population subgroups or geographical areas.
Suppression methods follow the Washington State Health Care Authority small numbers standards to address confidentiality and reliability issues with small numbers.
The publicly-available version of the HW Dashboard suppresses data using the following primary suppression criteria:
In order to prevent computation of values removed in primary suppression, additional data are suppressed (a step known as secondary suppression). This prevents users from being able to “back into” small numbers. Groups with consistently small numbers may be excluded from Medicaid Population Explorer to improve user experience and prevent undesirable secondary suppression.
In the Population Explorer dashboard screen shot example above, we are filtered on:
The applied filters show that there are 3,780 female children in Mason County with Medicaid coverage. The demographic charts show a further breakdown of this population. The inclusive race/ethnicity categories will not sum to 3,780, since an individual can be counted multiple times if they select multiple race/ethnicity categories. Asian and Native Hawaiian/Pacific Islander categories are suppressed in this chart. For language, there are 3,109 English-speakers and all other categories are not displayed so that the 671 suppressed counts are suppressed in a way that does not allow a user to derive the missing numbers. Although you can assume that the numbers that are primary suppressed are very small or are zero, the numbers that are secondary suppressed are removed to further reduce the ability to derive the small numbers.
This section provides high-level information about measure calculation for measures included in the HW Dashboard. Detailed information about claims-based and P4P measures can be found by clicking the links below. Information for non-claims-based and non-P4P measures is provided below.
Specification sheets for P4P measures are available on HCA’s website. Please note that the P4P metrics exclusive to Project 3B (Reproductive and Maternal/Child Health) are not available on this dashboard.
Half of the metrics associated with Project 3B: Reproductive and Maternal/Child Health require additional information from either the First Steps databases or Vital Statistics, a Washington State Department of Health data source. Due to different data update schedules and production timelines, these metrics are calculated approximately 3-4 months later than other P4P metrics. The First Steps Database (FSDB) was designed to evaluate and monitor programs and services for low-income and other high-risk women and children in Washington State. Created and maintained by the Washington State Department of Social and Health Services-Research and Data Analysis (DSHS-RDA), the FSDB links vital statistics (such as birth and death certificate information provided by the Department of Health Center for Health Statistics); Medicaid claims, encounter, and eligibility data; immunization registry; and other information sources (see the DSRIP Measurement Guide for more information).
Given the sensitive nature of this information, FSDB operates under a separate and more restrictive confidentiality agreement under the Washington State Institutional Review Board and cannot share results that contain small numbers with outside entities. Thus, the demographic and geographic breakouts that are available are very limited and metric results will only be calculated for calendar year (Jan – Dec) and state fiscal year (July – June). In addition, the multiple data sources that contribute to the FSDB are updated at different frequencies and metric results may not be available on the same timeline as other metrics for inclusion in the HW Dashboard. However, publicly-available Maternal and Child Health Measures Reports are located on HCA’s box.com site, and a separate Maternal and Child Health Dashboard will become publicly-available during Summer 2020.
1The DSRIP Measurement Guide provides more about eligibility criteria. Back to Dashboard dimensions and filters
2See DSRIP Measurement Guide for more information. Back to ACH attribution