Viewing decrypted data once NACHA framework is implemented
We are starting to encrypt records using the NACHA framework - the first record being VNDR_BANK_ACCT.
We feel that there may be a need at some point to be able to run back-end queries of the data where the account number is not encrypted. Has anybody considered this and thought of an approach for taking encrypted tables (not just VNDR_BANK_ACCT, but any of the records that may be configured in the Encryption Framework) and creating some type of "shadow" record that allows for querying of the unencrypted data without having to decrypt the source table?
I'm thinking of some process that