PEOPLEFINDER (3.0)

ID

uniqueidentifier

SITEID

uniqueidentifier

true

Foreign key for site table.

BATCHID

uniqueidentifier

true

The batch instance into which the data will be imported.

BATCHAPPUSERID

uniqueidentifier

true

Represents the user who will be the owner of the batch once it is created by the import process.

ADDRESSTYPECODEID

uniqueidentifier

true

FK to ADDRESSTYPECODE

INFOSOURCECODEID

uniqueidentifier

true

FK to INFOSOURCECODE

DONOTMAILREASONCODEID

uniqueidentifier

true

The do not mail reason code for records marked do not mail.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PHONETYPECODEID

uniqueidentifier

true

FK to PHONETYPECODE

NAME

nvarchar(150)

false

Name to be used if there is no site.

DESCRIPTION

nvarchar(250)

false

The description of the PeopleFinder process.

DATELASTRUN

datetime

true

Stores the date of the list time one of the steps was run.

STEPCODE

tinyint

false

Tracks the most current state of the PeopleFinder process.

STEP

nvarchar(25) (Computed)

true

Provides a translation for the 'STEPCODE' field.

FILENAME

nvarchar(256)

false

The file name of the generated file that is to be uploaded to Blackbaud.

FILEUPLOADED

bit

false

Indicates whether the process created file has been uploaded to Blackbaud.

FILEAVAILABLE

bit

false

Indicates whether the file has been processed by Blackbaud and is available to download.

FILEDOWNLOADED

bit

false

Indicates whether the results file has been downloaded from Blackbaud.

PRIMARYCONTACTNAME

nvarchar(250)

false

The name of the primary person when data tune-up is complete.

PRIMARYCONTACTEMAIL

UDT_EMAILADDRESS

false

The email address of the primary contact when data tune-up is complete.

PRIMARYCONTACTPHONE

nvarchar(20)

false

The phone number of the primary contact when data tune-up is complete.

ALTERNATECONTACTNAME

nvarchar(250)

false

The name of the alternate person when data tune-up is complete.

ALTERNATECONTACTEMAIL

UDT_EMAILADDRESS

false

The email address of the alternate contact when data tune-up is complete.

ALTERNATECONTACTPHONE

nvarchar(20)

false

The phone number of the primary contact when data tune-up is complete.

INFOSOURCECOMMENTS

nvarchar(256)

false

MARKASDECEASED

bit

false

Designates whether to mark records as deceased that have come back from DES as deceased.

MARKASDONOTMAIL

bit

false

Designates whether to update address records as do not mail that have been marked as do not mail from DES.

UPDATEPHONENUMBER

bit

false

Designates whether to update the phone number 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.

MINIMUMRANKCODE

tinyint

false

Indicates the minimum rank from DES to use in processing records.

MINIMUMRANK

nvarchar(1) (Computed)

true

Provides a translation for the 'MINIMUMRANKCODE' field.

UPDATELASTNAMECODE

tinyint

false

Designates what action to take with the new last name from DES.

UPDATELASTNAME

nvarchar(85) (Computed)

true

Provides a translation for the 'UPDATELASTNAMECODE' field.

ADDFORMERLASTNAMEASALIAS

bit

false

Designates whether to add the consituent's current last name as an alias after changing their last name.

MARKPHONEASPRIMARY

bit

false

IX_PEOPLEFINDER_DATEADDED

False

False

True

IX_PEOPLEFINDER_DATECHANGED

False

False

False

PK_PEOPLEFINDER

True

True

False

UIX_PEOPLEFINDER_SITEID

True

False

False

TR_PEOPLEFINDER_AUDIT_UPDATE

TR_PEOPLEFINDER_AUDIT_DELETE

BATCHPEOPLEFINDER

PEOPLEFINDERID

PEOPLEFINDERFILE

ID

PEOPLEFINDERGETPROCESS

PEOPLEFINDERID

PEOPLEFINDERRESUBMITPROCESS

PEOPLEFINDERID

PEOPLEFINDERSUBMITPROCESS

PEOPLEFINDERID