SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

Opportunities

Retrieves a list of opportunities

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.

  • Id supports the '=' operator.
  • ConstituentId supports the '=,in' operators.
  • DateAdded supports the '>=,>' operators.
  • DateModified supports the '>=,>' operators.
  • IncludeInactive supports the '=' operator.
For example:
	
	SELECT * FROM Opportunities WHERE Id = '4'
	
	SELECT * FROM Opportunities WHERE ConstituentId IN ('255', '266')
	
	SELECT * FROM Opportunities WHERE DateAdded >= '1999-06-01 14:03:35'

Columns

Name Type References Description
Id [KEY] String The immutable system record ID of the opportunity.
AskAmountValue Double The monetary amount solicited from the prospect for the opportunity.
AskDate Date The date when the solicitation was made.
CampaignId String

Campaigns.Id

The immutable system record ID of the campaign associated with the opportunity. The campaign sets the overall objectives for raising money.
ConstituentId String

Constituents.Id

The immutable system record ID of the constituent associated with the opportunity.
DateAdded Datetime The date when the opportunity was created.
DateModified Datetime The date when the opportunity was last modified.
Deadline Datetime The goal date for the opportunity to result in a gift.
ExpectedAmountValue Double The monetary amount that is realistically expected to result from the opportunity.
ExpectedDate Datetime The date when the prospect is expected to give in response to the opportunity.
FundId String

Funds.Id

The immutable system record ID of the fund associated with the opportunity.
FundedAmountValue Double The monetary amount that the prospect gave in response to the opportunity.
FundedDate Datetime The date when the prospect gave in response to the opportunity.
Fundraisers String Fundraiser constituents interact with other constituents and prospects on behalf of your organization to cultivate relationships and advance opportunities to secure major gifts.
Inactive Boolean Indicates whether the opportunity is inactive.
LinkedGifts String The immutable system record IDs of the gifts related to the opportunity.
Name String The name that identifies the opportunity throughout the program, such as in lists or on constituent records.
Purpose String The intended use for any money raised as a result of the opportunity.
Status String The status that indicates where the opportunity is in the solicitation process.

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 opportunities in the response.
ListId String Defines a list identifier used to filter the set of opportunities to those included in the specified list. If this value is set, other specified filters will be ignored.

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