When exporting Prospect > Prospect manager > Is active, the "Active" value is referring to that manager's status as a fundraiser, not the status of their current relationship to the prospect.
In order to determine whether a relationship between a prospect and manager is current, export the following:
Prospect > Prospect manager end date
If this field is blank (or in the future), the fundraiser is the current manager for the related prospect.
Connect and collaborate with fellow Blackbaud users.