Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 LOGGEDINUSER bit   Default = 0 Indicates whether the linked constituent was logged in to NetCommunity during the transaction.
 BBNCTRANID int   Default = 0
 ADDEDBY nvarchar(255)   Default = ''
 BBNCDONORNAME nvarchar(154)   Default = '' Donor name entered through NetCommunity
 REGISTRATIONDATE datetime Date when the transaction occured
 DONORINFORMATION xml Transaction data for the donor information tab
 DONORADDRESSINFORMATION xml Transaction data for the donor address tab
 DONORADDRESSINFORMATIONALLFIELDS xml Transaction data for the donor address tab when adding a new address
 DONORADDRESSUPDATE bit   Default = 0 Indicates whether existing donor address information should be updated
 DONORADDRESSADD bit   Default = 0 Indicates whether new donor address information should be added
 DONORADDRESSMAKEPRIMARY bit   Default = 0 Indicates whether the new donor address information should be added as the primary address
 PHONETYPES xml
 REGISTRATIONS xml
 GUESTS xml
 GIFTINFORMATION xml
 ORIGINPAGENAME nvarchar(1000)   Default = '' Name of the BBNC page from which the registration originated
 ORIGINPAGEID int   Default = 0 ID of the BBNC page from which the registration originated
 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 = ''
 BBNCID int   Default = 0
 DONORINFORMATIONALLFIELDS xml Transaction data for the donor information tab with no fields removed
 ADDITIONALDONATION xml
 UNPAIDEVENTREGISTRATIONPAYMENT bit   Default = 0 Indicates whether this transaction is a payment for an existing registration.

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 DONORID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier   NETCOMMUNITYTRANSACTIONPROCESSOR.ID FK to NETCOMMUNITYTRANSACTIONPROCESSOR
 DONORADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID The address type code to use for the address that was previously marked as primary
 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
 GUESTSECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 DONORSITEID uniqueidentifier SITE.ID FK to SITE
 GUESTSITEID 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.

Index Name Field(s) Unique Primary Clustered
 IX_BATCHBBNCEVENTREGISTRATION_BATCHID BATCHID      
 IX_BATCHBBNCEVENTREGISTRATION_DATEADDED DATEADDED    
 IX_BATCHBBNCEVENTREGISTRATION_DATECHANGED DATECHANGED      
 IX_BATCHBBNCEVENTREGISTRATION_DONORID DONORID      
 PK_BATCHBBNCEVENTREGISTRATION ID  

Trigger Name Description
 TR_BATCHBBNCEVENTREGISTRATION_AUDIT_UPDATE
 TR_BATCHBBNCEVENTREGISTRATION_AUDIT_DELETE

Referenced by Field
 BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGES BATCHBBNCEVENTREGISTRATIONID
 BATCHBBNCEVENTREGISTRATIONBATCHUSERMESSAGE ID

Entity-Relationship diagram of this table