BATCHBBNCEVENTREGISTRATION
Stores Blackbaud Internet Solutions event registration transaction batch information.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| LOGGEDINUSER |
bit |
|
Default = 0 |
Indicates whether the linked constituent was logged in to Blackbaud Internet Solutions during the transaction. |
| BBNCTRANID |
int |
|
Default = 0 |
|
| ADDEDBY |
nvarchar(255) |
|
Default = '' |
|
| BBNCDONORNAME |
nvarchar(154) |
|
Default = '' |
Donor name entered through Blackbaud Internet Solutions |
| REGISTRATIONDATE |
datetime |
yes |
|
Date when the transaction occurred |
| DONORINFORMATION |
xml |
yes |
|
Transaction data for the donor information tab |
| DONORADDRESSINFORMATION |
xml |
yes |
|
Transaction data for the donor address tab |
| DONORADDRESSINFORMATIONALLFIELDS |
xml |
yes |
|
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 |
yes |
|
|
| REGISTRATIONS |
xml |
yes |
|
|
| GUESTS |
xml |
yes |
|
|
| GIFTINFORMATION |
xml |
yes |
|
|
| ORIGINPAGENAME |
nvarchar(1000) |
|
Default = '' |
Name of the Blackbaud Internet Solutions page from which the registration originated |
| ORIGINPAGEID |
int |
|
Default = 0 |
ID of the Blackbaud Internet Solutions 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| DONORIDAUTOMATCH |
nvarchar(255) |
|
Default = '' |
|
| BBNCID |
int |
|
Default = 0 |
|
| DONORINFORMATIONALLFIELDS |
xml |
yes |
|
Transaction data for the donor information tab with no fields removed |
| ADDITIONALDONATION |
xml |
yes |
|
|
| UNPAIDEVENTREGISTRATIONPAYMENT |
bit |
|
Default = 0 |
Indicates whether this transaction is a payment for an existing registration. |
| CONSENT |
xml |
yes |
|
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| BATCHID |
uniqueidentifier |
|
BATCH.ID
|
FK to BATCH |
| DONORID |
uniqueidentifier |
yes |
CONSTITUENT.LOCALID
|
FK to CONSTITUENT |
| NETCOMMUNITYTRANSACTIONPROCESSORID |
uniqueidentifier |
|
NETCOMMUNITYTRANSACTIONPROCESSOR.ID
|
FK to NETCOMMUNITYTRANSACTIONPROCESSOR |
| DONORADDRESSTYPECODEID |
uniqueidentifier |
yes |
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 |
yes |
CONSTIT_SECURITY_ATTRIBUTE.ID
|
FK to CONSTIT_SECURITY_ATTRIBUTE |
| GUESTSECURITYID |
uniqueidentifier |
yes |
CONSTIT_SECURITY_ATTRIBUTE.ID
|
FK to CONSTIT_SECURITY_ATTRIBUTE |
| DONORSITEID |
uniqueidentifier |
yes |
SITE.ID
|
FK to SITE |
| GUESTSITEID |
uniqueidentifier |
yes |
SITE.ID
|
FK to SITE |
| PDACCOUNTSYSTEMID |
uniqueidentifier |
yes |
PDACCOUNTSYSTEM.ID
|
FK to PDACCOUNTSYSTEM |
| ATTRIBUTECURRENCYID |
uniqueidentifier |
yes |
CURRENCY.ID
|
Currency used to parse and commit attributes with a currency data type. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_BATCHBBNCEVENTREGISTRATION_BATCHID |
BATCHID |
|
|
|
| IX_BATCHBBNCEVENTREGISTRATION_DATEADDED |
DATEADDED |
|
|
yes |
| IX_BATCHBBNCEVENTREGISTRATION_DATECHANGED |
DATECHANGED |
|
|
|
| IX_BATCHBBNCEVENTREGISTRATION_DONORID |
DONORID |
|
|
|
| PK_BATCHBBNCEVENTREGISTRATION |
ID |
yes |
yes |
|
Triggers
Referenced by