Skip to content
  • There are no suggestions because the search field is empty.

Blackbaud CRM Integration - Field Mapping Reference

This article provides specific mapping details for the integration from Golden into Blackbaud CRM.

Volunteer → Constituent

When a volunteer registers for an opportunity, Golden creates or updates a constituent record in Blackbaud CRM with the following field mappings:

Golden → Blackbaud CRM

  • First Name → first_name
  • Middle Name → middle_name
  • Last Name → last_name
  • Gender → gender (mapped as: "male" → "male", "female" → "female", "nonbinary" → "other", empty/none → "unknown")
  • Email → emailaddresses (with configurable email_address_type)
  • Phone → phones (with configurable phone_type, includes number field)
  • Mailing Address → addresses (with configurable address_type, includes address_block, city, state, postcode, country)

Additionally, Golden creates:

  • Alternate Lookup ID with the Golden Volunteer ID for easy cross-reference
  • Volunteer record linked to the constituent with emergency contact information (emergency_contact_name, emergency_contact_phone)

Opportunity, Timeslot → Volunteer Opportunity

Golden opportunities and timeslots are mapped to jobs and job occurrences in Blackbaud CRM:

Opportunity → Job:

  • Opportunity Title + ID → name (formatted as "Title (OpportunityID)")
  • Full Description → description
  • Volunteer Rate → estimated_value (converted from cents to dollars)

Timeslot → Job Occurrence:

  • Opportunity Title + Start Date/Time → description
  • Time Type → type ("ongoing" for flexible opportunities, "one time" for scheduled)
  • Start Date/Time → start_date, one_start_time (hour, minute)
  • End Date/Time → end_date, one_end_time (hour, minute)
  • Maximum Volunteers → volunteers_needed
  • Volunteer Rate → estimated_value
  • Opportunity Location → location
  • Day of Week → day_of_week (calculated from start date, or "every day" for ongoing/ranged opportunities)

Registration → Assignment

When a volunteer registers for an opportunity, Golden creates an assignment in Blackbaud CRM connecting the volunteer with the job occurrence. When the registration is canceled, the assignment is deleted.

Mapping:

  • Volunteer ID → volunteer_id
  • Start Date → date
  • Job Occurrence ID → job_occurrence_id (nested in assignments array)

Registration → Timesheet

When a registration is marked as completed, Golden creates a timesheet in Blackbaud CRM to reflect the hours volunteered.

Mapping:

  • Volunteer ID → volunteer_id
  • Job Occurrence ID → job_occurrence
  • Hours Completed → hours_worked
  • Start Date → start_date
  • End Date → end_date