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 |