Returns summary information for a membership.

View-Specific Information

Select

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

• MemberJunctionId supports the = operator.

For example:

	SELECT * FROM MembershipSummary WHERE MemberJunctionId = '1'

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

Columns

Name	Type	References	Description
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the membership.
MemberJunctionId	String	Memberships.Id	The ID of the member junction record used to retrieve the membership summary.
ConstituentName	String		The name of the constituent associated with the membership.
CustomMembershipId	String		The user-defined identifier for the membership.
ExpiresOnDate	Date		The date on which the membership expires.
Notes	String		Notes about the membership.
Primary	Boolean		Indicates whether this is the primary member's membership.
PrimaryMemberConstituentId	String	Constituents.Id	The immutable system record ID of the primary member's constituent record.
PrimaryMemberConstituentName	String		The name of the primary member's constituent record.
Standing	String		The membership status. Available values are New, Active, Lapsed, and Dropped.