Notifications
Clear all
Topic starter
I have been tasked with extracting immunization data from Centricity EMR.
We want data for patients that have had specific immunizations and those who do not, so we can do outreach to those patients.
I understand from co-workers that this was easier when Obs Terms were assigned to the immunizations.
But now Immunizations are in a view, so we need a new way.
We considered pulling orders, but that leaves those patients that are preloaded unaccounted for.
Anyone found a good way to report in the new system?
I believe CQR result reporting would have the same limitation.
Thanks for any assistance you can grant me!
Posted : July 21, 2016 6:05 am
Are you comfortable with Crystal Reports or SQL Reports? I ask because it is a relatively easy report to create over the Immunization table in the database. You'll need to join to the PatientProfile table to get the patient information.
Posted : July 21, 2016 8:35 am
I have MEL code that displays Immunization data in a note - have not yet built a way to do a 'protocol'. By 'protocol', I mean the logic to determine if a particular immunization would now be due.
I am also working on a report to determine flu and pneumo immunization status for our older 50+ and 65+ patients. But this approach would be more for outreach efforts, and not necessarily while a patient is here for a visit.
Which are you trying to do?
Posted : July 21, 2016 9:36 am
i was able to built something and get some information. but I'm not very good at organizing information in crystal report..
Posted : July 22, 2016 6:08 am
is it possible to share the code?
Posted : July 22, 2016 6:08 am
I have a display in a form. Data Display of a MEL expression:
{
fnTextTransImmunHx(IMMUN_GETLIST("", "all"))
}
And, on the right side of VFE, I have defined the function:
{!fn fnTextTransImmunHx() {
local hold = getfield(IMMUN_GETLIST("", "all"), "|", "")
local temp
global rslt = ""
for i = 1, i <= size(hold), i = i + 1 do
temp = getfield(hold[i], "^", "")
if (rslt <> "") then
rslt = rslt + rtntype
endif
rslt = rslt + temp[3] + if temp[4] <> "" then " - " else "" endif + temp[4] + " on " + temp[30] + HRET
endfor
return rslt
}}
Which will then display:
Pneumococcal PPSV23 - PNEUMOVAX on 6/19/2014 11:25 AM
Pneumococcal PPSV23 - PNEUMOVAX on 9/29/2014 9:44 AM
Human Papillomavirus - HPV #3 on 6/19/2014 11:25 AM
Influenza - FLU VAX on 6/19/2014 1:08 PM
Influenza - FLU VAX on 8/20/2014 12:25 PM
Influenza - FLU VAX on 9/29/2014 9:44 AM
DTaP - Diphtheria-Tetanus Toxoids DT Intramuscular Suspension 25-5 LFU/0.5ML on 6/16/2015 12:14 PM
BCG - BCG Vaccine Injection Injectable on 6/9/2005 12:00 AM
Human Papillomavirus - Gardasil Intramuscular Suspension on 6/16/2015 1:45 PM
Influenza - Flu Vax on 12/25/2015 12:00 AM
Influenza - Flu Vax on 12/25/2015 12:00 AM
Influenza - Fluzone High-Dose Intramuscular Suspension on 1/26/2016 4:04 PM
DTaP on 2/9/2016 10:33 AM
MMR - Unspecified Formulation on 1/2/2014 12:00 AM
Measles - Unspecified Formulation on 1/2/2014 12:00 AM
Posted : July 22, 2016 7:21 am
Topic starter
Both, but the outreach is most pressing.
We can run crystal or SQL reports but the letter generation doesn’t create an entry in the chart.
Our practice managers would need to the manual process which could be a few thousand letters
Posted : July 27, 2016 5:11 am
So you are asking to build a "Letter" in Centricity that has immunization information on it?
Have you looked into the command "IMMUN_GETLIST"? If you use this command with If/Then or Case statements, you should be able to build the type of letter you want; I believe.
Posted : July 27, 2016 10:44 am
Topic starter
Not really. I am looking to pull patients with immunizations within a specific time frame. I intend to pull our initial patient population then use the report to exclude those who have the immunizations. Then we will send an outreach letter to those who need immunizations. Unless someone has a better way. As I understand it from co-workers, we cannot pull those who need the immunization directly because you cannot report on a null set within the table for each patient. And we cannot pull from orders or codes due to pre-loaded patients and other sources who administered the immunization. Hope this clarifies, I'm new to medical field, so I'm still trying to get the lingo down.
Posted : July 27, 2016 11:10 am
I am also in search of something similar.
I need a report that will look for patients who have or have not had a particular vaccine (Pneumo specifically at this time). I am very limited on Crystal Reports and don't have access to DB tables to understand how to create a report. Does anyone have a report that would do this?
We are on EMR 9.8
Thanks
Posted : October 11, 2016 2:36 am
