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

Copying "Organization" field to "Email" in Admin>"Referring Provider"

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

69 Views

RSS

mfretwell

(@mfretwell)

Posts: 14

Eminent Member

Topic starter

Hello,

We're looking to mass move data from one field to another in the "Referring Provider" setup area - the fields being "Organization" to "Email" as we want the referring providers organization to appear in the patient banner and there seems to be no data symbol for org. but there is one for email.

I tried searching through the database to find the table in which this data was stored but nothing turned up. If someone could point me in the right direction on getting this data moved to a different field or assist me in this process it would be much appreciated

We're using CPS if helps any.

Posted : July 10, 2018 5:32 am

rfisher

(@rfisher)

Posts: 126

Estimable Member

SELECT OrgName,EmailAddress,* FROM DoctorFacility WHERE TYPE = 3

Posted : July 10, 2018 5:53 am

mfretwell

(@mfretwell)

Posts: 14

Eminent Member

Topic starter

Thank you very much for this! I was able to update the table to copy everything from org>e-mail.

Posted : July 10, 2018 6:49 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

An alternative approach would be to use the OBS term REFAGENCYNME to record the referring organization name for the patient and then display that in the banner with OBSANY("REFAGENCYNME"). This would keep you from having to use a workaround if you ever did need to legitimately record the email address of your referring physicians.

Posted : July 10, 2018 7:54 am

mfretwell

(@mfretwell)

Posts: 14

Eminent Member

Topic starter

How does one go about mapping OBSterms? I'm a bit new to this side of CPS.

Thank you for the alternate route - I'm sure it will eventually come up that we need the email field cleared out for actual emails.

Posted : July 10, 2018 8:27 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

One of the downsides to OBS terms is that they are not exposed to folks doing patient registration on the PM side, so it is likely you would need to get the nurse or physician to identify the referring organization when the patient is seen for the first time and enter the info on a custom form. You could also create a flowsheet with that OBS term and have staff enter it manually once the patient has been registered on the PM side.

Screenshot of a flowsheet to capture patient registration data:

Either way, once the data had been entered for the patient, it would display in your custom banner from that point forward until a new value was entered. You would customize the banner with a string similar to what I have below:

Referring Org: {if OBSANY("REFAGENCYNME") = "" then "Unknown" else OBSANY("REFAGENCYNME") endif}

It would display like this:

Posted : July 10, 2018 8:54 am

mfretwell

(@mfretwell)

Posts: 14

Eminent Member

Topic starter

This makes more sense now. I was under the impression that there was another way to manipulating the OBS to be picked up.

This can be something to consider for newer form dev.

Thank you very much for your input, especially the flow sheet workaround.

Posted : July 10, 2018 9:02 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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

Powered by wpForo Powered by wpForo version 2.4.0