BATCHPHONEFINDER (4.0SP17)

ID

uniqueidentifier

BATCHID

uniqueidentifier

false

The batch the data in this table belongs to

PHONEFINDERID

uniqueidentifier

false

This batch's parent PhoneFinder process

CONSTITUENTID

uniqueidentifier

true

The constituent to update

ADDRESSID

uniqueidentifier

true

The address of the constituent to update

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

SEQUENCE

int

false

PHONENUMBER

nvarchar(20)

false

The phone number to insert or update

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.

PHONEMATCHTYPE

nvarchar(1)

false

The match type returned by the PhoneFinder service

MATCHCOMPOSITESCORE

nvarchar(5)

false

The match composite score returned by the PhoneFinder service

PHONESTATUS

nvarchar(1)

false

The phone status returned by the PhoneFinder service

DONOTCALLSTATUS

nvarchar(1)

false

The phone's do not call status returned by the PhoneFinder service

PHONEVERIFIED

bit

false

Whether or not the phone was verified by the finder process

IX_BATCHPHONEFINDER_ADDRESSID

False

False

False

IX_BATCHPHONEFINDER_CONSTITUENTID

False

False

False

IX_BATCHPHONEFINDER_DATEADDED

False

False

True

IX_BATCHPHONEFINDER_DATECHANGED

False

False

False

PK_BATCHPHONEFINDER

True

True

False

TR_BATCHPHONEFINDER_AUDIT_UPDATE

TR_BATCHPHONEFINDER_AUDIT_DELETE

BATCHPHONEFINDERBATCHSYSTEMMESSAGES

BATCHPHONEFINDERID

BATCHPHONEFINDERBATCHUSERMESSAGE

ID