YOU’VE IDENTIFIED THE PROBLEM.

YOU KNOW THE QUESTIONS.

WHIO’s Intelligence Bank informs the solution by providing the data you need for a winning strategy. You’ll get the answers essential to your organization to solve problems, take advantage of opportunities, better understand your competitors, and differentiate yourself in the marketplace. You’ll know the data underlying your decisions are based on Wisconsin’s most comprehensive and highest quality database.

WHIO offers two comprehensive data assets designed to meet your unique needs.  Both leverage over 1 billion (and counting) medical and pharmacy claims and eligibility records to give you a data source flexible enough to attack with your own BI tools, query languages, and analytical approaches.

The Standard Integrated Data (SID) file is a “just the facts” set of relational tables fully supported for your MS SQL technical environment.  The SID is a perfect complement to your data assets with a simple structure: just two fact tables and plenty of dimensions to guide your investigations. SID’s key components are outlined below.

• Service and pharmacy fill dates starting 1/1/2017 with quarterly updates.
• Claim line detail with ten slots for diagnosis codes, six ICD procedure codes, place of service, service dates, provider NPI, billed charges and more.
• Records for commercial, Medicare Advantage, and Wisconsin Medicaid patients.
• Unique and persistent WHIO patient ID, birth year, gender, ZIP code, and county.
• Reference tables including code sets, pharmacy meta-data, and a fully identified Wisconsin provider registry.

The SID is perfect for use cases demanding over time analyses, large data sets and a straightforward approach to healthcare claims.

The WHIO also offers an Enhanced Data (ED) asset. The ED builds on SID with its own set of relational tables also supported for your MS SQL technical environment. Key enhancements included in the ED are listed below.

• Episodes of care to facilitate your investigation of bundles of care, transplant package rates, or provider profiling.
• Patient risk adjustment to allow “apples to apples” comparisons.
• Normalized pricing to help you avoid false conclusions on healthcare costs due to differences in fee schedules or provider-specific payment arrangements.

The WHIO also offers topic focused data files to use alone or in conjunction with the SID and ED files.

HealthSCAPE is a comprehensive data file that contains descriptive data on more than 175 hospitals and other inpatient health care facilities in Wisconsin. HealthSCAPE includes details on each facility’s location, type, structural characteristics, credentials and operating statistics. Finally, HealthSCAPE locates over 100 health care service offerings.

Health Attributes and DEmographic Navigator (HADEN) includes over 20 data elements to evaluate a community’s ability to support the health of its citizens. HADEN includes distinct demographic attributes, as well as the Social Vulnerability Index (SVI) and Area Deprivation Index (ADI) sourced by census tract level and applied at the insured person level. The SVI is used to identify communities that may need additional support during a disaster and the ADI is used to measure the resilience of neighborhoods.

I-ZCTA is available to researchers who want more precise geographic populations. This file includes a ZIP Code Tabulation Area (ZCTA) code for each insured person in the WHIO’s Insights Hub. ZCTAs are created by the U.S. Census Bureau and are based on ZIP Codes but are not identical to ZIP Codes. ZCTAs provide a more stable and representative geographic area from demographic analyses.