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 connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive addresses in the result. |