BATCHPEOPLEFINDER (4.0SP5)

ID

uniqueidentifier

BATCHID

uniqueidentifier

false

FK to BATCH

PEOPLEFINDERID

uniqueidentifier

false

FK to PEOPLEFINDER

CONSTITUENTID

uniqueidentifier

true

FK to CONSTITUENT

OLDADDRESSID

uniqueidentifier

true

FK to ADDRESS

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

NEWSTATEID

uniqueidentifier

true

The new state received from DES.

SEQUENCE

int

false

NEWADDRESSBLOCK

nvarchar(150)

false

The new address received from DES.

NEWCITY

nvarchar(50)

false

The new city recieved from DES.

NEWPOSTCODE

nvarchar(12)

false

The new post code received from DES.

OTHERLASTNAME

nvarchar(100)

false

The new last name received from DES.

NEWPHONENUMBER

nvarchar(100)

false

The new phone number received from DES.

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.

NEWADDRESSINFOSOURCE

nvarchar(20)

false

The new info source received from DES.

DECEASEDYEAR

UDT_FUZZYDATE

false

The year deceased received from DES.

CONFIDENCELEVEL

smallint

false

The confidence level received from the third party as to how firm this information is.

SENDMAIL

bit

false

The value received from DES.

ISDECEASED

bit

false

The value received from DES.

DECEASEDYEARDISPLAY

varchar(4) (Computed)

true

The display value for DECEASEDYEAR

IX_BATCHPEOPLEFINDER_CONSTITUENTID

False

False

False

IX_BATCHPEOPLEFINDER_DATEADDED

False

False

True

IX_BATCHPEOPLEFINDER_DATECHANGED

False

False

False

IX_BATCHPEOPLEFINDER_OLDADDRESSID

False

False

False

PK_BATCHPEOPLEFINDER

True

True

False

TR_BATCHPEOPLEFINDER_AUDIT_UPDATE

TR_BATCHPEOPLEFINDER_AUDIT_DELETE

BATCHPEOPLEFINDERBATCHSYSTEMMESSAGES

BATCHPEOPLEFINDERID

BATCHPEOPLEFINDERBATCHUSERMESSAGE

ID