SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

Relationships

Returns a list of relationships between constituents and other individuals and organizations such as family, friends, and employers

Table Specific Information

Select

The component will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • Id supports the '=' operator.
  • ConstituentId supports the '=' operator.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
For example:
	SELECT * FROM Relationships WHERE Id = '1'
	
	SELECT * FROM Relationships WHERE ConstituentId = '280'
	

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the relationship.
Comment String The comment on the relationship.
ConstituentId String

Constituents.Id

The immutable system record ID of the constituent associated with the relationship.
DateAdded Datetime The date when the relationship was created.
DateModified Datetime The date when the relationship was last modified.
EndD Integer The end day for the relationship.
EndM Integer The end month for the relationship.
EndY Integer The end year for the relationship.
IsOrganizationContact Boolean Indicates whether the related individual represents the organization as a contact.
IsPrimaryBusiness Boolean Indicates whether the related organization is the individual's primary business.
IsSpouse Boolean Indicates whether the related constituent is the constituent's spouse.
Name String The name of the related constituent.
OrganizationContactType String Provides context for interactions with the related individual who represents the organization as a contact.
Position String The individual's position in the organization.
ReciprocalRelationshipId String The identifier for the reciprocal relationship record.
ReciprocalType String Describes the constituent's relationship to the related constituent.
RelationId String The immutable system record ID of the related individual or organization.
StartD Integer The start day for the relationship.
StartM Integer The start month for the relationship.
StartY Integer The start year for the relationship.
Type String The type of relation that the relationship represents.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930