Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MATCHFINDERRECORDID int   Default = 0 The ID of the MatchFinder Online record that has been linked to the constituent.
 UPDATEORGNAME bit   Default = 0 Indicates that the organization name should be updated from MatchFinder Online.
 MFORGNAME nvarchar(100)   Default = ''
 UPDATEALIAS bit   Default = 0 Indicates that the alias should be updated from MatchFinder Online.
 MFALIAS nvarchar(100)   Default = ''
 UPDATEINDUSTRY bit   Default = 0 Indicates that the industry should be updated from MatchFinder Online.
 MFINDUSTRY nvarchar(100)   Default = ''
 UPDATEADDRESS bit   Default = 0 Indicates that the address should be updated from MatchFinder Online.
 MFADDRESSBLOCK nvarchar(150)   Default = ''
 MFCITY nvarchar(50)   Default = ''
 MFSTATE nvarchar(100)   Default = ''
 MFCOUNTRY nvarchar(100)   Default = ''
 MFPOSTCODE nvarchar(12)   Default = ''
 UPDATEPHONE bit   Default = 0 Indicates that the phone number should be updated from MatchFinder Online.
 MFPHONE nvarchar(100)   Default = ''
 UPDATEFAX bit   Default = 0 Indicates that the fax number should be updated from MatchFinder Online.
 MFFAX nvarchar(100)   Default = ''
 UPDATEWEBADDRESS bit   Default = 0 Indicates that the web address should be updated from MatchFinder Online.
 MFWEBADDRESS nvarchar(2047)   Default = ''
 UPDATEMATCHINGFACTOR bit   Default = 0 Indicates that the matching factor should be updated from MatchFinder Online.
 MFMATCHINGFACTOR decimal(5, 2)   Default = 0
 UPDATEMINMATCHPERGIFT bit   Default = 0 Indicates that the minimum match per gift should be updated from MatchFinder Online.
 MFMINMATCHPERGIFT money   Default = 0
 UPDATEMAXMATCHPERGIFT bit   Default = 0 Indicates that the maximum match per gift should be updated from MatchFinder Online.
 MFMAXMATCHPERGIFT money   Default = 0
 UPDATEMAXMATCHANNUAL bit   Default = 0 Indicates that the maximum match per year should be updated from MatchFinder Online.
 MFMAXMATCHANNUAL money   Default = 0
 UPDATEMAXMATCHTOTAL bit   Default = 0 Indicates that the total maximum match should be updated from MatchFinder Online.
 MFMAXMATCHTOTAL money   Default = 0
 UPDATEMATCHNOTES bit   Default = 0 Indicates that the match notes should be updated from MatchFinder Online.
 MFMATCHNOTES nvarchar(max)   Default = ''
 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.
 SEQUENCE int   Default = 0
 CREATENEWCONTACT bit   Default = 0 Indicates that a new contact should be created when updating contact data.
 UPDATECONTACT bit   Default = 0 Indicates that the contact pointed to by CONTACTLINKID should be updated when updating contact data.
 UPDATECONTACTNAME bit   Default = 0 Indicates that the contact name should be updated from MatchFinder Online
 MFCONTACTFIRSTNAME nvarchar(100)   Default = ''
 MFCONTACTLASTNAME nvarchar(100)   Default = ''
 MFCONTACTFULLNAME nvarchar(100)   Default = ''
 UPDATECONTACTEMAIL bit   Default = 0 Indicates that the contact email should be updated from MatchFinder Online
 MFCONTACTEMAIL nvarchar(100)   Default = ''

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 CONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID FK to CONSTITUENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 MFSTATEID uniqueidentifier STATE.LOCALID FK to STATE
 MFCOUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 CONTACTLINKID uniqueidentifier CONSTITUENT.LOCALID The contact that will be updated when updating contact data and UPDATECONTACT is true.

Index Name Field(s) Unique Primary Clustered
 IX_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH_CONSTITUENTID CONSTITUENTID      
 IX_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH_CONTACTLINKID CONTACTLINKID      
 IX_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH_DATEADDED DATEADDED    
 IX_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH_DATECHANGED DATECHANGED      
 PK_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH ID  

Trigger Name Description
 TR_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH_AUDIT_UPDATE
 TR_UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH_AUDIT_DELETE

Referenced by Field
 UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHSYSTEMMESSAGES UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHID
 UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHUSERMESSAGE ID

Entity-Relationship diagram of this table