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

How to get a registration picture out of the EMR

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

81 Views

RSS

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Topic starter

I know this was asked at some time on the old CHUG. I stumbled across this when I was investigating a call where the user said pictures had disappeared out of registration. This is in EMR 9.5 but probably works for other versions.

The pictures are stored in the database as BLOBs (Binary Large Objects). Table is ml.person_pict. Two columns, PID and PICT. You can export the pictures out using Oracle's SQL Developer product.

In SQL Developer I had to change these settings:

Tools Preferences, Database, Export/View DDL Options, PDF Format, Column Layout

I set Binary Large Object Column to Link to BLOB Created in a Separate file

I ran a query to find the patient:

select pid, firstname, lastname from ml.person where medrecno is xxxxxx

Took the PID and queried the other table:

select * from ml.person_pict where pid = yyyyyyyyyyyyyyyyy (you could obviously join this table on the person table to return names, medical record number, etc.)

Then I highlighted the row returned (easiest way is to click a cell then CTRL-A), right-clicked a highlighted area and chose Export.

Changed the Format choice to PDF. Change the other fields as needed. Next then Finish. I ended up with a PDF and a new folder that had a .jpg file of the picture in Registration for that patient. Also works selecting multiple patients - creates a separate .jpg for each line.

Now, the .jpg file names aren't the PID number. You can open the .pdf file and click on the BLOB icon and you get a launch dialog that shows which file it wants to open.

Hope this helps someone sometime Laugh

David Shower

OU Tulsa School of Community Medicine

Posted : July 13, 2012 5:40 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

DavidShower said:

I know this was asked at some time on the old CHUG. I stumbled across this when I was investigating a call where the user said pictures had disappeared out of registration. This is in EMR 9.5 but probably works for other versions.

The pictures are stored in the database as BLOBs (Binary Large Objects). Table is ml.person_pict. Two columns, PID and PICT. You can export the pictures out using Oracle's SQL Developer product.

In SQL Developer I had to change these settings:

Tools Preferences, Database, Export/View DDL Options, PDF Format, Column Layout

I set Binary Large Object Column to Link to BLOB Created in a Separate file

I ran a query to find the patient:

select pid, firstname, lastname from ml.person where medrecno is xxxxxx

Took the PID and queried the other table:

select * from ml.person_pict where pid = yyyyyyyyyyyyyyyyy (you could obviously join this table on the person table to return names, medical record number, etc.)

Then I highlighted the row returned (easiest way is to click a cell then CTRL-A), right-clicked a highlighted area and chose Export.

Changed the Format choice to PDF. Change the other fields as needed. Next then Finish. I ended up with a PDF and a new folder that had a .jpg file of the picture in Registration for that patient. Also works selecting multiple patients - creates a separate .jpg for each line.

Now, the .jpg file names aren't the PID number. You can open the .pdf file and click on the BLOB icon and you get a launch dialog that shows which file it wants to open.

Hope this helps someone sometime

David Shower

OU Tulsa School of Community Medicine

Thanks so much, David. We're on 9.5 SP2 as well. We'll give this a try.

David Bragg, MD

Baylor Health Care Systerm Dallas

Posted : August 10, 2012 12:21 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

We do not see a picture in EMR when we do not add it to registration. However, we do have a copy of the DL in the PM side to allow for ID verification.

Just a thought

Posted : August 13, 2012 3:39 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Hi David,

I posted the photo capturing question. Can I get your email so I can contact you?

We are trying to use affinity cards.

I look forward to hearing from you.

Thanks

David Bragg

Baylor HealthCare

Dallas

Posted : November 29, 2012 1:56 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