Tax Claim amount in RE tables (SQL)

Yau Oskar

I would like to get the tax claim amount for each gift in my RE NXT in SQL. Am I right to join the gift table and giftsplit table to get the correct tax claim? Many Thanks

Alex Wong

@Yau Oskar
giftsplit table record only the campaign, fund, appeal, package, and split amount fo this set of CFAP. Not what you are looking for.

in the gift table itself, there is a field call TAXCLAIMAMOUNT.

If you are going to work SQL in RE, you will need to read and understand the RESchema help file that exists in the Blackbaud RE installation folder (if you are self/3rd party/locally hosted).

Yau Oskar

@Alex Wong

Thank you very much. Yes, I know there 2 taxclaimamount, One in Gift table and one in Giftsplit table. And I have the RE schema. What I am struggling now is which field should I refer to for Gift Aid. Neither the taxclaimamount from the Gift table nor the taxclaimamount from Giftsplit match with what I directly exported from RE. We are using RE NXT, that is hosted by Blackbaud. And I expect the backup image provided by BB should be match with our live RE NXT (or course not exact match, but at least discrepancy should be reasonable) We find the Taxclaimamount in recent 4 years is similar but not in earlier years. Is there any other field store the gift aid amount ? or any other field I can refer to? am I right to say there isn't any field to store gross amount in SQL? Many Thanks

Alex Wong

@Yau Oskar
I am in the united states, so gift aid isn't something I am familiar with or uses. I also didn't realize that taxclaimamount also exists in the gift split, which I find it odd, but again, i don't know how “gift aid” “tax claim” works in a RE that uses it, so you are going to need to do some more digging.

You will also need to account for what GIFTAIDQMETHOD means (value of 1,2,3) and how it may affect the amount.

Good luck and hope someone else that uses SQL and in your country can help.