Contributions and Solicitations for a given fiscal year

Thank you!!!  Those were the links I was missing.  I may have other questions as I add additional tables. :D

Regards,

James E. Fairfield

Database Administrator

james.fairfield@attpac.org

(214) 978-2868 Office

(214) 954-9936 Fax

AT&T Performing Arts Center

2100 Ross Avenue, Suite 650

Dallas, Texas 75201

www.attpac.org

Important/Confidential: This communication and any files or documents attached to it are intended for use only by the named recipient/addressee. It may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the named recipient/addressee of this communication, you are hereby notified that copying, distributing, or otherwise using this communication is strictly prohibited. Any review, retransmission, dissemination or other use of, or action taken in reliance upon this information by persons or entities other than the named recipient/addressee is prohibited. If you received this communication in error, please notify the sender by reply e-mail and delete and destroy all forms of this communication (electronic or paper). Thank you.

I'm guessing that you have some patrons who have multiple solicitations within the same campaign (or fiscal year) which would cause your contribution totals to be higher than expected (due to a Cartesian result when you join to the solicitation table).

You will need to decide how you want to deal with this if it is the case.  If someone has two solicitations, which one do you want to include in your data set? Alternately, you could try joining t_solicitation and t_contribution using customer_no, campaign_no and designation.  That should eliminate the problem as well.

Thank you!!!  Those were the links I was missing.  I may have other questions as I add additional tables. :D

Regards,

James E. Fairfield

Database Administrator

james.fairfield@attpac.org

(214) 978-2868 Office

(214) 954-9936 Fax

AT&T Performing Arts Center

2100 Ross Avenue, Suite 650

Dallas, Texas 75201

www.attpac.org

Important/Confidential: This communication and any files or documents attached to it are intended for use only by the named recipient/addressee. It may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the named recipient/addressee of this communication, you are hereby notified that copying, distributing, or otherwise using this communication is strictly prohibited. Any review, retransmission, dissemination or other use of, or action taken in reliance upon this information by persons or entities other than the named recipient/addressee is prohibited. If you received this communication in error, please notify the sender by reply e-mail and delete and destroy all forms of this communication (electronic or paper). Thank you.

I'm guessing that you have some patrons who have multiple solicitations within the same campaign (or fiscal year) which would cause your contribution totals to be higher than expected (due to a Cartesian result when you join to the solicitation table).

You will need to decide how you want to deal with this if it is the case.  If someone has two solicitations, which one do you want to include in your data set? Alternately, you could try joining t_solicitation and t_contribution using customer_no, campaign_no and designation.  That should eliminate the problem as well.