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.

StephenAdamsMD

@stephenadamsmd

Forum Home | Recent Posts

Eminent Member

Joined: June 8, 2012 10:49 am

Topics: 1 / Replies: 22

AllTopicsReplies

I have written reports in the past using docdata and haven't seen errors. Can you give more specifics about what you're trying to do? &nb...

8 years ago

Forum

MEL, SQL, Oracle

try this: select distinct person.PID , PERSON.EXTERNALID, PERSON.SEARCHNAME, person.db_updated_date FROM person where not exists...

8 years ago

Forum

MEL, SQL, Oracle

We have psychiatry and forensic child abuse examinations in CEHR using confidential document types. As you noted, the problem and med lists are not co...

8 years ago

Forum

General Discussion

If you are on CEMR, you should try Oracle SQL Developer. It is a free download.

8 years ago

Forum

General Discussion

OOPS my mistake... The command I gave you was for Oracle, and I THINK that CPS is SQL Server. The correct command for SQL server would be: select *...

8 years ago

Forum

MEL, SQL, Oracle

select * from USR where LAST_LOGIN_DATE<SYSDATE-180

8 years ago

Forum

MEL, SQL, Oracle

I'm not sure in CPS, but in CEHR there is a last_login_date in USRINFO. Hope this helps.

8 years ago

Forum

MEL, SQL, Oracle

What about using a CTE instead?

8 years ago

Forum

CPS, C-EMR, PM

Your best bet is to download the data dictionary (you need two versions: the 2005 PDF explains the tables but isn't up to date; the current data dicti...

9 years ago

Forum

CPS, C-EMR, PM

POOLED_RISK_NLA_FRAMINGHAM_TEXT_COMPONENT Sounds like copy/paste didn't work. I've attached the file. SA

9 years ago

Forum

MEL, SQL, Oracle

Good morning With some help from fellow user czelnick's post a couple years ago, I put together a text component that gives the pooled cohort CV ris...

9 years ago

Forum

MEL, SQL, Oracle

We are using the GPRO Web Portal method with a combination of reports and manual abstraction.

9 years ago

Forum

MU, CQR, PQRS, etc.

I like "SQL Queries For Mere Mortals" (bought off Amazon); you'll also need to learn the data dictionary. Take GE specific training if possible. If yo...

9 years ago

Forum

General Discussion

You can find the report definitions here: C:\Program Files (x86)\Centricity EMR 9.2\crwrpts The accuracy of the reports provided by GE...

9 years ago

Forum

General Discussion

RPTOBS is a view, not a table. The table that holds observation values is OBS. Good luck!

9 years ago

Forum

MEL, SQL, Oracle

Page 1 / 2 Next