MembershipBenefits
Returns a list of benefits 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.
SELECT * FROM MembershipBenefits WHERE MemberJunctionId = '1'
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 benefit. | |
| MemberJunctionId | String |
Memberships.Id | The ID of the member junction record used to retrieve the membership benefits. |
| Benefit | String | The name of the membership benefit. | |
| Comments | String | Comments about the membership benefit. | |
| Count | Integer | The number of units of the membership benefit. | |
| CurrencySymbol | String | The currency symbol for the membership benefit's monetary values. | |
| Sent | String | Indicates whether the membership benefit has been sent. | |
| TotalBenefitValue | Decimal | The total value of the membership benefit. | |
| UnitCost | Decimal | The cost of a single unit of the membership benefit. |