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 »

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: 597
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Re: social security numbers

Post by Justin Shafer »

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: 366
Joined: Mon Feb 25, 2008 3:09 am

Re: social security numbers

Post by Tom Zaccaria »

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