Tableau Connector for Blackbaud Raisers Edge NXT

Build 21.0.7930

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.
For example:
	
	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.

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