Hi all,
I'm trying to find a way to make a consortium-friendly output element for customer_last_gift_dt. Our consortium shares a great number of constituents, and for the most part the control group scheme works well to keep contributions data segregated among the organizations.
However, the current standard output set element returns the last gift date by the constituent to ANY consortium organization, which can be confusing! For example, our development associate pulled a list that shows a donor's last gift date was 12/21/2015; however the last gift he made to our organization was over a year ago.
My question is two-fold:
1. Where is last_gift_dt, as seen in the T_CUSTOMER table, coming from?
and
2. Has anyone already written a custom output element for this and would they be willing to share the code?
Thanks and Happy New Year!
Thank you all!
I've had good success with views in the past; I think I was having a mental block on this one because of the column coming from T_CUSTOMER and not a contributions table. Or, just possibly, because it's that "lost week" of the year :)