Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Export Problem Custom List Missing ICD10

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

64 Views

RSS

relliott

(@relliott)

Posts: 145

Estimable Member

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

jsander

(@jsander)

Posts: 108

Estimable Member

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

relliott

(@relliott)

Posts: 145

Estimable Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

jsander

(@jsander)

Posts: 108

Estimable Member

Nice - thanks!

Posted : October 10, 2016 1:37 am

relliott

(@relliott)

Posts: 145

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0