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 WHIO’s nearly 450 million (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.  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:

  • Service and pharmacy fill dates starting 1/1/2017 with quarterly updates within 8 weeks after the close of a calendar quarter;
  • Claim line detail with ten slots for diagnosis codes; six ICD procedure codes; revenue, POS, type of bill, and other codes; service dates; provider, biller, and prescriber NPI; billed charges and more;
  • Records for commercial, Medicare Advantage, and Wisconsin Medicaid patients;
  • Unique and persistent WHIO patient ID; birth year, gender, and patient ZIP code or county are retained;
  • Reference tables including code sets, pharmacy meta-data, and a fully identified Wisconsin provider registry.

SID is perfect for use cases demanding long over-time period analyses; large data sets; and a straightforward approach to healthcare claims.

WHIO also offers an Enhanced Data (ED) asset.  ED builds on SID with its own set of relational tables also supported for your MS SQL technical environment.  Key enhancements in ED include:

  • 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;
  • Service dates over a 24-month period, plus 3 months of claims processing lag, for each release;
  • Records for commercial, Medicare Advantage, and Wisconsin Medicaid patients.

Contact us today for more information on WHIO’s best-in-Wisconsin healthcare data.

The Socio-Economic Reference File (SERF ™) connects WHIO’s patient records to key socio-economic factors in the location of their most recent residence.  The SERF includes social and economic data obtained from public sources, customized to the geographic area in which each WHIO patient resided in 2020. These data provide an estimate of social and economic characteristics of sub-populations in Wisconsin. Included are factors for race, ethnicity, housing and housing vacancies, educational attainment, mean and median income, labor force participation and unemployment rate, and household computer and broadband availability.