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.
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. |