Decrypt Private Info

This option is used to decrypt information that is encrypted in the database. For example, you may need to use this feature for testing (to compare pre-encryption and post-encryption data), exporting data (e.g., to move carrier tax information from Circulation to an external AR system), or when changing encryption methods (e.g., going from FFW to GPG).

To decrypt private subscriber and account information:

1. In character Circulation, select Decrypt Private Info from the Setup | System | Security menu.
2. Select Add and enter decryption information in the fields described in the table below.

   Field

   Type

   What to enter

   ALL TABLES

   yes/no

   Indicate whether data should be decrypted in all tables. Set this to “n” if you only wish to decrypt certain tables.

   TABLE

   predefined

   If All Tables is set to “n”, indicate the table that should be decrypted. The choices are: AutoRenewSubscription, AutoRenewTran, Carrier, CashTransaction, SubscriptionPayment and SubscriptionRefund.

   RESTORE DATA

   yes/no

   Indicate whether data should be decrypted in the database. If you just wish to export encrypted information in an unencrypted format, set this field to “n”.

   EXPORT DATA

   yes/no

   Indicate whether data should be exported to an ASCII file once it is decrypted (it will be exported in an unencrypted form).

   EXPORT TO

   open (50)

   If Export Data is set to “y”, enter the directory to which the data will be exported. The default is /dti/exchange/cm/secure. Each table will be exported to a separate file. The file names will be the same as the encryption file names, only the file extension will be “dec”. Only private information (credit card number, social security number, etc.) will be exported.

3. Select Continue to decrypt the data. The encrypted information will be removed from the database, and the original fields will be unmasked.