Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FIRSTGIFTAMOUNT money   Default = 0 The amount of the first gift given by the constituent. This data comes from The Raiser's Edge.
 FIRSTGIFTDATE datetime The date of the first gift given by the constituent. This data comes from The Raiser's Edge.
 LARGESTGIFTAMOUNT money   Default = 0 The amount of the largest gift given by the constituent. This data comes from The Raiser's Edge.
 LARGESTGIFTDATE datetime The date of the largest gift given by the constituent. This data comes from The Raiser's Edge.
 LATESTGIFTAMOUNT money   Default = 0 The amount of the latest gift given by the constituent. This data comes from The Raiser's Edge.
 LATESTGIFTDATE datetime The date of the latest gift given by the constituent. This data comes from The Raiser's Edge.
 TOTALGIFTSGIVEN int   Default = 0 The total number of gifts given by the constituent. This data comes from The Raiser's Edge.
 TOTALGIFTAMOUNT money   Default = 0 The amount of the total gift amount given by the constituent. This data comes from The Raiser's Edge.
 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.
 FIRSTGIFTTYPE nvarchar(100)   Default = '' The gift type of first gift given by the constituent. This data comes from The Raiser's Edge.
 FIRSTGIFTDESIGNATION nvarchar(100)   Default = '' The gift first designation of gift given by the constituent. This data comes from The Raiser's Edge.
 LARGESTGIFTTYPE nvarchar(100)   Default = '' The gift type of largest gift given by the constituent. This data comes from The Raiser's Edge.
 LARGESTGIFTDESIGNATION nvarchar(100)   Default = '' The gift largest designation of gift given by the constituent. This data comes from The Raiser's Edge.
 LATESTGIFTTYPE nvarchar(100)   Default = '' The gift type of latest gift given by the constituent. This data comes from The Raiser's Edge.
 LATESTGIFTDESIGNATION nvarchar(100)   Default = '' The gift latest designation of gift given by the constituent. This data comes from The Raiser's Edge.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   CONSTITUENT.LOCALID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_RE7INTEGRATIONGIVINGSUMMARY_DATEADDED DATEADDED    
 IX_RE7INTEGRATIONGIVINGSUMMARY_DATECHANGED DATECHANGED      
 PK_RE7INTEGRATIONGIVINGSUMMARY ID  

Trigger Name Description
 TR_RE7INTEGRATIONGIVINGSUMMARY_AUDIT_UPDATE
 TR_RE7INTEGRATIONGIVINGSUMMARY_AUDIT_DELETE

Entity-Relationship diagram of this table