Reports for Patient Flow Board and Drug Screening

teryhill wrote on Friday, May 29, 2015:

We are getting very close to completing Patient Flow Board ( almost ready for a community code review) , so I am working on the next step. Reports, so far my thinking is to configure filter elements that allow the following information to be reported.

Patient Flow Board Reports.

Report showing total time by visit type in a selected time period. Useful for setting appointment slot duration.

Report showing total time by status code in a selected time period. Just to see if there are any bottle necks.

Report showing flow for a selected patient in a selected time period. When the patient calls and says I spent 2 hours waiting to see the Doctor.

Drug Screen Reports.

Report showing patients selected / completed for a selected time period.

Report showing number of times a specific patient was selected / screened for a selected period.

I would like some feedback on this.

Thanks

Terry

1 Like

bradymiller wrote on Friday, May 29, 2015:

As an aside, see here for Terry’s most recent Patient Flow Board code. This thing is pretty awesome and look forward to the reports:
https://sourceforge.net/p/openemr/discussion/202506/thread/f702bb01

-brady

robertovasquez wrote on Friday, May 29, 2015:

very useful tool. A Demo will help.

teryhill wrote on Sunday, May 31, 2015:

Chugging thru the reports. Screen shots of the drug screen reports.

Terry

teryhill wrote on Wednesday, June 03, 2015:

report is on the demo. under reports->visits

Terry

teryhill wrote on Thursday, June 04, 2015:

Any thoughts on the report.

What needs to be added to the report?

Is there enough flexibility in the report?

I am pretty much at the end of this project till I get some more feedback.

Thanks to all those that contributed , Suggestions , criticism , Help , Encouragement , Knowledge and Code.

Terry

mdsupport wrote on Friday, June 05, 2015:

On a separate note, what happens if recording of patient check out or worse, patient going to an exam room, is missed? Catch-22, do we allow corrections or entry of past events?

teryhill wrote on Friday, June 05, 2015:

Enhancement request 8^)

Do you really think people are going to use this?

Terry

tmccormi wrote on Friday, June 05, 2015:

Frankly I’m unclear what it’s for. Did I miss the explanation? What kind of practices would use it and how does it relate to the ‘flow board’?

–Tony

teryhill wrote on Friday, June 05, 2015:

What’s what for?

tmccormi wrote on Friday, June 05, 2015:

THe Drug Test report thingy …

Tony McCormick, CTO

Support: 866-735-0897, Direct: 713-574-6709
My Calendar: http://bit.ly/XznvDo
… we have to slow down a bit to be able to speed up a lot… (me)

On Thu, Jun 4, 2015 at 5:56 PM, Terry Hill teryhill@users.sf.net wrote:

What’s what for?

Reports for Patient Flow Board and Drug Screening
https://sourceforge.net/p/openemr/discussion/202506/thread/0d3797e3/?limit=25#188b

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net

–
Please be aware that e-mail communication can be intercepted in
transmission or misdirected. Please consider communicating any sensitive
information by telephone. The information contained in this message may be
privileged and confidential. If you are NOT the intended recipient, please
notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and
destroy this message.

teryhill wrote on Friday, June 05, 2015:

Oh that thingy. It is used by anestheologist (spelling error). But there are other portions of the report for the flow board. The drug screen stuff can be turned off in globals.

Terry

Sent from my iPhone

On Jun 4, 2015, at 10:58 PM, Tony McCormick tmccormi@users.sf.net wrote:

THe Drug Test report thingy …

Tony McCormick, CTO
www.mi-squared.com
Support: 866-735-0897, Direct: 713-574-6709
My Calendar: http://bit.ly/XznvDo
… we have to slow down a bit to be able to speed up a lot… (me)

On Thu, Jun 4, 2015 at 5:56 PM, Terry Hill teryhill@users.sf.net wrote:

What’s what for?

Reports for Patient Flow Board and Drug Screening
https://sourceforge.net/p/openemr/discussion/202506/thread/0d3797e3/?limit=25#188b

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net

–
Please be aware that e-mail communication can be intercepted in
transmission or misdirected. Please consider communicating any sensitive
information by telephone. The information contained in this message may be
privileged and confidential. If you are NOT the intended recipient, please
notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and
destroy this message.


Reports for Patient Flow Board and Drug Screening


Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/openemr/discussion/202506/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

bradymiller wrote on Friday, June 05, 2015:

Hi,

The random drug test feature is a pretty neat feature, but is specific for certain clinics (pain, mental health and other social type clinics). In globals, can turn it on (it is off by default) and can set the percentage of encounters to test in globals. Then when a patient checks in, the randomization is done. There is also definitely room for expansion of the code(for example, if wanted to support only certain groups of patients undergoing the randomized drug test).

Having this feature was discussed in following thread by Sherwin, and Terry then added it to the patient board since it fits in nicely with it:
https://sourceforge.net/p/openemr/discussion/202506/thread/c816c6f0/

-brady
OpenEMR

bradymiller wrote on Friday, June 05, 2015:

Hi,

On the report, noted the bug that if click Status for ordering, the entries all disappear and then breaks when try to click on another item for ordering.

Would be better to throw out the standard patient selector popup when click on the Patient ID field, which could then populate the Patient ID with selected patient.

Would be nice to have a “details” toggle, which basically then would list out every element in patient_tracker_elements for each tracker entry with a time at each status(note some times may be long, such as None and Reminder Given so may want to incorporate showing hours or days in those when minutes is over a certain amount).

-brady
OpenEMR

bradymiller wrote on Friday, June 05, 2015:

Also when doing the details report, would highlight the rows of check in and check out statuses to allow user to get quick idea of issues with flow when look at the report.

-brady

teryhill wrote on Friday, June 05, 2015:

Bug Squashed. Patient Name search added. Details toggle in place ,still some coding to do to make it functional.

teryhill wrote on Monday, June 08, 2015:

The latest changes to the report are on the demo site http://demo.open-emr.org:2105/openemr .

Comments , Thoughts .

Thanks
Terry

mdsupport wrote on Monday, June 08, 2015:

  1. It may be good to offer an option to display times rounded up to the minute rather than seconds.
  2. Although there is value in tracking interval between check-out and billing, inclusion of billing distorts values for patient flow measurements for most practices - in real life you would be including intervals lasting minutes versus other intervals where days or week(s) are normal. So it may be better to offer a choice to run report(s) between two statuses - e.g. check-in to check-out, check-in to ‘in exam room’, ‘in exam room’ start to end, check-out to billed etc…

Broadly, since this is a new feature, it may be good to have a short note somewhere explaining the background or one of the ways a ‘typical openEMR practice’ could incorporate this feature in their existing workflow - specifically what actions did the developer/original sponsor expect to be performed and by whom - e.g

  1. front clerk updates appointment status to ‘Checked In’ when patient signs in.
  2. When clinician selects the next patient for measurement of vitals, the clinician should update flow board record.
    …
    It would be great if some thoughts about the recommended uses of this reports are included as well.

At a later point we would try to enhance current design for user specific reporting - our workflows involve multiple users - e.g. events are : patient enters exam room, a nurse joins, a doctor joins, the doctor leaves, nurse leaves, patient leaves. In that scenario, the report will need to consider the users and/or roles as well.

Thank you for making this feature a complete package.

teryhill wrote on Monday, June 08, 2015:

Thanks for the feed back, The seconds can be turned off easily by just flipping a flag from true to false in the code. I could incorporate a global to do that or just turn it off till someone needed to see the seconds.

Selecting the status to show the interval between is on my list for the future. currently the “Complete Visit” under status is “check in” to “check out” (will most likely need some refinement). The foundation for the specific user is there and should not take much to bring it out.

My concern is will this be useful feature to the community or was it just a learning project for me.

It came about because I was asked if it could be done, don’t have any one that is actively using it, and the person that asked if it could has not seen it since the end of April.

Terry

bradymiller wrote on Wednesday, June 10, 2015:

Hi,

I just committed Terry’s work to the official codebase. Thank you for the awesome contribution!

-brady
OpenEMR