| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 STARTDATE |
datetime |  |
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) | |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 CONSTITUENTID |
uniqueidentifier | |
BATCHREVENUECONSTITUENT.ID | FK to BATCHREVENUECONSTITUENT |
| RELATIONID |
uniqueidentifier | |
BATCHREVENUECONSTITUENT.ID | FK to BATCHREVENUECONSTITUENT |
| RELATIONSHIPTYPECODEID |
uniqueidentifier | |
RELATIONSHIPTYPECODE.ID | Stores the relationship type for the relationship record |
| RECIPROCALTYPECODEID |
uniqueidentifier | |
RELATIONSHIPTYPECODE.ID | Stores the relationship type for the reciprocal relationship record |
| CONTACTTYPECODEID |
uniqueidentifier | |
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 | |
JOBCATEGORYCODE.ID | Stores the category of the job for this relationship |
| CAREERLEVELCODEID |
uniqueidentifier | |
CAREERLEVELCODE.ID | Stores the career level of the job for this relationship |
| PRIMARYRECOGNITIONTYPECODEID |
uniqueidentifier | |
REVENUERECOGNITIONTYPECODE.ID | FK to REVENUERECOGNITIONTYPECODE |
| RECIPROCALRECOGNITIONTYPECODEID |
uniqueidentifier | |
REVENUERECOGNITIONTYPECODE.ID | FK to REVENUERECOGNITIONTYPECODE |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_BATCHREVENUECONSTITUENTRELATION_CONSTITUENTID_RELATIONID |
CONSTITUENTID, RELATIONID | |||
 IX_BATCHREVENUECONSTITUENTRELATION_DATEADDED |
DATEADDED | |
||
| IX_BATCHREVENUECONSTITUENTRELATION_DATECHANGED |
DATECHANGED | |||
| PK_BATCHREVENUECONSTITUENTRELATION |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_BATCHREVENUECONSTITUENTRELATION_AUDIT_UPDATE |
|
| TR_BATCHREVENUECONSTITUENTRELATION_AUDIT_DELETE |