BATCHBBNCSIGNUP (4.0SP17)

Stores Blackbaud Internet Solutions signup transaction batch information.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier	false	BATCH.ID	FK to BATCH
LINKID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	false	NETCOMMUNITYTRANSACTIONPROCESSOR.ID	FK to NETCOMMUNITYTRANSACTIONPROCESSOR
PREFERREDADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	Previous address type
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
LINKEDCONSTITUENTSECURITYID	uniqueidentifier	true	CONSTIT_SECURITY_ATTRIBUTE.ID	FK to CONSTIT_SECURITY_ATTRIBUTE
LINKEDCONSTITUENTSITEID	uniqueidentifier	true	SITE.ID	FK to SITE
ATTRIBUTECURRENCYID	uniqueidentifier	true	CURRENCY.ID	Currency used to parse and commit attributes with a currency data type.

Fields
Field	Field Type	Null	Notes	Description
BBNCTRANID	int	false	0
ADDEDBY	nvarchar(255)	false	''
BBNCCONSTITNAME	nvarchar(154)	false	''
BBNCADDRESS	nvarchar(300)	false	''
ISORGANIZATION	bit	false	0
BBNCUSERID	int	false	0	Blackbaud Internet Solutions client user ID.
SIGNUPTRANSACTIONDATE	datetime	true		Time when the signuptransaction was created.
BIOGRAPHICAL	xml	true		Transaction data for the biographical tab
PREFERREDADDRESS	xml	true		Transaction data for the preferred address tab
PREFERREDADDRESSUPDATE	bit	false	1	Update the preferred address with the downloaded information
PREFERREDADDRESSADD	bit	false	0	Add the downloaded information as a new preferred address
PREFERREDADDRESSMAKEPRIMARY	bit	false	0	Make the new address the preferred address
PHONETYPES	xml	true
CONSTITUENTATTRIBUTES	xml	true		Transaction data for the constituent attributes tab.
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.
LINKIDAUTOMATCH	nvarchar(255)	false	''
BBNCID	int	false	0
BIOGRAPHICALALLFIELDS	xml	true		Transaction data for the biographical tab with no data removed
PREFERREDADDRESSALLFIELDS	xml	true		Transaction data for the preferred address tab with no data removed

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BATCHBBNCSIGNUP_BATCHID	BATCHID	False	False	False
IX_BATCHBBNCSIGNUP_DATEADDED	DATEADDED	False	False	True
IX_BATCHBBNCSIGNUP_DATECHANGED	DATECHANGED	False	False	False
IX_BATCHBBNCSIGNUP_LINKID	LINKID	False	False	False
PK_BATCHBBNCSIGNUP	ID	True	True	False

Triggers
Trigger Name	Description
TR_BATCHBBNCSIGNUP_AUDIT_UPDATE
TR_BATCHBBNCSIGNUP_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHBBNCSIGNUPBATCHSYSTEMMESSAGES	BATCHBBNCSIGNUPID
BATCHBBNCSIGNUPBATCHUSERMESSAGE	ID