Changing constituents code/ how it affects reporting

I can't imagine making this change not having a large impact on the reports you run.  How could it not?  Generally speaking, constituency is probably one of the more reported criteria out there.  Not only will you be removing codes, but you will potentially be changing consitiuents' primary code, which is by default the gift constituency.  But it needs to be done.  Have a plan for all of your constituency codes, and how they are going to be removed/replaced.  


The impact will be determined by how you run your mailings, reports, etc.  As far as VSE goes, I would imagine you're using constituency for these (In theory, you could use gift constituency, but they pull from the same table so...).  


It also sounds like you are using your database for two different distinct organizations.  That sounds like a bit of trouble.  In your hierarchy of codes, do you have a set or codes for the foundation, and a set for the institution?  Regardless, I would hope that making mailing and reporting easier/more accurate is the reason for you cleaning up these codes.

If you are going to clean up constituent codes, then you have to figure you should also clean up gift constituent codes to shadow the changes.  It can get tricky since primary constituent code in school settings often change throughout lifetime, so some gift constituent codes maybe one thing during a period of time and then change to something else and you have to take that into account when changing.  Or -- you just have to document and know that reporting is going to be funky prior to the year/date you do the clean up.  Even though it feels like a hassle at the time, I have always fixed the gift constituent codes because I'm a stickler for consistency.