SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

ParticipantOptions

Returns the participant options for a participant.

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.
Note: ParticipantId is required in order to query ParticipantOptions.

  • ParticipantId supports the '=' operator.
For example:
	SELECT * FROM ParticipantOptions WHERE ParticipantId = '197'

Columns

Name Type References Description
Id [KEY] String The ID of the participant option.
ParticipantId String

EventParticipants.Id

The ID of the participant.
AddedByService String The name of the service that added this participant option.
AddedByUser String The ID of the user that added the participant option.
DateAdded Datetime The date the participant option was added.
DateUpdated Datetime The date the participant option was updated.
EventId String The ID of the event.
EventParticipantOptionId String The ID of the event participant option.
OptionValue String The participant's response to the option.
UpdatedByService String The name of the service that updated this participant option.
UpdatedByUser String The ID of the user who updated the participant option.

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