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

Crystal Report for Problems Custom List

Page 1 / 2 Next

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

24 Posts

7 Users

0 Reactions

170 Views

RSS

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Does anyone have a crystal report that allows you to type in the ICD-10 code and then run it to find out which custom lists that problem is in?

I have it for ICD-9 but not 10. Desperately need it to remove the 311 non-billable codes form the August KB.

Posted : October 12, 2016 6:41 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Are you referring to removing them from the Patient's Problem List? If so, GE provided a report you can run to tell you which patients have the non-billable codes in their Problem Lists.

Posted : October 12, 2016 6:50 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Thank you but no, I meant removiing them from the custom lists. Once they are removed from the pt's chart, they can still be added by doctors via custom lists. I need a quick report to tell me which custom lists the nonbillable codes are on. Thank you though!

Did that report GE provided work well for you?

Posted : October 12, 2016 6:59 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Unfortunately, we have a large number of providers, so this report was actually too large to do us much good.

Posted : October 12, 2016 7:33 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

no report but here is a EMR-Oracle query that might get you started

select a.description, c.code
from QPICKS a, ICDDEPT b, MASTERDIAGNOSIS c
where b.GID=a.QPID
and b.ICD10MASTERDIAGNOSISID=c.MASTERDIAGNOSISID
and c.code='E78.5'

Posted : October 12, 2016 7:44 am

JBell

(@jbell)

Posts: 285

Honorable Member

I don't know if this will help, but have you tried the Uncoded Procedure codes on custom list report? In the Chart Reports > MedicaLogic folder there is a report called Procedure codes on custom list report.

It should list out anything uncoded or expired on a custom list.

Good luck!!

Posted : October 12, 2016 7:50 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

the report only reports on people with appointments coming up in a specified time. that is my only issue with it. had to query to get a list of all patients with non billable codes

Posted : October 12, 2016 7:50 am

JBell

(@jbell)

Posts: 285

Honorable Member

Sorry - I meant to say Uncoded diagnosis codes on custom lists. (I realized I typed procedures)

Posted : October 12, 2016 7:50 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Thanks, does this give me all problems in a custom list?

Posted : October 12, 2016 7:59 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

I actually just tried this, it doesn't account for all of the 311 codes but I do see some! Thank you! It's a start

Posted : October 12, 2016 8:00 am

jryan

(@jryan)

Posts: 119

Estimable Member

I need to work on validating but I have one I can send if you want to get me your email address. I took the GE report that came out for CPS, took all the codes out of their selection formula and added it to a report I already had for custom problem lists. Thx. Jen [email protected]

Posted : October 12, 2016 8:20 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

that query will give you the name of the custom lists that include the code specified in the qualifier.

Posted : October 12, 2016 8:29 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

related question....

According to data model the "DIAGNOSIS" table should contain a list of codes that are currently billable.....

I suppose they just decided to stop updating/using that table....???? I see billable and non billable codes in the table and can't find any difference.

Posted : October 12, 2016 8:31 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

I haven't looked at the SQL behind this report, but I would suppose it uses the diagnosis table, which is you see my comment doesn't not seem to be used/up to date any more....

Yet the report is still there, the table still there and still documented.

Oh so typical.

Posted : October 12, 2016 8:37 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

it is definitely is not an accurate report.

Posted : October 12, 2016 8:38 am

Page 1 / 2 Next

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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