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.

jbarta

@jbarta

Forum Home | Recent Posts

Active Member

Joined: December 15, 2015 4:44 pm

Topics: 1 / Replies: 11

AllTopicsReplies

I have not attempted this type of report before, but I was able to jump in and look at the AUDIT tables in the database and pull a query that might ge...

6 years ago

Forum

CPS, C-EMR, PM

I believe I understand what you are after. I have provided a query below that can possibly help you with this. I use temp tables as you have, but most...

6 years ago

Forum

MEL, SQL, Oracle

Sorry, there were a few mistakes in my query. select * ,m.Description AS AppointmentStatus from Appointments ap inner join PatientProfile pp on ...

6 years ago

Forum

MEL, SQL, Oracle

If I understand your need, it appears you are running the first query to get the patients to run in the second query. I would do something like the qu...

6 years ago

Forum

MEL, SQL, Oracle

I see the logic there, but when I query the value 12 and look up one of the patients in Centricity, it appears that Address 1 and Address 2 changed. B...

6 years ago

Forum

MEL, SQL, Oracle

Thanks for responding. I have the same information plus a small list of what some of the numeric values map to: Numeric bitmap that indicates which...

6 years ago

Forum

MEL, SQL, Oracle

Topic

6 years ago

Forum

MEL, SQL, Oracle

Replies: 5

Did you get this resolved? As DavidShower said I would join to the OBSHEAD table with a join on the HDID and then filter to those rows in the OBSHE...

6 years ago

Forum

MEL, SQL, Oracle

What report is it under the component specific? Can you attach the .rpt file and I can import and troubleshoot?

6 years ago

Forum

CPS, C-EMR, PM

Yes they are written in SSRS SQL 2008r2 and I am in the process of converting them over to a new SQL Server 2016 server. I didn't upgrade my current e...

7 years ago

Forum

General Discussion

It might be worth looking into. Fortunately for me, when I started here at this CHC, we had multiple copies of SQL Server 2008R2. So I was able to spi...

7 years ago

Forum

General Discussion

I am the database analyst at our community health center and we mainly use SQL server report services reporting (SSRS) and SQL server integration serv...

7 years ago

Forum

General Discussion