Stores Blackbaud Internet Solutions donation transaction batch information.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
BATCHID
|
uniqueidentifier
|
false
|
|
FK to BATCH
|
|
NETCOMMUNITYTRANSACTIONPROCESSORID
|
uniqueidentifier
|
false
|
|
FK to NETCOMMUNITYTRANSACTIONPROCESSOR
|
|
ORIGINAPPEALID
|
uniqueidentifier
|
true
|
|
Stores the source appeal for a donation.
|
|
DONORID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
CORPORATEDONORID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
APPEALID
|
uniqueidentifier
|
true
|
|
FK to APPEAL
|
|
MGCONSTITUENTID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
DONORADDRESSINFORMATIONADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to ADDRESSTYPECODE
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
DONORSECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
CORPORATEDONORSECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
MGCOMPANYSECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
TRIBUTEID
|
uniqueidentifier
|
true
|
|
FK to TRIBUTE
|
|
TRIBUTEACKNOWLEDGEELINKID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
TRIBUTETYPECODEID
|
uniqueidentifier
|
true
|
|
FK to TRIBUTETYPECODE
|
|
TRIBUTEACKNOWLEDGEESECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
DONORSITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
CORPORATEDONORSITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
MGCOMPANYSITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
TRIBUTEACKNOWLEDGEESITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
SPOUSELINKID
|
uniqueidentifier
|
true
|
|
New spouse for this individual
|
|
SPOUSESECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
SPOUSESITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
PDACCOUNTSYSTEMID
|
uniqueidentifier
|
true
|
|
FK to PDACCOUNTSYSTEM
|
|
ATTRIBUTECURRENCYID
|
uniqueidentifier
|
true
|
|
Currency used to parse and commit attributes with a currency data type.
|
|
CATEGORYCODEID
|
uniqueidentifier
|
true
|
|
Foreign key to the GLREVENUECATEGORYMAPPING table.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
BBNCTRANSACTIONGUID
|
uniqueidentifier
|
true
|
|
|
|
BBNCTRANID
|
int
|
false
|
|
|
|
ORIGINPAGE
|
nvarchar(1000)
|
false
|
|
|
|
ORIGINPAGEID
|
int
|
false
|
|
|
|
ADDEDBY
|
nvarchar(255)
|
false
|
|
|
|
LOGGEDINUSER
|
bit
|
false
|
|
Indicates whether the linked constituent was logged in to Blackbaud Internet Solutions during the transaction.
|
|
DONORINFORMATION
|
xml
|
false
|
|
|
|
DONORADDRESSINFORMATION
|
xml
|
false
|
|
|
|
DONORADDRESSINFORMATIONALLFIELDS
|
xml
|
true
|
|
|
|
PHONETYPES
|
xml
|
true
|
|
|
|
GIFTINFORMATION
|
xml
|
false
|
|
|
|
GIFTATTRIBUTEINFORMATION
|
xml
|
false
|
|
|
|
MGINFORMATIONFROMMFO
|
bit
|
false
|
|
Indicates if Blackbaud Internet Solutions recieved the information from MatchFinder Online.
|
|
UPDATEMGINFORMATIONFROMMFO
|
bit
|
false
|
|
|
|
MGINFORMATION
|
xml
|
false
|
|
|
|
DONORADDRESSINFORMATIONDONOTHING
|
bit
|
false
|
|
|
|
DONORADDRESSINFORMATIONCREATENEW
|
bit
|
false
|
|
|
|
DONORADDRESSINFORMATIONUPDATE
|
bit
|
false
|
|
|
|
DONORADDRESSINFORMATIONMAKEPRIMARY
|
bit
|
false
|
|
|
|
DONOTRECEIPT
|
bit
|
false
|
|
|
|
DONOTACKNOWLEDGE
|
bit
|
false
|
|
|
|
SEQUENCE
|
int
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
DONORIDAUTOMATCH
|
nvarchar(255)
|
false
|
|
|
|
CORPORATEDONORIDAUTOMATCH
|
nvarchar(255)
|
false
|
|
|
|
MGCONSTITUENTIDAUTOMATCH
|
nvarchar(255)
|
false
|
|
|
|
ISTEAMFUNDRAISINGOFFLINEGIFT
|
bit
|
false
|
|
|
|
BBNCID
|
int
|
false
|
|
|
|
DONORINFORMATIONALLFIELDS
|
xml
|
true
|
|
|
|
TRIBUTENAME
|
nvarchar(500)
|
false
|
|
|
|
TRIBUTEDESCRIPTION
|
nvarchar(500)
|
false
|
|
|
|
ADDTRIBUTEACKNOWLEDGEE
|
bit
|
false
|
|
|
|
UPDATETRIBUTEACKNOWLEDGEEADDRESS
|
bit
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEENAME
|
nvarchar(250)
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEEEMAIL
|
nvarchar(100)
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEESTREETADDRESS
|
nvarchar(300)
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEECITY
|
nvarchar(100)
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEESTATE
|
nvarchar(100)
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEEPOSTCODE
|
nvarchar(12)
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEECOUNTRY
|
nvarchar(100)
|
false
|
|
|
|
APPLYTRIBUTETODONATION
|
bit
|
false
|
|
|
|
TRIBUTEACKNOWLEDGEEPHONE
|
nvarchar(100)
|
false
|
|
|
|
REMOVESPOUSE
|
bit
|
false
|
|
|
|
SPOUSEINFORMATION
|
xml
|
true
|
|
|
|
SAMESPOUSE
|
bit
|
false
|
|
This name change is for the same spouse record
|
|
SPOUSEOLDNAME
|
nvarchar(200)
|
false
|
|
Full name of this constituent's current spouse
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_BATCHBBNCDONATION_BATCHID
|
|
False
|
False
|
False
|
|
IX_BATCHBBNCDONATION_CORPORATEDONORID
|
|
False
|
False
|
False
|
|
IX_BATCHBBNCDONATION_DATEADDED
|
|
False
|
False
|
True
|
|
IX_BATCHBBNCDONATION_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_BATCHBBNCDONATION_DONORID
|
|
False
|
False
|
False
|
|
IX_BATCHBBNCDONATION_MGCONSTITUENTID
|
|
False
|
False
|
False
|
|
IX_BATCHBBNCDONATION_SPOUSELINKID
|
|
False
|
False
|
False
|
|
IX_BATCHBBNCDONATION_TRIBUTEACKNOWLEDGEELINKID
|
TRIBUTEACKNOWLEDGEELINKID
|
False
|
False
|
False
|
|
PK_BATCHBBNCDONATION
|
|
True
|
True
|
False
|
