JillSnider – 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.

Notifications

Clear all

JillSnider

@jillsnider

Estimable Member

Joined: April 20, 2012 12:06 pm

Topics: 5 / Replies: 105

AllTopicsReplies

select pharmacy, count(*) from PRESCRIB where PHARMACY <> 'null' group by pharmacy order by 2 desc

11 years ago

Forum

MEL, SQL, Oracle

Join the appt to the view erx_activity_rpt (provides the script date) Jill

11 years ago

Forum

MEL, SQL, Oracle

If you are referring to the Care Alerts, they are can be found by the following: select * from flag where contextid1 = PID Is this what you're l...

11 years ago

Forum

CPS, C-EMR, PM

Pardon me - We are not using BCG for TB tests. We are using the PPD form within EMR as mentioned by IKeith.

11 years ago

Forum

CPS, C-EMR, PM

I'm not clinical but understand PPD is for TB. We were told to use BCG and that's where we've set up the TB test. Jill

11 years ago

Forum

CPS, C-EMR, PM

Are you familiar with SQL? You can do it through the database. It's not very complicated. I don't have the command at my fingertips but, if I remem...

11 years ago

Forum

CPS, C-EMR, PM

I also think that if you merge a chart and the meds are in each, they will duplicate. Jill

11 years ago

Forum

Bugs, Known Issues, Open Cases

I'm in SQL Developer almost daily. Great for troubleshooting and queries. Don't forget SnagIT! SnagIT rocks my world. 🙂 This I use SEVERAL time...

11 years ago

Forum

MEL, SQL, Oracle

It's DEFINITELY possible. 🙂 You can put all sorts of logic into Crystal Reports. Any SQL query can be incorporated into a CR. First, you will nee...

11 years ago

Forum

CPS, C-EMR, PM

Yes they do! 🙂 Are you using the Factory Custom List or creating your own for the Immunization form? If you set up your own, you'll want to tie an ...

11 years ago

Forum

CPS, C-EMR, PM

I believe you would want to run once. Keep in mind that the migration tool COPIES the information from the OBS table to the Immunization table. It d...

11 years ago

Forum

CPS, C-EMR, PM

When we had the problem with an SR, this is the SPR # they provided as the fix. Yarg. This has nothing to do with CPS (at least in our case). We ...

12 years ago

Forum

CPS, C-EMR, PM

Incorrect Parameter has another SPR: # 56411

12 years ago

Forum

CPS, C-EMR, PM

I worked with John Christian and Hillary Hart - they should be very familiar. After the SQL command, they also had me reinstall JBoss and Service Lay...

12 years ago

Forum

CPS, C-EMR, PM

If you like, call GE support and you can discuss with them. That is where I got it from.

12 years ago

Forum

CPS, C-EMR, PM

Page 6 / 8 Prev Next

25 Forums
9,996 Topics
40 K Posts
1 Online
6,498 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed