Most Recent Posts
Insurance on encounter sheet
by Raj1 - 10/06/2025 10:57 AM
Insurance Not Populating on Orders
by ChrisFNP - 09/12/2025 7:02 AM
find past insurances
by Naeem - 09/11/2025 9:41 AM
Member Spotlight
bmdubu
bmdubu
Tampa
Posts: 34
Joined: August 2010
Newest Members
SmartRX, sne787, Dr. Christine Se, ozonr666, ESMI
4,598 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#44033 04/29/2012 12:59 PM
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.

Joined: Dec 2009
Posts: 1,205
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,205
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
Joined: Sep 2009
Posts: 2,991
Likes: 5
JBS Online Content
Member
Online Content
Member
Joined: Sep 2009
Posts: 2,991
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 (), 106 guests, and 27 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
Naeem 1
Raj1 1
tcosta 1
Top Posters
Bert 12,899
JBS 2,991
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