BATCHSPONSORSHIPCONSTITUENTRELATION

Stores relation information for constituents added in sponsorship batch.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
STARTDATE	datetime	yes		Date that the relationship was established or became effective
PRIMARYRELATIONSHIPEXISTS	bit		Default = 0	Soft credit the related constituent when a donation/pledge payment is made by the constituent.
PRIMARYMATCHFACTOR	decimal(5, 2)		Default = 0	Matching factor of the soft credit.
RECIPROCALRELATIONSHIPEXISTS	bit		Default = 0	Soft credit the constituent when a donation/pledge payment is made by the related constituent.
RECIPROCALMATCHFACTOR	decimal(5, 2)		Default = 0	Matching factor of the soft credit.
COPYPRIMARYINFORMATION	bit		Default = 1
ISSPOUSE	bit		Default = 0	Designates the relationship as a spouse record.
ISPRIMARYBUSINESS	bit		Default = 0	Designates the relationship as a primary business record.
ISCONTACT	bit		Default = 0	Designates the relationship as a contact record.
ISPRIMARYCONTACT	bit		Default = 0	Indicates whether the contact is a primary contact.
POSITION	nvarchar(50)		Default = ''	Store the position value for records marked as contacts.
ISMATCHINGGIFTRELATIONSHIP	bit		Default = 0	The organization in the relationship will match the individual's gifts.
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
CONSTITUENTID	uniqueidentifier	yes	BATCHSPONSORSHIPCONSTITUENT.ID	FK to BATCHSPONSORSHIPCONSTITUENT
RELATIONID	uniqueidentifier	yes	BATCHSPONSORSHIPCONSTITUENT.ID	FK to BATCHSPONSORSHIPCONSTITUENT
RELATIONSHIPTYPECODEID	uniqueidentifier	yes	RELATIONSHIPTYPECODE.ID	Stores the relationship type for the relationship record
RECIPROCALTYPECODEID	uniqueidentifier	yes	RELATIONSHIPTYPECODE.ID	Stores the relationship type for the reciprocal relationship record
CONTACTTYPECODEID	uniqueidentifier	yes	CONTACTTYPECODE.LOCALID	Stores the contact type for records marked as contacts.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
JOBCATEGORYCODEID	uniqueidentifier	yes	JOBCATEGORYCODE.ID
CAREERLEVELCODEID	uniqueidentifier	yes	CAREERLEVELCODE.ID
PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID
RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_CONSTITUENTID_RELATIONID	CONSTITUENTID, RELATIONID
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_CONTACTTYPECODEID	CONTACTTYPECODEID
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_DATEADDED	DATEADDED			yes
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_DATECHANGED	DATECHANGED
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_RECIPROCALTYPECODEID	RECIPROCALTYPECODEID
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_RELATIONID	RELATIONID
IX_BATCHSPONSORSHIPCONSTITUENTRELATION_RELATIONSHIPTYPECODEID	RELATIONSHIPTYPECODEID
PK_BATCHSPONSORSHIPCONSTITUENTRELATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHSPONSORSHIPCONSTITUENTRELATION_AUDIT_UPDATE
TR_BATCHSPONSORSHIPCONSTITUENTRELATION_AUDIT_DELETE