Gift Aid Backend Data

Rachel Chew

Hope someone can help me or direct me to the right channel. Blackbaud suggested I post my query here, so here it is:

We have a couple of gifts (under the same record) whereby it is showing the tax claim amount in RE database but on the backend coding it is showing as 0. Where as some of them did have -1 (still in the same record).

I was wondering how do I get hold of the backend data and more importantly I want to know why is the coding different. This is important to us as we are using the backup data to feed into our analysis software and it's showing inaccurate reporting.

We are Blackbaud hosted and UK based Charity.

Appreciate any help on this.

Thank you.

Alex Wong

@Rachel Chew
I am assuming that by “backend coding” you mean the the RE Schema database tables.

Which table and which table field are you talking about?

in RE database schema, generally when you have a “checkbox” that represent true (checked) or false (not checked), the field is represented as a SMALLINT data type where 0 means false (not checked) and -1 means true (checked).

For example: in the RECORDS table, there is a DECEASED field (that represent the Deceased checkbox on an Individual constituent record in RE), where if the record is deceased, this field will be -1.

If you are going to be querying the database directly, it is best you know the RE schema well. Assuming you are self hosted (or 3rd party hosted), you can get the RE7Schema.chm (windows help file extension) in the Blackbaud RE installation folder (it is in the help subfolder)