Skip Navigation
Healthcare Cost and Utilization Project logo
SASD File Composition - Utah
This section describes the original data files obtained from data organizations in participating states and used to create HCUP databases. Information about the source of the original data files, the types of hospitals included in those files, the records excluded during HCUP processing (if any), and other pertinent information to understand the composition of these files are presented.
search icon
 
  Home      Databases      Tools & Software      Reports      News & Events      Technical Assistance   
 
Source Files

The Office of Health Care Statistics, Utah Department of Health provides ambulatory surgery (AS) and emergency department (ED) records to HCUP in two separate files. One file contains information on selected ambulatory surgeries occurring in hospital outpatient departments, hospital-affiliated ambulatory surgery centers, and freestanding ambulatory surgery centers. The second file contains emergency department encounters (identified by revenue codes in the range 450 to 459) from all Utah licensed hospitals. If a patient comes into the ED and has an ambulatory surgery, that record is included in the AS file.

The list of procedures that qualify as ambulatory surgery in Utah include the following:

Description CPT-4 Codes ICD-9-CM Procedure Codes
Mastectomy 19120-19220 850-8599
Musculoskeletal 20000-29909 760-8499
Respiratory 30000-32999 300-3499
Cardiovascular 33010-37799 350-3999
Lymphatic/Hematic 38100-38999 400-4199
Diaphragm 39501-39599 ICD9 codes in Respiratory
Digestive System 40490-49999 420-5499
Urinary 50010-53899 550-5999
Male Genital 54000-55899 600-6499
Laparoscopy 56300-56399 ICD9 codes in Musculoskeletal, Digestive, and Female Genital
Female Genital 56405-58999 650-7199
Endocrine/Nervous 60000-64999 010-0799
Eye 65091-68899 080-1699
Ear 69000-69979 180-2099
Nose, Mouth, Pharynx CPT codes in Musculoskeletal and Respiratory 210-2999
Heart Catheterization 93501-93660 ICD-9 Codes in Cardiovascular
Selection of Records

The following records were excluded from the HCUP Utah ambulatory surgery files:

  • Discharges with disposition of "still a patient" were excluded.
Selection of Records in 2003, Version 1 Files, Only

Using the standard HCUP criteria for assigning records to the 2003 SASD and positive emergency room charges for assigning records to the SEDD, the Utah outpatient source records are separated as follows:

  • 37% of source records are assigned to the SASD
  • 62% of source records are included in the SEDD
  • 2% of source records are excluded.
General SASD Notes

Identifying Freestanding Facilities. Starting in 1998, the data element FREESTANDING identifies hospital-based and freestanding ambulatory surgery facilities. Prior to 1998, there are two identifiers on the SASD that allow a researcher to identify hospital-based and freestanding ambulatory surgery centers.

  • DSHOSPID is the facility identifier provided by the data source.
  • AHAID is the facility identifier used by the American Hospital Association.

1997 Utah SASD. There are 53 unique DSHOSPID values in the 1997 UT SASD.

  • 39 have the AHAID coded indicating they are a hospital-based facility.
  • 1 facility (DSHOSPID=307) with a missing AHAID is a hospital-based facility. DSHOSPID 307 provided inpatient data for the 1997 UT SID and is therefore considered a hospital-based facility.
  • The remaining 13 facilities with DSHOSPID coded and the AHAID missing should be considered freestanding ambulatory surgery centers.

Possible Data Problems for one Utah Hospital. Please use the 1997 data for DSHOSPID="408" with caution. Based on a cursory review of the hospital's data, the following problems were identified:

  • The original discharge date field was shifted by one character causing most of the reported dates to be invalid. During HCUP processing, YEAR was assigned to 97 and DQTR and DDATE were assigned using the shifted position.
  • DISP was missing (DISP = .) on 74% of the discharges, and
  • the median total charge (TOTCHG) was $14.

Additional information is available on the AHRQ Website.
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Are you having problems viewing or printing pages on this Website?
Internet Citation: HCUP Central Distributor SID Utah File Composition. Healthcare Cost and Utilization Project (HCUP). August 2006
Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/db/state/sasddist/sasddist_filecomput.jsp.
Last modified 8/15/06