Customer ID and Name Change History

Gentle note about those who have SOX requirements, knowing who entered a record, with what values, and when is kind a big deal - at least with the auditors I have run into. It demonstrates control. If someone can add a record and delete it without some audit log then the auditor deems you’re not in control of your process.

For situations like SOX, the ChgLog is not an audit log. These types of logs are best placed in an immutable place, which means outside the database. Change Data Capture (CDC) will probably be a better alternative for these types of audit requirements.