BATCHBBNCSIGNUP
Stores Blackbaud Internet Solutions signup transaction batch information.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| BBNCTRANID |
int |
|
Default = 0 |
|
| ADDEDBY |
nvarchar(255) |
|
Default = '' |
|
| BBNCCONSTITNAME |
nvarchar(154) |
|
Default = '' |
|
| BBNCADDRESS |
nvarchar(300) |
|
Default = '' |
|
| ISORGANIZATION |
bit |
|
Default = 0 |
|
| BBNCUSERID |
int |
|
Default = 0 |
Blackbaud Internet Solutions client user ID. |
| SIGNUPTRANSACTIONDATE |
datetime |
yes |
|
Time when the signuptransaction was created. |
| BIOGRAPHICAL |
xml |
yes |
|
Transaction data for the biographical tab |
| PREFERREDADDRESS |
xml |
yes |
|
Transaction data for the preferred address tab |
| PREFERREDADDRESSUPDATE |
bit |
|
Default = 1 |
Update the preferred address with the downloaded information |
| PREFERREDADDRESSADD |
bit |
|
Default = 0 |
Add the downloaded information as a new preferred address |
| PREFERREDADDRESSMAKEPRIMARY |
bit |
|
Default = 0 |
Make the new address the preferred address |
| PHONETYPES |
xml |
yes |
|
|
| CONSTITUENTATTRIBUTES |
xml |
yes |
|
Transaction data for the constituent attributes tab. |
| 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. |
| LINKIDAUTOMATCH |
nvarchar(255) |
|
Default = '' |
|
| BBNCID |
int |
|
Default = 0 |
|
| BIOGRAPHICALALLFIELDS |
xml |
yes |
|
Transaction data for the biographical tab with no data removed |
| PREFERREDADDRESSALLFIELDS |
xml |
yes |
|
Transaction data for the preferred address tab with no data removed |
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| BATCHID |
uniqueidentifier |
|
BATCH.ID
|
FK to BATCH |
| LINKID |
uniqueidentifier |
yes |
CONSTITUENT.LOCALID
|
FK to CONSTITUENT |
| NETCOMMUNITYTRANSACTIONPROCESSORID |
uniqueidentifier |
|
NETCOMMUNITYTRANSACTIONPROCESSOR.ID
|
FK to NETCOMMUNITYTRANSACTIONPROCESSOR |
| PREFERREDADDRESSTYPECODEID |
uniqueidentifier |
yes |
ADDRESSTYPECODE.ID
|
Previous address type |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| LINKEDCONSTITUENTSECURITYID |
uniqueidentifier |
yes |
CONSTIT_SECURITY_ATTRIBUTE.ID
|
FK to CONSTIT_SECURITY_ATTRIBUTE |
| LINKEDCONSTITUENTSITEID |
uniqueidentifier |
yes |
SITE.ID
|
FK to SITE |
| 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_BATCHBBNCSIGNUP_BATCHID |
BATCHID |
|
|
|
| IX_BATCHBBNCSIGNUP_DATEADDED |
DATEADDED |
|
|
yes |
| IX_BATCHBBNCSIGNUP_DATECHANGED |
DATECHANGED |
|
|
|
| IX_BATCHBBNCSIGNUP_LINKID |
LINKID |
|
|
|
| PK_BATCHBBNCSIGNUP |
ID |
yes |
yes |
|
Triggers
Referenced by