Primary Key Field Type
 ID uniqueidentifier

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) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID The type code used when synchronizing address data with MatchFinder Online.
 PHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID The type code used when synchronizing phone data with MatchFinder Online.
 CONTACTTYPECODEID uniqueidentifier CONTACTTYPECODE.LOCALID The contact type code used when synchronizing contact data with MatchFinder Online.
 CONTACTRELATIONSHIPTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID The relationship type code used when creating contacts from MatchFinder Online data.
 CONTACTRECIPROCALRELATIONSHIPTYPECODEID uniqueidentifier 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 EMAILADDRESSTYPECODE.ID The email type code used when synchronizing contact data with MatchFinder Online.
 FAXTYPECODEID uniqueidentifier PHONETYPECODE.LOCALID The type code used when synchronizing fax data with MatchFinder Online.
 ALIASTYPECODEID uniqueidentifier ALIASTYPECODE.ID The alias type code used when synchronizing organization data with MatchFinder Online.
 MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier MATCHINGGIFTCONDITIONTYPECODE.ID The matching gift condition type code used when synchronizing matching gift condition data with MatchFinder Online.
 INFOSOURCECODEID uniqueidentifier INFOSOURCECODE.ID The information source code used when synchronizing contact information with MatchFinder Online.

Index Name Field(s) Unique Primary Clustered
 IX_MATCHFINDERCONFIGURATION_DATEADDED DATEADDED    
 IX_MATCHFINDERCONFIGURATION_DATECHANGED DATECHANGED      
 PK_MATCHFINDERCONFIGURATION ID  

Trigger Name Description
 TR_MATCHFINDERCONFIGURATION_AUDIT_UPDATE
 TR_MATCHFINDERCONFIGURATION_AUDIT_DELETE

Entity-Relationship diagram of this table