Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 BBNCTRANSACTIONGUID uniqueidentifier
 BBNCTRANID int   Default = 0
 ORIGINPAGE nvarchar(1000)   Default = ''
 ORIGINPAGEID int   Default = 0
 ADDEDBY nvarchar(255)   Default = ''
 LOGGEDINUSER bit   Default = 0 Indicates whether the linked constituent was logged in to NetCommunity during the transaction.
 DONORINFORMATION xml  
 DONORADDRESSINFORMATION xml  
 DONORADDRESSINFORMATIONALLFIELDS xml
 PHONETYPES xml
 GIFTINFORMATION xml  
 GIFTATTRIBUTEINFORMATION xml  
 MGINFORMATIONFROMMFO bit   Default = 0 Indicates if NetCommunity recieved the information from MatchFinder Online.
 UPDATEMGINFORMATIONFROMMFO bit   Default = 0
 MGINFORMATION xml  
 DONORADDRESSINFORMATIONDONOTHING bit   Default = 0
 DONORADDRESSINFORMATIONCREATENEW bit   Default = 0
 DONORADDRESSINFORMATIONUPDATE bit   Default = 0
 DONORADDRESSINFORMATIONMAKEPRIMARY bit   Default = 0
 DONOTRECEIPT bit   Default = 0
 DONOTACKNOWLEDGE bit   Default = 0
 SEQUENCE int   Default = 0
 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.
 DONORIDAUTOMATCH nvarchar(255)   Default = ''
 CORPORATEDONORIDAUTOMATCH nvarchar(255)   Default = ''
 MGCONSTITUENTIDAUTOMATCH nvarchar(255)   Default = ''
 ISTEAMFUNDRAISINGOFFLINEGIFT bit   Default = 0
 BBNCID int   Default = 0
 DONORINFORMATIONALLFIELDS xml
 TRIBUTENAME nvarchar(500)   Default = ''
 TRIBUTEDESCRIPTION nvarchar(500)   Default = ''
 ADDTRIBUTEACKNOWLEDGEE bit   Default = 0
 UPDATETRIBUTEACKNOWLEDGEEADDRESS bit   Default = 0
 TRIBUTEACKNOWLEDGEENAME nvarchar(250)   Default = ''
 TRIBUTEACKNOWLEDGEEEMAIL nvarchar(100)   Default = ''
 TRIBUTEACKNOWLEDGEESTREETADDRESS nvarchar(300)   Default = ''
 TRIBUTEACKNOWLEDGEECITY nvarchar(100)   Default = ''
 TRIBUTEACKNOWLEDGEESTATE nvarchar(100)   Default = ''
 TRIBUTEACKNOWLEDGEEPOSTCODE nvarchar(12)   Default = ''
 TRIBUTEACKNOWLEDGEECOUNTRY nvarchar(100)   Default = ''
 APPLYTRIBUTETODONATION bit   Default = 0
 TRIBUTEACKNOWLEDGEEPHONE nvarchar(100)   Default = ''
 REMOVESPOUSE bit   Default = 0
 SPOUSEINFORMATION xml
 SAMESPOUSE bit   Default = 1 This name change is for the same spouse record
 SPOUSEOLDNAME nvarchar(200)   Default = '' Full name of this constituent's current spouse

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier   NETCOMMUNITYTRANSACTIONPROCESSOR.ID FK to NETCOMMUNITYTRANSACTIONPROCESSOR
 ORIGINAPPEALID uniqueidentifier APPEAL.LOCALID Stores the source appeal for a donation.
 DONORID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 CORPORATEDONORID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 APPEALID uniqueidentifier APPEAL.LOCALID FK to APPEAL
 MGCONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 DONORADDRESSINFORMATIONADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 DONORSECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 CORPORATEDONORSECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 MGCOMPANYSECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 TRIBUTEID uniqueidentifier TRIBUTE.LOCALID FK to TRIBUTE
 TRIBUTEACKNOWLEDGEELINKID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 TRIBUTETYPECODEID uniqueidentifier TRIBUTETYPECODE.LOCALID FK to TRIBUTETYPECODE
 TRIBUTEACKNOWLEDGEESECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 DONORSITEID uniqueidentifier SITE.ID FK to SITE
 CORPORATEDONORSITEID uniqueidentifier SITE.ID FK to SITE
 MGCOMPANYSITEID uniqueidentifier SITE.ID FK to SITE
 TRIBUTEACKNOWLEDGEESITEID uniqueidentifier SITE.ID FK to SITE
 SPOUSELINKID uniqueidentifier CONSTITUENT.LOCALID New spouse for this individual
 SPOUSESECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 SPOUSESITEID uniqueidentifier SITE.ID FK to SITE
 PDACCOUNTSYSTEMID uniqueidentifier PDACCOUNTSYSTEM.ID FK to PDACCOUNTSYSTEM
 ATTRIBUTECURRENCYID uniqueidentifier CURRENCY.ID Currency used to parse and commit attributes with a currency data type.
 CATEGORYCODEID uniqueidentifier GLREVENUECATEGORYMAPPING.ID

Index Name Field(s) Unique Primary Clustered
 IX_BATCHBBNCDONATION_BATCHID BATCHID      
 IX_BATCHBBNCDONATION_CORPORATEDONORID CORPORATEDONORID      
 IX_BATCHBBNCDONATION_DATEADDED DATEADDED    
 IX_BATCHBBNCDONATION_DATECHANGED DATECHANGED      
 IX_BATCHBBNCDONATION_DONORID DONORID      
 IX_BATCHBBNCDONATION_MGCONSTITUENTID MGCONSTITUENTID      
 IX_BATCHBBNCDONATION_SPOUSELINKID SPOUSELINKID      
 IX_BATCHBBNCDONATION_TRIBUTEACKNOWLEDGEELINKID TRIBUTEACKNOWLEDGEELINKID      
 PK_BATCHBBNCDONATION ID  

Trigger Name Description
 TR_BATCHBBNCDONATION_AUDIT_UPDATE
 TR_BATCHBBNCDONATION_AUDIT_DELETE

Referenced by Field
 BATCHBBNCDONATIONBATCHSYSTEMMESSAGES BATCHBBNCDONATIONID
 BATCHBBNCDONATIONBATCHUSERMESSAGE ID
 BATCHBBNCDONATIONGIFTAPPLICATION BATCHBBNCDONATIONID
 BATCHBBNCDONATIONSOLICITOR BATCHBBNCDONATIONID
 BATCHBBNCDONATIONSPLIT BATCHBBNCDONATIONID

Entity-Relationship diagram of this table