| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHID |
uniqueidentifier | FK to BATCH | ||
| NETCOMMUNITYTRANSACTIONPROCESSORID |
uniqueidentifier | FK to NETCOMMUNITYTRANSACTIONPROCESSOR | ||
| ADDEDBY |
nvarchar(255) | Default = '' | ||
| SEQUENCE |
int | Default = 0 | ||
| BBNCID |
int | Default = 0 | ||
| BBNCTRANID |
int | Default = 0 | ||
| ORIGINPAGE |
nvarchar(1000) | Default = '' | ||
| ORIGINPAGEID |
int | Default = 0 | ||
| EMAILSUBJECT |
nvarchar(255) | Default = '' | ||
| EMAILID |
int | Default = 0 | ||
| MEMBERSHIPPROGRAMINFO |
xml |  |
||
| PAYMENTINFO |
xml | |
||
| 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. |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 MEMBERSHIPID |
uniqueidentifier | |
MEMBERSHIP.ID | FK to MEMBERSHIP |
| MEMBERSHIPLEVELID |
uniqueidentifier | |
MEMBERSHIPLEVEL.ID | FK to MEMBERSHIPLEVEL |
| MEMBERSHIPLEVELTERMID |
uniqueidentifier | |
MEMBERSHIPLEVELTERM.ID | FK to MEMBERSHIPLEVELTERM |
| MEMBERSHIPPROGRAMID |
uniqueidentifier | |
MEMBERSHIPPROGRAM.ID | FK to MEMBERSHIPPROGRAM |
| MEMBERSECURITYID |
uniqueidentifier | |
CONSTIT_SECURITY_ATTRIBUTE.ID | FK to CONSTIT_SECURITY_ATTRIBUTE |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| MEMBERSHIPLEVELTYPECODEID |
uniqueidentifier | |
MEMBERSHIPLEVELTYPECODE.ID | FK to MEMBERSHIPLEVELTYPECODE |
| MEMBERSITEID |
uniqueidentifier | |
SITE.ID | FK to SITE |
| PDACCOUNTSYSTEMID |
uniqueidentifier | |
PDACCOUNTSYSTEM.ID | FK to PDACCOUNTSYSTEM |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_BATCHBBNCMEMBERSHIP_BATCHID |
BATCHID | |||
 IX_BATCHBBNCMEMBERSHIP_DATEADDED |
DATEADDED | |
||
| IX_BATCHBBNCMEMBERSHIP_DATECHANGED |
DATECHANGED | |||
| IX_BATCHBBNCMEMBERSHIP_MEMBERSHIPID |
MEMBERSHIPID | |||
| IX_BATCHBBNCMEMBERSHIP_MEMBERSHIPLEVELID |
MEMBERSHIPLEVELID | |||
| IX_BATCHBBNCMEMBERSHIP_MEMBERSHIPLEVELTERMID |
MEMBERSHIPLEVELTERMID | |||
| IX_BATCHBBNCMEMBERSHIP_MEMBERSHIPPROGRAMID |
MEMBERSHIPPROGRAMID | |||
| PK_BATCHBBNCMEMBERSHIP |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_BATCHBBNCMEMBERSHIP_AUDIT_UPDATE |
|
| TR_BATCHBBNCMEMBERSHIP_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGES |
BATCHBBNCMEMBERSHIPID |
| BATCHBBNCMEMBERSHIPBATCHUSERMESSAGE |
ID |
| BATCHBBNCMEMBERSHIPMEMBER |
BATCHBBNCMEMBERSHIPID |