It would be hard to formulate a one-size-fits-all solution even if you were talking about relatively modern systems. There’s a trade-off between having a manual vs. automated process in the best of circumstances. You might think intuitively that an automated process would be easier and more reliable, but depending on local factors for each of the databases, there might be issues like availability or locking that coul…
This is such a good answer because sometimes a system where people are used to solve the issue is the right way.
And I say 'system' because as long as the company knows that Sally does the updating each day, but if Sally is on holidays or sick or quits, then there is a protocol where the work is done and the checks/balances are done to ensure that that mortgage rate change is done.