|
|
|
Posts: 272
Joined: June 2012
|
|
#44033
04/29/2012 11:59 AM
|
Joined: Jan 2006
Posts: 84
Member
|
OP
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,215 Likes: 9
Member
|
|
Member
Joined: Dec 2009
Posts: 1,215 Likes: 9 |
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
|
|
|
|
|
Joined: Sep 2009
Posts: 3,002 Likes: 5
Member
|
|
Member
Joined: Sep 2009
Posts: 3,002 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!
|
|
|
|
1 members (It's me),
158
guests, and
84
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
.png "ACUF Donor I")
