1. CSR Partnerships | Double the Donation
  2. Integration Documentation and API Access

Reference: Data Schema

This article provides Double the Donation's data schema.

/update-donation endpoint

/update-company endpoint



/update-donation endpoint

Field Name

Type

Description

Example

submission_status

string

The status of the matching gift record. Refer to this page for available statuses

approved

donation_id

string 

Unique ID of the record. Use the same ID you retrieved with the record from the /get-updated-donations endpoint

h32437s2 

matched_amount

number 

The amount of the matching gift, NOT always the same as the initial donation amount. Can be affected by matching ratio, available funds remaining in the donor's account, program maximums, etc.

50

payment_method

string 

How the matching funds will be sent to the nonprofit? Check, ACH, etc.

ACH

payment_cleared_date

string 

When the funds will be sent/were sent to the nonprofit

01302022

reject_reason

string

If the matching gift request was rejected, the reason why. Refer to this page for available reasons

Max Employee Funds Spent 


/update-company endpoint

Field Name

Type

Description

Example

 

company_name

string 

Name of the company

Greenwood, Inc.

 

duns_number

 string

The Dun & Bradstreet D‑U‑N‑S Number is a unique nine-digit identifier for businesses (more here)

111111111

 

corporate_contact_name

string 

Name of the main contact person or department for the corporate giving program at the company

Greenwood Giving Foundation

 

 

 

corporate_contact_email

 string

Email of the main contact person or department for the corporate giving program at the company

givingfoundation@greenwood.org

 

corporate_contact_phone

string

Phone number of the main contact person or department for the corporate giving program at the company

(555) 555-5555

 

email_domains

array[string]

Email domains associated with company employees; are used for eligibility screening so should be as comprehensive as possible

greenwood.com, greenwoodgivingfoundation.org

 

subsidiaries

array[string]

Any subsidiaries, brands, or acquisitions under the company umbrella that the corporate giving program is extended to; these appear to donors/employees in searches so should be as comprehensive as possible

Greenwood Foundation, Greenwood North

 

matching_gift_offered

 boolean

True if the company offers a matching gift program

true

 

full_time_eligible

 boolean

True if full-time employees are eligible for the matching gift program

true

 

part_time_eligible

 boolean

True if part-time employees are eligible for the matching gift program

true

 

retirees_eligible

 boolean

True if retiree employees are eligible for the matching gift program

false

 

arts_and_cultural

 boolean

True if the company will match gifts made to arts and cultural nonprofit organizations

true

 

civic_community

 boolean

True if the company will match gifts made to civic and community nonprofit organizations

true

 

environmental

 boolean

True if the company will match gifts made to environmental nonprofit organizations

false

 

health_human_services

 boolean

True if the company will match gifts made to health and human services nonprofit organizations

false

 

higher_ed

 boolean

True if the company will match gifts made to higher education nonprofit organizations, such as university foundations

 true

 

k12

boolean

True if the company will match gifts made to K-12 nonprofit organizations, such as independent schools

 false

 

minimum_matched

 string

The minimum amount a donation has to meet to qualify for a company matching gift; this is the text that will appear to the donor/employee, so format this string with the unit of measure ($) and provide any qualifying information useful for the donor; should be the same amount as the minimum_matched_amount

$25

 

minimum_matched_amount

 integer

The minimum amount a donation has to meet to qualify for a company matching gift; this is used for internal calculations and analytics, so provide an integer only; should be the same amount as the minimum_matched

25

 

maximum_matched

string

The maximum amount a donation cannot exceed to qualify for a company matching gift; this is the text that will appear to the donor/employee, so format this string with the unit of measure ($) and provide any qualifying information useful for the donor; should be the same amount as the maximum_matched_amount

$5,000 to schools or $1,000 to other 501(c)(3) organizations

 

maximum_matched_amount

integer

The maximum amount a donation cannot exceed to qualify for a company matching gift; this is used for internal calculations and analytics, so provide an integer only; should be the same amount as the maximum_matched

1000

 

currency_code

string

The currency the company matching gift program should be displayed in, oer ISO 4217 (more here); should always be USD, please contact DTD if USD seems to not apply

USD

 

ratio

 string

The ratio at which the company matching gift program matches employee donations; represented as a #:# ratio with the amount of the company matching donation on the left and the amount of the initial donation on the right

2:1*

 

url_forms

 string

The URL where employees submit their donations for a matching gift; could be a URL to a page within your platform that require authenticated access

 https://www.greenwoodgivingfoundation.org/matchinggifts

 

intranet_forms

 boolean

True if the URL of the matching gift request form in the previous row is only available by the employee logging in to your platform or another internal system

 false

 

url_guidelines

 string

The URL where employees can view the guidelines for the company’s matching gift program

 https://www.greenwoodgivingfoundation.org/matchinggifts

 

matching_gift_process

string

Plain-text field to explain nuances of the matching gift process

 Greenwood, Inc. matches donations from current employees to nearly all nonprofits including:

Educational institutions (K-12 included)

Arts and cultural organizations

Civic and community organizations

Submission Process:

Donors who are employees of Greenwood, Inc. should register their matching gift requests electronically.

 

volunteer_grant_offered

 boolean

True if the company offers a volunteer grant program

true

 

volunteer_grant_process

 string

Plain-text field to explain nuances of the volunteer grant process

 

Greenwood, Inc. offers a volunteer grant program as a way to support organizations at which employees and retirees volunteer on a regular basis. 

 

The three tiers are as follows:

 

50-149 hours = $100 grants

150-199 hours = $300 grants

200+ volunteer hours = $400 grants

 

volunteer_minimum_hours_required

 string

The minimum amount of hours an employee has to volunteer to qualify for a company volunteer grant; this is the text that will appear to the donor/employee, so format this string with the unit of measure (hours) and provide any qualifying information useful for the donor

50 hours

 

corporate_donation_offered

string

The amount of the volunteer grant the company will provide for the volunteer hours; this is the text that will appear to the donor/employee, so format this string with the unit of measure ($) and provide any qualifying information useful for the donor, as it’s likely that some additional context may be required

Up to $400

 

misc

string

Any additional information about the company corporate giving program you think DTD should know; this field is just for your platform to send information to the DTD database team and will not be included in this format in the database entry

Retired employees have a completely different process for matching gifts. They should contact giving@greenwoodfoundation.org to request a matching gift form instead of accessing the online form.

 

corporate_vendor

 string

The name of your company/platform; ensure you send the same string every time

Corporate Vendor X

 

 

*representing a company that will double an initial donation, that is, a $200 match for a $100 initial donation