Notifications
Clear all
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
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
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
