ODBC Driver for Blackbaud Raisers Edge NXT

Build 26.0.9770

MembershipCards

Returns a list of membership cards 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 columns and operators.

  • Id supports the = operator.
  • MemberJunctionId supports the = operator.
For example:
	SELECT * FROM MembershipCards WHERE MemberJunctionId = '1'
	SELECT * FROM MembershipCards WHERE MemberJunctionId = '1' AND Id = '2'
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 card.
MemberJunctionId String

Memberships.Id

The ID of the member junction record used to retrieve the membership cards.
AddressToPrint String Indicates whose address is printed on the membership card.
CardExpires String Indicates when the membership card expires. Available values are Same Dates and Lifetime.
CardMember Boolean Indicates whether the member receives a membership card.
CardType String The type of membership card.
Editable Boolean Indicates whether the membership card can be edited.
JointMember Boolean Indicates whether the membership card belongs to a joint member.
JointMemberId Integer The immutable system record ID of the joint member associated with the membership card.
LastPrintedOn Datetime The date when the membership card was last printed.
MemberName String The name of the member on the membership card.
MembershipId String

Memberships.Id

The immutable system record ID of the membership associated with the membership card.
NameOnCard String The name printed on the membership card.
NumberOfCards Integer The number of membership cards issued to the member.
Primary Boolean Indicates whether this is the primary member's membership card.
Relation String The member's relationship to the primary member.
Sequence Integer The placement of the membership card in the order of membership card table values.
Status String The status of the membership card.
ValidFromDate Datetime The date on which the membership card becomes valid.
ValidToDate Datetime The date on which the membership card expires.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770