When employee changes companies the leave accrual balance does not move with them

Hi All,

When employees move around from one company to another, their leave accrual balance is not moving to the new company.

Since the leave accrual table uses company as part of the key,  a new row is created, and the accrual starts fresh. 

But logically, if an employee moves from one company to another, we want their balance to carryover.

Has anyone else had this issue, and if so, how was it handled?