BATCHCONSTITUENTUPDATE (4.0SP12)

Stores constituentupdate batch information.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier	false	BATCH.ID	FK to BATCH
PRIMARYRECORDID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
SUFFIXCODEID	uniqueidentifier	true	SUFFIXCODE.ID	FK to SUFFIXCODE
TITLECODEID	uniqueidentifier	true	TITLECODE.ID	FK to TITLECODE
PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
ORG_INDUSTRYCODEID	uniqueidentifier	true	INDUSTRYCODE.ID	FK to INDUSTRYCODE
ORG_PARENTCORPID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
MARITALSTATUSCODEID	uniqueidentifier	true	MARITALSTATUSCODE.ID	FK to MARITALSTATUSCODE
SPOUSE_ID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
SPOUSE_TITLECODEID	uniqueidentifier	true	TITLECODE.ID	FK to TITLECODE
SPOUSE_SUFFIXCODEID	uniqueidentifier	true	SUFFIXCODE.ID	FK to SUFFIXCODE
SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	true	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	true	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
BUSINESS_ID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
BUSINESS_ADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
BUSINESS_COUNTRYID	uniqueidentifier	true	COUNTRY.ID	FK to COUNTRY
BUSINESS_DONOTMAILREASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	FK to DONOTMAILREASONCODE
BUSINESS_EMAILADDRESSTYPECODEID	uniqueidentifier	true	EMAILADDRESSTYPECODE.ID	FK to EMAILADDRESSTYPECODE
BUSINESS_INDUSTRYCODEID	uniqueidentifier	true	INDUSTRYCODE.ID	FK to INDUSTRYCODE
BUSINESS_PARENTCORPID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
BUSINESS_PHONETYPECODEID	uniqueidentifier	true	PHONETYPECODE.ID	FK to PHONETYPECODE
BUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	true	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	true	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
BUSINESS_STATEID	uniqueidentifier	true	STATE.ID	FK to STATE
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
BUSINESS_PHONE_COUNTRYID	uniqueidentifier	true	COUNTRY.ID	FK to COUNTRY
BUSINESS_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	true	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
BUSINESS_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	true	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
SPOUSE_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	true	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
SPOUSE_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	true	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE

Fields
Field	Field Type	Null	Notes	Description
SEQUENCE	int	false	0
CONSTITUENTTYPECODE	tinyint	false	0	0=Individual, 1=Organization, 2=Household, 3=Constituent group
CONSTITUENTTYPE	nvarchar(17) (Computed)	true		Provides a translation for the 'CONSTITUENTTYPECODE' field.
BIRTHDATE	UDT_FUZZYDATE	false	'00000000'
FIRSTNAME	nvarchar(50)	false	''
GENDERCODE	tinyint	false	0	0=Unknown, 1=Male, 2=Female
GENDER	nvarchar(7) (Computed)	true		Provides a translation for the 'GENDERCODE' field.
GIVESANONYMOUSLY	bit	false	0
KEYNAME	nvarchar(100)	false	''
LOOKUP_ID	nvarchar(100)	false	''
MAIDENNAME	nvarchar(100)	false	''
MIDDLENAME	nvarchar(50)	false	''
NICKNAME	nvarchar(50)	false	''
WEBADDRESS	UDT_WEBADDRESS	false	''
DECEASED	bit	false	0
DECEASEDDATE	UDT_FUZZYDATE	false	'00000000'
CONSTITUENT_SITEID	uniqueidentifier	true
GROUPTYPEID	uniqueidentifier	true
GROUPDESCRIPTION	nvarchar(300)	false	''
GROUPSTARTDATE	date	true
ORG_NUMEMPLOYEES	int	false	0
ORG_NUMSUBSIDIARIES	int	false	0
SPOUSE_FIRSTNAME	nvarchar(50)	false	''
SPOUSE_NICKNAME	nvarchar(50)	false	''
SPOUSE_MIDDLENAME	nvarchar(50)	false	''
SPOUSE_MAIDENNAME	nvarchar(100)	false	''
SPOUSE_LASTNAME	nvarchar(100)	false	''
SPOUSE_BIRTHDATE	UDT_FUZZYDATE	false	'00000000'
SPOUSE_GENDERCODE	tinyint	false	0	0=Unknown, 1=Male, 2=Female
SPOUSE_GENDER	nvarchar(7) (Computed)	true		Provides a translation for the 'SPOUSE_GENDERCODE' field.
SPOUSE_LOOKUPID	nvarchar(100)	false	''
BUSINESS_ADDRESSBLOCK	nvarchar(150)	false	''
BUSINESS_CART	nvarchar(10)	false	''
BUSINESS_CITY	nvarchar(50)	false	''
BUSINESS_DONOTMAIL	bit	false	0
BUSINESS_DPC	nvarchar(8)	false	''
BUSINESS_EMAILADDRESS	UDT_EMAILADDRESS	false	''
BUSINESS_LOOKUPID	nvarchar(100)	false	''
BUSINESS_LOT	nvarchar(5)	false	''
BUSINESS_NAME	nvarchar(100)	false	''
BUSINESS_NUMEMPLOYEES	int	false	0
BUSINESS_NUMSUBSIDIARIES	int	false	0
BUSINESS_PHONENUMBER	nvarchar(100)	false	''
BUSINESS_WEBADDRESS	UDT_WEBADDRESS	false	''
BUSINESS_POSTCODE	nvarchar(12)	false	''
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	false	0
BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	false	0
BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	false	0
BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	false	0
BUSINESS_EMAILADDRESSSTARTDATE	date	true
SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	false	0
SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	false	0
SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	false	0
SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	false	0
REMOVESPOUSE	bit	false	0
DOMANUALREVIEWFORAUTOMATCH	bit	false	0
DIFFERENTPHONECODE	tinyint	false	3
NEWPHONEENDDATECODE	tinyint	false	0
NEWPHONEPRIMARYCODE	tinyint	false	1
DIFFERENTEMAILCODE	tinyint	false	3
NEWEMAILENDDATECODE	tinyint	false	0
NEWEMAILPRIMARYCODE	tinyint	false	1
USEGLOBALSETTINGS	bit	false	1
DIFFERENTEMAIL	nvarchar(42) (Computed)	true
CREATEHISTORICALNAMECODE	tinyint	false	1
CREATEHISTORICALNAME	nvarchar(3) (Computed)	true
NAMECODE	tinyint	false	1
SIMILARADDRESSCODE	tinyint	false	3
UNSIMILARADDRESSCODE	tinyint	false	3
UNSIMILARADDRESS	nvarchar(42) (Computed)	true
NEWADDRESSENDDATECODE	tinyint	false	0
NEWADDRESSPRIMARYCODE	tinyint	false	1
BIRTHDATERULECODE	tinyint	false	1
NAME	nvarchar(42) (Computed)	true
SIMILARADDRESS	nvarchar(63) (Computed)	true
NEWADDRESSENDDATE	nvarchar(30) (Computed)	true
NEWADDRESSPRIMARY	nvarchar(61) (Computed)	true
DIFFERENTPHONE	nvarchar(42) (Computed)	true
NEWPHONEENDDATE	nvarchar(28) (Computed)	true
NEWPHONEPRIMARY	nvarchar(57) (Computed)	true
NEWEMAILENDDATE	nvarchar(36) (Computed)	true
NEWEMAILPRIMARY	nvarchar(65) (Computed)	true
REQUESTSNOEMAIL	bit	false	0
BIRTHDATERULE	nvarchar(17) (Computed)	true
ROWFROMBATCHUI	bit	false	0
ORIGINAL_KEYNAME	nvarchar(100)	false	''
ORIGINAL_FIRSTNAME	nvarchar(50)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BATCHCONSTITUENTUPDATE_BATCHID	BATCHID	False	False	False
IX_BATCHCONSTITUENTUPDATE_BUSINESS_ID	BUSINESS_ID	False	False	False
IX_BATCHCONSTITUENTUPDATE_BUSINESS_PARENTCORPID	BUSINESS_PARENTCORPID	False	False	False
IX_BATCHCONSTITUENTUPDATE_DATEADDED	DATEADDED	False	False	True
IX_BATCHCONSTITUENTUPDATE_DATECHANGED	DATECHANGED	False	False	False
IX_BATCHCONSTITUENTUPDATE_ORG_PARENTCORPID	ORG_PARENTCORPID	False	False	False
IX_BATCHCONSTITUENTUPDATE_PRIMARYRECORDID	PRIMARYRECORDID	False	False	False
IX_BATCHCONSTITUENTUPDATE_PROSPECTMANAGERFUNDRAISERID	PROSPECTMANAGERFUNDRAISERID	False	False	False
IX_BATCHCONSTITUENTUPDATE_SPOUSE_ID	SPOUSE_ID	False	False	False
PK_BATCHCONSTITUENTUPDATE	ID	True	True	False

Triggers
Trigger Name	Description
TR_BATCHCONSTITUENTUPDATE_AUDIT_UPDATE
TR_BATCHCONSTITUENTUPDATE_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHCONSTITUENTUPDATEADDRESSES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATEALTERNATELOOKUPIDS	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATEBATCHUSERMESSAGE	ID
BATCHCONSTITUENTUPDATEBBNCINFO	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATECONSTITUENCIES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATECONSTITUENCIESSYSTEM	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATEEMAILADDRESSES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATEINTERESTS	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATENAMEFORMATS	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATEPHONES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATERELATIONSHIPS	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATESECURITYATTRIBUTES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATESITES	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT	BATCHCONSTITUENTUPDATEID
BATCHCONSTITUENTUPDATESPOUSEALTERNATELOOKUPIDS	BATCHCONSTITUENTUPDATEID
BATCHREVENUECONSTITUENTEDITINFO	ID