SQL Query to get list of employees where the Base Plan and roll over target plan balance differs.
Here i have a scenario. Plan A has roll over to the target plan - Plan B. But few cases the balance is not transferring correctly from Plan A to Plan B.
For example on December 31- 2023 , Plan a has 7 balance but only 4 has been transferred to Plan B and the remaining 3 has been forfeitured.
I need a query to list out the effected users who did not get correct balance. Someone please help me in getting the query.
Thanks in advance.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):