Memberships

Returns a list of memberships.

Table Specific Information

Select

The component 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 component.

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.

SSIS Components for Blackbaud Raisers Edge NXT

Memberships

Table Specific Information

Select

Columns