Notifications
Clear all
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.
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.
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.
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
Posted : January 31, 2014 5:01 am
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
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
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
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
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
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
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
Topic starter
Thanks for the reply. I will discuss with our interface analysts.
Posted : February 3, 2014 4:48 am
