Returns detail 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 MembershipDetails WHERE MemberJunctionId = '1'

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

Columns

Name	Type	References	Description
CategoryName	String		The membership category name.
MemberJunctionId	String	Memberships.Id	The ID of the member junction record used to retrieve the membership details.
ConsecYears	Integer		The number of consecutive membership years.
ConstituentId	String	Constituents.Id	The immutable system record ID of the constituent associated with the membership.
Dues	Double		The dues amount.
JoinedDate	Date		The date the membership began.
LastDroppedDate	Date		The date the membership was last dropped.
LastRenewedDate	Date		The date the membership was last renewed.
NextRenewalDate	Date		The date of the membership's next renewal.
Notes	String		Notes about the membership.
ProgramName	String		The membership program name.
SubcategoryName	String		The membership subcategory name.
TimesRenewed	Integer		The number of times the membership was renewed.
TotalYears	Integer		The total number of years of membership.
Type	String		The membership type.