Skip Navigation
Healthcare Cost and Utilization Project logo
SID File Composition - New York
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
 
 
Source Files

The HCUP New York inpatient files were constructed from the New York State Department of Health's Statewide Planning and Research Cooperative System (SPARCS) Master File.

For 1988-1993, New York supplied their Master File which consists of Discharge Data Abstracts (DDAs) matched to Uniform Billing Forms (UBFs) for inpatient stays. New York created the Master File by matching DDAs and UBFs based on Permanent Facility Identifier, Medical Record Number, Admitting Number, Admit Date, and Discharge Date. If the DDA and UBF records matched, the information from the DDA and UBF was included in the Master File. If there was no match, the information from the DDA was included in the Master File. Due to an administrative change in the collection of billing records for 1989, a large percentage of the DDAs could not be matched to a UBF. When there was no match, charge information, which would have come from the UBF, is missing. The match rate improves over time and stabilizes after 1991. The percentage of DDA records that have a matching UBF record in the Master File are as follows:

1988 77.2%
1989 26.3%
1990 62.8%
1991 93.7%
1992 91.8%
1993 95.5%

Beginning in 1994, hospitals submitted discharge records to New York in a new format, using Universal Data Set (UDS) specifications. This format combines the old UBF and DDA data into a single submission record. In these years, New York supplied records for HCUP that contain complete discharge and uniform billing data corresponding to the "matched" records in earlier years.

Which Hospitals

The New York files contain inpatient discharges from acute care hospitals in the state, excluding long-term care units of short-term hospitals and Federal hospitals.

Not all hospitals report a full calendar year of data. Some hospitals close during the year; other hospitals have technical problems that prevent them from reporting a full year.

Inclusion of Stays in Special Units

The documentation supplied by New York indicates that the data include stays in detoxification (alcohol and drug abuse), alcohol rehabilitation, mental retardation, mental rehabilitation, rehabilitation, alternate level of care, and psychiatric (acute and long term) units within community hospitals. Records for these different types of care cannot be identified from the data elements available in the HCUP New York inpatient data.

Exclusion of Records

The following New York records were excluded from the HCUP inpatient database:

  • For all years, interim records for patients who had not been discharged.
  • For 1988-1992, records with a transaction code indicating "Deletion of a Record Previously Accepted" were excluded. These records were incorrect versions of accurate records included elsewhere in the SPARCS files. This was not a problem in subsequent years' data.
  • For 1988-1993, Uniform Billing Forms (UBFs) that could not be matched to Discharge Data Abstracts (DDAs) were excluded. Matched DDA and UBF records and unmatched DDA records (without charges) were retained in the data.
  • Beginning in 1994, records with a discharge disposition of "still a patient."
  • Beginning in 1998, records with a discharge disposition of "admitted to this hospital."

Beginning in 2008, New York suppressed the identifier for the hospital (DSHOSPID) on records with an indication of induced abortion. These records are retained in the HCUP files with the DSHOSPID set to "BLNK". Analyses that group discharges by type of hospital or are limited to community, non-rehabilitation hospitals will exclude these discharges. New York defines induced abortion records as follows:

  • All Diagnosis code fields to include: 635.0-639.9 or 779.6
  • All Procedure code fields to include: 69.0, 69.5, 69.6, 69.93, 73.8, 74.91, 75.0 or 96.49
  • All CPT-4 codes to include 59812, 59820, 59821, 59830, 59840, 59841, 59850, 59851, 59852, 59855, 59856, 59857, 59100, 88304, or 88305

Internet Citation: HCUP Central Distributor SID New York 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/siddist/siddist_filecompny.jsp.
Are you having problems viewing or printing pages on this Website?
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Last modified 8/11/06