Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

StephenAdamsMD

@stephenadamsmd

Forum Home | Recent Posts

Eminent Member

Joined: June 8, 2012 10:49 am

Topics: 1 / Replies: 22

AllTopicsReplies

Reply

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

7 years ago

Forum

MEL, SQL, Oracle

Reply

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

Reply

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

Reply

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

8 years ago

Forum

General Discussion

Reply

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

Reply

select * from USR where LAST_LOGIN_DATE<SYSDATE-180

8 years ago

Forum

MEL, SQL, Oracle

Reply

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

Reply

What about using a CTE instead?

8 years ago

Forum

CPS, C-EMR, PM

Reply

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

Reply

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

Reply

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

Reply

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

9 years ago

Forum

MU, CQR, PQRS, etc.

Reply

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

Reply

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

Reply

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