GiftAidTaxDeclarations
Returns a list of Gift Aid tax declarations.
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.
- DeclarationId supports the '=' operator.
- ConstituentId supports the '=' operator.
SELECT * FROM GiftAidTaxDeclarations WHERE ConstituentId = 280 SELECT * FROM GiftAidTaxDeclarations WHERE DeclarationId = 1
Columns
| Name | Type | References | Description |
| DeclarationId [KEY] | Integer | The immutable system record ID of the declaration. | |
| ConstituentId | Integer | The system record ID of the constituent. | |
| ImportId | String | The import identifier for the declaration. | |
| Sequence | Integer | The sequence number of the declaration. | |
| ConstituentPaysTax | Boolean | Indicates whether the constituent pays tax. | |
| TaxPayerStatus | String | The tax payer status of the constituent. | |
| TaxPayerStatusId | Integer | The tax payer status code ID. | |
| DeclarationIndicator | String | The declaration indicator. | |
| DeclarationIndicatorId | Integer | The declaration indicator code ID. | |
| DeclarationSource | String | The declaration source. | |
| DeclarationSourceId | Integer | The declaration source code ID. | |
| DeclarationMade | Datetime | The date the declaration was made. | |
| ConfirmationSent | Datetime | The date the confirmation was sent. | |
| ConfirmationReturned | Datetime | The date the confirmation was returned. | |
| DeclarationStarts | Datetime | The date the declaration takes effect. | |
| DeclarationEnds | Datetime | The date the declaration expires. | |
| TaxNotes | String | Notes about the tax declaration. |