Notifications
Clear all
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
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
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
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
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
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
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
Sorry - I meant to say Uncoded diagnosis codes on custom lists. (I realized I typed procedures)
Posted : October 12, 2016 7:50 am
Topic starter
Thanks, does this give me all problems in a custom list?
Posted : October 12, 2016 7:59 am
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
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
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
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
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
it is definitely is not an accurate report.
Posted : October 12, 2016 8:38 am
Page 1 / 2
Next
