VUHDDS Frequently Asked Questions
- What is the Vermont Uniform Hospital Discharge Data Set (VUHDDS)?
- What are the conditions of use for the Public Use File?
- What data elements are included in the Public Use File?
- Which Public Use Files are currently available for downloading?
- What do I need to know in order to download the VUHDDS?
- How do I request a research file with non-public data elements not included in the Public Use Files?
- How are hospital service areas (HSAs) defined in the VUHDDS?
Vermont has been collecting and reporting hospital discharge data since the early 1980’s. All fourteen of Vermont's general acute care hospitals currently contribute records for Vermont residents and non-residents to the Vermont Uniform Hospital Discharge Data Set (VUHDDS). Under the statutory authority to collect these data (18 V.S.A. §§§ 9410, 9456 and 9457), the Vermont Department of Financial Regulation (DFR) administers the program and the Vermont Department of Health (VDH) manages the data set under an agreement with DFR.
The Vermont Association of Hospitals and Health Systems-Network Services Organization (VAHHS-NSO) contracts with the state of Vermont to collect the Vermont hospitals data that are then incorporated into the VUHDDS following a series of quality assurance checks performed by VDH. The Veterans Administration Hospital in White River Junction has not submitted data since June 30, 2006. The Vermont psychiatric hospitals, including the Brattleboro Retreat and the Vermont State Hospital, do not submit data to VUHDDS.
In addition to the data collected from Vermont hospitals, DFR obtains records for Vermont residents using hospital services in the bordering states of New Hampshire, New York and Massachusetts under data use agreements with the New Hampshire Department of Health and Human Services, the New York Department of Health, and the Massachusetts Division of Health Care Finance and Policy. While records for Vermont residents using hospitals in New Hampshire, New York, and Massachusetts include inpatient discharges, not all states collect comparable data sets for outpatient and emergency department discharges. DFR is prohibited from releasing records obtained from these bordering states per provisions of the data use agreements with each state.The Vermont hospital subset of the VUHDDS includes records for inpatient, outpatient, emergency department, observation bed, and series patient discharges for both Vermont residents and non-residents. The collection of emergency department records from Vermont hospitals began with reporting year 2001. From 1989-2000, outpatient data collection was limited to records that each hospital identified as surgical procedures performed in operating rooms. Starting in reporting year 2001, the outpatient definition was revised to include ICD-9-CM procedure codes 00.0-86.99 that occurred in all hospital-based outpatient settings. Starting in reporting year 2006, while all Vermont hospitals continued to report the core outpatient set specified by code range, most hospitals also started to submit all records considered outpatient procedures beyond the specified code range. This includes a wider range of diagnostic procedures and treatments. DFR is working with VDH, VAHHS-NSO, and Vermont hospitals to determine how to define, edit, and use the expanded outpatient data set.
Release of public use data is subject to the following conditions, which the requestor agrees to comply with upon accepting copies of the data:
Hospital Data Release Policy (Last updated November 2002)
The data may not be used in any manner that attempts to or does identify, directly or indirectly, any individual patient or health care practitioner (18 V.S.A. § 9457).
The requestor agrees to incorporate the following, or a substantially similar, disclaimer in all reports or publications that include public use data:
“Hospital discharge data for use in this study were supplied by the Vermont Association of Hospitals and Health Systems-Network Services Organization (VAHHS-NSO) and the Vermont Department of Financial Regulation (DFR). All analyses, interpretations or conclusions based on these data are solely that of [the requestor]. VAHHS-NSO and DFR disclaim responsibility for any such analyses, interpretations or conclusions. In addition, as the data have been edited and processed by VAHHS-NSO, DFR assumes no responsibility for errors in the data due to coding or processing by hospitals, VAHHS-NSO or any other organization, including [the requestor].”
Public Use File Data Elements:
- Patient type (Inpatient, Outpatient, Emergency Department, Observation Bed, Series Patient)
- Hospital of discharge
- Admission type
- Admission source
- Age (in the following groups)-Under 1, 1-17, 18-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75+
- ZIP code (3-digit ZIP for most of Vermont and all other states; combined 058 and 059 area; 5-digit ZIP for areas with a population of over 10,000 (12 ZIP Codes))
- Discharge status
- Principal payment source
- Total charges
- Special Care Unit (SCU) days (Inpatient only)
- Diagnosis related group (DRG) (Inpatient only)
- Major diagnostic category (MDC) (Inpatient only)
- Grouper used to assign DRG and MDC (Inpatient only)
- Principal diagnosis and up to 19 secondary diagnoses
- Principal procedure and up to 19 secondary procedures
- Clinical Classifications Software (CCS) diagnosis group
- Clinical Classifications Software (CCS) procedure group
- Hospital service area
- Patient days (length of stay)
- Same day flag – flags those admitted and discharged on the same day
- Year of discharge
- ER flag – flags those records with an associated emergency department revenue record
Brief Descriptions of Data Files
The Inpatient Data and Outpatient Data files combine to make the complete data set for each calendar year (based on discharge date). These files are separated for easier downloading and because they are frequently used individually. The third data file for each year includes only records relating to the Emergency Department (ED), and is extracted from both the Inpatient and Outpatient data files.
The fourth data file, starting in 2006, is the Expanded Outpatient file. The submission of "expanded" outpatient records by Vermont hospitals for calendar years 2006, 2007, and 2008 with principal procedures outside the ICD-9-CM range of 00.00-86.99 was incomplete and inconsistent across the hospitals. DFR is working with the Vermont hospitals to ensure a complete and consistent filing of the expanded outpatient data set in more recent reporting years.
Data files from 2006 and later do not include records from the Veterans Affairs Medical Center, although these records are included in the 2005 and earlier files. Text files are .zip formatted for greater downloading ease. Zipped sizes shown.
For each calendar year, there are two Excel files in addition to data files. These files, Field Properties and Code Tables, include the file layouts, field properties and code tables for use with the Inpatient, Outpatient, Emergency Department, Expanded Outpatient and Revenue Code data. These files can be used to set up your tables prior to downloading or to reduce the size of your tables after downloading them.
Please note that the Inpatient data files include a number of fields that do not appear in the Outpatient, Emergency Department and Expanded Outpatient data files (SCU_DAYS, SAME DAY FLAG, DRG, MDC, and DRG_GROUPER_VERSION). These fields are not valid across all hospital settings and should only be used with the Inpatient data. Please use the Outpatient Layout for the Outpatient, Expanded Outpatient and Emergency Department files for this reason.
The DRG field in the Inpatient data file changed as of October 1st, 2008 as a result of Federal regulation to use of MS-DRG codes. The field name is still referred to as DRG, but MS-DRG codes populate the data field.
Note that an ID field is highlighted in yellow in the Excel files. An ID field is not included in the Public Use Files, but you may want to add a unique ID to your data set if you are combining multiple text files into a master file.
Data Files Available Online
Annual data files available online are listed below. Please contact VDH for information about earlier VUHDDS data files, as listed in the Contacts section.
- 2002 through 2011 Vermont Outpatient Data
- 2002 through 2011 Vermont Inpatient Data
- 2002 through 2011 Emergency Department Data
- 2006 through 2011 Vermont Expanded Outpatient Data
- 2006 through 2011 Vermont Revenue Code Data
- Field Properties Excel documents
- Code Tables Excel documents
How do I request a research file with non-public data elements not included in the Public Use Files?
To request a research file with non-public data elements not included in the Public Use File, fill out the following form:
Send the completed form to:
Dian Kahn, Director of Analysis and Data Management
Vermont Department of Financial Regulation
89 Main Street
Montpelier, VT 05620-3101
This section has been prepared to assist you with loading and using the Vermont Uniform Hospital Discharge Data Set (VUHDDS) public use files. This section covers Installation Minimum Requirements, Concepts & Purpose of this Relational Data Set, Data Issues, and Getting Started Instructions. If you have questions about or run into issues with the loading of these data sets, please send an email requesting assistance to VDH, as listed in the Contacts section.
- Installation Minimum Requirements
The Expanded Outpatient and Revenue Code public use files are very large and contain millions of records. These larger data files are too large to load into software packages such as Microsoft Excel or Microsoft Access.
To load the large files and take advantage of their features requires a relational database application, such as MYSql, Oracle, DB2, SAS, SPSS or SQLServer. It is also recommended that sufficient hard drive storage space be available to efficiently manage the processing of the data tables. Your Database Administrator (DBA) should be able to determine minimum storage requirements based on the size of the files that are extracted to your computer.
- Concepts & Purpose of this Relational Data Set
The primary purpose of this relational data set is to give research entities access to de-identified hospital discharge data that can be used to produce public research analyses.
The concept used in the creation of this data set was to create primary data tables that hold specific information and then provide code tables that define the values listed within primary data tables. A conceptual layout of the field properties and code tables is included on this web site.
Each line of information is a unique discharge where all information relating to a given discharge record has already been combined. Since there are a large number of variables in these files, the unique discharge is separated from the revenue code file, but can be linked together using the unique id for each record. There may be many revenue records that link to a single discharge record.
This method provides a useable dataset where all adjustments to the data have been applied to the extent possible within the given time period. The annual data sets provided on the website are based on the discharge date by calendar year. A given year’s data set will be posted as soon as the data are cleaned and become available for public use.
- Data Issues
Discharge records may contain values that are blank or negative dollar charge values. Although the data are edited and cleaned, there may still be missing information or unresolved code issues in some cases. Timely availability of data requires the acceptance of a reasonable degree of errors or missing data.
- Getting Started
The Vermont Public Use files on the web site are in a comma-delimited text file format and can be read by any software package/database loading process that can use this format. In each of the data files the first row contains the appropriate Data Dictionary field/column name. Each field is delimited with a ‘,’ or comma.
The hospital service area (HSA) definitions used in the VUHDDS have been modified three times to reflect changing discharge patterns. Starting with the 2002 Monograph, HSAs are based on inpatient discharges where the diagnosis indicated the need for immediate care, for the cumulative reporting years spanning 1997-2001.
Prior definitions of HSAs had been based on all inpatient stays (except for newborns and transfers) and had used a strict decision rule for inclusion of ZipTowns in a hospital’s service area (towns or groups of towns: see definition below for ZipTowns). Use of a strict inclusion rule meant that there were always towns that were not assigned to any HSA and were labeled “contested.”
In preparing for the fourth version of HSAs, rules used to define the 3rd version of HSAs were applied to 1997-2001 data. The number of contested towns rose from 54 to 80, nearly a third of all Vermont towns. This resulted in the loss of one hospital service area and a serious erosion of others. As a result of this increase in contested towns, two major changes were made to the process of defining HSAs.
The first major change was that selection of records was limited to those discharges with diagnoses considered to require immediate hospitalization as described by Newton and Goldacre in their 1994 article, “How many patients are admitted in districts other than their own, and why?” (Journal of Public Health Medicine, 1994, Vol. 16, No. 2, pp. 159-164). Newton and Goldacre used records of patients with acute conditions that require immediate hospitalization, because patients with these conditions tend to go to the hospital nearest to them when they become ill. The authors excluded newborns and patients transferred from another hospital. The authors included records with the following acute conditions as their primary diagnoses: appendicitis, abscess of anal and rectal regions, peritonitis, acute myocardial infarction, pneumococcal pneumonia, and asthma.
The second major change was the shift to a plurality rule in assigning ZipTowns to HSAs, so that all towns are assigned to an HSA with none remaining contested. ZipTowns are towns or groups of towns with over 1,000 residents and relatively contained ZIP code boundaries. ZipTowns were assigned to hospital service areas as follows:
1. If the plurality of a ZipTown’s discharges were from a Vermont hospital or Dartmouth Hitchcock Medical Center (DHMC) in Lebanon, New Hampshire, the ZipTown was assigned to that hospital’s service area.
2. If the plurality of a ZipTown’s discharges were from a non-Vermont hospital other than DHMC, the ZipTown was assigned to the HSA of the Vermont hospital (or DHMC) with the next highest number of discharges. The HSAs continue to include two multi-hospital areas: the White River Junction HSA (Dartmouth Hitchcock Medical Center, Mt. Ascutney Hospital, and the Veterans Administration Hospital) and the Brattleboro HSA (Brattleboro Memorial Hospital and Grace Cottage Hospital). These HSAs include multiple hospitals because resident hospitalizations are split among the hospitals with no clear majority of inpatient discharges concentrated at any one hospital.
In addition to these definitional changes, HSA names were changed. To distinguish these new HSAs from previous ones, HSAs were given the name of the most populous town in their area.
Return to Top