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

Extracting Immunization Data

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

10 Posts

5 Users

0 Reactions

97 Views

RSS

stamburro

(@stamburro)

Posts: 4

Active Member

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

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

is it possible to share the code?

Posted : July 22, 2016 6:08 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

stamburro

(@stamburro)

Posts: 4

Active Member

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

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

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

stamburro

(@stamburro)

Posts: 4

Active Member

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

relliott

(@relliott)

Posts: 145

Estimable Member

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

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