Skip to content

Gift Aid data model

The Gift Aid package adds two objects to your Salesforce org:

  • Gift Aid Declaration
  • Gift Aid Distribution Scenario

The distribution relationships are only to Account and Contact, whereas the declaration has relationships as illustrated below.

FinDock Gift Aid data model ERD

New fields for Installment and Contact objects

In addition to the declaration and distribution objects, the following fields are added to the Installment object.

Field LabelField NameData TypeDescriptionUsed on Record Type
Consider for Gift Aidgaid__Consider_for_Gift_Aid__cText(1) (External ID)This field is for internal performance optimization only.Receivable
Contact has Active GADgaid__Contact_has_Active_GAD__cCheckboxDeprecated.
Eligible for Gift Aidgaid__Eligible_for_GiftAid_formula__cFormula (Checkbox)According to a specific formula, FinDock determines if this receivable installment is eligible for Gift Aid. If the installment is eligible, the checkbox is marked (true).Receivable
Exclude from Gift Aidgaid__Exclude_from_GiftAid__cCheckboxIf true (checked), this receivable installment is not considered for Gift Aid.Receivable
GA Claim Totalgaid__GA_Claim_Total__cCurrency (16, 2)This field is calculated by FinDock. It shows the amount of the receivable installment (original donation) or the amount of the Gift Aidable field if that is used. In Gift Aid Distribution scenarios, the selected amount is multiplied by the distribution percentage.Gift Aid
Gift Aid Claimedgaid__GiftAid_Claimed__cCheckboxIndicates if Gift Aid has been claimed for this installment.Receivable
Gift Aid Declarationgaid__Gift_Aid_Declaration__cLookup (Gift Aid Declaration)When a new Gift Aid installment is created as part of the payment, this field contains a link to the Gift Aid declaration which at the time of generation was proof that this installment was eligible.Gift Aid
Gift Aidable Amountgaid__Gift_Aidable_Amount__cCurrency (16, 2)If only part of a donation is eligible for Gift Aid, enter the eligible amount in this field on the receivable installment.Receivable
Related Transactiongaid__Related_Transaction__cLookup (Installment)This is the receivable installment that is the basis of the Gift Aid installment.Gift Aid
Valid Gift Aid Declarationgaid__Valid_Gift_Aid_Declaration__cLookup (Gift Aid Declaration)The valid declaration at the receivable installment due date. If there is no currently valid declaration, but there is one in a cooling off period, that is selected. Otherwise, the field is empty.Receivable

The Contact object gets one new field.

Field LabelField NameData TypeDescription
Has Valid GAD Nowgaid__Has_Valid_GAD_Now__cCheckboxThis field is for marketing purposes only. The values can be set by running the batch Apex class ContactsUpdateHasValidNowGadJob or scheduling Apex class ContactsUpdateHasValidNowGadSchedule. The checkbox is marked if the contact had a valid declaration on the date when the Apex class was run.

Gift Aid Declaration object

API name: gaid__Gift_Aid_Declaration__c

The Gift Aid Declaration object is used to register and track Gift Aid declarations made by your donors. All other functionality of the Gift Aid implementation for FinDock depends on the details in the Gift Aid declaration record.

Field LabelField NameData TypeDescription
Accountgaid__Account__cLookup(Account)The (Person) Account of the donor who has made the the Gift Aid declaration.
Acquisition Methodgaid__Acquisition_Method__cPicklistDefine here how the declaration was received by your organization. The options are Written (paper), Oral or Digital. NOTE: There is no difference between Written and Digital acquisition for HMRC. We recommend using one or the other for non-oral declarations unless you have specific requirements for tracking the paper vs. digital acquisition.
Activegaid__Active__cCheckboxWhen checked, the declaration can be used to claim Gift Aid. This checkbox typically does not need to be changed manually. It is primarily for process and workflow actions.
Close Reasongaid__Close_Reason__cPicklistReason for closing the declaration. Only the value “Termination of Employment” is pre-shipped. Other values can be added through customization according to your own charity’s needs.
Confirmation Dategaid__Confirmation_Date__cDateThe date on which the Gift Aid declaration has been confirmed to the customer. This is the start of the cooling-off period for oral declarations. By default the value of this field is set to Date Made when you save the declaration.
Contactgaid__Contact__cDonor who has made the Gift Aid declaration. This is prefilled using the contact where you are creating the new declaration.
Cooling Off Period End Dategaid__Cooling_Off_Period_End_Date__cIf the acquisition method is oral, this field indicates when the mandatory cooling off period ends. The date is automatically calculated based on the “Number of days cooling-off period” setting of the Gift Aid extension (under FinDock Setup) when you save the declaration. You can modify it later if needed.
Custom First Namegaid__Firstname__cIf a different name should be used than the name on the contact, you can enter it here. This overrides the contact name and remains as such (i.e. no further sync between contact and declaration names).
Custom Last Namegaid__Lastname__cHandled the same as Custom First Name. See above.
Date Madegaid__Date_Made__cDate the declaration was made by the donor (or when you received it).
End Dategaid__End_Date__cDate when the declaration ceases to be valid. This field can be left empty if no end date is specified by the donor.
Final First Namegaid__First_Name__cFormula (Text)First name from the linked contact.
Final Last Namegaid__Last_Name__cFormula (Text)Last name from the linked contact.
Gift Aid Declaration NameNameAuto NumberAuto-generated number of the distribution record.
House Name or Numbergaid__Housename_or_number__cText(40)Enter the house or building number or name for UK residents, for non-UK residents, enter the Street, Number and City. NOTE: This field must be manually filled in or handled through custom business logic. Because the contact address can be stored in different ways in Salesforce, FinDock cannot automatically determine the correct address value.
In Cooling Off Periodgaid__In_Cooling_off_Period__cFormula (Checkbox)Formula field that indicates if the declaration is cooling off today.
Overseasgaid__Overseas__cCheckboxIf the address is a non-UK address, this checkbox must be marked. This parameter is required by HMRC.
Postal codegaid__Postalcode__cText(15)Enter the postal code for UK residents, for non UK Residents, enter "X". NOTE: This field must be manually filled in or handled through custom business logic. Because the contact address can be stored in different ways in Salesforce, FinDock cannot automatically determine the correct address value.
Reason for Deactivationgaid__Reason_for_Deactivation__cText(255)Optional free text field for a more detailed explanation for closing the declaration. This field can be used as input, for example, for later follow up as part of an internal donor management review process.
Start Dategaid__Start_Date__cDateThis field can be left empty to have the maximum allowed validity period (current fiscal year minus four years), or you can set a start date that limits validity of this declaration for past donations, making them ineligible for Gift Aid.
Titlegaid__Title__cFormula (text)Title from linked contact.
Typegaid__Type__cPicklistDeprecated.
Valid Nowgaid__Valid_Now__cFormula (Checkbox)Formula field that calculates of the declaration is valid today.

Gift Aid Distribution Scenario object

The Gift Aid Distribution Scenario is used to distribute Gift Aid claims on donations from partners to the individual contacts.

Field LabelField NameData TypeDescription
Accountgaid__Account__cMaster-Detail(Account)The organization (partnership) the distribution scenario applies to in a master-detail relationship.
Activegaid__Active__cFormula(Checkbox)When checked, the scenario can be to automatically distribute amount percentages across contacts.
Contactgaid__Contact__cLookup(Contact)Contacts for the distribution scenario.
Declaration Start Dategaid__Declaration_Start_Date__cFormula (Date)Earliest start date from the contacts' valid declarations.
Declaration Typegaid__Declaration_Type__cFormula (Text)Deprecated.
Enabledgaid__Enabled__cCheckboxIf checked, the scenario can be used for new distributions.
Gift Aid Distribution Scenario NameNameAuto NumberAuto-generated number of the scenario record.
Set Percentagegaid__Set_Percentage__cPercent(18, 0)Percentage of amount for the distribution scenario.