Returns a list of memberships.

View-Specific Information

Select

The driver uses the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following columns and operators.

• 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'

The rest of the filter is executed client-side within the driver.

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. The allowed values are New, Lapsed, Active, Dropped.
Subcategory	String		The membership subcategory.
CustomMembershipId	String		The custom membership ID.