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.

sahupala

@sahupala

Forum Home | Recent Posts

Active Member

Joined: March 20, 2015 8:45 am

Topics: 0 / Replies: 10

AllTopicsReplies

I can’t say for sure, as I was never been inquired to make any changes to the IDC-10 description. I only replied, based on database management and abi...

5 years ago

Forum

CPS, C-EMR, PM

Good evening, Yes this can be done with an UPDATE statement with a SQL script, using MS SQL Server Studio. Thanks, Dennis

5 years ago

Forum

CPS, C-EMR, PM

53 GB single physician practice

6 years ago

Forum

MEL, SQL, Oracle

mfornkahl, You can change the length of the email column with a SQL script; That if you have access to the SQL Server. If you don't have access yo...

9 years ago

Forum

CPS, C-EMR, PM

You connect from Crystal Report stand alone directly to the SQL server. I create a Stored Proc on the SQL Server and call this Stored Proc to desig...

9 years ago

Forum

CPS, C-EMR, PM

Hi Jessica, If you are able to access a SQL Server, you can run the following Script; select PatientId, pp.Last+', '+First as PatientName, p.Lis...

9 years ago

Forum

General Discussion

try this: SELECT x.code, x.description, x.orderdate FROM (SELECT code, description, orderdate, ROW_NUMBER() OVER (PARTITION BY code ORDER BY orde...

10 years ago

Forum

MEL, SQL, Oracle

SELECT x.patientid, x.visit, x.listname FROM (SELECT pp.patientid, pv.visit, df.listname, ROW_NUMBER() OVER (PARTITION BY pp.patientid ORDER BY pv.v...

10 years ago

Forum

MEL, SQL, Oracle

I would recommend Virtual OfficeWare Healthcare Solutions www.vowhs.com

10 years ago

Forum

General Discussion

Email address can be displayed, but this field need to be added in the SQL script and added in Crystal Reports. Thx, Dennis

10 years ago

Forum

Trading Post