ConstituentAppeals
Returns a list of appeals for a constituent.
Table Specific Information
Select
The driver 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 driver.
- ConstituentId supports the '=' operator.
SELECT * FROM ConstituentAppeals WHERE ConstituentId = '280'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The immutable system record ID. | |
| AppealCategoryDescription | String | The appeal category description. | |
| AppealCategoryId | String | The immutable system record ID of the appeal category. | |
| AppealCategoryInactive | Boolean | Indicates whether the appeal category is inactive. | |
| AppealDescription | String | The appeal description. | |
| AppealId | String | The immutable system record ID of the appeal. | |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the constituent the appeal is associated to. |
| Date | Datetime | The date when the appeal was added. | |
| PackageDescription | String | The package description. | |
| PackageId | String | The package Id. | |
| Comments | String | The comments on the appeal. | |
| FinderNumber | String | The finder number on the appeal. | |
| MailingId | String | The mailing ID on the appeal. | |
| MarketingSegment | String | The marketing segment on the appeal. | |
| MarketingSourceCode | String | The marketing source code on the appeal. | |
| Response | String | The response to the appeal. |