BATCHBBNCEVENTREGISTRATION (4.0)

Stores NetCommunity event registration transaction batch information.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

BATCHID

uniqueidentifier

false

FK to BATCH

DONORID

uniqueidentifier

true

FK to CONSTITUENT

NETCOMMUNITYTRANSACTIONPROCESSORID

uniqueidentifier

false

FK to NETCOMMUNITYTRANSACTIONPROCESSOR

DONORADDRESSTYPECODEID

uniqueidentifier

true

The address type code to use for the address that was previously marked as primary

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

DONORSECURITYID

uniqueidentifier

true

FK to CONSTIT_SECURITY_ATTRIBUTE

GUESTSECURITYID

uniqueidentifier

true

FK to CONSTIT_SECURITY_ATTRIBUTE

DONORSITEID

uniqueidentifier

true

FK to SITE

GUESTSITEID

uniqueidentifier

true

FK to SITE

PDACCOUNTSYSTEMID

uniqueidentifier

true

FK to PDACCOUNTSYSTEM

ATTRIBUTECURRENCYID

uniqueidentifier

true

Fields
Field Field Type Null Notes Description

LOGGEDINUSER

bit

false

0

Indicates whether the linked constituent was logged in to NetCommunity during the transaction.

BBNCTRANID

int

false

0

ADDEDBY

nvarchar(255)

false

''

BBNCDONORNAME

nvarchar(154)

false

''

Donor name entered through NetCommunity

REGISTRATIONDATE

datetime

true

Date when the transaction occured

DONORINFORMATION

xml

true

Transaction data for the donor information tab

DONORADDRESSINFORMATION

xml

true

Transaction data for the donor address tab

DONORADDRESSINFORMATIONALLFIELDS

xml

true

Transaction data for the donor address tab when adding a new address

DONORADDRESSUPDATE

bit

false

0

Indicates whether existing donor address information should be updated

DONORADDRESSADD

bit

false

0

Indicates whether new donor address information should be added

DONORADDRESSMAKEPRIMARY

bit

false

0

Indicates whether the new donor address information should be added as the primary address

PHONETYPES

xml

true

REGISTRATIONS

xml

true

GUESTS

xml

true

GIFTINFORMATION

xml

true

ORIGINPAGENAME

nvarchar(1000)

false

''

Name of the BBNC page from which the registration originated

ORIGINPAGEID

int

false

0

ID of the BBNC page from which the registration originated

SEQUENCE

int

false

0

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

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

''

BBNCID

int

false

0

DONORINFORMATIONALLFIELDS

xml

true

Transaction data for the donor information tab with no fields removed

ADDITIONALDONATION

xml

true

UNPAIDEVENTREGISTRATIONPAYMENT

bit

false

0

Indicates whether this transaction is a payment for an existing registration.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_BATCHBBNCEVENTREGISTRATION_BATCHID

BATCHID

False

False

False

IX_BATCHBBNCEVENTREGISTRATION_DATEADDED

DATEADDED

False

False

True

IX_BATCHBBNCEVENTREGISTRATION_DATECHANGED

DATECHANGED

False

False

False

IX_BATCHBBNCEVENTREGISTRATION_DONORID

DONORID

False

False

False

PK_BATCHBBNCEVENTREGISTRATION

ID

True

True

False
Triggers
Trigger Name Description

TR_BATCHBBNCEVENTREGISTRATION_AUDIT_UPDATE

TR_BATCHBBNCEVENTREGISTRATION_AUDIT_DELETE

Referenced by
Referenced by Field

BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGES

BATCHBBNCEVENTREGISTRATIONID

BATCHBBNCEVENTREGISTRATIONBATCHUSERMESSAGE

ID