Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 AMOUNT money   Default = 0
 SEQUENCE int   Default = 0
 DATE datetime
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the planned gift designation in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the planned gift designation in transaction currency.

Foreign Key Field Type Null Notes Description
 PLANNEDGIFTADDITIONID uniqueidentifier   PLANNEDGIFTADDITION.ID Planned gift addition record to which the designation belongs.
 DESIGNATIONID uniqueidentifier DESIGNATION.ID The designation record for this planned gift addition.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CATEGORYCODEID uniqueidentifier PLANNEDGIFTDESCATEGORYCODE.ID FK to PLANNEDGIFTDESCATEGORYCODE
 USECODEID uniqueidentifier DESIGNATIONUSECODE.ID FK to DESIGNATIONUSECODE
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this revenue split.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this planned gift designation.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the base amount.
 TYPECODEID uniqueidentifier OPPORTUNITYDESIGNATIONTYPECODE.ID FK to OPPORTUNITYDESIGNATIONTYPECODE

Index Name Field(s) Unique Primary Clustered
 IX_PLANNEDGIFTADDITIONDESIGNATION_BASECURRENCYID BASECURRENCYID      
 IX_PLANNEDGIFTADDITIONDESIGNATION_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_PLANNEDGIFTADDITIONDESIGNATION_DATEADDED DATEADDED    
 IX_PLANNEDGIFTADDITIONDESIGNATION_DATECHANGED DATECHANGED      
 IX_PLANNEDGIFTADDITIONDESIGNATION_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_PLANNEDGIFTADDITIONDESIGNATION_PLANNEDGIFTADDITIONID PLANNEDGIFTADDITIONID      
 IX_PLANNEDGIFTADDITIONDESIGNATION_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_PLANNEDGIFTADDITIONDESIGNATION ID  

Trigger Name Description
 TR_PLANNEDGIFTADDITIONDESIGNATION_AUDIT_UPDATE
 TR_PLANNEDGIFTADDITIONDESIGNATION_AUDIT_DELETE
 TR_PLANNEDGIFTADDITIONDESIGNATION_INSERTUPDATE_CURRENCY

Referenced by Field
 PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN PLANNEDGIFTADDITIONDESIGNATIONID

Entity-Relationship diagram of this table