SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

RatingCategories

Returns a list of all available rating categories.

Table Specific Information

Select

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

  • IncludeInactive supports the '=' operator.
  • SourceName supports the '=' operator.
For example:
	
	SELECT * FROM RatingCategories WHERE SourceName = 'Econometrics'
	
	SELECT * FROM RatingCategories WHERE IncludeInactive = true

Columns

Name Type References Description
Inactive Boolean Indicates whether the category is inactive.
Name String The name of the rating category.
SourceName String The source of the category.
Type String The type of the rating category.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IncludeInactive Boolean If set to true, includes inactive rating categories in the result.

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