Tip: Medicare ICD9 and ICD10 code identifiers

0106

Medicare

Jan 14, 2022

Mar 14, 2022 Sep 12, 2022

Updated guidance below.

Added code. Included in September 2022 Data Tips email

Flags to distinguish between ICD9 and ICD10 codes

Active

Arkansas Medicare data is acquired from the Research Data Center (ResDAC) and CMS. ICD version codes are provided on the source file and are not transformed before they are included in the APCD.

Identifying ICD9 Codes:

1. When the value in an ICD version code, e.g. PRNCPAL_DGNS_VRSN_CD, ICD_DGNS_VRSN_CD1 through ICD_DGNS_VRSN_CD25*, contains the value 9, the ICD code is ICD9.

2. When the value in an ICD version code, e.g. PRNCPAL_DGNS_VRSN_CD, ICD_DGNS_VRSN_CD1 through ICD_DGNS_VRSN_CD25*, is NULL and the service date year is 2013, the ICD code is ICD9.

Identifying ICD10 codes:

1. When the value in an ICD version code, e.g. PRNCPAL_DGNS_VRSN_CD, ICD_DGNS_VRSN_CD1 through ICD_DGNS_VRSN_CD25*, contains the value 0, the ICD code is ICD10.

2. When the value in the DGNS_VRSN_CD is NULL and the service date is 2014 forward, the ICD code is ICD10

*There are several types of fields on different tables that contain ICD codes. Look for VRSN in the field name.

Helpful code to identify ICD9 codes that are after Jan 1, 2015:

SELECT ICD_DGNS_CD1, LEFT(ICD_DGNS_CD1,1), icd_dgns_vrsn_cd1, clm_from_dt
FROM apcd_MCR_OUT_CLM
WHERE icd_dgns_vrsn_cd1 IS NULL
AND LEFT(ICD_DGNS_CD1,1) ~ '^[0-9]'
AND clm_from_dt > '2015-01-01';

Medicare

ICD Codes

Tip