Stores NetCommunity profile update transaction batch information.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
BATCHID
|
uniqueidentifier
|
false
|
|
FK to BATCH
|
|
LINKID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
NETCOMMUNITYTRANSACTIONPROCESSORID
|
uniqueidentifier
|
false
|
|
FK to NETCOMMUNITYTRANSACTIONPROCESSOR
|
|
PRIMARYBUSINESSORGANIZATIONLINKID
|
uniqueidentifier
|
true
|
|
Existing organization represented by the primary business data.
|
|
PRIMARYBUSINESSADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
Previous business address type
|
|
PREFERREDADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
Previous address type
|
|
SPOUSELINKID
|
uniqueidentifier
|
true
|
|
New spouse for this individual
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
SPOUSESECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
PRIMARYBUSINESSSECURITYID
|
uniqueidentifier
|
true
|
|
FK to CONSTIT_SECURITY_ATTRIBUTE
|
|
SPOUSESITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
PRIMARYBUSINESSSITEID
|
uniqueidentifier
|
true
|
|
FK to SITE
|
|
ATTRIBUTECURRENCYID
|
uniqueidentifier
|
true
|
|
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
BBNCTRANID
|
int
|
false
|
|
|
|
ADDEDBY
|
nvarchar(255)
|
false
|
|
|
|
PRIMARYBUSINESS
|
xml
|
true
|
|
Transaction data for the primary business tab
|
|
PRIMARYBUSINESSALLFIELDS
|
xml
|
true
|
|
Transaction data for the primary business tab when adding a new business address
|
|
PRIMARYBUSINESSUPDATE
|
bit
|
false
|
|
Update the primary business with the downloaded information
|
|
PRIMARYBUSINESSADD
|
bit
|
false
|
|
Add the downloaded information as a new organization relationship
|
|
PRIMARYBUSINESSMAKEPRIMARY
|
bit
|
false
|
|
Make the new organization the primary business
|
|
BIOGRAPHICAL
|
xml
|
true
|
|
Transaction data for the biographical tab
|
|
EDUCATION
|
xml
|
true
|
|
Transaction data for the education tab
|
|
PREFERREDADDRESS
|
xml
|
true
|
|
Transaction data for the preferred address tab
|
|
PREFERREDADDRESSALLFIELDS
|
xml
|
true
|
|
Transaction data for the preferred address tab when adding a new address
|
|
PREFERREDADDRESSUPDATE
|
bit
|
false
|
|
Update the preferred address with the downloaded information
|
|
PREFERREDADDRESSADD
|
bit
|
false
|
|
Add the downloaded information as a new preferred address
|
|
PREFERREDADDRESSMAKEPRIMARY
|
bit
|
false
|
|
Make the new address the preferred address
|
|
PHONETYPES
|
xml
|
true
|
|
|
|
SPOUSE
|
xml
|
true
|
|
Transaction data for the spouse tab
|
|
SPOUSEREMOVE
|
bit
|
false
|
|
Remove this spouse from the constituent record
|
|
SAMESPOUSE
|
bit
|
false
|
|
This name change is for the same spouse record
|
|
SPOUSEOLDNAME
|
nvarchar(200)
|
false
|
|
Full name of this constituent's current spouse
|
|
CONSTITUENTATTRIBUTES
|
xml
|
true
|
|
Transaction data for the constituent attributes tab
|
|
EDUCATIONATTRIBUTES
|
xml
|
true
|
|
Transaction data for the education attributes tab
|
|
SEQUENCE
|
int
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
PRIMARYBUSINESSAUTOMATCH
|
nvarchar(255)
|
false
|
|
|
|
BBNCID
|
int
|
false
|
|
|
|
ISORGANIZATIONUPDATE
|
bit
|
false
|
|
Indicates that this profile transaction was made against an organization.
|
|
ADDITIONALADDRESSES
|
xml
|
true
|
|
Transaction data for the additional addresses tab
|
|
EMPLOYMENTHISTORY
|
xml
|
true
|
|
Transaction data for the employment tab
|
|
EDUCATIONALHISTORY
|
xml
|
true
|
|
Transaction data for the educational history tab
|
|
EDUCATIONALINVOLVEMENTS
|
xml
|
true
|
|
|
|
PHONENUMBERS
|
xml
|
true
|
|
|
|
EMAILADDRESSES
|
xml
|
true
|
|
|
|
ORGRELATIONSHIPS
|
xml
|
true
|
|
|
|
NAMEFORMATS
|
xml
|
true
|
|
|
