BATCHAUCTIONITEMCONSTITUENTRELATION

Stores relation information for constituents added in auction item 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(100)		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	BATCHAUCTIONITEMCONSTITUENT.ID	FK to BATCHAUCTIONITEMCONSTITUENT
RELATIONID	uniqueidentifier	yes	BATCHAUCTIONITEMCONSTITUENT.ID	FK to BATCHAUCTIONITEMCONSTITUENT
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.
JOBCATEGORYCODEID	uniqueidentifier	yes	JOBCATEGORYCODE.ID	Stores the category of the job for this relationship
CAREERLEVELCODEID	uniqueidentifier	yes	CAREERLEVELCODE.ID	Stores the career level of the job for this relationship
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID
RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHAUCTIONITEMCONSTITUENTRELATION_CONSTITUENTID_RELATIONID	CONSTITUENTID, RELATIONID
IX_BATCHAUCTIONITEMCONSTITUENTRELATION_DATEADDED	DATEADDED			yes
IX_BATCHAUCTIONITEMCONSTITUENTRELATION_DATECHANGED	DATECHANGED
PK_BATCHAUCTIONITEMCONSTITUENTRELATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHAUCTIONITEMCONSTITUENTRELATION_AUDIT_UPDATE
TR_BATCHAUCTIONITEMCONSTITUENTRELATION_AUDIT_DELETE