*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
-loan id stays the same throughout all loan trans
Historic Loan Rows Anonymization Process
Here are the details of the process that will be followed to replance replace the user_id field on historic loan rows with NULL on Friday, May 9:
...
| Step | Status | |
|---|---|---|
| 1 | As specified in the Metadb documentation, the hosting team will stop the server to prevent it from operating with an out-of-date cache. | |
| 2 | The hosting team will run the 2 anonymization scripts on the loan tables in the Metadb reporting database. | |
| 3 | As specified in the Metadb documentation, the hosting team will restart the server | |
| 4 | The hosting team will inform Sharon when the Steps 2 and 3 are complete. | |
| 5 | Sharon and Joanne will verify that the loan anonymization process has been successful and that normal data synchronization is continuing through test scripts that capture data stamps in loan_id rows. |
Loan Anonymization Scripts
This script replaces the user_id values with NULL in historic loan rows on the loan__ table:
...