| SEQUENCE |
int |
|
Default = 0 |
|
| CONSTITUENTTYPECODE |
tinyint |
|
Default = 0 |
0=Individual, 1=Organization, 2=Household, 3=Constituent group |
| CONSTITUENTTYPE |
nvarchar(17) (Computed) |
yes |
CASE [CONSTITUENTTYPECODE] WHEN 0 THEN N'Individual' WHEN 1 THEN N'Organization' WHEN 2 THEN N'Household' WHEN 3 THEN N'Constituent group' END |
Provides a translation for the 'CONSTITUENTTYPECODE' field. |
| BIRTHDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| FIRSTNAME |
nvarchar(50) |
|
Default = '' |
|
| GENDERCODE |
tinyint |
|
Default = 0 |
0=Unknown, 1=Male, 2=Female |
| GIVESANONYMOUSLY |
bit |
|
Default = 0 |
|
| KEYNAME |
nvarchar(100) |
|
Default = '' |
|
| LOOKUP_ID |
nvarchar(100) |
|
Default = '' |
|
| MAIDENNAME |
nvarchar(100) |
|
Default = '' |
|
| MIDDLENAME |
nvarchar(50) |
|
Default = '' |
|
| NICKNAME |
nvarchar(50) |
|
Default = '' |
|
| WEBADDRESS |
UDT_WEBADDRESS |
|
Default = '' |
|
| DECEASED |
bit |
|
Default = 0 |
|
| DECEASEDDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| CONSTITUENT_SITEID |
uniqueidentifier |
yes |
|
|
| GROUPTYPEID |
uniqueidentifier |
yes |
|
|
| GROUPDESCRIPTION |
nvarchar(300) |
|
Default = '' |
|
| GROUPSTARTDATE |
date |
yes |
|
|
| ORG_NUMEMPLOYEES |
int |
|
Default = 0 |
|
| ORG_NUMSUBSIDIARIES |
int |
|
Default = 0 |
|
| SPOUSE_FIRSTNAME |
nvarchar(50) |
|
Default = '' |
|
| SPOUSE_NICKNAME |
nvarchar(50) |
|
Default = '' |
|
| SPOUSE_MIDDLENAME |
nvarchar(50) |
|
Default = '' |
|
| SPOUSE_MAIDENNAME |
nvarchar(100) |
|
Default = '' |
|
| SPOUSE_LASTNAME |
nvarchar(100) |
|
Default = '' |
|
| SPOUSE_BIRTHDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| SPOUSE_GENDERCODE |
tinyint |
|
Default = 0 |
0=Unknown, 1=Male, 2=Female |
| SPOUSE_LOOKUPID |
nvarchar(100) |
|
Default = '' |
|
| BUSINESS_ADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
|
| BUSINESS_CART |
nvarchar(10) |
|
Default = '' |
|
| BUSINESS_CITY |
nvarchar(50) |
|
Default = '' |
|
| BUSINESS_DONOTMAIL |
bit |
|
Default = 0 |
|
| BUSINESS_DPC |
nvarchar(8) |
|
Default = '' |
|
| BUSINESS_EMAILADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
|
| BUSINESS_LOOKUPID |
nvarchar(100) |
|
Default = '' |
|
| BUSINESS_LOT |
nvarchar(5) |
|
Default = '' |
|
| BUSINESS_NAME |
nvarchar(100) |
|
Default = '' |
|
| BUSINESS_NUMEMPLOYEES |
int |
|
Default = 0 |
|
| BUSINESS_NUMSUBSIDIARIES |
int |
|
Default = 0 |
|
| BUSINESS_PHONENUMBER |
nvarchar(100) |
|
Default = '' |
|
| BUSINESS_WEBADDRESS |
UDT_WEBADDRESS |
|
Default = '' |
|
| BUSINESS_POSTCODE |
nvarchar(12) |
|
Default = '' |
|
| 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. |
| BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS |
bit |
|
Default = 0 |
|
| BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR |
decimal(5, 2) |
|
Default = 0 |
|
| BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS |
bit |
|
Default = 0 |
|
| BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR |
decimal(5, 2) |
|
Default = 0 |
|
| BUSINESS_EMAILADDRESSSTARTDATE |
date |
yes |
|
|
| SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS |
bit |
|
Default = 0 |
|
| SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR |
decimal(5, 2) |
|
Default = 0 |
|
| SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS |
bit |
|
Default = 0 |
|
| SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR |
decimal(5, 2) |
|
Default = 0 |
|
| REMOVESPOUSE |
bit |
|
Default = 0 |
|
| DOMANUALREVIEWFORAUTOMATCH |
bit |
|
Default = 0 |
|
| DIFFERENTPHONECODE |
tinyint |
|
Default = 3 |
|
| NEWPHONEENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWPHONEPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| DIFFERENTEMAILCODE |
tinyint |
|
Default = 3 |
|
| NEWEMAILENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWEMAILPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| USEGLOBALSETTINGS |
bit |
|
Default = 1 |
|
| DIFFERENTEMAIL |
nvarchar(42) (Computed) |
yes |
CASE [DIFFERENTEMAILCODE] WHEN 0 THEN N'Ignore email address' WHEN 3 THEN N'Add as new email address' WHEN 2 THEN N'Require manual review (generate exception)' END |
|
| CREATEHISTORICALNAMECODE |
tinyint |
|
Default = 1 |
|
| CREATEHISTORICALNAME |
nvarchar(3) (Computed) |
yes |
CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END |
|
| NAMECODE |
tinyint |
|
Default = 1 |
|
| SIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| UNSIMILARADDRESSCODE |
tinyint |
|
Default = 3 |
|
| UNSIMILARADDRESS |
nvarchar(42) (Computed) |
yes |
CASE [UNSIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 3 THEN N'Add as new address' WHEN 2 THEN N'Require manual review (generate exception)' END |
|
| NEWADDRESSENDDATECODE |
tinyint |
|
Default = 0 |
|
| NEWADDRESSPRIMARYCODE |
tinyint |
|
Default = 1 |
|
| BIRTHDATERULECODE |
tinyint |
|
Default = 1 |
|
| NAME |
nvarchar(42) (Computed) |
yes |
CASE [NAMECODE] WHEN 0 THEN N'Ignore name' WHEN 1 THEN N'Update name' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add name as an alias' END |
|
| SIMILARADDRESS |
nvarchar(63) (Computed) |
yes |
CASE [SIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 1 THEN N'Update existing address (old address data will not be retained)' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END |
|
| NEWADDRESSENDDATE |
nvarchar(30) (Computed) |
yes |
CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'Make existing address inactive' WHEN 1 THEN N'Keep existing address active' END |
|
| NEWADDRESSPRIMARY |
nvarchar(61) (Computed) |
yes |
CASE [NEWADDRESSPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary address has the same address type' WHEN 2 THEN N'Always' END |
|
| DIFFERENTPHONE |
nvarchar(42) (Computed) |
yes |
CASE [DIFFERENTPHONECODE] WHEN 0 THEN N'Ignore phone' WHEN 3 THEN N'Add as new phone' WHEN 2 THEN N'Require manual review (generate exception)' END |
|
| NEWPHONEENDDATE |
nvarchar(28) (Computed) |
yes |
CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'Make existing phone inactive' WHEN 1 THEN N'Keep existing phone active' END |
|
| NEWPHONEPRIMARY |
nvarchar(57) (Computed) |
yes |
CASE [NEWPHONEPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary phone has the same phone type' WHEN 2 THEN N'Always' END |
|
| NEWEMAILENDDATE |
nvarchar(36) (Computed) |
yes |
CASE [NEWEMAILENDDATECODE] WHEN 0 THEN N'Make existing email address inactive' WHEN 1 THEN N'Keep existing email address active' END |
|
| NEWEMAILPRIMARY |
nvarchar(65) (Computed) |
yes |
CASE [NEWEMAILPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary email address has the same email type' WHEN 2 THEN N'Always' END |
|
| REQUESTSNOEMAIL |
bit |
|
Default = 0 |
|
| BIRTHDATERULE |
nvarchar(17) (Computed) |
yes |
CASE [BIRTHDATERULECODE] WHEN 0 THEN N'Ignore birth date' WHEN 1 THEN N'Update birth date' END |
|
| ROWFROMBATCHUI |
bit |
|
Default = 0 |
|
| ORIGINAL_KEYNAME |
nvarchar(100) |
|
Default = '' |
|
| ORIGINAL_FIRSTNAME |
nvarchar(50) |
|
Default = '' |
|
| GENDER |
nvarchar(7) (Computed) |
yes |
CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' WHEN 3 THEN N'Other' END |
|
| SPOUSE_GENDER |
nvarchar(7) (Computed) |
yes |
CASE [SPOUSE_GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' WHEN 3 THEN N'Other' END |
|