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

program to Remove PCP from inactive banners

General Discussion

Last Post by jmazurow 11 years ago

9 Posts

3 Users

0 Reactions

59 Views

RSS

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

I am inquiring about a script, tool, or report that would be used to clear
the PCP or Collaborating provider from inactive banners in Logician. We are not
familiar with any such tool or report. However, we would be interested in such
a tool.

Can you tell me if there is a way to do this ? Because the PCP remains on
the banner when inactivated, it is causing issues with our reporting.

We might be willing to pay for such a tool if it isn't too expensive. Any information would be appreciated. We would like
to prevent having an individual have to enter every single chart ( over 16,000)
and have to manually remove them. Thanks.

John

Faxton St. Lukes Healthcare

[email protected]

Posted : January 31, 2014 5:01 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

I'm not sure what you are asking. Banners can't be inactive. Are you talking about a PCP being associated to an inactive patient?

Posted : February 1, 2014 11:27 pm

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

Yes, we want to be able to remove any PCP assigned to an inactive patient. There are still several thousand inactive patients that have a PCP assigned, and we want to clean them up by removing the PCP from the banner. Thanks.

Posted : February 2, 2014 9:52 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

So, if I understand your request:

1) Read through Person file, and log all that are 'inactive' to file1

2) Read file1, and set responsible-provider to blank

Either as batch (described in 2-steps), or as each person is found do immediately.

I am not aware of any way to do this, but need to ask "why?". Is this to correct issues when you run a panel report of number of patients assigned to each doctor?

Posted : February 2, 2014 10:42 pm

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

Yes. Our admin dept. runs reports for providers and their patients, and the inactives are causing the numbers to be off. We were going to assign the task of manually removing the PCP from the banners to an individual, but there are like 14,000 total that need to be changed. That is why we are looking for a script or program that might do the task. Thanks.

John

Posted : February 2, 2014 10:44 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Are they Crystal Reports you run to determine Panel Size? If so, maybe add the following couple lines:

{PERSON.PSTATUS} = "A" and
{PERSON.ISPATIENT} = "Y"

to make sure the record is for a patient and that the patient is active.

If you are doing as an Inquiry in GE, you can also filter for only Active patients.

Posted : February 2, 2014 11:00 pm

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

Thanks. I will pass that on to the requestor. I believe there was an idea to clean these patients up as well, thus removing the PCP. I appreciate the response !!

Posted : February 2, 2014 11:02 pm

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Two ways to do this. If you have an interface engine like Qvera you can run a sql query like

select * from ml.person where ISPATIENT= 'Y' and PSTATUS in ('I', 'O') and RESPPROVID is not NULL

And then you can use that data and run it through Qvera to create HL7 files to run through LinkLogic to remove the provider. Qvera can help you with this.

Otherwise ,I believe you are going to need to run a SQL query like this:

update ml.person set RESPPROVID = NULL where ISPATIENT= 'Y' and PSTATUS in ('I', 'O')

The query

select * from ml.person where ISPATIENT= 'Y' and PSTATUS in ('I', 'O')

will tell you which patients are going to be updated.

I would also manually remove a Responsible Provider and then run the query on that patient to make sure it is setting that field to NULL

This will set the responsible provider value back to NULL (empty) where the person is a patient and their patient status is set to inactive or obsolete. You want to TEST, TEST, TEST and verify this query before you run it against LIVE data.

And when you are ready to do live data, run it against ONE patient and make sure it is doing what you think it is and not breaking anything else. I make no guarantees and take no responsibility! And GE doesn't like folks manipulating the database directly. And you have no audit train in the EMR to get this done.

Posted : February 3, 2014 12:28 am

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

Thanks for the reply. I will discuss with our interface analysts.

Posted : February 3, 2014 4:48 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