Returns a list of memberships.
Table Specific Information
The connector will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- ConstituentId supports the '=' operator.
- DateAdded supports the '>=,>' operators.
- DateModified supports the '>=,>' operators.
SELECT * FROM Memberships WHERE ConstituentId = '280' SELECT * FROM Memberships WHERE DateAdded >= '2010-06-01 14:03:35'
|Id [KEY]||String||The immutable system record ID of the membership.|
|The immutable system record ID of the constituent associated with the membership.|
|Category||String||The membership category.|
|DateAdded||Datetime||The date when the membership was created.|
|DateModified||Datetime||The date when the membership was last modified.|
|DuesValue||Integer||The membership dues.|
|Expires||Datetime||The date when the membership expires.|
|Joined||Datetime||The date when the membership becomes active.|
|Program||String||The membership program.|
|Standing||String||The membership status. Available values are New, Active, Lapsed, and Dropped.|
|Subcategory||String||The membership subcategory.|