Notifications
Clear all
Topic starter
When I export a Problem custom list, the ICD10 codes are missing. Has anyone else had this problem? I thought I had seen a post about this, but don't find anything.
Thanks
Posted : October 4, 2016 4:20 am
You're not the only one. I don't know if newer versions have this fixed or not. We're on CPS 12.08. The last column in the problem list .PCL file is the master diagnosis ID, and will import and translate back into ICD-10 codes. You just have to find the new codes.
What I did to get the full list of ICD-10 codes was to do this SQL query:
SELECT CodeMasterDiagnosisID,ItemRange,ItemDescription
FROM ICDStructure
WHERE (CodeType <> 1)
to get a list like this:
CodeMasterDiagnosisID ItemRange ItemDescription
3493 P09 Abnormal findings on neonatal screening
Posted : October 4, 2016 4:38 am
Topic starter
Thanks. We are on EMR and I am not familiar with how to run the SQL query.
Posted : October 7, 2016 5:31 am
Here's a query to get the problem customs lists and both codes. I use a tool called Oracle SQL Developer to connect to an EMR Oracle database and run queries against it. It is a java application so just has to be unzipped into a directory. This query works in both SQL and Oracle
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 : October 7, 2016 9:52 am
Nice - thanks!
Posted : October 10, 2016 1:37 am
Topic starter
Thanks David. I am passing this by our DB manager to see if they can assist me with the query.
Posted : October 11, 2016 2:09 am
