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_1.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-05-24 (v4.1)
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.1
22
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.
23
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.
24
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.
25
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.
26
Schema sourcesMicrosoft Learn connector references: blackbaudraisersedge, blackbaudconstituent, blackbaudfundraising, blackbaudgifts. Membership API supplemented from Blackbaud community announcement posts.
27
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.
28
#Appeal!A1
29
Key updates in v4
30
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).
31
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.
32
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.
33
EntityRelationshipsAdded 7 FK rows linking each *CustomFields table back to its parent entity via parent_id.
34
Sheet orderingCustom Fields sheets are placed immediately after their parent entity sheet for logical browsing.
35
#Appeal!A1
36
Sheets in this workbook
37
Core constituent entityConstituent, Address, EmailAddress, Phone, Note
38
Constituent sub-entities (new in v3)
Action, Relationship, Membership, Education
39
Fundraising fact tablesGift, GiftSplit, GiftFundraiser, SoftCredit, Opportunity, OpportunityFundraiser
40
Fundraising hierarchyCampaign, Fund, Appeal
41
EventsEvent, EventParticipant, EventRegistrant
42
VolunteersVolunteer, VolunteerAssignment, VolunteerJob, VolunteerTimesheet, VolunteerAvailability, VolunteerEmergencyContact
43
Custom Fields (new in v4)ConstituentCustomFields, ActionCustomFields, GiftCustomFields, OpportunityCustomFields, CampaignCustomFields, FundCustomFields, AppealCustomFields
44
Reference & metadataEntityRelationships, FieldMapping, SKYAPIEndpoints, BreakingChanges
45
#VolunteerJob!A1
46
#Relationships!A1
47
#FieldMapping!A1
48
#Event!A1
49
#EventParticipant!A1
50
#EventRegistrant!A1
51
#Volunteer!A1
52
#VolunteerAssignment!A1
53
#VolunteerJob!A1
54
#VolunteerTimesheet!A1
55
#VolunteerAvailability!A1
56
#VolunteerEmergencyContact!A1
57
58
59
60
61
62
63
64
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