Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONSTITUENT_MAPPINGID int   Default = 0
 CONSTITUENT_UPDATEDTITLE nvarchar(100)   Default = ''
 CONSTITUENT_UPDATEDFIRSTNAME nvarchar(50)   Default = ''
 CONSTITUENT_UPDATEDKEYNAME nvarchar(100)   Default = ''
 CONSTITUENT_UPDATEDADDRESSBLOCK nvarchar(150)   Default = ''
 CONSTITUENT_UPDATEDCITY nvarchar(50)   Default = ''
 CONSTITUENT_UPDATEDPOSTCODE nvarchar(12)   Default = ''
 CONSTITUENT_UPDATEDPHONE nvarchar(100)   Default = ''
 CONSTITUENT_UPDATEDEMAILADDRESS nvarchar(100)   Default = ''
 CONSTITUENT_ISINDIVIDUAL bit   Default = 0
 CONSTITUENT_LOOKUPID nvarchar(255)   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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CONSTITUENT_AUTOMATCHSTATUSCODE tinyint   Default = 0 0=DidNotAutomatch, 1=MatchedSingleConstituent, 2=MatchedMultipleConstituents, 3=MatchedZeroConstituents, 4=MatchedSinglePotentialConstituent, 5=UserChoseConstituent
 CONSTITUENT_AUTOMATCHSTATUS nvarchar(33) (Computed) CASE [CONSTITUENT_AUTOMATCHSTATUSCODE] WHEN 0 THEN N'DidNotAutomatch' WHEN 1 THEN N'MatchedSingleConstituent' WHEN 2 THEN N'MatchedMultipleConstituents' WHEN 3 THEN N'MatchedZeroConstituents' WHEN 4 THEN N'MatchedSinglePotentialConstituent' WHEN 5 THEN N'UserChoseConstituent' END Provides a translation for the 'CONSTITUENT_AUTOMATCHSTATUSCODE' field.
 CONSTITUENT_UPDATECONTACTINFO bit   Default = 0

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   BATCHAMPROIMPORT.ID Primary Key.
 CONSTITUENT_LINKID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CONSTITUENT_UPDATEDSTATEID uniqueidentifier STATE.LOCALID FK to STATE
 CONSTITUENT_UPDATEDCOUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 CONSTITUENT_NEWSECURITYATTRIBUTEID uniqueidentifier CONSTIT_SECURITY_ATTRIBUTE.ID FK to CONSTIT_SECURITY_ATTRIBUTE
 CONSTITUENT_NEWSITEID uniqueidentifier SITE.ID FK to SITE

Index Name Field(s) Unique Primary Clustered
 IX_BATCHAMPROIMPORTCONSTITUENT_CONSTITUENT_LINKID CONSTITUENT_LINKID      
 IX_BATCHAMPROIMPORTCONSTITUENT_DATEADDED DATEADDED    
 IX_BATCHAMPROIMPORTCONSTITUENT_DATECHANGED DATECHANGED      
 PK_BATCHAMPROIMPORTCONSTITUENT ID  

Trigger Name Description
 TR_BATCHAMPROIMPORTCONSTITUENT_AUDIT_UPDATE
 TR_BATCHAMPROIMPORTCONSTITUENT_AUDIT_DELETE

Entity-Relationship diagram of this table