COMMUNITY HEALTHCARE USER GROUP Forum

Welcome to the NEW Community Healthcare User Group ( the new CHUG)— your ultimate destination for insights and discussions at the intersection of healthcare and technology.

Please scroll to the bottom for “Centricity” related topics from the previous forum.

ronmoses

@ronmoses

Forum Home | Recent Posts

Estimable Member

Joined: November 1, 2013 1:16 pm

Topics: 22 / Replies: 136

AllTopicsReplies

I did a quick redact by simply removing the patient names. Just be aware you'd normally see the names in that empty column. PhoneNoteTimeline

7 years ago

Forum

General Discussion

I think you're pulling in voided transactions. Try filtering on the following... WHERE Voided IS NULL

7 years ago

Forum

MEL, SQL, Oracle

Hi Ted. My involvement with the project ended as soon as we switched over (in fact I left that department entirely to work solely on reporting), so un...

7 years ago

Forum

General Discussion

Oops... I forgot to give you my list-parsing function. You may not need it at all; if you're only reporting on one location, you'll want to remove all...

7 years ago

Forum

General Discussion

Yep! I've attached the report and the stored procedure in a ZIP file. I imagine you'll have to do some tweaking, but hopefully this will give you some...

7 years ago

Forum

General Discussion

I was hoping to leverage those descriptions to find all antibiotics as one big class. Since the application lumps them all together as "Anti-Infective...

7 years ago

Forum

MEL, SQL, Oracle

Yes, I've done a SELECT *, and there's plenty in the table. All the names are in all caps, and none of them correspond to what's displayed in the char...

7 years ago

Forum

MEL, SQL, Oracle

CPS12, and mldefs is referencing that file.

7 years ago

Forum

MEL, SQL, Oracle

I've done a SELECT against that table WHERE TC_NAME = each of those values. The query comes up empty. Those values do not appear in the table.

7 years ago

Forum

MEL, SQL, Oracle

For example, I'm looking at a patient with three meds. The classes displayed in the chart's medication section read "Central Nervous System Drugs" (At...

7 years ago

Forum

MEL, SQL, Oracle

I've reviewed MS_TCRF, and have seen the report based on it, but its descriptions don't match up to what's displayed in the chart.

7 years ago

Forum

MEL, SQL, Oracle

Topic

7 years ago

Forum

MEL, SQL, Oracle

Replies: 15

Just to play devil's advocate... is it wise to allow a patient to enter clinical information into their own chart? Simple demographic changes or notes...

7 years ago

Forum

Patient Self Service

Well this is interesting. It took quite a bit of sleuthing, I must say. If I run this query against the GEMedispan database, using what we'll call the...

8 years ago

Forum

MEL, SQL, Oracle

I thought the same thing, but CQR's QDM data shows it as 309362, clopidogrel 75 MG Oral Tablet. Definitely the same med, the start date is the same, a...

8 years ago

Forum

MEL, SQL, Oracle

Page 1 / 11 Next