Most Recent Posts
Closing up shop
by dgrauman - 12/12/2025 2:18 PM
Erx slowness
by Raj1 - 12/11/2025 11:12 AM
ACITIC user seat dilemma
by Enio - 12/10/2025 12:35 PM
Citrix
by Enio - 12/10/2025 12:32 PM
Updox replacement?
by ffac - 12/09/2025 12:53 PM
AC Version 12.3
by denvertech - 11/24/2025 12:23 PM
Script
by denvertech - 11/24/2025 12:16 PM
Losing connectivity in Peer-to-Peer networks
by denvertech - 11/24/2025 12:02 PM
Member Spotlight
Ruben
Ruben
Florida
Posts: 141
Joined: February 2014
Newest Members
scfpmd1955, jpark, sara25, SmartRX, sne787
4,601 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#44033 04/29/2012 11:59 AM
Joined: Jan 2006
Posts: 84
Zak Offline OP
Member
OP Offline
Member
Joined: Jan 2006
Posts: 84
A few years ago I had a assistant with terrible typing/spelling skills. This caused a bunch of erroneous data points to be created in the insurance and city fields in the demographics section. Example: City: Ashland spelled as Ashaland, Asland etc. Insurance: Medicare as Medcare ...
I understand that there is no way to delete these data points because they exist in a patient's chart somewhere; but is there a way to search, replace and delete the erroneous entries?
Thank you in advance.

Zak #44034 04/29/2012 12:47 PM
Joined: Dec 2009
Posts: 1,208
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,208
Likes: 8
Why yes there is. Unfortunately, it means going into the database and using SQL commands to do it.

You'll need a professional to do this for you.

JamesNT


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net
Zak #44035 04/29/2012 12:47 PM
Joined: Sep 2009
Posts: 2,999
Likes: 5
JBS Offline
Member
Offline
Member
Joined: Sep 2009
Posts: 2,999
Likes: 5
The process can be laborious if there are a lot of errors, but it is doable.
1. Go to Reports...demographics...city= ... and put in the incorrectly spelled city.
2. Run the report
3. Correct each of the patients demographics by clicking on their name in the report and going to their demos page
4. Restart AC and the incorrect spelling should be deleted from the drop down list IF you have deleted every instance of the error.


Jon
GI
Baltimore

Reduce needless clicks!

Moderated by  ChrisFNP, DocGene, JBS, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 169 guests, and 16 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
Raj1 4
Enio 3
ffac 1
Top Posters
Bert 12,899
JBS 2,999
Wendell365 2,367
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5