ronmoses – Activity – 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

Genericmed and RxNorm code are two very different things.

8 years ago

Forum

MEL, SQL, Oracle

Topic

8 years ago

Forum

MEL, SQL, Oracle

Replies: 7

Unfortunately even this table is sketchy. For example, the DDID value for Advair Diskus is 150990. Look that up in DDID_RXNORM and you'll find three R...

8 years ago

Forum

CPS, C-EMR, PM

I agree with @carlosjr... a table join would be the proper way to achieve this. If you're in CPS, you'd link on PROBLEM.ICD10MasterDiagnosisID > Ma...

8 years ago

Forum

MEL, SQL, Oracle

I created a system for just this purpose, involving a stored procedure that populates a custom table on an hourly basis, a computed column in the Pati...

8 years ago

Forum

General Discussion

You can do it as a component-specific report out of Registration. The report itself would be pretty simple, though I'd need to tinker with how to set ...

8 years ago

Forum

CPS, C-EMR, PM

There are many appropriate uses of cloud storage. Critical healthcare information is not one of them. Just remember folks... there is no cloud. It's j...

8 years ago

Forum

General Discussion

We're a CPS shop, but we did transition very recently from Dragon to M*Modal. Overall, it was about as smooth a transition as you could ask for. There...

8 years ago

Forum

General Discussion

Third for Clinically Speaking. We recently dropped Dragon in favor of M*Modal (a vast improvement), but while we were on Dragon Clinically Speaking wa...

8 years ago

Forum

Trading Post

Again, I'm on CPS and I don't know if the table structure for EMR will match, so I'm going to start with a rough sketch of the query and hope that get...

8 years ago

Forum

Trading Post

For the activity data, you're looking in the ActivityLog table for records where TableName = 'Appointments' and Value2 = 'Arrived' or 'Completed'. Rec...

8 years ago

Forum

Trading Post

I'm happy to share it, but it's based on a stored procedure and there are a few things in there that are kinda specific to how we do business. Also, t...

8 years ago

Forum

Trading Post

Since we're on CPS I'm not sure I could create a report for you that would work. But I could probably get you going in the right direction. My first q...

8 years ago

Forum

Trading Post

We use the ActivityLog table, and look for the events "Arrived" and "Completed" for the appointment. Here's my blog post on the subject:

8 years ago

Forum

Trading Post

That's the table we use, so I think you're on the right track. My first thought is to be sure you're doing a LEFT JOIN to the USR_CredentialedStates t...

8 years ago

Forum

Trading Post

Page 2 / 11 Prev Next