Donor Gift Summary DMO

Object Properties

Object API Name: ssot__DonorGiftSummary__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

  • FirstGiftCampaignId has a FOREIGNKEY relationship with the Campaign DMO Id field.
  • DonorId has a FOREIGNKEY relationship with the Account DMO Id field.

Fields

AverageGiftAmount

  • Field API Name: ssot__AverageGiftAmount__c
  • Data Type: DOUBLE
  • Description: The average value of the gifts the donor directly contributed.

BestGiftYear

  • Field API Name: ssot__BestGiftYear__c
  • Data Type: TEXT
  • Description: The year when the donor directly contributed the largest value of gifts.

cdp_sys_record_currency

  • Field API Name: ssot__cdp_sys_record_currency__c
  • Data Type: TEXT
  • Description: System-generated metadata field that stores a 3-letter ISO currency code.

CompositeRfmScoreNumber

  • Field API Name: ssot__CompositeRfmScoreNumber__c
  • Data Type: DOUBLE
  • Description: The composite RFM (Recency, Frequency, Monetary) score for the donor.

CurrentRecurringStartDate

  • Field API Name: ssot__CurrentRecurringStartDate__c
  • Data Type: DATETIME
  • Description: The date and time of the current recurring start date.

CurrentYearGiftCount

  • Field API Name: ssot__CurrentYearGiftCount__c
  • Data Type: DOUBLE
  • Description: The total number of gifts the donor directly contributed this year.

DataSourceId

  • Field API Name: ssot__DataSourceId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.

DataSourceObjectId

  • Field API Name: ssot__DataSourceObjectId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.

DaysSinceLastGift

  • Field API Name: ssot__DaysSinceLastGift__c
  • Data Type: TEXT
  • Description: The number of days since the donor gave a direct contribution.

DonorId

  • Field API Name: ssot__DonorId__c
  • Data Type: TEXT
  • Description: The person, household, or organization account associated with the donor gift summary.

FirstGiftAmount

  • Field API Name: ssot__FirstGiftAmount__c
  • Data Type: DOUBLE
  • Description: The value of the first gift the donor directly contributed.

FirstGiftCampaignId

  • Field API Name: ssot__FirstGiftCampaignId__c
  • Data Type: TEXT
  • Description: The first campaign the donor contributed to.

FirstGiftDate

  • Field API Name: ssot__FirstGiftDate__c
  • Data Type: DATETIME
  • Description: The date and time of the first gift date.

FirstRecurringStartDate

  • Field API Name: ssot__FirstRecurringStartDate__c
  • Data Type: DATETIME
  • Description: The date and time of the first recurring start date.

FirstSoftCreditAmount

  • Field API Name: ssot__FirstSoftCreditAmount__c
  • Data Type: DOUBLE
  • Description: The value of the first gift the donor influenced but didn't directly contribute.

FirstSoftCreditDate

  • Field API Name: ssot__FirstSoftCreditDate__c
  • Data Type: DATETIME
  • Description: The date and time of the first soft credit date.

FirstVolunJobPstnAsgntDate

  • Field API Name: ssot__FirstVolunJobPstnAsgntDate__c
  • Data Type: DATEONLY
  • Description: The date of the contact's first volunteer shift. Data Processing Engine finds the first job position assignment that's related to a volunteer initiative and calculates the value. You can schedule this calculation to run regularly.

FrequencyScoreNumber

  • Field API Name: ssot__FrequencyScoreNumber__c
  • Data Type: DOUBLE
  • Description: The frequency score for the donor based on how often they give gifts.

GiftCount

  • Field API Name: ssot__GiftCount__c
  • Data Type: DOUBLE
  • Description: The total number of gifts the donor directly contributed.

GiftsLastYearAmount

  • Field API Name: ssot__GiftsLastYearAmount__c
  • Data Type: DOUBLE
  • Description: The value of gifts the donor directly contributed last year.

GiftsThisYearAmount

  • Field API Name: ssot__GiftsThisYearAmount__c
  • Data Type: DOUBLE
  • Description: The value of gifts the donor directly contributed this year.

GiftsTwoYearsAgoAmount

  • Field API Name: ssot__GiftsTwoYearsAgoAmount__c
  • Data Type: DOUBLE
  • Description: The value of gifts the donor directly contributed two years ago.

GivingLevel

  • Field API Name: ssot__GivingLevel__c
  • Data Type: TEXT
  • Description: The level within which the donor's total contributions fall for the current year. Example values include $25, 000, 000+, $10, 000, 000-$24, 999, 999, $5, 000, 000-$9, 999, 999.

HighestGiftAmount

  • Field API Name: ssot__HighestGiftAmount__c
  • Data Type: DOUBLE
  • Description: The largest single gift the donor directly contributed.

HighestGiftYearAmount

  • Field API Name: ssot__HighestGiftYearAmount__c
  • Data Type: DOUBLE
  • Description: The largest value of gifts the donor directly contributed in one year.

HighestSoftCreditAmount

  • Field API Name: ssot__HighestSoftCreditAmount__c
  • Data Type: DOUBLE
  • Description: The value of the largest single gift the donor influenced but didn't directly contribute.

HighestSoftCreditDate

  • Field API Name: ssot__HighestSoftCreditDate__c
  • Data Type: DATETIME
  • Description: The date and time of the highest soft credit date.

Id

  • Field API Name: ssot__Id__c
  • Data Type: TEXT
  • Description: Required. A unique, system-generated identifier for this DonorGiftSummary record. Maximum size is 15 characters.

InternalOrganizationId

  • Field API Name: ssot__InternalOrganizationId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.

KQ_DonorId

  • Field API Name: KQ_DonorId__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for DonorId

KQ_FirstGiftCampaignId

  • Field API Name: KQ_FirstGiftCampaignId__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for FirstGiftCampaignId

KQ_Id

  • Field API Name: KQ_Id__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for Id

LastGiftAmount

  • Field API Name: ssot__LastGiftAmount__c
  • Data Type: DOUBLE
  • Description: The value of the donor's most recent, directly-contributed gift.

LastGiftDate

  • Field API Name: ssot__LastGiftDate__c
  • Data Type: DATETIME
  • Description: The date and time of the last gift date.

LastRecurringPaymentDate

  • Field API Name: ssot__LastRecurringPaymentDate__c
  • Data Type: DATETIME
  • Description: The date and time of the last recurring payment date.

LastSoftCreditAmount

  • Field API Name: ssot__LastSoftCreditAmount__c
  • Data Type: DOUBLE
  • Description: The value of the last gift the donor influenced but didn't directly contribute.

LastSoftCreditDate

  • Field API Name: ssot__LastSoftCreditDate__c
  • Data Type: DATETIME
  • Description: The date and time of the last soft credit date.

LastTwoYearGiftCount

  • Field API Name: ssot__LastTwoYearGiftCount__c
  • Data Type: DOUBLE
  • Description: The total number of gifts the donor directly contributed two years ago.

LastVolunJobPstnAsgntDate

  • Field API Name: ssot__LastVolunJobPstnAsgntDate__c
  • Data Type: DATEONLY
  • Description: The date of the contact's last volunteer shift. Data Processing Engine calculates this value by finding the most recent job position assignment that's related to a volunteer initiative. You can schedule this calculation to run on a regular basis.

LastYearGiftCount

  • Field API Name: ssot__LastYearGiftCount__c
  • Data Type: DOUBLE
  • Description: The total number of gifts the donor directly contributed last year.

LowestGiftAmount

  • Field API Name: ssot__LowestGiftAmount__c
  • Data Type: DOUBLE
  • Description: The smallest single gift the donor directly contributed.

MonetaryScoreNumber

  • Field API Name: ssot__MonetaryScoreNumber__c
  • Data Type: DOUBLE
  • Description: The monetary score for the donor based on the value of their gifts.

RecencyScoreNumber

  • Field API Name: ssot__RecencyScoreNumber__c
  • Data Type: DOUBLE
  • Description: The recency score for the donor based on when they last gave a gift.

SecondGiftDate

  • Field API Name: ssot__SecondGiftDate__c
  • Data Type: DATETIME
  • Description: The date and time of the second gift date.

SoftCreditCount

  • Field API Name: ssot__SoftCreditCount__c
  • Data Type: DOUBLE
  • Description: The total number of gifts the donor influenced and didn't directly contribute.

TotalGiftsAmount

  • Field API Name: ssot__TotalGiftsAmount__c
  • Data Type: DOUBLE
  • Description: The value of gifts the donor directly contributed.

TotalHardSoftCredits

  • Field API Name: ssot__TotalHardSoftCredits__c
  • Data Type: DOUBLE
  • Description: The number of gifts the donor directly contributed and influenced.

TotalHardSoftCreditsAmount

  • Field API Name: ssot__TotalHardSoftCreditsAmount__c
  • Data Type: DOUBLE
  • Description: The total value of all gifts the donor directly contributed and influenced.

TotalPaidRcrInstallments

  • Field API Name: ssot__TotalPaidRcrInstallments__c
  • Data Type: DOUBLE
  • Description: The number of recurring installments the donor directly contributed.

TotalPaidRcrInstlAmt

  • Field API Name: ssot__TotalPaidRcrInstlAmt__c
  • Data Type: DOUBLE
  • Description: The value of all of the recurring installments the donor directly contributed.

TotalSoftCreditsAmount

  • Field API Name: ssot__TotalSoftCreditsAmount__c
  • Data Type: DOUBLE
  • Description: The total value of all gifts the donor influenced but didn't directly contribute.

TotalVolunJobPstnAsgnCount

  • Field API Name: ssot__TotalVolunJobPstnAsgnCount__c
  • Data Type: DOUBLE
  • Description: Total number of job position assignments the person is associated with.

TotalVolunteerHoursNumber

  • Field API Name: ssot__TotalVolunteerHoursNumber__c
  • Data Type: DOUBLE
  • Description: The total hours a contact volunteered. The Data Processing Engine adds the hours from job position assignments related to volunteer initiatives and calculates the value. You can schedule this calculation to run regularly.