Action / Resolution | 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: 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. 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: 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. 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'; |
---|