Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 BBNCTRANID int   Default = 0
 ADDEDBY nvarchar(255)   Default = ''
 PRIMARYBUSINESS xml Transaction data for the primary business tab
 PRIMARYBUSINESSALLFIELDS xml Transaction data for the primary business tab when adding a new business address
 PRIMARYBUSINESSUPDATE bit   Default = 1 Update the primary business with the downloaded information
 PRIMARYBUSINESSADD bit   Default = 0 Add the downloaded information as a new organization relationship
 PRIMARYBUSINESSMAKEPRIMARY bit   Default = 0 Make the new organization the primary business
 BIOGRAPHICAL xml Transaction data for the biographical tab
 EDUCATION xml Transaction data for the education tab
 PREFERREDADDRESS xml Transaction data for the preferred address tab
 PREFERREDADDRESSALLFIELDS xml Transaction data for the preferred address tab when adding a new address
 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
 SPOUSE xml Transaction data for the spouse tab
 SPOUSEREMOVE bit   Default = 0 Remove this spouse from the constituent record
 SAMESPOUSE bit   Default = 1 This name change is for the same spouse record
 SPOUSEOLDNAME nvarchar(200)   Default = '' Full name of this constituent's current spouse
 CONSTITUENTATTRIBUTES xml Transaction data for the constituent attributes tab
 EDUCATIONATTRIBUTES xml Transaction data for the education 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.
 PRIMARYBUSINESSAUTOMATCH nvarchar(255)   Default = ''
 BBNCID int   Default = 0
 ISORGANIZATIONUPDATE bit   Default = 0 Indicates that this profile transaction was made against an organization.
 ADDITIONALADDRESSES xml Transaction data for the additional addresses tab
 EMPLOYMENTHISTORY xml Transaction data for the employment tab
 EDUCATIONALHISTORY xml Transaction data for the educational history tab
 EDUCATIONALINVOLVEMENTS xml Transaction data for the educational involvements tab
 PHONENUMBERS xml Transaction data for the phone number tab
 EMAILADDRESSES xml Transaction data for the email address tab
 ORGRELATIONSHIPS xml Transaction data for the organization relationships tab
 NAMEFORMATS xml

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
 PRIMARYBUSINESSORGANIZATIONLINKID uniqueidentifier CONSTITUENT.LOCALID Existing organization represented by the primary business data.
 PRIMARYBUSINESSADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID Previous business address type
 PREFERREDADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID Previous address type
 SPOUSELINKID uniqueidentifier CONSTITUENT.LOCALID New spouse for this individual
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SPOUSESECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 PRIMARYBUSINESSSECURITYID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 SPOUSESITEID uniqueidentifier SITE.ID FK to SITE
 PRIMARYBUSINESSSITEID 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_BATCHBBNCPROFILE_BATCHID BATCHID      
 IX_BATCHBBNCPROFILE_DATEADDED DATEADDED    
 IX_BATCHBBNCPROFILE_DATECHANGED DATECHANGED      
 IX_BATCHBBNCPROFILE_LINKID LINKID      
 IX_BATCHBBNCPROFILE_PRIMARYBUSINESSORGANIZATIONLINKID PRIMARYBUSINESSORGANIZATIONLINKID      
 IX_BATCHBBNCPROFILE_SPOUSELINKID SPOUSELINKID      
 PK_BATCHBBNCPROFILE ID  

Trigger Name Description
 TR_BATCHBBNCPROFILE_AUDIT_UPDATE
 TR_BATCHBBNCPROFILE_AUDIT_DELETE

Referenced by Field
 BATCHBBNCPROFILEBATCHSYSTEMMESSAGES BATCHBBNCPROFILEID
 BATCHBBNCPROFILEBATCHUSERMESSAGE ID

Entity-Relationship diagram of this table