Deleting Old Marketing Efforts

Rick Root
Rick Root
Tenth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud CRM Developer Discussions

Hi!

I'm hoping to delete some old marketing efforts. We have 5,460 entries in the MKTSEGMENTATION table.

Now, I can't delete efforts with revenue because of the foreign key constraint on REVENUE_EXT.MAILINGLISTID

So, in theory, I could wipe out that field on gifts from old marketing efforts that I want to delete, while leaving the SOURCECODE and APPEALID fields intact.

Has anyone done anything like this?

Categories