social security numbers

For users or potential users.
Post Reply
davidbpresser5756
Posts: 1
Joined: Sat Mar 27, 2021 4:50 pm

social security numbers

Post by davidbpresser5756 » Sat Mar 27, 2021 5:02 pm

Is it possible to delete all patients social security numbers in one report or one command? Insurance ID numbers used to be the patients social security numbers, but that has changed and I do not want to have the liability of keeping social security numbers. It's pretty time consuming to delete them one at a time. If anyone knows the answer, I would appreciate it.

User avatar
Justin Shafer
Posts: 596
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Re: social security numbers

Post by Justin Shafer » Mon Mar 29, 2021 7:55 am

It can be done in a query or just one sql statement.

If nobody helps you with this, I will after a bit.

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: social security numbers

Post by Tom Zaccaria » Mon Mar 29, 2021 8:18 am

Didn't think we could ever delete things in this version of mysql by design. Only hide. And that had to be done by OD central.

drtmz

Post Reply