BATCHAMPROIMPORTCONSTITUENT (4.0)

Stores rows relating to constituents which are imported from AuctionMaestro Pro.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

CONSTITUENT_LINKID

uniqueidentifier

true

FK to CONSTITUENT

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CONSTITUENT_UPDATEDSTATEID

uniqueidentifier

true

FK to STATE

CONSTITUENT_UPDATEDCOUNTRYID

uniqueidentifier

true

FK to COUNTRY

CONSTITUENT_NEWSECURITYATTRIBUTEID

uniqueidentifier

true

FK to CONSTIT_SECURITY_ATTRIBUTE

CONSTITUENT_NEWSITEID

uniqueidentifier

true

FK to SITE
Fields
Field Field Type Null Notes Description

CONSTITUENT_MAPPINGID

int

false

0

CONSTITUENT_UPDATEDTITLE

nvarchar(100)

false

''

CONSTITUENT_UPDATEDFIRSTNAME

nvarchar(50)

false

''

CONSTITUENT_UPDATEDKEYNAME

nvarchar(100)

false

''

CONSTITUENT_UPDATEDADDRESSBLOCK

nvarchar(150)

false

''

CONSTITUENT_UPDATEDCITY

nvarchar(50)

false

''

CONSTITUENT_UPDATEDPOSTCODE

nvarchar(12)

false

''

CONSTITUENT_UPDATEDPHONE

nvarchar(100)

false

''

CONSTITUENT_UPDATEDEMAILADDRESS

nvarchar(100)

false

''

CONSTITUENT_ISINDIVIDUAL

bit

false

0

CONSTITUENT_LOOKUPID

nvarchar(255)

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.

CONSTITUENT_AUTOMATCHSTATUSCODE

tinyint

false

0

0=DidNotAutomatch, 1=MatchedSingleConstituent, 2=MatchedMultipleConstituents, 3=MatchedZeroConstituents, 4=MatchedSinglePotentialConstituent, 5=UserChoseConstituent

CONSTITUENT_AUTOMATCHSTATUS

nvarchar(33) (Computed)

true

Provides a translation for the 'CONSTITUENT_AUTOMATCHSTATUSCODE' field.

CONSTITUENT_UPDATECONTACTINFO

bit

false

0

Indexes
Index Name Field(s) Unique Primary Clustered

IX_BATCHAMPROIMPORTCONSTITUENT_CONSTITUENT_LINKID

CONSTITUENT_LINKID

False

False

False

IX_BATCHAMPROIMPORTCONSTITUENT_DATEADDED

DATEADDED

False

False

True

IX_BATCHAMPROIMPORTCONSTITUENT_DATECHANGED

DATECHANGED

False

False

False

PK_BATCHAMPROIMPORTCONSTITUENT

ID

True

True

False
Triggers
Trigger Name Description

TR_BATCHAMPROIMPORTCONSTITUENT_AUDIT_UPDATE

TR_BATCHAMPROIMPORTCONSTITUENT_AUDIT_DELETE