FundraiserAssignments
Returns a list of assignments for a fundraiser.
Table Specific Information
Select
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.
Note: FundraiserId is required in order to query FundraiserAssignments.
- FundraiserId supports the '=' operator.
SELECT * FROM FundraiserAssignments WHERE FundraiserId = '4'
Columns
| Name | Type | References | Description |
| Id | String | The immutable system record ID of the given assignment. | |
| AmountValue | Double | The goal amount for the fundraiser to solicit from the assigned constituent. | |
| AppealId | String | The immutable system record ID of the appeal the fundraiser should use to request gifts. | |
| CampaignId | String |
Campaigns.Id | The immutable system record ID of the campaign to apply resulting gifts to. |
| ConstituentId | String |
Constituents.Id | The immutable system record ID of the target constituent. |
| End | Datetime | The fundraiser end date. | |
| FundId | String |
Funds.Id | The immutable system record ID of the fund any resulting gifts should be applied to. |
| FundraiserId | String | The immutable system record ID of the fundraiser assigned to the constituent. | |
| Start | Datetime | The fundraiser start date. | |
| Type | String | The type of fundraiser. |