Grants
Returns the list of grants.
The connector will use the Blackbaud Financial Edge NXT API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- GrantId supports the '=' operator.
- Type supports the '=' operator.
- Status supports the '=' operator.
- TransactionCodeValue supports the '=' operator.
SELECT * FROM Grants WHERE GrantId = 1
SELECT * FROM Grants WHERE Status = 'Active'
SELECT * FROM Grants WHERE Type = 'Campaign'
Columns
| Name | Type | References | Description |
| GrantId [KEY] | Integer | The grant identifier. | |
| UiGrantId | String | The grant user-visible identifier. | |
| Description | String | The grant description. | |
| Type | String | The grant type. | |
| Status | String | The grant status. | |
| StartDate | Datetime | The grant start date, in ISO 8601 format: 2016-03-14. | |
| EndDate | Datetime | The grant end date, in ISO 8601 format: 2016-03-14. | |
| TransactionCodeValue | String | The transaction code of the grant. | |
| Amount | Double | The amount of the grant. | |
| DateAdded | Datetime | The created date of the grant. | |
| AddedBy | String | The creator of the grant. | |
| DateModified | Datetime | The modified date of the grant. | |
| ModifiedBy | String | The modifier of the grant. |