EMAILFINDER (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

The EmailFinder process is represented by this table.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SITEID	uniqueidentifier	true	SITE.ID	Foreign key for site table.
BATCHID	uniqueidentifier	true	BATCH.ID	The batch instance into which the data will be imported.
BATCHAPPUSERID	uniqueidentifier	true	APPUSER.ID	Represents the user who will be the owner of the batch once it is created by the import process.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
EMAILADDRESSTYPECODEID	uniqueidentifier	true	EMAILADDRESSTYPECODE.ID	FK to EMAILADDRESSTYPECODE
INFOSOURCECODEID	uniqueidentifier	true	INFOSOURCECODE.ID	FK to INFOSOURCECODE

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(150)	false	''	Name to be used if there is no site.
DESCRIPTION	nvarchar(250)	false	''	The description of the EmailFinder process.
DATELASTRUN	datetime	true		Stores the date of the list time one of the steps was run.
STEPCODE	tinyint	false	0	Tracks the most current state of the EmailFinder 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	0	Indicates whether the process created file has been uploaded to Blackbaud.
FILEAVAILABLE	bit	false	0	Indicates whether the file has been processed by Blackbaud and is available to download.
FILEDOWNLOADED	bit	false	0	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 primary person when data tune-up is complete.
ALTERNATECONTACTEMAIL	UDT_EMAILADDRESS	false	''	The email address of the primary contact when data tune-up is complete.
ALTERNATECONTACTPHONE	nvarchar(20)	false	''	The phone number of the primary contact when data tune-up is complete.
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.
OPTOUTSUBJECT	nvarchar(255)	false	''
OPTOUTREPLYTO	UDT_EMAILADDRESS	false	''
OPTOUTORG	nvarchar(150)	false	''
OPTOUTADDRESS	nvarchar(300)	false	''
OPTOUTPHONE	nvarchar(150)	false	''
OPTOUTWEBSITE	nvarchar(150)	false	''
OPTOUTMISSION	nvarchar(300)	false	''
OPTOUTDEFAULTEMAIL	nvarchar(1024)	false	''
MARKASPRIMARY	bit	false	0
INFOSOURCECOMMENTS	nvarchar(256)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_EMAILFINDER_DATEADDED	DATEADDED	False	False	True
IX_EMAILFINDER_DATECHANGED	DATECHANGED	False	False	False
PK_EMAILFINDER	ID	True	True	False
UIX_EMAILFINDER_SITEID	SITEID	True	False	False

Triggers
Trigger Name	Description
TR_EMAILFINDER_AUDIT_UPDATE
TR_EMAILFINDER_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHEMAILFINDER	EMAILFINDERID
EMAILFINDERFILE	ID
EMAILFINDERGETPROCESS	EMAILFINDERID
EMAILFINDERRESUBMITPROCESS	EMAILFINDERID
EMAILFINDERSUBMITPROCESS	EMAILFINDERID