The ICD10PCS procedure codes from inpatient admissions are not added to the TEMP_INPATIENT_ADMISSIONS table because per OHDSI Truevn CCAE MDCR mapping specification, page 18:
- For the procedure codes use the query in section 3.1.2 with the
filters: WHERE SOURCE_VOCABULARY_ID IN (‘ICD9Proc’,‘HCPCS’,‘CPT4’)
AND TARGET_STANDARD_CONCEPT IS NOT NULL AND TARGET_INVALID_REASON IS
NULL AND TARGET_CONCEPT_CLASS_ID NOT IN (‘HCPCS Modifier’,‘CPT4
Modifier’)
This should be due to the inpatient admission not having the PROCTYP field. So, the mapping spec is only getting the (‘ICD9Proc’,‘HCPCS’,‘CPT4’) procedure codes from inpatient admissions, and all the inpatient admission ICD10PCS procedure codes are being dropped. The same happens to the facility header ICD10PCS procedure codes.
Shouldn’t we include the ICD10PCS vocabulary in the WHERE clause of the “filter” references on pages 18, 29 and 31 (WHERE SOURCE_VOCABULARY_ID IN (‘ICD9Proc’,‘HCPCS’,‘CPT4’,‘ICD10PCS’))?
Thanks.