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.

jtlewis

@jtlewis

Forum Home | Recent Posts

Eminent Member

Joined: March 8, 2016 2:21 pm

Topics: 3 / Replies: 32

AllTopicsReplies

The workaround presented by Athena is "Rebuild all content (forms, letters, Quick Text) that uses LAST_SIGNED_OBS_VALUE or LASTOBSVALUE."

5 years ago

Forum

MEL, SQL, Oracle

What version of Centricity are you on? There was a known issue at one point where LAST_SIGNED_OBS_VALUE wouldn't return the value. It was in 12.2.

5 years ago

Forum

MEL, SQL, Oracle

I will definitely let you know, we are going to start with an 18 gb allocation (we always error on the side of caution) and see what that does for us.

6 years ago

Forum

General Discussion

Sadly we are already rocking a 9 gb configuration for that. We have approximately 250 active users, but GE's example configurations, even for 1000 use...

6 years ago

Forum

General Discussion

Topic

6 years ago

Forum

General Discussion

Replies: 7

This should do the trick: select * from FLAG where type = 1 and status = 1 and popup = 1 That is a basic query, can easily be expanded.

6 years ago

Forum

CPS, C-EMR, PM

Do you have this case number for this? I would like to follow up with GE on this to get a complete rundown of the issue. We are about to upgrade this ...

6 years ago

Forum

CPS, C-EMR, PM

If you have access to this database, this will pull some information for you. It can be modified to include more: select name as OrganizationName, ...

6 years ago

Forum

General Discussion

I would think it only records when the database is updated. The user viewing an item doesn't modify it. Best way to tell for sure would be to test ...

6 years ago

Forum

General Discussion

Are you looking for the "Orders" table and the column "LOCOFSERVICE"? If not, can you be more specific on what information you are looking for?

6 years ago

Forum

General Discussion

It sounds like you will need to do something like this: 1 visibility region (Intensity of Ideation) with the below code: DOCUMENT.Q1 = "Yes" or DO...

6 years ago

Forum

MEL, SQL, Oracle

I am not experiencing the same issue, you are calculating the sum of the count(*), correct?

6 years ago

Forum

MEL, SQL, Oracle

Definitely can, just need to join the Doctypes table in. select dt.DESCRIPTION as DocType, d.SUMMARY as DocumentSummary, count(*) from DOCUMENT d...

6 years ago

Forum

MEL, SQL, Oracle

The below query should do the trick. This will allow you to pull in any documents containing Cerner within the date range, then also count how much of...

6 years ago

Forum

MEL, SQL, Oracle

You could use this with SQL, I have never bothered to make anything into "nice" formatting with crystal reports, but this will export the data you des...

6 years ago

Forum

CPS, C-EMR, PM

Page 1 / 3 Next