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
 
  Home      Databases      Tools & Software      Reports      News & Events      Technical Assistance   
 
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."

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 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.
Last modified 8/11/06