Relationships
Returns a list of relationships between constituents and other individuals and organizations such as family, friends, and employers
Table Specific Information
Select
The cmdlet 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 cmdlet.
- Id supports the '=' operator.
- ConstituentId supports the '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
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. | |
| FirstName | String | The first name of the constituent. For individuals only. | |
| LastName | String | The last name of the constituent. For individuals only. | |
| IsSpouseHeadOfHousehold | Boolean | Indicates whether the spouse constituent is the head household. Only applies to spousal relationships between individuals. | |
| IsConstituentHeadOfHousehold | Boolean | Indicates whether the constituent is the head of household. Only applies to spousal relationships between individuals. |