Assigned Solicitor enter multiple times on one Constituent

I've seen records with multiple assigned solicitors/fundraisers. Have been at org where they may have person #1 for capital campaign and person #2 for annual campaign or a different campaign. I am guilty of assigning campaigner for each annual campaign as a separate relationship. We wanted the history and to be able to pull solicitor reports by fund. (This was pre web-view.) At one point I think it was 5 yrs or so, we just did some clean up and put all the old ones as 'old' and deleted duplications.


I like the option of an end date and/or type of former. Using color legend can have all those former relationships be gray and current are clearly viewed in db view.

This is kind of a pet peeve of mine, and falls under the general category of “don't overcode your database”. ? My general approach is to use a light hand. And as always, it also depends very much on how you want to report the information.

I have yet to see an organization that reports any sort of solicitor totals based on the Campaign or Fund of a gift. Most say things like “we need a report of everyone assigned to Tony Stark and what they gave this fiscal year.” That is a different request from “We need to see which gifts Tony Stark solicited this year”. That is a gift solicitor assignment, and not a Relationship solicitor assignment.

There is a lot to discuss related to this, but I'd suggest - based on my experience - that this level of detail in solicitor assignments is unnecessary. Some discussions should probably take place to figure out how the organization needs to report on this information, and then set up a structure to support that goal.

Karen

While I totally agree about not having superfluous data in database, I have seen and used " reports any sort of solicitor totals based on the Campaign or Fund of a gift." At previous org the solicitor performance report was probably one of our most pulled reports. Assignments were based on fund and many gifts for fund did not fall in CY/FY.


For a capital campaign 3-5 years after the previous, we entered solicitor assignment a second time if taken by same volunteer. We wanted the history and also were able to review effectiveness.


So, to those reading this post not looking at the clean up side, don't think you're doing something wrong if it is the best fit for your org needs.

Personally, I'm a big fan of the Primary/Secondary relationship tracking, where the Primary is the one leading the strategy. I used the notes field on assignments to track anything relevant there (e.g., reassigned from Jane Smith due to interest in XYZ College, etc.) Anything related to campaigns or giving would be tracked via Opportunities.

@Kathy Arnold It depends on your data entry practice. Our current assigned solicitor is coded as "primary solicitor' so that name can be pulled on any reports.

When it comes to pulling a record without a current solicitor, pulling the former can be more challenging and can probably only be done with pulling multiple names sorted by date to if those are entered. If no assignment dates are used, there's no real way to tell the most recent.