ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Blackbaud Raiser's Edge NXT – Core Data Dictionary
3
Spreadsheet dictionary for constituent-related tables, gifts, opportunities, events, volunteers, and constituent sub-entities (Action, Relationship, Membership, Education).
4
5
WorkbookRENXT_core_data_dictionary_v4_2.xlsx
6
ScopeCore constituent-related tables, gifts, and opportunities based on public Blackbaud Raiser's Edge NXT SKY API product pages and entity documentation.
7
Entity groupsConstituent, Address, EmailAddress, Phone, Note, Gift, GiftSplit, GiftFundraiser, SoftCredit, Opportunity, OpportunityFundraiser, Campaign, Fund, Appeal, Action, Relationship, Membership, Education, Event, EventParticipant, EventRegistrant, Volunteer, VolunteerAssignment, VolunteerJob, VolunteerTimesheet, VolunteerAvailability, VolunteerEmergencyContact
8
Modeling noteThis workbook is an ERD-style analytical data dictionary. The Action, Relationship, Membership, and Education sheets were rebuilt against the current SKY API documentation (Constituent API v1 and Membership API v1, post 2025-03-10 endpoint change). The EntityRelationships sheet (formerly 'Relationships') summarizes how every child entity links to Constituent for relational reporting.
9
Generated2026-06-04 (v4.2)
10
Source URLhttps://developer.blackbaud.com/skyapi/products/renxt
11
12
Key updates in v3
13
Action sheetNew entity sheet with 23 fields documenting category, status, dates, fundraisers, opportunity link, and audit timestamps from the Constituent API Action entity.
14
Relationship sheetNew entity sheet with 23 fields documenting type, reciprocal_type, FuzzyDate start/end, head-of-household and organization-contact flags, and the reciprocal_relationship_id self-reference.
15
Membership sheetNew entity sheet with 21 fields (category/subcategory/program/reason flattened to value+legacy_id pairs). Endpoint paths reflect the 2025-03-10 breaking change that removed '/skyapi/' from Membership API paths.
16
Education sheetNew entity sheet with 26 fields including UK-specific fields (class_of_degree, department, faculty, registration_number, subject_of_study) and three FuzzyDate columns.
17
EntityRelationshipsRenamed from 'Relationships' (the FK map sheet). Eight new FK rows added linking Action, Relationship, Membership, and Education back to Constituent.
18
SKYAPIEndpoints sheetNew reference sheet listing 34 REST endpoints (operations + code tables) across all four newly documented modules.
19
BreakingChanges sheetNew sheet documenting the Membership API '/skyapi/' path removal (announced 2025-02-25, effective 2025-03-10) and confirming no breaking changes for the other three modules.
20
#GiftSplit!A1
21
Key updates in v4.2
22
New entity sheets (5)Added Alias, CommunicationPreference, ConstituentCode, ConstituentAttachment, ActionAttachment. All are peer entities to Address/EmailAddress/Phone/OnlinePresence (one-to-many under Constituent), except ActionAttachment which is one-to-many under Action.
23
Alias4 fields: id, constituent_id, name (free-text up to 100 chars — not split first/middle/last), type (logical FK to alias type list). PATCH does not include constituent_id.
24
CommunicationPreference5 fields covering /communicationpreferences endpoints. IMPORTANT: these endpoints are solicit-code-only (e.g. 'Do Not Solicit', 'No Email') and are flagged for deprecation. Full channel-level consent (channel, consent_statement, consent_source, response_date) uses /constituents/{id}/consents — added as a supplementary row in SKYAPIEndpoints.
25
ConstituentCode15 fields including the code value (description), sequence (1 = primary), and fuzzy-date start/end. The description field CANNOT be changed via PATCH — delete and recreate to change the code value.
26
Attachment (split into two)ConstituentAttachment (13 fields) and ActionAttachment (12 fields) share the same shape but have different parents. Both support type='Physical' (uploaded file via CreateDocument) or 'Link' (external URL). ActionAttachment PATCH body allows changing parent_id and type, unlike ConstituentAttachment.
27
Sheet orderingConstituent sub-entities now flow: Address → EmailAddress → Phone → OnlinePresence → Alias → CommunicationPreference → ConstituentCode → ConstituentAttachment → Note → ConstituentCustomFields. ActionAttachment sits right after ActionCustomFields.
28
29
Key updates in v4.1
30
Field coverage auditAudited every primary entity sheet against the official POST request body schema. Previous sheets were built from a high-level summary view and were missing many fields the API actually accepts.
31
Constituent sheet expandedGrew from 12 fields to 69 fields. Now includes birthplace, gender, former_name, marital_status, preferred_name, middle, ethnicity, religion, income, title/suffix 1 & 2, gives_anonymously, fuzzy date_of_birth (day/month/year), primary_addressee and primary_salutation (with custom_format / configuration_id / formatted_name), requests_no_email, is_solicitor, no_valid_address, target, receipt_type, is_memorial, matching_gift_factor, num_employees, plus all matching-gift min/max fields for organizations.
32
Sheets rebuiltConstituent (69), Action (20), Gift (36), Opportunity (19), Campaign (12), Fund (15), Appeal (15), Event (16), Membership (16), Education (30), Relationship (21). 269 total field rows across 11 entities.
33
Constituent typeConstituent sheet now merges Individual and Organization variants. Each row indicates 'Applies to: Individual only / Organization only / Individual + Organization' in the Lineage / Notes column.
34
Schema sourcesMicrosoft Learn connector references: blackbaudraisersedge, blackbaudconstituent, blackbaudfundraising, blackbaudgifts. Membership API supplemented from Blackbaud community announcement posts.
35
OnlinePresence sheet (post-v4.1 add)
Added OnlinePresence sheet with 8 fields (id, constituent_id, type, address, primary, inactive, date_added, date_modified) parallel to Address, EmailAddress, and Phone. Added 6 OnlinePresence REST endpoints to SKYAPIEndpoints and 1 FK row to EntityRelationships.
36
#Appeal!A1
37
Key updates in v4
38
Custom Fields sheets (7)Added ConstituentCustomFields, ActionCustomFields, GiftCustomFields, OpportunityCustomFields, CampaignCustomFields, FundCustomFields, AppealCustomFields. Each documents the shared 9-field schema (id, parent_id, category, type, value, date, comment, date_added, date_modified).
39
Custom Fields scopeOnly entities with documented SKY API custom field endpoints are included. Event, Membership, Education, and Relationship do NOT have custom field endpoints in SKY API.
40
Custom Field API previewAdded rows in SKYAPIEndpoints for the new Custom Field API (Public Preview, April 2026) which manages custom field categories themselves at /customfield/v1/customfieldcategories.
41
EntityRelationshipsAdded 7 FK rows linking each *CustomFields table back to its parent entity via parent_id.
42
Sheet orderingCustom Fields sheets are placed immediately after their parent entity sheet for logical browsing.
43
#Appeal!A1
44
Sheets in this workbook
45
Core constituent entityConstituent, Address, EmailAddress, Phone, Note
46
Constituent sub-entities (new in v3)
Action, Relationship, Membership, Education
47
Fundraising fact tablesGift, GiftSplit, GiftFundraiser, SoftCredit, Opportunity, OpportunityFundraiser
48
Fundraising hierarchyCampaign, Fund, Appeal
49
EventsEvent, EventParticipant, EventRegistrant
50
VolunteersVolunteer, VolunteerAssignment, VolunteerJob, VolunteerTimesheet, VolunteerAvailability, VolunteerEmergencyContact
51
Custom Fields (new in v4)ConstituentCustomFields, ActionCustomFields, GiftCustomFields, OpportunityCustomFields, CampaignCustomFields, FundCustomFields, AppealCustomFields
52
Reference & metadataEntityRelationships, FieldMapping, SKYAPIEndpoints, BreakingChanges
53
#VolunteerJob!A1
54
#Relationships!A1
55
#FieldMapping!A1
56
#Event!A1
57
#EventParticipant!A1
58
#EventRegistrant!A1
59
#Volunteer!A1
60
#VolunteerAssignment!A1
61
#VolunteerJob!A1
62
#VolunteerTimesheet!A1
63
#VolunteerAvailability!A1
64
#VolunteerEmergencyContact!A1
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100