-
hcup-us.ahrq.gov/db/nation/nis/nisfilespecs.jsp
November 01, 2024 - _HOSPITAL
Number of Records: 4,544
Record layout NIS 2022 Hospital
Diagnosis and Procedure … Groups File
Data Set Name: NIS_2022_DX_PR_GRPS
Number of Records: 6,578,372
Record layout … : NIS_2021_CORE
Number of Records: 6,666,752
Record layout NIS 2021 Core
Hospital Weights … File
Data Set Name: NIS_2018_DX_PR_GRPS
Number of Records: 7,105,498
Record layout NIS … Set Name: NIS_2017_CORE
Number of Records: 7,159,694
Record layout NIS
2017 Core
-
hcup-us.ahrq.gov/db/nation/neds/nedsfilespecs.jsp
November 01, 2024 - _HOSPITAL
Number of Records: 993
Number of Data Elements: 15
Record layout NEDS 2021 Hospital … _2021_DX_PR_GRPS
Number of Records: 30,099,368
Number of Data Elements: 568
Record layout NEDS … _DX_PR_GRPS
Number of Records: 28,037,034
Number of Data Elements: 565
Record layout NEDS 2020 … _DX_PR_GRPS
Number of Records: 33,147,251
Number of Data Elements: 565
Record layout NEDS 2019 … Data Set Name: NEDS_2018_HOSPITAL
Number of Records: 990
Number of Data Elements: 15
Record
-
hcup-us.ahrq.gov/db/nation/nrd/nrdfilespecs.jsp
December 01, 2024 - Set Name: NRD_2022_HOSPITAL
Number of Records: 2,505
Number of Data Elements: 12
Record layout … Record layout NRD 2021 Core
Hospital File
Data Set Name: NRD_2021_HOSPITAL
Number of Records … _HOSPITAL
Number of Records: 2,539
Number of Data Elements: 12
Record layout NRD 2020 Hospital … Set Name: NRD_2020_DX_PR_GRPS
Number of Records: 16,692,694
Number of Data Elements: 919
Record … of Records: 2,355
Number of Data Elements: 12
Record layout NRD 2016
-
hcup-us.ahrq.gov/datainnovations/raceethnicitytoolkit/or19.pdf
June 16, 2014 - Record Linkage Concepts
Record Linkage
Concepts
Acknowledgements
Slides adapted from training … Linkage
• Can be accomplished manually, by visually comparing
records from two separate sources … • Approach becomes time consuming, tedious, inefficient,
and unpractical as the number of records in … Probabilistic Matching
• Find the records in File 2 that seem to match records in
File 1
• Calculate … Record pairs between cut-off values are
clerically reviewed.
-
hcup-us.ahrq.gov/db/nation/kid/kidfilespecs.jsp
December 01, 2024 - HOSPITAL
Number of Records: 3,811
Record layout KID 2022 Hospital
Severity File
Data … _CORE_V2
Number of Records: 3,089,283
Record layout KID 2019 Core V2
Hospital Weights File … Set Name: KID_2016_CORE
Number of Records: 3,117,413
Record layout KID 2016 Core
Hospital … _CORE
Number of Records: 3,195,782
Record layout KID 2012 Core
Hospital Weights File … Data Set Name: KID_2012_HOSPITAL
Number of Records: 4,179
Record layout KID 2012 Hospital
-
hcup-us.ahrq.gov/db/nation/nass/nassfilespecs.jsp
December 01, 2024 - Data Set Name: NASS_2022_HOSPITAL
Number of Records: 2,799
Number of Data Elements: 13
Record … : NASS_2021_DX_PR_GRPS
Number of Records: 8,896,507
Number of Data Elements: 568
Record layout … Data Set Name: NASS_2020_HOSPITAL
Number of Records: 2,899
Number of Data Elements: 14
Record … Set Name: NASS_2019_DX_PR_GRPS
Number of Records: 8,994,101
Number of Data Elements: 565
Record … of Records: 2,751
Number of Data Elements: 15
Record layout NASS 2016 Hospital
Supplemental
-
hcup-us.ahrq.gov/datainnovations/raceethnicitytoolkit/or19.jsp
July 01, 2014 - Linkage
Can be accomplished manually, by visually comparing records from two separate sources … Approach becomes time consuming, tedious, inefficient, and unpractical as the number of records in file … Estimate probability/likelihood that two records are for the same person versus not
slide … 10
Probabilistic Matching
Find the records in File 2 that seem to match records in File 1
Calculate … a score that indicates, for any pair of records, how likely it is that they both refer to the same
-
hcup-us.ahrq.gov/db/state/sedddist/sedd_multi.jsp
August 01, 2025 - services (OS) records) 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. … HCUP derives data elements during HCUP data processing to indicate evidence on the HCUP record of ED … If the HCUP Partner has indicated that the record is an AS 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
-
hcup-us.ahrq.gov/db/state/sasddist/sasd_multi.jsp
August 01, 2025 - If available, records with OS in combination with ED services would be included in the SEDD; OS records … services (OS) records) 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. … A record in the SASD that also had evidence of ED services based on the HCUP criteria (HCUP data element … Records identified as ED were included in the SEDD, while all other records were included in the SASD
-
hcup-us.ahrq.gov/db/state/sedddist/sedddist_filecompnd.jsp
August 01, 2025 - MHA includes a type of record flag on its outpatient file that identifies each outpatient record type … Any external cause of injury codes Flag assignment is not hierarchical, which means that an ED record … ED records are included with records for other nonemergent outpatient services. … If a record in the SASD also has evidence of ED services based on the HCUP criteria (HCUP data element … HCUP_ED not equal to 0), then the SASD record is also included in the SEDD.
-
hcup-us.ahrq.gov/db/state/sedddist/sedddist_filecompdc.jsp
May 01, 2024 - Selection of Records for Inclusion in the SEDD
All records identified by DCHA as ED are included in … If a record in the SASD also has evidence of ED services based on the HCUP criteria (HCUP data element … HCUP_ED not equal to 0), then the SASD record is also included in the SEDD. … HCUP expects these records to be included in the SEDD, however, ED-OS combination records are not provided … ED-OS records account for roughly 3-6 percent of SEDD records in 2012.
-
hcup-us.ahrq.gov/db/state/sedddist/NC2011-2012SASD_SEDD.pdf
January 01, 2011 - How to Identify and Remove the Problematic Records
The table below lists the number of records in … Data Year
North Carolina SASD
Total number
of SEDD records
Number of
duplicated records
How … to identify and
remove duplicated records
2011 2,762,300 878,164 Delete records with STATE_ED = … the number of records in each year of the North Carolina SEDD, the
number of erroneous records, and … Data Year
North Carolina SEDD
Total number
of SEDD records
Number of
erroneous records
How
-
hcup-us.ahrq.gov/db/state/sedddist/SC2006-2012SEDD.pdf
January 01, 2006 - How to Identify and Remove the Duplicate Records
The table below lists the number of records in each … Data Year
South Carolina SEDD
Total number
of SEDD records
Number of
duplicated records
How … to identify and
remove duplicated records
2006 1,686,258 42,742 Delete records with STATE_AS=1 … =1
2009 1,930,611 62,475 Delete records with STATE_AS=1
2010 1,909,548 65,818 Delete records with … records with STATE_AS=1
(71,416 records) and delete records
with STATE_OS=1 (54,328 records)
-
hcup-us.ahrq.gov/db/state/sedddist/sedddist_filecompmo.jsp
June 01, 2024 - Emergency room (01)
Outpatient surgery (02)
Outpatient observation (03)
Other outpatient (04)
One record … Selection of Records for Inclusion in the SEDD
All records identified by HIDI as ED are included in … If a record in the SASD also has evidence of ED services based on the HCUP criteria (HCUP data element … HCUP_ED not equal to 0), then the SASD record is also included in the SEDD. … Exclusion of Records During HCUP Data Processing
Beginning with 2016 data, records with a discharge
-
hcup-us.ahrq.gov/db/state/sasddist/sasddist_filecompdc.jsp
May 01, 2024 - Selection of Records for Inclusion in the SASD
All records identified by DCHA as ambulatory surgery … Additionally, any records in the SASD that also have evidence of emergency department services based … These records will have the same value for the HCUP data element KEY. … Exclusion of Records During HCUP Data Processing
Beginning with 2016 data, records with a discharge … Prior to 2016 data, these records were excluded.
-
hcup-us.ahrq.gov/db/state/sasddist/sasddist_filecompnd.jsp
August 01, 2025 - Selection of Records for Inclusion in the SASD
All records identified by MHA as ambulatory surgery … Any other nonemergent outpatient records (STATE_ED not equal 1) also are included in the SASD. … These records will have the same value for the HCUP data element KEY. … Exclusion of Records During HCUP Data Processing
Beginning with 2016 data, records with a discharge … Prior to 2016 data, these records were excluded.
-
hcup-us.ahrq.gov/db/state/siddist/IncorrectPayerMappings_IntramuralFiles.pdf
January 01, 2011 - records. … Data
Year
SID PAY1_X SEDD PAY1_X
Records with
PAY1_X = 28
Percentage of
total SID records … Records with
PAY1_X = 28
Percentage of total
SID records
2011 3,269 2.4 3,321 0.9
2012 4,260 … records. … records.
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/hi27.pdf
December 04, 2011 - Year…………………..……………………………………………………………………..16
APPENDIX F: Discharge Records with No Lab Record … records linked to a hospitalization discharge record. … This resulted in
178,426 laboratory records linked to an inpatient discharge record. … A total of 9,233,342 laboratory
records were not linked to an inpatient discharge record as these records … TO INPATIENT DISCHARGE RECORD
Iteration Matched
Records
%4 Account
Number
Medical
Record
-
hcup-us.ahrq.gov/db/state/sasddist/sasddist_filecompmo.jsp
June 01, 2024 - HIDI uses the following hierarchy to identify each outpatient record with a place of service:
Emergency … in data year 2017, HIDI provides their complete outpatient file to HCUP, with the type of outpatient record … Selection of Records for Inclusion in the SASD
All records identified by HIDI as ambulatory surgery … Exclusion of Records During HCUP Data Processing
Beginning with 2016 data, records with a discharge … Prior to 2016 data, these records were excluded.
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/hi27.jsp
September 01, 2014 - Year
APPENDIX F: Discharge Records with No Lab Record, By Hospital and Calendar Year
IV. … A total record count of 29,456,278 lab records were used in the preliminary linking process. … This resulted in 178,426 laboratory records linked to an inpatient discharge record. … A total of 9,233,342 laboratory records were not linked to an inpatient discharge record as these records … TO INPATIENT DISCHARGE RECORD
Iteration
Matched Records
% 4
Account Number
Medical Record