Notifications
Clear all
Topic starter
I am trying to write a SQL query to pull patients based on specific ICD-10 codes associated with their visit. I was trying to use the PatientVisit and PatientVisitDiags tables but, looking at the data model I have, it appears they only store ICD-9 information. Am I possibly looking at an old version of the data model or is there another table that houses ICD-10 information. Thanks!
Posted : May 13, 2021 7:03 am
PatientVisitDiags links to Diagnosis which links to MasterDiagnosis. Anywhere you want to query for ICD10 codes you need to link back to the MasterDiagnosis table.
Posted : May 13, 2021 7:36 am
Topic starter
Thank you!
Posted : May 13, 2021 8:15 am
