We're introducing a new Sapling admin workflow to facilitate seamless employee role changes.
The first phase of this workflow will help ensure you update all relevant custom tables and effective dates when a user is promoted/relocated.
Future phases of this feature will include document, email, and task assignments as well.