ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

Memberships

Returns a list of memberships.

Table Specific Information

Select

The 本製品 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 本製品.

  • ConstituentId supports the '=' operator.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
For example:
	
	SELECT * FROM Memberships WHERE ConstituentId = '280'
	
	SELECT * FROM Memberships WHERE DateAdded >= '2010-06-01 14:03:35'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the membership.
ConstituentId String

Constituents.Id

The immutable system record ID of the constituent associated with the membership.
Category String The membership category.
DateAdded Datetime The date when the membership was created.
DateModified Datetime The date when the membership was last modified.
DuesValue Double The membership dues.
Expires Datetime The date when the membership expires.
Joined Datetime The date when the membership becomes active.
Program String The membership program.
Standing String The membership status. Available values are New, Active, Lapsed, and Dropped.
Subcategory String The membership subcategory.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062