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.

jesran

@jesran

Forum Home | Recent Posts

Active Member

Joined: April 23, 2013 2:15 pm

Topics: 1 / Replies: 12

AllTopicsReplies

In Centricity EMR something like: SELECT MEDRECNO FROM PERSON... JOIN INSURANC... JOIN INSURECO WHERE INSURECO.PLANCODE IN ['Medicare, Medica...

6 years ago

Forum

MEL, SQL, Oracle

To view schedule IIs {MEDINFO.CLASSCODE} = "2"

7 years ago

Forum

Trading Post

It's called an "Alias" and it can be created in the Database Expert by adding the same table twice to a report by using the > button. The second ti...

7 years ago

Forum

CPS, C-EMR, PM

Karen, Ask GE for help with their Archive Obs script. This will put an "archived" flag field in the obs table for observations greater than a certa...

8 years ago

Forum

CPS, C-EMR, PM

Topic

8 years ago

Forum

MEL, SQL, Oracle

Replies: 12

Essentially, you need a "commit" button that will combine them into an OBSNOW() function. You've seen how "commit" works on the Risk Factors form w...

9 years ago

Forum

Bugs, Known Issues, Open Cases

Joe, Yes you need to push a new report to all fat-clients. Most user jobs.txt. To find out which Crystal Reports file is linked to which report yo...

10 years ago

Forum

CPS, C-EMR, PM

Also, to test any MEL code quickly you can use personal quicktext before moving it to VFE. In your example we will take bhoover's advice and look at t...

10 years ago

Forum

MEL, SQL, Oracle

Actually, if you have a ? on the form then it is in the Immunizations table already, but you need secondary queries to 1) look at all undetermineds fo...

10 years ago

Forum

CPS, C-EMR, PM

"OUTER JOIN" may be the answer you are looking for. By default all joins are LEFT INNER, I believe. You can change this when you create the ta...

11 years ago

Forum

Trading Post

PID command example: SELECT "DOCUMENT"."PID" FROM (("ML"."DOCUMENT" "DOCUMENT" INNER JOIN "ML"."DOCTYPES" "DOCTYPES" ON "DOCUMENT"."DOCTYPE"="DO...

12 years ago

Forum

Trading Post

Ever consider a command? I typically use a command to view the base population; i.e. diabetics seen by these folks in this time frame. Then I link tha...

12 years ago

Forum

Trading Post

You need to create a formula called something like "Pharmacy" and it needs to contain something like: StringVar pharmacy := ({PRESCRIB.pharmac...

12 years ago

Forum

Trading Post