JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Blackbaud Raisers Edge NXT Views

Name Description
ActionAttachments Retrieves a list of attachments for an action.
ActionCustomFields Retrieves custom fields for an action
Actions Retrieves a list of actions for all constituents and for specified constituent and details of the specified action.
Addresses Addresses store information about constituent residences and other addresses along with information about where or whether to send mail
Aliases Retrieves a list of aliases for a constituent
AppealAttachments Returns a list of attachments for an appeal.
CampaignAttachments Returns a list of attachments for a campaign.
Campaigns Campaigns are your organization's overall fundraising efforts or initiatives, such as operating expenses, new buildings, and endowments
ConsentCategories Returns a list of consent categories.
ConsentChannelCategories Returns a list of valid consent channel category combinations.
ConsentChannels Represents the consent channel entity
ConsentSources Represents the consent source entity
ConstituentAppeals Returns a list of appeals for a constituent.
ConstituentAttachments Returns a list of attachments for a constituent.
ConstituentCodes Constituent codes define the high-level affiliations between constituents and your organization - such as Board member, Vendor, and Volunteer - to provide context for why constituents are in the database
ConstituentConsents Returns a list of constituent consent records.
ConstituentFundraiserAssignments Returns a list of fundraiser assignments for a constituent.
Constituents Returns a paginated list of constituents
ConstituentsCustomFields Retrieves custom fields for all constituents
ConstituentSolicitCodes Returns a list of solicit codes for the specified constituent.
Countries Returns the list of available countries.
Educations Returns a list of educations for all constituent or a specified constituent
Emails Returns a list of email addresses of all constituents or a specified constituent
EventCategories Returns a list of active event categories.
EventFees Returns a list of fees for an event.
EventParticipantGuests The participant's basic summary information
EventParticipantMemberships The individual's membership category
EventParticipantOptions Returns the participant options for an event.
EventParticipants Returns a list of participants for an event.
Events Returns a list of events
FundAttachments Returns a list of attachments for a fund.
FundraiserAssignments Returns a list of assignments for a fundraiser.
FundraiserGoals Returns a list of goals for a fundraiser
FundraisingAppeals Returns a list of fundraising appeals.
Funds Returns a list of funds.
GiftAcknowledgements Returns a list of acknowledgements for a gift
GiftAttachments Returns a list of attachments for a gift.
GiftBatches Returns a list of gift batches.
GiftPayments Returns payments for a gift.
GiftReceipts Returns receipts for a gift.
Gifts Returns a paginated list of gifts
GiftsCustomFields Retrieves custom fields for all gifts
GiftSoftCredits Returns soft credits for a gift.
GiftSplits Returns the splits for a gift.
Giving Returns the first, latest or greatest gift recorded for a constituent.
GivingAppeals Returns the giving appeals summary for the constituent
GivingCampaigns Returns the giving campaigns summary for the constituent
GivingFunds Returns the giving funds summary for the constituent
LifetimeGiving Returns the lifetime giving information for a constituent.
Lists Returns a list of lists for the given list type
Members Returns the list of members.
Memberships Returns a list of memberships.
Notes Returns a list of notes that tracks helpful or important details such as specific interests and special instructions for donations
OnlinePresences Returns a paginated list of online presences that store a constituent's social media accounts, websites.
Opportunities Retrieves a list of opportunities
OpportunitiesCustomFields Retrieves custom fields for an opportunity
OpportunityAttachments Returns a list of attachments for an opportunity
Packages Returns a list of packages that contains content and other items for the appeals that organizations use to solicit gifts
ParticipantFeePayments Returns the fee payments for a participant.
ParticipantFees Returns a list of fees for a participant.
ParticipantLevels Returns a list of participation levels for all events.
ParticipantOptions Returns the participant options for a participant.
Phones Returns a list of phones for all constituents or a specific constituent
RatingCategories Returns a list of all available rating categories.
Ratings Returns a list of ratings for a constituent.
RatingSources Returns a list of all available rating sources.
Relationships Returns a list of relationships between constituents and other individuals and organizations such as family, friends, and employers

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462