JDBC Driver for Blackbaud Financial Edge NXT

Build 21.0.7930


Returns details for every fiscal period and project in scenario.

The driver 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 driver.

  • BudgetScenarioId, UiProjectId support the '=' operator. A blank search is not supported.
For example, the following queries are processed server side:
Select * FROM BudgetProjects WHERE BudgetScenarioId = 123
Select * FROM BudgetProjects WHERE BudgetScenarioId = 123 AND UiProjectId = 'abc' 
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.


Name Type References Description
BudgetScenarioId [KEY] Integer


The scenario id for this budget.
UiProjectId [KEY] String The user-visible identifier of the project.
BudgetCategory String The budget category for this period.
FiscalYear String


The fiscal year for this period.
FiscalPeriodId Integer


The fiscal period.
AccountNumber String


The account number for this period.
PeriodAmount Decimal The amount for this period.
TotalAmount Decimal The total amount for this period.
PeriodPercent Double The percent for this period.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930