I need help to create a diabetes report. One of the conditions is that the patient should have been treated by the same physician/group for at least 1 yr. I am assuming it has to be taken from the billing codes. Can anyone provide help/suggestions on how to do this, which tables, links, etc.
Any help is appreciated.
Thanks in advance
Create report based on Office Visit, Diabetic ICD Code, & Clinical Date as far back as 1 year.
Thank you for the reply.
I have a report which pulls the latest observation values of a patient and all the office visit dates. The report is grouped by patient and then on clinical date. The latest obs. values are displayed in the GF2 (clinical date). How can I get all the diagnosis codes that were billed for a a particular visit (in GF2)?
What do you mean when you say GF2? I am using EMR 9.5 You could run a separate report to list all diag codes & its description then you can determine which ICD code goes with the Diabetic code based on its description? Hope this helps.
Sorry, I meant Group Footer 2. I have been given the diabetes ICD-codes to be used for this report. What I need is, to display all the diagnosis codes in Group Footer2
eg: a patient had office visits on 4/4/2012, 11/10/2012
the out put should be something similar to the following
4/4/2012 ICD-250.00, ICD-486, ICD-277.00
11/10/21012 ICD-493.90, ICD-357.2, ICD-V72.31
ummm, if you had the diag code table.field to the footer it doesnt work? I am sorry I cant help you on any further.
Could you just have the diag code and clinical dates listed in the detail line instead of the GF2? You could use Crystal Report selection criteria to only include certain diag codes and clinical date range?
I cannot display the detail section. Only GF2 should be visible. This is a very elaborate report. Thank you for your suggestions.
Hi wsc27,
Also, if you have any other suggestions, please let me know. Thank you.