Addresses
Addresses store information about constituent residences and other addresses along with information about where or whether to send mail
Table Specific Information
Select
The driver 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 driver.
- Id supports the '=' operator.
- ConstituentId supports the '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
- IncludeInactive supports the '=' operator.
SELECT * FROM Addresses WHERE ConstituentId = '280' SELECT * FROM Addresses WHERE DateModified >= '2010-06-01 14:03:35' SELECT * FROM Addresses WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID of the address. | |
| AddressLines | String | The address lines. | |
| City | String | The city of the address. | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent associated with the address. |
| Country | String | The country of the address. | |
| County | String | The county of the address. | |
| DateAdded | Datetime | The date when the address was created. | |
| DateModified | Datetime | The date when the address was last modified. | |
| DoNotMail | Boolean | Indicates whether the constituent requests not to be contacted at this address. | |
| End | Datetime | The date when the constituent ceased to reside at this address. | |
| FormattedAddress | String | The date when the constituent ceased to reside at this address. | |
| Inactive | Boolean | This computed field indicates that the address is active if the current date is before any end date. | |
| PostalCode | String | The postal code of the address. | |
| Preferred | Boolean | Indicates whether this is the constituent's preferred address. | |
| SeasonalEndD | Integer | The day of the year ceases to reside at this address. | |
| SeasonalEndM | Integer | The month of the year ceases to reside at this address. | |
| SeasonalEndY | Integer | The year ceases to reside at this address. | |
| SeasonalStartD | Integer | The day of year that the constituent begins residing at this address. | |
| SeasonalStartM | Integer | The month of year that the constituent begins residing at this address. | |
| SeasonalStartY | Integer | The year that the constituent begins residing at this address. | |
| Start | Datetime | The date when the constituent began residing at this address. | |
| State | String | The state of the address. | |
| Suburb | String | The suburb of the address. | |
| Type | String | The address type. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive addresses in the result. |