Notifications
Clear all
General Discussion
3
Posts
3
Users
0
Reactions
98
Views
Topic starter
Looking for a way to extract our Custom Problem List entries and include the ICD-10 codes. The basic Export from Centricity doesn't include ICD-1os. :-\
Thanks!
Posted : July 24, 2019 6:37 am
Depending on what format you want the data extracted into I can provide you a quote for a custom problem extraction. You can email me at [email protected].
The problem tables have multiple data sets embedded that contain the different code sets and you could even have uncoded problems in the table as well.
Posted : July 25, 2019 3:11 am
Try this SQL query:
select q.qpicktype,q.description,i.code,i.description,
m.CodeType, m.code, m.ShortDescription,m.longdescription,
m1.CodeType, m1.Code, m1.ShortDescription, m1.LongDescription
from icddept i, qpicks q, MasterDiagnosis m, MasterDiagnosis m1
where i.gid = q.qpid
and i.ICD9MasterDiagnosisId = m.MasterDiagnosisId
and i.ICD10MasterDiagnosisId = m1.MasterDiagnosisId
order by q.qpicktype,q.description
Posted : August 7, 2019 1:31 pm
