OHDSI Home | Forums | Wiki | Github

Checking ICD9 vs ICD10 via DXVER and PROCTYP values in Truven ETL

CDM Builders
#1

Hi @ericaVoss
In the latest version of the spec (Version 13.0 April 19, 2016 ) for CDM v5 Truven
“Common Data Model (CDM v5.0) ETL Mapping Specification for TRUVEN (CCAE and MDCR)”
https://github.com/OHDSI/ETL-CDMBuilder/blob/master/man/TRUVEN_CCAE_MDCR/Truven_CCAE_and_MDCR_ETL_CDM_V5.doc
there are several places where the values of DXVER and PROCTYP are checked, to see if the
populated diagnosis or procedure code is using version 9 or version 10 of ICD-CM/Proc/PCS.

Some questions:

  1. How are NULL values for DXVER and PROCTYP to be handled? Do we assume the code is version 9? Should we be checking DXVER the way PROCTYP is checked (i.e. if ‘0’, it is version 10, otherwise the code is version 9) ?

  2. On page 15, (Section 2.6, Visit Occurrence), PROCTYPE is checked for ‘*’. Should that be “<> 0” as is used elsewhere in the document?

  1. On page 18, the specs have “DXVER=10”. Should that be “0” ?

Thanks for your work on this spec !

t