Check Reconciliation Bank Account Cross Reference Encryption Status

The system includes a data conversion process (AE program DC33195853) that automatically sets the encryption status for the PY_BNKACCT_XREF source record to None or Encrypted, depending on whether data exists in the PAY_CHECK_DUE table or not.

Scenario 1: No Data in PAY_CHECK_DUE

If there isn’t any data in the PAY_CHECK_DUE table at the time the Data Conversion process is run, the process will always set the encryption status of the PY_BNKACCT_XREF source record to None on the Define Source Records Page.

Then during the first run of the Check Reconciliation process (PAY015A.SQR), it adds data in the PY_BNKACCT_XREF source record and updates the encryption status with the same value as the SRC_BANK source record.

If the encryption status of the PY_BNKACCT_XREF source record is not what you expected after the first run of the Check Reconciliation process, you can navigate to the Manage Encryption and Masking Page, select Encrypt (or Decrypt) in the Action field for the PY_BNKACCT_XREF source record to run the encryption process.

Scenario 2: Data Exists in PAY_CHECK_DUE

If data exists in the PAY_CHECK_DUE table at the time the Data Conversion process is run, the process creates a new PY_PAYCHECK_DUE table and generates data in the PY_BNKACCT_XREF source record. The process will automatically default the encryption status for PY_BNKACCT_XFER based on status of SRC_BANK. For example, if SRC_BANK displays Encrypted, PY_BNKACCT_XFER will also display Encrypted.

If the PY_BNKACCT_XFER source record is decrypted (or encrypted again) in the future, the status is set based on the action defined for its row on the Manage Encryption and Masking Page.