Returns a list of membership categories.

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.

• CategoryName supports the =, LIKE, CONTAINS operators.
• ProgramName supports the =, LIKE, CONTAINS operators.
• IncludeInactive supports the = operator.

For example:

    SELECT * FROM MembershipCategories WHERE ProgramName like '%ar_s%';
	SELECT * FROM MembershipCategories WHERE CONTAINS(ProgramName, 'rt');
	SELECT * FROM MembershipCategories WHERE IncludeInactive = true

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

Columns

Name	Type	References	Description
Id [KEY]	Integer		The immutable system record ID of the membership category.
BenefitNotes	String		Notes about the benefits provided by the membership category.
CategoryName	String		The name of the membership category.
DefaultExpiresDate	Date		The default date on which a membership in this category expires.
DefaultExpiresDays	Integer		The default number of days until a membership in this category expires.
DuesLevel	String		The dues level associated with the membership category.
Inactive	Boolean		Indicates whether the membership category is inactive.
LifetimeMembership	Boolean		Indicates whether the membership category represents a lifetime membership.
MaximumDues	Double		The maximum dues amount for the membership category.
MaximumMembers	Integer		The maximum number of members allowed under the membership category.
MinimumDues	Double		The minimum dues amount for the membership category.
NewMemExpiresInterval	String		The interval used with NewMemExpiresValue to calculate the expiration date for new memberships. Available values are Days, Months, and Years.
NewMemExpiresValue	Integer		The numeric value used with NewMemExpiresInterval to calculate the expiration date for new memberships.
PrintRenewals	Boolean		Indicates whether to print renewal notices for members in this category.
ProgramName	String		The name of the membership program associated with the category.
Sequence	Integer		The placement of the category in the order of category table values.
SendBenefitsTo	String		Indicates who receives the benefits for the membership category. Available values are PrimaryMember and Donor.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
IncludeInactive	Boolean		Indicates whether to include inactive membership categories and subcategories in the results.