Relationship between an Appeal and a Gift

Options
Rita Nicholson
Rita Nicholson ✭
Tenth Anniversary Facilitator 1 Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion
Hi,

I'm new to Raiser's Edge and I'm trying to write a donation report from the live tables.  Does anyone know how the gift table links (relates) to the appeal associated with the gift?   I've linked the "Gift" table to the "Constitutent_Appeal" table to the "Appeal" table but it gives me all appeals from the "Appeal" table for each gift, I want just the one associated with the gift.   I've looked at the "Campaign Appeals", and the "Fund Appeals" but I still can't see the connection.



I would  appreciate any advice out there.



Thanks,   Rita

Rita Nicholson

Manager, Information Systems

Children's Health Foundation

345 Westminster Avenue / VH - B1-010

London, ON, Canada N6C 4V3

Phone: 519-432-8062 Ext: 126

RNicholson@childhealth.ca


 
Tagged:

Comments

  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    I'll have to take a look at the schema to answer your question but for now I don't think you want the Constituent_Appeal table.  I think that is the data for the Appeals tab (a.k.a. assigned appeals) and not the appeal on the gifts.



    -Josh 
  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    Take a look at the GIFTSPLIT table, that has the APPEALID field that links to the APPEAL table... which brings up James' recent post about split gifts:



    https://community.blackbaud.com/forums/viewtopic/157/15722?post_id=49563#p49563



    and reminds me that campaign, fund, appeal and package are in a separate table.
  • Rita Nicholson
    Rita Nicholson ✭
    Tenth Anniversary Facilitator 1 Photogenic
    Actually I did change that, these are the links I have:



    RECORDS_ID to GIFT_CONSTIT_ID to GIFT ID_ID to CONSTIT_GIFTS_GIFTID to CAMPGIFTS_GIFTID to CAMPAIGN_ID to CAMPAIGN_ID to APPEAL_CAMPAIGN_ID



    that works fine if I query off the APPEAL_ID.   

     
  • Rita Nicholson
    Rita Nicholson ✭
    Tenth Anniversary Facilitator 1 Photogenic

    Josh Bekerman:

    Take a look at the GIFTSPLIT table, that has the APPEALID field that links to the APPEAL table... which brings up James' recent post about split gifts:



    https://community.blackbaud.com/forums/viewtopic/157/15722?post_id=49563#p49563



    and reminds me that campaign, fund, appeal and package are in a separate table.

    PERFECT, thanks so much it worked.  You made my week!

     
  • James Andrews
    James Andrews ✭
    Ancient Membership Facilitator 2 Photogenic

    Rita Nicholson:

    Actually I did change that, these are the links I have:



    RECORDS_ID to GIFT_CONSTIT_ID to GIFT ID_ID to CONSTIT_GIFTS_GIFTID to CAMPGIFTS_GIFTID to CAMPAIGN_ID to CAMPAIGN_ID to APPEAL_CAMPAIGN_ID



    that works fine if I query off the APPEAL_ID.   

     

    Be kinda careful with that const_gifts table - the flags thing is important to note for hard and soft credits.



    But yeah, GiftSplit and GiftPreviousSplit (if you're dealing with corrections/adjustments) are the key for linking that stuff.

Categories