-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AppendixK_2LOINCCodesMap.pdf
January 01, 2019 - Completed by: _______________________________
Test # Laboratory Test Name Specimen Type Units LOINC Code … Bicarbonate Arterial Blood mEq/L = mmol/L 1960-4 HCO3 BldA-sCnc
TO BE COMPLETED BY LABORATORYLOINC Code … Completed by: _______________________________
Test # Laboratory Test Name Specimen Type Units LOINC Code … Name Comments Specimen Type Units Normal Range Method Comments
TO BE COMPLETED BY LABORATORYLOINC Code … Specimen Type Units Normal Range Method Comments
Current LOINC Code Information Sheet
Template
-
hcup-us.ahrq.gov/toolssoftware/comorbidityicd10/CMR-ChangeLog-v20231-v20241.xlsx
December 01, 2023 - ICD-10-CM diagnosis codes that were added to a comorbidity measure (v2024.1 vs v2023.1)
ICD-10-CM Code … ICD-10-CM Code Description Comorbidity
Measure v2024.1
D6102 Shwachman-Diamond syndrome COAG
E7527 … -10-CM diagnosis codes that were removed from a comorbidity measure (v2024.1 vs v2023.1)
ICD-10-CM Code … ICD-10-CM Code Description Comorbidity
Measure v2024.1
No codes were removed from a comorbidity measure
-
hcup-us.ahrq.gov/db/nation/kid/tools/stats/PublicSummaryStats_KID_2006_DX_PR_GRPS.PDF
January 01, 2006 - 185.34
ECCSMGN4 : CCS-MHSA general category: E Code 4 2955 3128369 0.00 662.00 67.66 200.56
PCLASS1 … 298 0.01
.C: Inconsistent code 381 0.01
0: Not a MHSA code 2986533 95.38
650: Adjustment disorders … 298 0.01
.C: Inconsistent code 381 0.01
0: Not a MHSA code 3016945 96.35
6521: Conduct disorders … 298 0.01
.C: Inconsistent code 381 0.01
0: Non-chronic condition 2603145 83.13
1: Chronic condition … 2200 0.07
0: Not a MHSA code 239113 7.64
662: Suicide and intentional self-inflicted injury 21510
-
hcup-us.ahrq.gov/db/nation/neds/pgms/StataLoad_NEDS_2011_Core.Do
January 01, 2011 - ;
label var dxccs15 "CCS: diagnosis 15" ;
label var ecode1 "E code … 1" ;
label var ecode2 "E code 2" ;
label var ecode3 "E code 3" … " ;
label var e_ccs1 "CCS: E Code 1" ;
label var e_ccs2 "CCS: E … Code 2" ;
label var e_ccs3 "CCS: E Code 3" ;
label var e_ccs4 … expected payer (uniform)" ;
label var pl_nchs2006 "Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/neds/pgms/StataLoad_NEDS_2010_Core.Do
January 01, 2010 - ;
label var dxccs15 "CCS: diagnosis 15" ;
label var ecode1 "E code … 1" ;
label var ecode2 "E code 2" ;
label var ecode3 "E code 3" … " ;
label var e_ccs1 "CCS: E Code 1" ;
label var e_ccs2 "CCS: E … Code 2" ;
label var e_ccs3 "CCS: E Code 3" ;
label var e_ccs4 … expected payer (uniform)" ;
label var pl_nchs2006 "Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/neds/pgms/StataLoad_NEDS_2009_Core.Do
January 01, 2009 - ;
label var dxccs15 "CCS: diagnosis 15" ;
label var ecode1 "E code … 1" ;
label var ecode2 "E code 2" ;
label var ecode3 "E code 3" … " ;
label var e_ccs1 "CCS: E Code 1" ;
label var e_ccs2 "CCS: E … Code 2" ;
label var e_ccs3 "CCS: E Code 3" ;
label var e_ccs4 … expected payer (uniform)" ;
label var pl_nchs2006 "Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/neds/pgms/StataLoad_NEDS_2012_Core.Do
January 01, 2012 - ;
label var dxccs15 "CCS: diagnosis 15" ;
label var ecode1 "E code … 1" ;
label var ecode2 "E code 2" ;
label var ecode3 "E code 3" … " ;
label var e_ccs1 "CCS: E Code 1" ;
label var e_ccs2 "CCS: E … Code 2" ;
label var e_ccs3 "CCS: E Code 3" ;
label var e_ccs4 … expected payer (uniform)" ;
label var pl_nchs2006 "Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/neds/pgms/StataLoad_NEDS_2013_Core.Do
January 01, 2013 - ;
label var dxccs15 "CCS: diagnosis 15" ;
label var ecode1 "E code … 1" ;
label var ecode2 "E code 2" ;
label var ecode3 "E code 3" … " ;
label var e_ccs1 "CCS: E Code 1" ;
label var e_ccs2 "CCS: E … Code 2" ;
label var e_ccs3 "CCS: E Code 3" ;
label var e_ccs4 … expected payer (uniform)" ;
label var pl_nchs "Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/neds/pgms/StataLoad_NEDS_2011v2_Core.Do
February 25, 2015 - ;
label var dxccs15 "CCS: diagnosis 15" ;
label var ecode1 "E code … 1" ;
label var ecode2 "E code 2" ;
label var ecode3 "E code 3" … " ;
label var e_ccs1 "CCS: E Code 1" ;
label var e_ccs2 "CCS: E … Code 2" ;
label var e_ccs3 "CCS: E Code 3" ;
label var e_ccs4 … expected payer (uniform)" ;
label var pl_nchs2006 "Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/nis/NIS_Sources_and_Restrictions_2002.pdf
January 01, 2002 - hospitals:
• DSHOSPID, data source hospital identifier
• HOSPSTCO, hospital state, county FIPS code … hospitals:
• DSHOSPID, data source hospital identifier
• HOSPSTCO, hospital state, county FIPS code … • Behavioral Health including chemical dependency care or
psychiatric care (defined by a service code … hospitals:
• DSHOSPID, data source hospital identifier
• HOSPSTCO, hospital state, county FIPS code … hospitals:
• DSHOSPID, data source hospital identifier
• HOSPSTCO, hospital state, county FIPS code
-
hcup-us.ahrq.gov/db/nation/kid/corrections2019.jsp
January 01, 2023 - should indicate whether there is at least one major
diagnostic or therapeutic ICD-10-PCS procedure code … DX_PR_GRPS file onto the CORE file and correct the assignment of PCLASS_ORPROC using the following code … :
SAS Code:
PCLASS_ORPROC = 0;
ARRAY PCLASS (*) PCLASS1-PCLASS25; … DO I = 1 TO 25;
IF PCLASS(I) IN (3,4) THEN PCLASS_ORPROC=1;
END;
SPSS Code … Stata Code:
replace PCLASS_ORPROC=0
foreach pclass of varlist pclass1-pclass25 {
-
hcup-us.ahrq.gov/db/vars/drg/nedsnote.jsp
May 01, 2015 - The diagnosis code "V300" is considered valid by HCUP standards because until September 30, 1989 "V300 … " is a valid ICD-9-CM code. … The DRG Grouper does not recognize the "V300" code on October 1, 1989 and therefore groups the record … (DXV1=1) and at least one non-missing secondary diagnosis code (DX2, etc.) had the incorrect DRG and … Massachusetts (SID)
Some 1989-1990 discharges with a missing principal diagnosis code (DX1=" ") and
-
hcup-us.ahrq.gov/db/vars/mdc/nedsnote.jsp
May 01, 2015 - (DXV1=1) and at least one non-missing secondary diagnosis code (DX2, etc.) had the incorrect DRG and … Massachusetts (SID)
Some 1989-1990 discharges with a missing principal diagnosis code (DX1=" ") and … at least one non-missing secondary diagnosis code (DX2, etc.) have the incorrect DRG and MDC assigned … secondary diagnosis code (DX2, etc.) have the incorrect DRG and MDC assigned because of an error in … secondary diagnosis code (DX2, etc.) have the incorrect DRG and MDC assigned because of an error in
-
hcup-us.ahrq.gov/db/vars/dxn/nrdnote.jsp
August 01, 2015 - and one space following a 4-character diagnosis code (four and three spaces, respectively, in 2014). … For example, the diagnosis code 863.0 would appear as '8630 ' with trailing blanks in HCUP data. … Any zeroes at the beginning of the code are significant; they are part of the code. … For example, the ICD-9-CM diagnosis code 086.3 would be stored in the HCUP databases as '0863 ' and the … Invalid Diagnosis
Inconsistent Code
The value of DXn
"invl"
"incn"
DXCCSn
Set to
-
hcup-us.ahrq.gov/db/vars/zipinc4/nisnote.jsp
September 01, 2008 - NIS Description of Data Elements
ZIPINC4 - Median income for patient's ZIP Code … data elements derived from the patient's ZIP Code, one with four categories (ZIPINC4) and another more … Beginning in 1998, there is only one data element for median household income of the patient's ZIP Code … ZIPINC4 is missing (.) when the patient's ZIP code is missing, invalid, or outside of the United States … Values
Variable Description Value Value Description ZIPINC4 Median income for patient's ZIP Code
-
hcup-us.ahrq.gov/db/vars/zipinc4/kidnote.jsp
September 01, 2008 - KID Description of Data Elements
ZIPINC4 - Median income for patient's ZIP Code … data elements derived from the patient's ZIP Code, one with four categories (ZIPINC4) and another more … Beginning in 1998, there is only one data element for median household income of the patient's ZIP Code … ZIPINC4 is missing (.) when the patient's ZIP code is missing, invalid, or outside of the United States … Values
Variable Description Value Value Description ZIPINC4 Median income for patient's ZIP Code
-
hcup-us.ahrq.gov/db/nation/nrd/stats/FileSpecifications_NRD_2012_Core_V2.TXT
January 01, 2012 - 5 Char E code 3
NRD 2012 Core_V2 64 ECODE4 5 Char E code 4 … 1
NRD 2012 Core_V2 67 E_CCS2 4 Num CCS: E Code 2
NRD 2012 Core_V2 … 68 E_CCS3 4 Num CCS: E Code 3
NRD 2012 Core_V2 69 E_CCS4 4 … Num CCS: E Code 4
NRD 2012 Core_V2 70 FEMALE 2 Num Indicator of sex
NRD 2012 … 122 ZIPINC_QRTL 2 Num Median household income national quartile for patient ZIP Code
-
hcup-us.ahrq.gov/db/nation/nrd/stats/FileSpecifications_NRD_2011_Core_V2.TXT
January 01, 2011 - 5 Char E code 3
NRD 2011 Core_V2 64 ECODE4 5 Char E code 4 … 1
NRD 2011 Core_V2 67 E_CCS2 4 Num CCS: E Code 2
NRD 2011 Core_V2 … 68 E_CCS3 4 Num CCS: E Code 3
NRD 2011 Core_V2 69 E_CCS4 4 … Num CCS: E Code 4
NRD 2011 Core_V2 70 FEMALE 2 Num Indicator of sex
NRD 2011 … 122 ZIPINC_QRTL 2 Num Median household income national quartile for patient ZIP Code
-
hcup-us.ahrq.gov/db/nation/nrd/stats/FileSpecifications_NRD_2013_Core.TXT
January 01, 2013 - 5 Char E code 3
NRD 2013 Core 64 ECODE4 5 Char E code 4
NRD 2013 Core … Elective versus non-elective admission
NRD 2013 Core 66 E_CCS1 4 Num CCS: E Code … 1
NRD 2013 Core 67 E_CCS2 4 Num CCS: E Code 2
NRD 2013 Core 68 E_CCS3 … 4 Num CCS: E Code 3
NRD 2013 Core 69 E_CCS4 4 Num CCS: E Code … (uniform)
NRD 2013 Core 86 PL_NCHS 3 Num Patient Location: NCHS Urban-Rural Code
-
hcup-us.ahrq.gov/db/nation/nrd/stats/FileSpecifications_NRD_2010_Core_V2.TXT
January 01, 2010 - 5 Char E code 3
NRD 2010 Core_V2 64 ECODE4 5 Char E code 4 … 1
NRD 2010 Core_V2 67 E_CCS2 4 Num CCS: E Code 2
NRD 2010 Core_V2 … 68 E_CCS3 4 Num CCS: E Code 3
NRD 2010 Core_V2 69 E_CCS4 4 … Num CCS: E Code 4
NRD 2010 Core_V2 70 FEMALE 2 Num Indicator of sex
NRD 2010 … 122 ZIPINC_QRTL 2 Num Median household income national quartile for patient ZIP Code