Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 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.
 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.
 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.
 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.
 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.
 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.
 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.

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

Index Name Field(s) Unique Primary Clustered
 IX_BATCHRE7INTEGRATIONGIVINGSUMMARY_CONSTITUENTID CONSTITUENTID      
 IX_BATCHRE7INTEGRATIONGIVINGSUMMARY_DATEADDED DATEADDED    
 IX_BATCHRE7INTEGRATIONGIVINGSUMMARY_DATECHANGED DATECHANGED      
 PK_BATCHRE7INTEGRATIONGIVINGSUMMARY ID  

Trigger Name Description
 TR_BATCHRE7INTEGRATIONGIVINGSUMMARY_AUDIT_UPDATE
 TR_BATCHRE7INTEGRATIONGIVINGSUMMARY_AUDIT_DELETE

Referenced by Field
 BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGES BATCHRE7INTEGRATIONGIVINGSUMMARYID
 BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE ID

Entity-Relationship diagram of this table