Deleted roles or Roles removed from User Security control are not getting fetched

We have added the project roles to user say for example - Project manager, contract administrator etc and we are fetching the BIP report for the users which showcases the assigned roles for the user at security console level. when we delete or remove the role from the user at security console and run the BIP report, the deleted/removed role details are not getting fetched in BIP report output. we would like to know where we can see or find the deleted or removed roles for the users. Lets us know which table and column will be affected at the