| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 NAME |
nvarchar(150) | Default = '' | Name of the PhoneFinder process | |
| DESCRIPTION |
nvarchar(250) | Default = '' | Description of the PhoneFinder process | |
| FILENAME |
nvarchar(256) | Default = '' | Name of the file that is to be uploaded | |
| FILEUPLOADED |
bit | Default = 0 | Whether the process-created file has been uploaded | |
| FILEAVAILABLE |
bit | Default = 0 | Whether the file has been processed and is available for download | |
| FILEDOWNLOADED |
bit | Default = 0 | Whether the results file has been downloaded | |
| PRIMARYCONTACTNAME |
nvarchar(250) | Default = '' | The name of the primary person to contact when data tune-up is complete | |
| PRIMARYCONTACTEMAIL |
UDT_EMAILADDRESS | Default = '' | The primary contact's email address | |
| PRIMARYCONTACTPHONE |
nvarchar(20) | Default = '' | The primary contact's phone number | |
| ALTERNATECONTACTNAME |
nvarchar(250) | Default = '' | The name of an alternate person to contact when data tune-up is complete | |
| ALTERNATECONTACTEMAIL |
UDT_EMAILADDRESS | Default = '' | The alternate contact's email address | |
| ALTERNATECONTACTPHONE |
nvarchar(20) | Default = '' | The alternate contact's phone number | |
| DATEADDED |
datetime | Default = getdate() | Indicates the date this record was added. | |
| DATECHANGED |
datetime | Default = getdate() | Indicates the date this record was last changed. | |
| TS |
timestamp | Timestamp. | ||
 TSLONG |
bigint (Computed) |  |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| REQUESTFILE |
varbinary | |
The request file sent to Blackbaud as part of step 1. | |
| INDIVIDUALMARKASPRIMARY |
bit | Default = 0 | Whether or not to mark individual phone numbers primary | |
| ORGANIZATIONMARKASPRIMARY |
bit | Default = 0 | Whether or not to mark organization phone numbers primary | |
| STEP |
nvarchar(150) (Computed) | |
dbo.UFN_PHONEFINDER_GETSTEP(ID) | The step the PhoneFinder process is currently on |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SITEID |
uniqueidentifier | |
SITE.ID | Foreign key to site table |
| BATCHID |
uniqueidentifier | |
BATCH.ID | The batch instance into which data will be imported |
| BATCHAPPUSERID |
uniqueidentifier | |
APPUSER.ID | The user who will own the batch once it is created by the import process |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| INFOSOURCECODEID |
uniqueidentifier | |
INFOSOURCECODE.ID | FK to INFOSOURCECODE |
| INDIVIDUALPHONETYPECODEID |
uniqueidentifier | |
PHONETYPECODE.LOCALID | The type to apply to an individual's phone number |
| ORGANIZATIONPHONETYPECODEID |
uniqueidentifier | |
PHONETYPECODE.LOCALID | The type to apply to an organization's phone number |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_PHONEFINDER_DATEADDED |
DATEADDED | |
||
 IX_PHONEFINDER_DATECHANGED |
DATECHANGED | |||
| PK_PHONEFINDER |
ID | |
|
|
| UIX_PHONEFINDER_BATCHID |
BATCHID | |
||
| UIX_PHONEFINDER_SITEID |
SITEID | |
| Trigger Name | Description |
|---|---|
 TR_PHONEFINDER_AUDIT_UPDATE |
|
| TR_PHONEFINDER_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHPHONEFINDER |
PHONEFINDERID |
| PHONEFINDERGETPROCESS |
PHONEFINDERID |
| PHONEFINDERRESUBMITPROCESS |
PHONEFINDERID |
| PHONEFINDERSUBMITPROCESS |
PHONEFINDERID |