MATCHFINDERCONFIGURATION
Stores configuration information for integrating with the MatchFinder Online service.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| SITEID |
nvarchar(4000) |
|
Default = '' |
The site ID used to connect to the MatchFinder Online service. |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| ADDRESSTYPECODEID |
uniqueidentifier |
yes |
ADDRESSTYPECODE.ID
|
The type code used when synchronizing address data with MatchFinder Online. |
| PHONETYPECODEID |
uniqueidentifier |
yes |
PHONETYPECODE.LOCALID
|
The type code used when synchronizing phone data with MatchFinder Online. |
| CONTACTTYPECODEID |
uniqueidentifier |
yes |
CONTACTTYPECODE.LOCALID
|
The contact type code used when synchronizing contact data with MatchFinder Online. |
| CONTACTRELATIONSHIPTYPECODEID |
uniqueidentifier |
yes |
RELATIONSHIPTYPECODE.ID
|
The relationship type code used when creating contacts from MatchFinder Online data. |
| CONTACTRECIPROCALRELATIONSHIPTYPECODEID |
uniqueidentifier |
yes |
RELATIONSHIPTYPECODE.ID
|
The reciprocal relationship type code used when creating contacts from MatchFinder Online data. |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CONTACTEMAILADDRESSTYPECODEID |
uniqueidentifier |
yes |
EMAILADDRESSTYPECODE.ID
|
The email type code used when synchronizing contact data with MatchFinder Online. |
| FAXTYPECODEID |
uniqueidentifier |
yes |
PHONETYPECODE.LOCALID
|
The type code used when synchronizing fax data with MatchFinder Online. |
| ALIASTYPECODEID |
uniqueidentifier |
yes |
ALIASTYPECODE.ID
|
The alias type code used when synchronizing organization data with MatchFinder Online. |
| MATCHINGGIFTCONDITIONTYPECODEID |
uniqueidentifier |
yes |
MATCHINGGIFTCONDITIONTYPECODE.ID
|
The matching gift condition type code used when synchronizing matching gift condition data with MatchFinder Online. |
| INFOSOURCECODEID |
uniqueidentifier |
yes |
INFOSOURCECODE.ID
|
The information source code used when synchronizing contact information with MatchFinder Online. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_MATCHFINDERCONFIGURATION_DATEADDED |
DATEADDED |
|
|
yes |
| IX_MATCHFINDERCONFIGURATION_DATECHANGED |
DATECHANGED |
|
|
|
| PK_MATCHFINDERCONFIGURATION |
ID |
yes |
yes |
|
Triggers