Encrypt SSN and Credit Card #

For users or potential users.
Locked
User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Encrypt SSN and Credit Card #

Post by jordansparks » Tue Oct 30, 2007 10:14 pm

Copied from another thread posted by Yorek:
with identity theft making the headlines almost every day,
Are there any plans to encrypt patients' Social Security and Credit card #'s?

No matter how hard we try, laptops get stolen, USB drives get lost and we even hire a bad person unknowingly.

I try not to think of the implications but if the worst happens..
We'd have to send out letters to all our patients telling them we goofed,
their id's are at risk and now we'd like to pay for 1year of subscription to one of those Credit agencies. Ugh.

Is it possible to require a password to allow
full access to: enter, view or change the entire numbers.
(encryption in the actual data base if feasible)

Once entered, only ******* and the last 3 or 4 digits can be seen for verification.
(internal office policies already 'persuade' users not to leave their active workstations un-attended).

It would save an incredible amount of money, time and anxiety if this info should ever become compromised.

I'm sure there are many ways to do it and your already keenly aware of the huge amount of programing needed.
But I just thought I ask.
Last edited by jordansparks on Wed Oct 31, 2007 7:48 am, edited 1 time in total.
Jordan Sparks, DMD
http://www.opendental.com

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks » Tue Oct 30, 2007 10:50 pm

The programming isn't too hard. A simple symmetric encryption strategy would make those numbers unreadable in the database. And the current security framework would prevent unauthorized access. We would probably also have to encrypt insurance subscriber id's because those are frequently the same as SSNs.

So yes, I'll put this on the planned features list. The programming strategy is more clear than it was in the past.
Jordan Sparks, DMD
http://www.opendental.com

sparkly
Posts: 149
Joined: Tue Jun 26, 2007 8:13 pm
Location: IL

Post by sparkly » Wed Oct 31, 2007 6:42 am

yorek, that's a really good suggestion!! and it's fabulous to hear that this may be relatively easily programmed in.

sparkly
Posts: 149
Joined: Tue Jun 26, 2007 8:13 pm
Location: IL

Post by sparkly » Wed Oct 31, 2007 6:44 am

yorek, that's a really good suggestion!! and it's fabulous to hear that this may be relatively easily programmed in.

User avatar
steveng
Posts: 49
Joined: Mon Jun 18, 2007 7:41 pm
Location: New York

Post by steveng » Wed Oct 31, 2007 11:32 am

Once entered, only ******* and the last 3 or 4 digits can be seen for verification.

How do you get the information to call Insurance for eligibility?

This has to be controlled somehow.
Thanks,
Steven G.

sparkly
Posts: 149
Joined: Tue Jun 26, 2007 8:13 pm
Location: IL

Post by sparkly » Wed Oct 31, 2007 12:39 pm

steveng wrote:Once entered, only ******* and the last 3 or 4 digits can be seen for verification.

How do you get the information to call Insurance for eligibility?
that's what the password would be for. or maybe it could be set up as a right in the login? or it could be one of those short-acting passwords where you input the password and it lets you see the info for 10 min and then it logs itself out...like session in-activites on bank sites for example. would any of that be convenient to program in AND be staff friendly (and un-obnoxious)?

Yorek
Posts: 52
Joined: Wed Sep 19, 2007 6:38 pm

Post by Yorek » Wed Oct 31, 2007 5:06 pm

I'm glad this topic was received so favorably.

My thoughts were.. clearance would be given with the "permitted user's" log on (ie password).
A time-out could be set up individually by each office in administrators' preferences.

Lot's of cool ways and things to do with this.
It's up to Doc S.

I can't help but think, If the other expensive dinosaur software Co's don't have this yet,,
Open Dental would be the 1st,
Leading the way for this pretty important issue
And setting the bar higher for excellence.


Implications for SALES could be significant.
You could add this as another line on to one of those comparison charts of OD vs Them.

(I can see the sweat starting to form on their worried faces!)


PS
It'd be a good idea for the medical Hx's and scanned documents to be encrypted as well,
since they have the same information we're talking about.

Thanks Again.

User avatar
wjstarck
Posts: 936
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Post by wjstarck » Wed Oct 31, 2007 6:59 pm

Any serious discussion along this vein should take into consideration the PCI Data Security Standard:

https://www.pcisecuritystandards.org/tech/index.htm

AFAIK, *any* merchant that accepts credit cards needs to be in compliance with the standards, or risk hefty fines by Visa et al. should a breach occur.

Would they go after a dental office?...dunno
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

sparkly
Posts: 149
Joined: Tue Jun 26, 2007 8:13 pm
Location: IL

Post by sparkly » Wed Oct 31, 2007 8:23 pm

Yorek wrote:I can't help but think, If the other expensive dinosaur software Co's don't have this yet, Open Dental would be the 1st, Leading the way for this pretty important issue And setting the bar higher for excellence.
hey, yeah!

Yorek
Posts: 52
Joined: Wed Sep 19, 2007 6:38 pm

Post by Yorek » Thu Nov 01, 2007 7:07 pm

Except for maybe the last 4 digits of a credit card, (which is needed to tell a patient their card is no longer is active), the only employee needing access to private data is the insurance person once the info is entered into the system.

So these are always "locked up."

Occationally someone other than the insurance person may have to get access to the SS# or other secured id.

A nice touch would be an small "combination-lock" next to what ever item or folder that is partially viewable, hidden or encrypted.

Seeing the lock is logical way to say, hey this is encrypted and.. intuitively clicking on it would open a pop-up box for the password and give one time view of the data.


Sounds like the development team has this one under control.

User avatar
wjstarck
Posts: 936
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Post by wjstarck » Thu Nov 01, 2007 9:01 pm

More food for thought:

VISA Fined TJX Processor for Security Breach
By Evan Schuman
October 28, 2007

Court documents disclose that Visa fined TJX's card processor $880,000 because of massive data security violations.

http://www.eweek.com/article2/0,1895,2208563,00.asp
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks » Thu Nov 01, 2007 9:20 pm

Since 9 million records were stolen, that works out to about a fine of 10 cents per record. So maybe the risk to a dental office with 5000 patients is something like $500 plus lots of bad publicity. This is a little bit tongue in cheek. I am well aware that the risk doesn't necessarily scale like that.
Jordan Sparks, DMD
http://www.opendental.com

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: Encrypt SSN and Credit Card #

Post by enamelrod » Fri Jul 03, 2009 5:18 am

Is this another item we need to vote for? and is it viable to ask for the ability to add security so only certain persons can see the info such as cc info and ss?

richardwaite
Posts: 57
Joined: Thu Nov 15, 2007 6:51 am

Re: Encrypt SSN and Credit Card #

Post by richardwaite » Tue Jul 07, 2009 11:59 pm

Is there any reason why *all* personally identifiable information (PII) could not be encrypted in the database? This would be more secure as the raw database would be useless without decrypting the PII (you could only see an encrypted "blob" representing the PII of a patient and treatment data which would be meaningless without context). I'd appreciate any input on the matter as this is something I have been thinking about for a long time.

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Thu Jul 09, 2009 5:24 am

There's not really any reason why that couldn't be done other than limitations on our time. Vote for that feature request.
Jordan Sparks, DMD
http://www.opendental.com

Yorek
Posts: 52
Joined: Wed Sep 19, 2007 6:38 pm

Re: Encrypt SSN and Credit Card #

Post by Yorek » Tue Jul 14, 2009 7:33 am

Can we please include scanned documents on this 'voted' feature.

It'd be easier to know the entire program is 'bullet proof' secure from the 'factory'
and not have to resort to manually encrypting the files ourselves.

I'm not that geekish and don't want to leave the front door open by 'accident'!
(I was never any good at tuning my '67 Chevy either)

Keep up the great work.
Thanks

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Thu Jul 16, 2009 9:08 am

That's totally different. Turning on folder encryption in Windows is really really easy. Yes, we should add instructions in our manual.
Jordan Sparks, DMD
http://www.opendental.com

Yorek
Posts: 52
Joined: Wed Sep 19, 2007 6:38 pm

Re: Encrypt SSN and Credit Card #

Post by Yorek » Wed Jul 22, 2009 6:29 pm

So as I said, I was no Geek. (no insult meant).

Here's what I did to try to encrypt a 'test' folder in my doc's
It didn't seem to work..

Clicking sequences..
-----------------------------------
Right clicked the 'Test' folder
Selected..
sharing and security
general tab
Advanced
encrypt
Apply..
Choose..
>Option to select
this folder or all subfolders (I chose all)
Apply
turn on 'Folder Tasks'
turns folder and all subfiles green

Result..
NO password and
The 'Test' folder and it's files opens normally
No security apparent.
-----------------------------
So can anyone give the coorect sequence to securing the image folder using Windows?
and does it have to done manually every day morning and end of day?
Or can this be automated with openning and signing into Open Dental?

Many thanks.

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Wed Jul 22, 2009 8:54 pm

The encryption is only not apparent because you're accessing it through Windows. Just set up password to prevent a thief from stealing your computer and getting in to Windows. If they take the hard drive out, the encryption that you just turned on prevents them from accessing those files. So you did it just right.
Jordan Sparks, DMD
http://www.opendental.com

DrK
Posts: 8
Joined: Thu Sep 27, 2007 11:15 am

Re: Encrypt SSN and Credit Card #

Post by DrK » Thu Jul 23, 2009 12:27 am

SO can we use this method to encrypt the database folder?
does this affect backup & restore?
what if we have to restore to a new computer.

Thank you
Sarkis Keshishyan, D.D.S.

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Thu Jul 23, 2009 7:00 am

Yes, this is how you encrypt the database folder as well. Backups will not be encrypted unless you use an encrypted folder for them on the backup media. And I don't know what happens when you take that backup media to a different computer. We'll have to do some research.
Jordan Sparks, DMD
http://www.opendental.com

chrishilldmd
Posts: 6
Joined: Tue Jul 07, 2009 7:35 pm

Re: Encrypt SSN and Credit Card #

Post by chrishilldmd » Thu Jul 23, 2009 7:00 pm

I noticed that in the modules section, there is a box that you can check under Accounting that allows for storing Credit Card numbers, but I am not sure how or where it saves. Does anyone have any idea. i would like to save the numbers in a secured location. Right now, we have patients right there number on our consent form, scan it into images and then shred the documents.

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Thu Jul 23, 2009 10:02 pm

You are not actually supposed to retain a customer's credit card number. You're supposed to use it once and then completely destroy it. For recurrent use, you are supposed to use specialized software designed for that purpose. And in that case, no staff person would actually be able to retrieve the number, only the software. Those rules mostly apply to large retail establishments for obvious reasons. But the rules are changing and are more and more aimed at smaller businesses. So that's why we say it's not secure. You shouldn't really even be scanning them and saving the scan. But it is a bit of a gray area.
Jordan Sparks, DMD
http://www.opendental.com

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: Encrypt SSN and Credit Card #

Post by enamelrod » Sat Sep 12, 2009 8:02 pm

IS xcharge the only company that od integrates with?


I am looking for more features such as auto cc charges on a payment plan
check proceessing?

i have seen other cc processing company offereing these services. Is it an xcharge issue or OD?

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Sun Sep 13, 2009 8:50 am

I think Xcharge now offers repeating charges, but we haven't built an interface for that feature. We are open to integration with other companies, but haven't had any serious problems with xcharge so far. For example, an obvious CC company to look into would be the one run by Claim Connect.
Jordan Sparks, DMD
http://www.opendental.com

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: Encrypt SSN and Credit Card #

Post by enamelrod » Wed Sep 16, 2009 3:34 pm

so im sure your going to say put in a request..but we are in need of check processing and a payment plan that uses repeating cc charges

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Wed Sep 16, 2009 4:47 pm

Yup, sorry. You know, cc processing doesn't have to be totally integrated. You can set up repeating charges in a separate external cc program.
Jordan Sparks, DMD
http://www.opendental.com

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: Encrypt SSN and Credit Card #

Post by enamelrod » Mon Sep 28, 2009 5:06 pm

so you saying add another cc processing company xcharge says they can do it but they have to talk to you?

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

Re: Encrypt SSN and Credit Card #

Post by Justin Shafer » Mon Jun 25, 2012 8:46 am

Couldn't the SSN be read with the source? How would this work? Have the SSN's created around a certificate or password of some sort?

User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Encrypt SSN and Credit Card #

Post by jordansparks » Mon Jun 25, 2012 4:38 pm

This thread is just too old to be relevant anymore. I'm going to lock it. If you want to discuss this, the Advanced forum might be a better place.
Jordan Sparks, DMD
http://www.opendental.com

Locked