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.

jbaileysemmesmurp

@jbaileysemmesmurp

Forum Home | Recent Posts

Eminent Member

Joined: January 15, 2016 4:36 pm

Topics: 7 / Replies: 18

AllTopicsReplies

That is it indeed!! I didn't even think to look at the alias I had used in the query could be throwing a syntax error in crystal. I love how the si...

4 years ago

Forum

MEL, SQL, Oracle

I posted above..thanks for the reply

4 years ago

Forum

MEL, SQL, Oracle

SET NOCOUNT ON SELECT a.AppointmentsId, convert(varchar,a.ApptStart,101) [Appt Start], isnull(max(o.OBSVALUE),'') [Reschedule?], isnull(max(o1.O...

4 years ago

Forum

MEL, SQL, Oracle

Another note to add here.. SQL records: Crystal records I am able to see the full d...

4 years ago

Forum

MEL, SQL, Oracle

Thanks for the suggestions... Unfortunately, I still receive the same error. It just seems like crystal is not liking the max functions I have in t...

4 years ago

Forum

MEL, SQL, Oracle

Topic

4 years ago

Forum

MEL, SQL, Oracle

Replies: 8

PaymentMethod is the table. If we are talking turnaround for insurance payments... You can use your first filed date from the patient visit table t...

4 years ago

Forum

MEL, SQL, Oracle

I'm guessing the email will be stored in the USR table.. USE DataBasename --(AthenaPractice live database here) GO INSERT INTO dbo.USR(Office36...

4 years ago

Forum

MEL, SQL, Oracle

top 25 dx: SELECT top 25 count(PatientVisitDiags.Code) as Total, PatientVisitDiags.Code AS [DX Code], PatientVisitDiags.Description AS Di...

4 years ago

Forum

MEL, SQL, Oracle

From the PM side... top 25 cpt codes billed during a specified time range and specified location: SELECT top 25 count(pvp.code) as Total, pvp.C...

4 years ago

Forum

MEL, SQL, Oracle

We are experiencing the same issue as well

6 years ago

Forum

Bugs, Known Issues, Open Cases

Topic

8 years ago

Forum

MEL, SQL, Oracle

Replies: 1

Topic

8 years ago

Forum

CPS, C-EMR, PM

Replies: 1

Right.. that's what we will doing as well. We won't be overwriting any previous data, we will just be adding the "secmsg" to flowsheets of charts that...

8 years ago

Forum

General Discussion

Yea, we received the script to run the report of Linked & Unlinked accounts. We will be removing all unlinked accounts that are not current... unf...

8 years ago

Forum

General Discussion

Page 1 / 2 Next