Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 LIMITRECORDSINBATCH bit   Default = 0 Indicates that the number of records placed in a batch should be limited by MAXRECORDSINBATCH.
 MAXRECORDSINBATCH int   Default = 0 Indicates the maximum number of records that should be placed in a batch.
 UPDATEORGNAME bit   Default = 0 Indicates that the created batch should default to updating the organization name.
 UPDATEINDUSTRY bit   Default = 0 Indicates that the created batch should default to updating the industry.
 UPDATEADDRESS bit   Default = 0 Indicates that the created batch should default to updating the address.
 UPDATEPHONE bit   Default = 0 Indicates that the created batch should default to updating the phone number.
 UPDATEFAX bit   Default = 0 Indicates that the created batch should default to updating fax number.
 UPDATEWEBADDRESS bit   Default = 0 Indicates that the created batch should default to updating the web address.
 UPDATEMATCHINGGIFTINFORMATION bit   Default = 0 Indicates that the created batch should default to updating matching gift information.
 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.
 UPDATEALIAS bit   Default = 0 Indicates that the created batch should default to updating the alias.
 UPDATECONTACTNAME bit   Default = 0 Indicates that the created batch should default to updating the contact's name.
 UPDATECONTACTEMAIL bit   Default = 0 Indicates that the created batch should default to updating the contact's email.

Foreign Key Field Type Null Notes Description
 CONSTITUENTSELECTIONID uniqueidentifier IDSETREGISTER.ID Indicates the constituent selection used to filter records included in the process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BATCHOWNERID uniqueidentifier APPUSER.ID Indicates the user that will own the created batch.

Index Name Field(s) Unique Primary Clustered
 IX_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS_DATEADDED DATEADDED    
 IX_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS_DATECHANGED DATECHANGED      
 PK_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS ID  
 UC_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS_NAME NAME    

Trigger Name Description
 TR_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS_AUDIT_UPDATE
 TR_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS_AUDIT_DELETE

Referenced by Field
 UPDATEMULTIPLECONSTITUENTFROMMFOPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table