| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| 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 | NetCommunity client user ID. | |
| SIGNUPTRANSACTIONDATE |
datetime |  |
Time when the signuptransaction was created. | |
| BIOGRAPHICAL |
xml | |
Transaction data for the biographical tab | |
| PREFERREDADDRESS |
xml | |
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 | |
||
| CONSTITUENTATTRIBUTES |
xml | |
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) | |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| LINKIDAUTOMATCH |
nvarchar(255) | Default = '' | ||
| BBNCID |
int | Default = 0 | ||
| BIOGRAPHICALALLFIELDS |
xml | |
Transaction data for the biographical tab with no data removed | |
| PREFERREDADDRESSALLFIELDS |
xml | |
Transaction data for the preferred address tab with no data removed |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHID |
uniqueidentifier | BATCH.ID | FK to BATCH | |
| LINKID |
uniqueidentifier | |
CONSTITUENT.LOCALID | FK to CONSTITUENT |
| NETCOMMUNITYTRANSACTIONPROCESSORID |
uniqueidentifier | NETCOMMUNITYTRANSACTIONPROCESSOR.ID | FK to NETCOMMUNITYTRANSACTIONPROCESSOR | |
| PREFERREDADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | Previous address type |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| LINKEDCONSTITUENTSECURITYID |
uniqueidentifier | |
CONSTIT_SECURITY_ATTRIBUTE.ID | FK to CONSTIT_SECURITY_ATTRIBUTE |
| LINKEDCONSTITUENTSITEID |
uniqueidentifier | |
SITE.ID | FK to SITE |
| ATTRIBUTECURRENCYID |
uniqueidentifier | |
CURRENCY.ID | Currency used to parse and commit attributes with a currency data type. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_BATCHBBNCSIGNUP_BATCHID |
BATCHID | |||
 IX_BATCHBBNCSIGNUP_DATEADDED |
DATEADDED | |
||
| IX_BATCHBBNCSIGNUP_DATECHANGED |
DATECHANGED | |||
| IX_BATCHBBNCSIGNUP_LINKID |
LINKID | |||
| PK_BATCHBBNCSIGNUP |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_BATCHBBNCSIGNUP_AUDIT_UPDATE |
|
| TR_BATCHBBNCSIGNUP_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHBBNCSIGNUPBATCHSYSTEMMESSAGES |
BATCHBBNCSIGNUPID |
| BATCHBBNCSIGNUPBATCHUSERMESSAGE |
ID |