SSIS Components for Blackbaud Raisers Edge NXT

Build 24.0.9060

ParticipantLevels

Returns a list of participation levels for all events.

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.
For example:
	
	SELECT * FROM ParticipantLevels WHERE IncludeInactive = true

Columns

Name Type References Description
Id [KEY] String The ID of the participation level.
IsInactive Boolean Whether the participation level is inactive. True if inactive.
Name String The name of the participation level.

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 participation levels in the result.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060