Donor Gift Summary DMO

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

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

• AverageGiftAmount
• BestGiftYear
• cdp_sys_record_currency
• CompositeRfmScoreNumber
• CurrentRecurringStartDate
• CurrentYearGiftCount
• DataSourceId
• DataSourceObjectId
• DaysSinceLastGift
• DonorId
• FirstGiftAmount
• FirstGiftCampaignId
• FirstGiftDate
• FirstRecurringStartDate
• FirstSoftCreditAmount
• FirstSoftCreditDate
• FirstVolunJobPstnAsgntDate
• FrequencyScoreNumber
• GiftCount
• GiftsLastYearAmount
• GiftsThisYearAmount
• GiftsTwoYearsAgoAmount
• GivingLevel
• HighestGiftAmount
• HighestGiftYearAmount
• HighestSoftCreditAmount
• HighestSoftCreditDate
• Id
• InternalOrganizationId
• KQ_DonorId
• KQ_FirstGiftCampaignId
• KQ_Id
• LastGiftAmount
• LastGiftDate
• LastRecurringPaymentDate
• LastSoftCreditAmount
• LastSoftCreditDate
• LastTwoYearGiftCount
• LastVolunJobPstnAsgntDate
• LastYearGiftCount
• LowestGiftAmount
• MonetaryScoreNumber
• RecencyScoreNumber
• SecondGiftDate
• SoftCreditCount
• TotalGiftsAmount
• TotalHardSoftCredits
• TotalHardSoftCreditsAmount
• TotalPaidRcrInstallments
• TotalPaidRcrInstlAmt
• TotalSoftCreditsAmount
• TotalVolunJobPstnAsgnCount
• TotalVolunteerHoursNumber

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

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.

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

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

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

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

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

• 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.

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

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

• 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.

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

• 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.

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

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

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

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

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

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

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

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

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

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.