NXTFunds
Returns a list of funds.
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.
- Id supports the '=' operator.
- FundId supports the '=' operator.
- Description supports the '=' operator.
- IncludeInactive supports the '=' operator.
SELECT * FROM NXTFunds WHERE FundId = 'ANNFUND' SELECT * FROM NXTFunds WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The immutable system record ID of the fund. | |
| FundId | String | The user-defined identifier for the fund. | |
| Description | String | The fund description. | |
| FundCategory | String | The fund category name. | |
| FundCategoryId | Integer | The fund category ID. | |
| FundType | String | The fund type name. | |
| FundTypeId | Integer | The fund type ID. | |
| Campaign | String | The campaign associated with the fund. | |
| CampaignId | Integer | The campaign ID associated with the fund. | |
| DefaultAppeal | String | The default appeal associated with the fund. | |
| DefaultAppealId | Integer | The default appeal ID associated with the fund. | |
| StartDate | Datetime | The fund start date. | |
| EndDate | Datetime | The fund end date. | |
| Inactive | Boolean | Whether the fund is inactive. | |
| Goal | Decimal | The monetary goal of the fund. | |
| Notes | String | The fund notes. | |
| Restricted | Boolean | Whether the fund is restricted. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive funds in the result. |