BATCHREVENUECONSTITUENTRELATION

Stores relation information for constituents added in revenue 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	BATCHREVENUECONSTITUENT.ID	FK to BATCHREVENUECONSTITUENT
RELATIONID	uniqueidentifier	yes	BATCHREVENUECONSTITUENT.ID	FK to BATCHREVENUECONSTITUENT
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	Stores the category of the job for this relationship
CAREERLEVELCODEID	uniqueidentifier	yes	CAREERLEVELCODE.ID	Stores the career level of the job for this relationship
PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHREVENUECONSTITUENTRELATION_CONSTITUENTID_RELATIONID	CONSTITUENTID, RELATIONID
IX_BATCHREVENUECONSTITUENTRELATION_DATEADDED	DATEADDED			yes
IX_BATCHREVENUECONSTITUENTRELATION_DATECHANGED	DATECHANGED
PK_BATCHREVENUECONSTITUENTRELATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHREVENUECONSTITUENTRELATION_AUDIT_UPDATE
TR_BATCHREVENUECONSTITUENTRELATION_AUDIT_DELETE