Notifications
Clear all
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
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
SELECT DISTINCT O.HDID,OH.NAME
FROM OBS O
JOIN OBSHEAD OH ON OH.HDID = O.HDID
Posted : July 19, 2017 7:17 am
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
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
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
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
