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

In Process and Admin hold orders by Location

Trading Post

Last Post by rwilliams 11 years ago

11 Posts

5 Users

0 Reactions

71 Views

RSS

sgilkey

(@sgilkey)

Posts: 64

Estimable Member

Topic starter

Hi, we are looking for a report to show Referal and Test orders by location rather than by provider. We have providers that go to multiple locations. Currently, orders tracking reports show all the orders that are not Complete rather than those monitored by the individual site. Any thoughts or help would be appreicated!

Posted : April 26, 2013 12:31 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

sgilkey said:

Hi, we are looking for a report to show Referal and Test orders by location rather than by provider. We have providers that go to multiple locations. Currently, orders tracking reports show all the orders that are not Complete rather than those monitored by the individual site. Any thoughts or help would be appreicated!

Did you ever receive?

Posted : September 18, 2013 1:42 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

CPS or Oracle?

Posted : September 18, 2013 2:25 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Oracle

Posted : September 18, 2013 2:47 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Some with summary crosstabs only, some designed to show details equivalent to the Order Req. Intended to be run both by end-users/managers out of the EMR>Reports tab. Easy enough to switch between Referrals or Tests one one report via a parameter or limit to specific service provider.

Basically, these are all slices of the same data, which have morphed over time for different uses. Various things may be suppressed (for example, pulling in scanned Chart documents after the Order was placed). Biggest thing I haven't added but have been asked for is a prompt by Dx.

Orders_ReferralsAdminHoldInProcess_Aging_ALL

Orders_TestInProcess_Aging_ALL

OrdersReferrals-ActiveStatus_ALL_PickPractice

OrdersReferrals-ActiveStatus_ALL_PickPractice_EXPORT

I'm never sure if these links work, so feel free to contact me…

[email protected]

Posted : September 18, 2013 6:24 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

THANK YOU! But these will only download as text (.txt).

Would these happen to have the information on it that would list, (or was put down at order time) the Service Provider if it was not the authorising user?

Posted : September 18, 2013 6:38 am

sgilkey

(@sgilkey)

Posts: 64

Estimable Member

Topic starter

We use CPS so this would probably not work for us.

Posted : September 18, 2013 6:51 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Hmmm, the hyperlinks should save as *.rpt (I just tested from home). Service Provider is in the report.

The main problem with Crystal cross-tabs for Orders is that there are way too many good things you can compare; the Export is there just to dump data to an easier to use Excel pivot-table.

Posted : September 18, 2013 10:53 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I created an orders report last week before I read this but I ended up having to do it by provider because it does not look like a location is specified in the order. I looked in the database tables and I do not see a column for location anywhere either. In the CPS database doc there is a field in the order table called locofservice which does not exist in EMR but, based on the description, it does not seem like what I was looking for anyway.

Posted : November 19, 2013 7:16 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

you have authorizaing provider in the order. link to userinfo. link userinfo.location??? to locreg to get the location.

Posted : November 19, 2013 11:07 pm

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

jjordet said:

you have authorizaing provider in the order. link to userinfo. link userinfo.location??? to locreg to get the location.

To clarify your statement, you would link orders.authbyuserid to usr and then grab the homelocation field from usr and link it to locreg. The problem with doing it this way is that the OP (and us) have providers that travel to multiple locations. Home location is not necessarily the location the order was created. The location the order was created in is not captured with the order at all.

I was just about to submit this saying I did not think it could be done, then I figured it out. If you Link Orders.SDID to Document.SDID and then link Document.LOCOFCARE to LOCREG.LOCID you can pull up the location (locreg.name) for the order.

Posted : November 20, 2013 1:48 am

Share:

24 Forums
9,942 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

Powered by wpForo Powered by wpForo version 2.4.0