Unable find joining fields for Fund, Appeal, Campaign information tables to Gift information table in SQL Server.

Venky Immadisetty

Hi All,
I am trying to join the Gift Information with the Fund, Campaign, and Appeal information. For instance John made a donation of $25. While adding this information to the record Gift processing will also enter other information like Fund, Campaign and Associated Appeal to the gift.
Here is how it looks like.

I am looking for joining Fields to the FUND, CAMPAIGN, APPEAL tables. I tried looking at the FUND, CAMPAIGN, APPEAL table to see if there are any field like GIFT ID or GIFT system record ID to join. Any input on which fields to look at?
Thank you!

Alex Wong

@Venky Immadisetty
I assume you already have access to the RE Database Schema help file, the table you are looking for is call GIFTSPLIT

ONE gift can have MULTIPLE split of Campaign/Fund/Appeal/Package, so you will find potentially mutliple rows of data in the GIFTSPLIT table for each split of gift for the same GIFTID. (if your org use spit gift)

Venky Immadisetty

@Alex Wong
Yes, I do have access for RE Database Schema file. This is very helpful.

Steve Birnbaum

@Venky Immadisetty
The SKY API flattens many of the relational joins. If you like feel free, to contact me offline for more details. (steve@datamoose.org)