| BBNCTRANID |
int |
|
Default = 0 |
|
| ADDEDBY |
nvarchar(255) |
|
Default = '' |
|
| PRIMARYBUSINESS |
xml |
yes |
|
Transaction data for the primary business tab |
| PRIMARYBUSINESSALLFIELDS |
xml |
yes |
|
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 |
yes |
|
Transaction data for the biographical tab |
| EDUCATION |
xml |
yes |
|
Transaction data for the education tab |
| PREFERREDADDRESS |
xml |
yes |
|
Transaction data for the preferred address tab |
| PREFERREDADDRESSALLFIELDS |
xml |
yes |
|
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 |
yes |
|
|
| SPOUSE |
xml |
yes |
|
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 |
yes |
|
Transaction data for the constituent attributes tab |
| EDUCATIONATTRIBUTES |
xml |
yes |
|
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) |
yes |
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 |
yes |
|
Transaction data for the additional addresses tab |
| EMPLOYMENTHISTORY |
xml |
yes |
|
Transaction data for the employment tab |
| EDUCATIONALHISTORY |
xml |
yes |
|
Transaction data for the educational history tab |
| EDUCATIONALINVOLVEMENTS |
xml |
yes |
|
Transaction data for the educational involvements tab |
| PHONENUMBERS |
xml |
yes |
|
Transaction data for the phone number tab |
| EMAILADDRESSES |
xml |
yes |
|
Transaction data for the email address tab |
| ORGRELATIONSHIPS |
xml |
yes |
|
Transaction data for the organization relationships tab |
| NAMEFORMATS |
xml |
yes |
|
Transaction data for the name format tab |