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

query for "unbillable problems" (on EMR)

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

143 Views

RSS

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

Topic starter

I took the report provide by GE in SP10, removed the patient information, and appointment information to give me a query of all problems that are good enough. If you see anything wrong or any suggestions to improve, let me know.

Next, need a query to fix this, so they don't have to open every chart and do a dumb pre-load update.

select count(p.pid),p.Code,p.DESCRIPTION, md9.Code as md9Code, md10.Code as md10Code, i9.leaf as leaf9, i10.leaf as leaf10
from
PERSON patient
JOIN PROBLEM p on patient.PID = p.PID
left join MasterDiagnosis md9 on p.ICD9MASTERDIAGNOSISID=md9.MasterDiagnosisId
left join MasterDiagnosis md10 on p.ICD10MasterDiagnosisId=md10.MasterDiagnosisId
left join ICDstructure i9 on i9.codeMasterDiagnosisId=md9.MasterDiagnosisId
left join ICDstructure i10 on i10.codeMasterDiagnosisId=md10.MasterDiagnosisId
where(NOT p.code LIKE '%CPT%' or p.code is null)
and p.change in (0,1,2,4,5,6)
and (p.stopreason is null or p.stopreason <> 'E')
and (p.stopdate >= SYSDATE)
and ((i9.leaf is null or i9.leaf =0 or md9.MasterDiagnosisId is null) or (i10.leaf is null or i10.leaf =0 or md10.MasterDiagnosisId is null))
group by (p.Code),p.DESCRIPTION, md9.Code, md10.Code, i9.leaf, i10.leaf
order by count(p.pid) desc

Posted : August 26, 2015 11:16 am

SLHV

(@slhv)

Posts: 478

Honorable Member

This query works in CPS if you change "SYSDATE" to "GETDATE()".

I'm combing through the output now. I have a few more rows than I'd hoped.

Posted : August 27, 2015 3:56 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