UpdateGiftStatus
Edit the status of a recurring gift.
Stored Procedures Specific Information
Process of Update Gift Status
BlackBaud Raiser's Edge NXT allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. The available columns for UpdateGiftStatus are GiftId and GiftStatus.
For example:
EXECUTE UpdateGiftStatus GiftId = '281', GiftStatus = 'Held'
Input
| Name | Type | Required | Description |
| GiftId | String | True | The immutable system record ID of the recurring gift to update. |
| GiftStatus | String | True | The new status of the recurring gift. Available values are Active, Held, Terminated, Completed, and Cancelled. |
Result Set Columns
| Name | Type | Description |
| Success | String | Execution status of the stored procedure |