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

OBS term report

General Discussion

Last Post by jfitzmd 7 years ago

7 Posts

7 Users

0 Reactions

67 Views

RSS

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Is there some kind of report that I can run that would tell me all OBS terms that have ever been used in our EMR?? It would certainly come in handy when building new forms.

Posted : July 19, 2017 7:05 am

jtlewis

(@jtlewis)

Posts: 35

Eminent Member

This should do the trick. It will give you the name, description, and total amount used. Just run this against your database.

select oh.NAME, oh.DESCRIPTION, COUNT(o.OBSID) Total from OBS o
INNER JOIN OBSHEAD oh ON o.HDID = oh.HDID
GROUP BY oh.NAME, oh.DESCRIPTION ORDER BY Total desc

Posted : July 19, 2017 7:16 am

rfisher

(@rfisher)

Posts: 126

Estimable Member

SELECT DISTINCT O.HDID,OH.NAME

FROM OBS O

JOIN OBSHEAD OH ON OH.HDID = O.HDID

Posted : July 19, 2017 7:17 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Another way is select * from obshead where active = 'A'. This field's definition from the data dictionary:

"A single character that indicates if the term is active. This column contains "I" if the term is inactive and no content has requested it.
The application queries only for active terms when documenting a patient visit. When designing content, all terms may be requested.
A = Active; active term that has been used when documenting patient visits.
I = Inactive; no clinical content has requested this term "

Posted : July 19, 2017 9:37 am

burnsh

(@burnsh)

Posts: 155

Estimable Member

Another way is to use Chart Reports, select the obs term you are thinking of, select a timeframe (maybe the last year) and then choose "is not blank." This is my workaround - probably not as complete as the solutions above, but it seems to work. I'd love any feedback if folks think this is a risky way to do it.

Posted : July 23, 2017 5:54 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I run the attached Crystal Report every couple months. (Exporting to Excel)

It includes all codes available, as well as columns to indicate # of times a code has been used and the most recent date the code was used. I find this layout helpful when building forms and reports.

I usually try to run it on a weekend - when it will not interfere with normal clinic operations.

Posted : July 24, 2017 12:45 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I have a report summarizing all obs terms and frequencies. Please contact me if you are interested in it.

Posted : August 1, 2017 3:24 am

Share:

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