Planned Gift DMO

A complex gift such as an annuity, bequest, or trust.

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

• CaseId has a FOREIGNKEY relationship with the Case DMO Id field.
• ContactId has a FOREIGNKEY relationship with the Individual DMO Id field.
• DonorId has a FOREIGNKEY relationship with the Account DMO Id field.
• DonorGiftConceptId has a FOREIGNKEY relationship with the Donor Gift Concept DMO Id field.
• GiftAgreementId has a FOREIGNKEY relationship with the Gift Agreement DMO Id field.
• OpportunityId has a FOREIGNKEY relationship with the Opportunity DMO Id field.

• ActuarialFactorNumber
• BequestRealizationDate
• CaseId
• cdp_sys_record_currency
• CommittedDate
• ContactId
• CurrentValueAmt
• DataSourceId
• DataSourceObjectId
• DiscountRate
• DonorGiftConceptId
• DonorId
• ExpectancyYears
• ExpectedAmt
• ExpectedEstateValueAmt
• ExpensesAmt
• FaceValueAmt
• FirstPaymentDate
• FutureValueAmt
• GiftAgreementId
• GiftProbabilityPercent
• Id
• InternalOrganizationId
• InvestmentReturnRate
• IsRevocable
• LastValuationDate
• MarketValueAmt
• MaturityDate
• NetReturnRate
• NetValueAmt
• OpportunityId
• PayoutFrequency
• PayoutRate
• PlannedGiftName
• PlannedGiftType
• PolicyNumber
• PremiumAmt
• PresentValueAmt
• PrincipalAmt
• ReceivedAmt
• ReceivedDate
• ResiduarySharePercent
• StartDate
• Status
• TermEndDate
• TermType
• TermYears
• TrusteeFeesAmt
• TrustName
• TrustType
• UnitsHeldNumber
• UnitsValueAmt

• Field API Name: std__ActuarialFactorNumber__c
• Data Type: DOUBLE
• Description: A factor based on actuarial assumptions that's used to calculate the gift's future value.

• Field API Name: std__BequestRealizationDate__c
• Data Type: DATEONLY
• Description: Captures the expected date when a bequest is likely to be realized.

• Field API Name: std__CaseId__c
• Data Type: TEXT
• Description: The case associated with the planned gift.

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

• Field API Name: std__CommittedDate__c
• Data Type: DATEONLY
• Description: The date when the gift was committed.

• Field API Name: std__ContactId__c
• Data Type: TEXT
• Description: The contact for the planned gift.

• Field API Name: std__CurrentValueAmt__c
• Data Type: CURRENCY
• Description: Represents the actual recorded or realized value of an asset or planned gift at a specific point in time.

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

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

• Field API Name: std__DiscountRate__c
• Data Type: PERCENT
• Description: The discount rate applied to project the future value of the gift.

• Field API Name: std__DonorGiftConceptId__c
• Data Type: TEXT
• Description: The gift concept associated with the planned gift.

• Field API Name: std__DonorId__c
• Data Type: TEXT
• Description: The donor of the planned gift.

• Field API Name: std__ExpectancyYears__c
• Data Type: DOUBLE
• Description: The expected number of years to maturity, based on actuarial assumptions.

• Field API Name: std__ExpectedAmt__c
• Data Type: CURRENCY
• Description: The expected value of the planned gift.

• Field API Name: std__ExpectedEstateValueAmt__c
• Data Type: CURRENCY
• Description: Represents the total estimated value of the donor's estate.

• Field API Name: std__ExpensesAmt__c
• Data Type: CURRENCY
• Description: The total management expenses associated with the gift.

• Field API Name: std__FaceValueAmt__c
• Data Type: CURRENCY
• Description: The face value of the gift, if the gift is life insurance.

• Field API Name: std__FirstPaymentDate__c
• Data Type: DATEONLY
• Description: The date when the first payment is made, if the gift is a trust or an annuity.

• Field API Name: std__FutureValueAmt__c
• Data Type: CURRENCY
• Description: The gift's projected value at maturity.

• Field API Name: std__GiftAgreementId__c
• Data Type: TEXT
• Description: The gift agreement associated with the planned gift.

• Field API Name: std__GiftProbabilityPercent__c
• Data Type: PERCENT
• Description: The probability of receiving the gift.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Primary Key

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

• Field API Name: std__InvestmentReturnRate__c
• Data Type: PERCENT
• Description: The return rate on investments related to the gift.

• Field API Name: std__IsRevocable__c
• Data Type: BOOLEAN
• Description: Indicates whether the gift is revocable (true) or not (false).

• Field API Name: std__LastValuationDate__c
• Data Type: DATEONLY
• Description: Tracks the most recent date the planned gift value was reviewed or updated.

• Field API Name: std__MarketValueAmt__c
• Data Type: CURRENCY
• Description: The gift's current market value.

• Field API Name: std__MaturityDate__c
• Data Type: DATEONLY
• Description: The date when the gift is expected to mature or be realized.

• Field API Name: std__NetReturnRate__c
• Data Type: PERCENT
• Description: Represents the expected annual net return rate on the gift's investments.

• Field API Name: std__NetValueAmt__c
• Data Type: CURRENCY
• Description: The net value of the gift after expenses and payouts.

• Field API Name: std__OpportunityId__c
• Data Type: TEXT
• Description: The opportunity associated with the planned gift.

• Field API Name: std__PayoutFrequency__c
• Data Type: TEXT
• Description: The payment frequency. Example values include Annual, Semi-Annual, Quarterly

• Field API Name: std__PayoutRate__c
• Data Type: PERCENT
• Description: The rate at which payouts are made to beneficiaries.

• Field API Name: std__PlannedGiftName__c
• Data Type: TEXT
• Description: An auto-generated string or number assigned to the planned gift.

• Field API Name: std__PlannedGiftType__c
• Data Type: TEXT
• Description: The type of planned gift. Example values include Charitable Gift Annuity, Deferred Gift Annuity, Charitable Lead Annuity Trust

• Field API Name: std__PolicyNumber__c
• Data Type: TEXT
• Description: The policy number, if the gift is life insurance.

• Field API Name: std__PremiumAmt__c
• Data Type: CURRENCY
• Description: The premium amount, if the gift is life insurance.

• Field API Name: std__PresentValueAmt__c
• Data Type: CURRENCY
• Description: A calculated value of future cash flows associated with an asset or planned gift.

• Field API Name: std__PrincipalAmt__c
• Data Type: CURRENCY
• Description: The principal amount of the gift.

• Field API Name: std__ReceivedAmt__c
• Data Type: CURRENCY
• Description: The amount received since the planned gift record was created.

• Field API Name: std__ReceivedDate__c
• Data Type: DATEONLY
• Description: The date when the gift was received.

• Field API Name: std__ResiduarySharePercent__c
• Data Type: PERCENT
• Description: Captures the percentage of the estate allocated to the institution for residuary bequests.

• Field API Name: std__StartDate__c
• Data Type: DATEONLY
• Description: The date when the gift agreement is initiated.

• Field API Name: std__Status__c
• Data Type: TEXT
• Description: The status of the planned gift. Example values include Active, Inactive, Matured

• Field API Name: std__TermEndDate__c
• Data Type: DATEONLY
• Description: The date when the gift matures or the trust term ends.

• Field API Name: std__TermType__c
• Data Type: TEXT
• Description: The term type for the trust, such as fixed number of years, one life, or two lives.

• Field API Name: std__TermYears__c
• Data Type: DOUBLE
• Description: Defines the term (in years) of a trust for calculating future and present value.

• Field API Name: std__TrusteeFeesAmt__c
• Data Type: CURRENCY
• Description: Fees paid to the trustee.

• Field API Name: std__TrustName__c
• Data Type: TEXT
• Description: The name of the trust, if the gift is categorized as a trust.

• Field API Name: std__TrustType__c
• Data Type: TEXT
• Description: The type of trust. Example values include Charitable Lead Annuity Trust, Charitable Remainder Annuity Trust, Charitable Lead Unitrust

• Field API Name: std__UnitsHeldNumber__c
• Data Type: DOUBLE
• Description: The number of units that the donor holds in the pooled income fund.

• Field API Name: std__UnitsValueAmt__c
• Data Type: CURRENCY
• Description: The value of 1 unit in the pooled income fund.