Hello there,Is there a way to read encrypted data(credit card number) that is stored in t_account_data?
Our box office manager want me to create some sort of script to track transactions associated with certain account types based on the first 6 digit of patrons credit cardIs it possible for me to do this?Thank you very much in advance!Vicky
Without knowing exactly what you're after, this may not work for what your box office manager has in mind, but it seems like it'd be simpler to just reference the account type, which is stored in tr_payment_method.
Thank you for your reply Amanda.
I am looking for Bank Identification Numbers, a six-digit Issuer Identification Number, or the first 6 digits of the credit card account number.
To track those account types, I have to read their credit card numbers. Visa/Mastercard have various account types...
I need to find out whether this account is Golden Card Holder(with annual fee) or a genenral credit card account (no annaul fee)
I hope I made myself clear enough on this if not I will give better detail. ...
Thanks
In that case, you may consider setting up a unique payment method for each of those card types. Then you could track via tr_payment_method as Amanda stated above. Also - most importantly, consider that if you are able to decrypt those numbers you'll be opening up a PCI compliance issue. I think the only way to decrypt it would be to have the encryption algorithm that the Tessitura client uses. The client will decrypt the card # for certain users with appropriate permission, but I don't think that the Tessitura can hand out that encryption code without invalidating the entire application's PCI compliance status. I'll be interested to see how this pans out.
Good luck -
I find an alternative way to work on this: the first 6 digit number of cc_number is not encrypted in T_CC_SERVER_LOG.Maybe I can use this field in my report.Thank you all for your kind help!Vicky