HCUP State Emergency Department Databases (SEDD) File Composition This section describes the original data files obtained from data organizations in participating states and used to create the HCUP outpatient databases. Information about the source of the original data files, the types of hospitals included in those files, the records excluded during HCUP processing, and other pertinent information to understand the composition of these files are presented after the Overview in state-specific sections.
Overview of HCUP Outpatient Databases HCUP uses the state-defined indication of AS and ED records for inclusion in the SASD and SEDD. Records identified by the state as AS were included in the SASD. Records identified by the state as ED were included in the SEDD. Three HCUP data elements (STATE_AS for AS services, STATE_ED for ED services, and STATE_OS for observation services) include information on the state-defined record type. They are set to a value of 1 if the state identifies the record as AS, ED or OS respectively. Data elements derived during HCUP data processing indicate that there is evidence on the HCUP record to indicate an AS, ED, or observation stay (OS) service, per HCUP criteria. These three data elements (HCUP_AS for AS services, HCUP_ED for ED services, and HCUP_OS for observation services) are on the SASD and SEDD files. All ED records are placed in the SEDD. This includes
Note also that some ED records will be included in BOTH the SASD and SEDD. If the HCUP Partner has indicated that the record is an ambulatory surgery record, but there is evidence of ED services on the HCUP records (i.e., ED charges or revenue codes), then the record is placed in both the SASD and SEDD. In the SEDD, these records will have STATE_AS = 1, HCUP_ED > 0. This approach began with the recreated, version 2, 2003 data and data year 2004. Prior to data year 2003, HCUP Partners were asked to provide HCUP with separate ambulatory surgery (AS) and emergency department (ED) source files, if possible, and a combined outpatient file with records flagged by type, as an alternative. Records identified as AS were included in the SASD. Records identified as ED were included in the SEDD. Investigation of these data files revealed that different data sources often defined AS and ED records slightly differently. In addition, a number of the AS and ED source files included other types of outpatient records such as chemotherapy, mammograms, and observation stays. The section "Selection of Records Prior to 2003" includes state-specific information on the inclusion of records in the SASD and/or SEDD prior to 2003. In the first version of data year 2003, the allocation of records into the SASD and SEDD was handled differently. HCUP applied uniform criteria based on information available on the HCUP file for the selection of AS records for the SASD and ED records for the SEDD. For the SASD, the criteria for identifying ambulatory surgery records include the following:
For all states, records that fit neither the AS nor ED screen are excluded from the SASD and SEDD. Records excluded from the SASD and SEDD were placed in the State Unused Files (STUF). It became apparent in evaluating the records excluded from the SASD and SEDD that in some cases the HCUP Partners had more information available to them and, therefore, were better able to identify AS and ED records. If the data elements EDflag or ASflag are on the 2003 data file, then the HCUP file had records excluded and placed in the STUF file. If the data elements HCUP_AS, HCUP_ED, or HCUP_OS are on the 2003 file, then records were not excluded and placed in the STUF file. For a description of the file composition for one or multiple states, check the corresponding boxes below and then click the "View File Composition" button. |
Internet Citation: HCUP Central Distributor SEDD File Composition Healthcare Cost and Utilization Project (HCUP). August 2012. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/db/state/sedddist/sedd_multi.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/7/12 |