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.

Notifications

Clear all

A few questions

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

58 Views

RSS

cliffstark

(@cliffstark)

Posts: 194

Reputable Member

Topic starter

Is there a company or SQL script that anyone is aware of that can update our Master Patient Index to make all names, addresses, etc. uppercase?

Is anyone aware of an API button that could be added in GE that would allow us to see documents from another GE database? Or is there an application that could allow us to quickly see the chart documents and such on another database, without having to log in to 2 different CPS sessions?

Is there a company or a workflow that allows for the migration of demographics and A/R from one system to another.

We are looking at merging 2 CPS 10 databases but there are still a lot of questions and things the company we are using doesn't do. Any help or advice would be appreciated.

Posted : November 14, 2013 4:43 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

The uppercase update would be

update tablename set column1 = upper(column1), column2 = upper(column2), etc.

I would definitely test it out before running it against live as there would be no going back without restoring a backup. Leaving off the WHERE clause causes all rows to be updated. You could add a WHERE clause to update just one or a few rows like:

update tablename set column1 = upper(column1), column2 = upper(column2) where column1 = "Joe"

Test, test and retest before doing something like this in Live. Also, this may throw off some spacing in forms, letters, banners and handouts possibly.

Posted : November 19, 2013 3:59 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

cliffstark said:

Is there a company or SQL script that anyone is aware of that can update our Master Patient Index to make all names, addresses, etc. uppercase?

Is anyone aware of an API button that could be added in GE that would allow us to see documents from another GE database? Or is there an application that could allow us to quickly see the chart documents and such on another database, without having to log in to 2 different CPS sessions?

Is there a company or a workflow that allows for the migration of demographics and A/R from one system to another.

We are looking at merging 2 CPS 10 databases but there are still a lot of questions and things the company we are using doesn't do. Any help or advice would be appreciated.

Chris says:

Personally, It's not something I would do. This is presentation layer stuff, not data layer stuff. What is the goal you are trying to achieve?

As a 20+ year database administrator I'd look for another solution and not churn your database unnecessarily.

Chris Mangus

Database Administrator, ArchitraveHealth, Roseburg, Oregon

Posted : November 19, 2013 4:55 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0