Blackbaud Enterprise Data Warehouse Tables
This page provides a comprehensive listing of the tables available in Blackbaud Data Warehouse version 4.0SP40.
| Table | Description |
|---|---|
| CONFIGFISCALYEARINFO | |
| CONSTITUENCYCRITERIA | Stores information about constituency criteria settings |
| DIM_ACCOUNTSYSTEM | Stores information about account systems |
| DIM_ADDON | Contains information about membership program add-ons. |
| DIM_ADJUSTMENTREASON | Contains information about adjustment reasons. |
| DIM_APPEAL | The Appeal dimension contains information about the appeal. |
| DIM_APPUSER | Contains information about application users |
| DIM_ATTRIBUTE | Contains information about attribute. |
| DIM_BENEFIT | Contains information about benefits. |
| DIM_BENEFIT_STAGE | Intermediate storage table for benefits. |
| DIM_BENEFITTYPE | Contains information about an event registration. |
| DIM_BUSINESSUNIT | Stores information about business units |
| DIM_CAMPAIGN | The dimension contains information about campaigns. |
| DIM_CAMPAIGN_STAGE | Intermediate storage table for campaigns |
| DIM_CAMPAIGNPRIORITY | The Campaign Priority dimension contains information about campaign priorities. |
| DIM_CONDITIONSETTING | Contains conditions and their states. |
| DIM_CONSTITUENCY | The Constituency dimension contains information about constituencies. This includes user defined constituencies as well as system defined ones (Volunteer, Board Member, Fundraiser, Group Member, Staff, and Committee). |
| DIM_CONSTITUENT | The Constituent dimension contains information about the constituent including primary address |
| DIM_CONSTITUENT_STAGE | The Constituent dimension contains information about the constituent including primary address |
| DIM_CONSTITUENTADDRESS | The Constituent Address dimension contains information about constituent addresses. |
| DIM_CONSTITUENTADDRESSDETAIL | Contains additional information about constituent addresses. |
| DIM_CONSTITUENTADDRESSFLAG | Contains flags for constituent addresses. |
| DIM_CONSTITUENTADDRESSTYPE | Contains address types used for constituent addresses. |
| DIM_CONSTITUENTDECEASED_STAGE | Contains information about deceased constituents who have been marked not deceased. |
| DIM_CONSTITUENTDEMOGRAPHIC | Contains demographic information about constituents. |
| DIM_CONSTITUENTEMAILADDRESS | Contains information about constituent email addresses |
| DIM_CONSTITUENTEMAILADDRESSFLAG | Contains flags for constituent email addresses |
| DIM_CONSTITUENTEMAILADDRESSTYPE | Contains information about constituent email address types |
| DIM_CONSTITUENTGROUP | Stores information about constituent groups and households |
| DIM_CONSTITUENTGROUP_STAGE | Intermediate storage table for DIM_CONSTITUENTGROUP |
| DIM_CONSTITUENTGROUPMEMBERROLE | Stores information about constituent group members |
| DIM_CONSTITUENTINFORMATION | Contains information about constituents. |
| DIM_CONSTITUENTINTEREST | Contains information about constituent interests. |
| DIM_CONSTITUENTINTEREST_STAGE | Contains information about constituent interests. |
| DIM_CONSTITUENTPHONE | Contains details about Constituent Phone Numbers |
| DIM_CONSTITUENTPHONEFLAG | The Constituent Phone Flag dimension contains flags for constituent phone numbers |
| DIM_CONSTITUENTPHONETYPE | Contains information about constituent phone types |
| DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT | Contains information about constituent employment. |
| DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT_STAGE | Intermediate storage table for constituent employment. |
| DIM_CONSTITUENTRELATIONSHIPFLAG | Contains flags for constituent relationships. |
| DIM_CONSTITUENTRELATIONSHIPSET | Contains sets used for constituent relationships. |
| DIM_CONSTITUENTRELATIONSHIPSET_STAGE | Contains sets used for constituent relationships. |
| DIM_CONSTITUENTRELATIONSHIPTYPE | Contains relationship types used for constituent relationships. |
| DIM_CONSTITUENTSECURITYGROUP | Contains information about constituent security groups |
| DIM_CONTACTTYPE | Contains contact types used for constituent relationships. |
| DIM_COUNTRY | Contains information about countries |
| DIM_CREDITCARDTYPE | Contains information about credit card types |
| DIM_CURRENCY | Contains information about currencies. |
| DIM_DATE | Contains calendar-year and fiscal-year dates, plus other date-related attributes. |
| DIM_DATE_FISCALPERIOD_STAGE | Intermediate storage table for fiscal period information |
| DIM_DESIGNATION | The dimension contains information about designations. |
| DIM_DONOTCALLREASON | Contains information about Constituent Phone Do Not Call Reasons |
| DIM_DONOTMAILREASON | Contains the do not mail reason used for constituent addresses. |
| DIM_EDUCATION | The Education dimension contains information about a constituents educational history. |
| DIM_EDUCATION_STAGE | The Education additional information dimension contains additional information about a constituents educational history. |
| DIM_EDUCATIONADDITIONALINFORMATION | The Education Additional Information dimension contains additional information about a constituents educational history. |
| DIM_EDUCATIONADDITIONALINFORMATION_STAGE | Intermediate storage table for DIM_EDUCATIONADDITIONALINFORMATION |
| DIM_EDUCATIONALINVOLVEMENT | Educational involvement, based on the EDUCATIONALINVOLVEMENT table. |
| DIM_EDUCATIONALINVOLVEMENT_STAGE | Educational involvement, based on the EDUCATIONALINVOLVEMENT table. |
| DIM_EMAILCAMPAIGN | Email sent to constituents through Luminate Online. |
| DIM_EMAILCAMPAIGN_STAGE | Email sent to constituents through Luminate Online. |
| DIM_EMAILMESSAGE | Email sent to constituents through Luminate Online. |
| DIM_EMAILMESSAGE_STAGE | Email sent to constituents through Luminate Online. |
| DIM_ETHNICITY | Contains ethnicity information for constituents. |
| DIM_EVENT | Contains information about an event. |
| DIM_EVENT_STAGE | Intermediate storage table for events |
| DIM_EVENTGOALTYPE | Contains information about event goals |
| DIM_EVENTREGISTRANTROLE_STAGE | Contains information about a registrants role |
| DIM_EVENTREGISTRATION | Contains information about an event registration. |
| DIM_EVENTREGISTRATIONCODES | Contains information about inbound and recruitment channels and roles. |
| DIM_FUNDINGREQUEST | contains information about funding requests. |
| DIM_FUNDINGREQUESTOUTLINESTEP | Contains information about the funding request outline step dimension. |
| DIM_FUNDRAISER | All Fundraisers as defined in dbo.[FUNDRAISERDATERANGE]. Main information from the DIM_CONSTITUENT table; Also includes additional summary information about a Fundraiser's activity. |
| DIM_FUNDRAISERCAMPAIGN | The dimension relates fundraisers to campaigns |
| DIM_FUNDRAISERSECONDARY | Relates additional fundraisers to a prospect plan. |
| DIM_FUNDRAISERTEAM | Contains information about fundraising teams. |
| DIM_FUNDRAISERTEAM_STAGE | Intermediate storage table for DIM_FUNDRAISERTEAM |
| DIM_FUNDRAISERTEAMFLAGS_STAGE | Contains flags indicating availability of team's images, videos, and story. |
| DIM_FUNDRAISERTEAMMEMBER | contains information about fundraising team members. |
| DIM_FUNDRAISERTEAMURL_STAGE | Contains team URL. |
| DIM_GLREVENUECATEGORY | Contains information about GL revenue categories. |
| DIM_GROUPLEADERS_STAGE | Contains information about group leaders associated with this registrants household, team or company. |
| DIM_IDSETREGISTER | Contains information about selections. |
| DIM_INSTALLMENT | Contains information about an installment. |
| DIM_INSTALLMENT_STAGE | Contains information about an installment. |
| DIM_INTERACTION | The Interaction dimension contains information about constituent interactions. |
| DIM_LETTER | Stores information about letters |
| DIM_LETTER_STAGE | Staging table for the letter dimension |
| DIM_MAILPREFERENCE | Stores information about mailing preferences |
| DIM_MARKETINGSEGMENT | The Marketing Segment dimension contains information about marketing efforts and their segments, test segments, packages and letters. |
| DIM_MARKETINGSEGMENT_STAGE | Contains information about marketing segments |
| DIM_MARKETINGSEGMENTATION | The Marketing Effort dimension contains information about marketing efforts. |
| DIM_MARKETINGSEGMENTATION_STAGE | Intermediate storage table for DIM_MARKETINGSEGMENTATION table. |
| DIM_MARKETINGSOURCECODE | The Marketing Source Code dimension contains information about source codes used in marketing efforts. |
| DIM_MARKETINGSOURCECODE_STAGE | Marketing Source Code Table |
| DIM_MARKETINGSOURCECODEPART | The Marketing Source Code Part dimension contains information about source code parts used in marketing source codes. |
| DIM_MARKETINGSOURCECODEPART_STAGE | Staging table for the Marketing Source Code Part dimension |
| DIM_MEMBERFLAG | Contains flags for members. |
| DIM_MEMBERSHIP | Contains information about memberships. |
| DIM_MEMBERSHIP_STAGE | Intermediate storage table for memberships. |
| DIM_MEMBERSHIPACTION | Contains actions for memberships. |
| DIM_MEMBERSHIPPROGRAM | Contains information about membership programs. |
| DIM_MEMBERSHIPSTATUS | Contains statuses for memberships. |
| DIM_ONLINECONSTITUENT_STAGE | Constituent synced to an external online system. |
| DIM_OTHERPAYMENTMETHOD | Stores information about other payment method |
| DIM_PLANNEDGIFT | Stores information about planned gifts. |
| DIM_PLANNEDGIFT_STAGE | Staging table for the planned gift dimension. |
| DIM_PLANOUTLINESTEP | Contains informationabout prospect plan outline steps. |
| DIM_PLANPARTICIPANT | Contains information on plan participants. |
| DIM_PROCESS | Stores information about various processes |
| DIM_PROCESS_STAGE | Intermediate storage for the process dimension |
| DIM_PROSPECT | Contains information about prospects. |
| DIM_PROSPECTFUNDINGINTEREST | Contains information about prospect funding interests. |
| DIM_PROSPECTPLAN | Contains information about prospect plans. |
| DIM_PROSPECTPLANREQUESTASSIGNMENT | Contains information about prospect plan assignment requests |
| DIM_PROSPECTPLANSTATUS | Contains information about prospect plant status codes. |
| DIM_PURPOSELEVEL | The purpose level dimension contains information about designation purposes. |
| DIM_RECURRINGGIFTDEVELOPMENT | DEPRECATED as of 4.0. Contains information about recurring gift development. |
| DIM_RECURRINGGIFTFLAG | Contains boolean flags for recurring gift installments. |
| DIM_RECURRINGGIFTSTATUSREASON | Stores information about recurring gift status reasons. |
| DIM_RECURRINGGIFTSTATUSREASON_STAGE | Staging table for the recurring gift status reason dimension. |
| DIM_RESPONSE | The Response dimension contains information about responses to constituent appeals, constituent correspondence and constituent interactions. |
| DIM_REVENUECHANNEL | Contains information about revenue channels. |
| DIM_REVENUECODE | Contains type code values for revenue records. |
| DIM_REVENUEFLAG | Contains boolean flags for revenue records. |
| DIM_REVENUEOTHERTYPECODE | Stores information about other revenue type |
| DIM_REVENUERECOGNITIONTYPE | Contains descriptive information about the revenue recognition type. |
| DIM_REVENUESCHEDULE | Contains information about a Revenue Schedule. |
| DIM_SITE | Main Site table used for Site security. Based on the SITE table. |
| DIM_SITE_STAGE | Intermediate storage table for sites |
| DIM_SMARTFIELD | Contains information about smart fields. |
| DIM_SOLICITCODE | Stores information about solicit codes |
| DIM_SOURCE | This describes all data sources being fed into the Data Warehouse. By default there is only 1 which is BBEC and this pulls some info from the INSTALLATIONINFO table. |
| DIM_SPONSOR | Stores information about sponsors |
| DIM_SPONSOR_STAGE | Intermediate storage for sponsors |
| DIM_SPONSORSHIP | Stores information about sponsorships |
| DIM_SPONSORSHIP_STAGE | Intermediate storage for sponsorship records |
| DIM_SPONSORSHIPLOCATION | Stores information about sponsorship locations |
| DIM_SPONSORSHIPLOCATION_STAGE | Intermediate storage for sponsorship location records |
| DIM_SPONSORSHIPOPPORTUNITYCHILD | Stores information about sponsorship opportunity children |
| DIM_SPONSORSHIPOPPORTUNITYCHILD_STAGE | Intermediate storage for sponsorship opportunity child records |
| DIM_SPONSORSHIPOPPORTUNITYPROJECT | Stores information about sponsorship opportunity projects |
| DIM_SPONSORSHIPOPPORTUNITYPROJECT_STAGE | Intermediate storage for sponsorship opportunity project records |
| DIM_SPONSORSHIPREASON | Stores information about sponsorship reasons |
| DIM_SPONSORSHIPREASON_STAGE | Intermediate storage for sponsorship reason records |
| DIM_STORY_STAGE | Contains information about registrant customization of images and stories in HQ. |
| DIM_SYSTEMROLE | Contains information about system roles |
| DIM_TIME | Contains times |
| DIM_TIMEZONE | Stores information about time zones |
| DIM_TRIBUTE | Contains information about tributes associated with revenues. |
| DIM_TRIBUTE_STAGE | Contains information about tributes associated with revenues. |
| DIM_WEEK | The Week dimension is a list of weeks used for weeks from calculations. |
| DIM_WRITEOFF | Contains information about a Write-offs. |
| ETLCONTROL | |
| FACT_ACCOUNTSYSTEMSITE | Contains information about sites associated with account systems. |
| FACT_ACCOUNTSYSTEMSITE_STAGE | Intermediate storage table for account system sites. |
| FACT_APPEALATTRIBUTE | Contains information from appeal attributes. |
| FACT_APPEALATTRIBUTE_STAGE | Staging table for the appeal attributes fact. |
| FACT_BENEFITATTRIBUTE | Contains information from benefit attributes. |
| FACT_BENEFITATTRIBUTE_STAGE | Contains information from benefit attributes. |
| FACT_CAMPAIGNGOAL | Contains information about the campaign goals and campaign hierarchy goals. |
| FACT_CAMPAIGNGOAL_STAGE | Intermediate storage for information about the campaign goals and campaign hierarchy goals. |
| FACT_CAMPAIGNSITE | Contains information about sites associated with campaigns. |
| FACT_CAMPAIGNSITE_STAGE | Intermediate storage table for campaign sites. |
| FACT_CONSTITUENCY | The Constituency fact associates constituents to constituencies. This includes user defined constituencies as well as system defined ones (Volunteer, Board Member, Fundraiser, Group Member, Staff, and Committee). |
| FACT_CONSTITUENCY_STAGE | The Constituency fact associates constituents to constituencies. This includes user defined constituencies as well as system defined ones (Volunteer, Board Member, Fundraiser, Group Member, Staff, and Committee). |
| FACT_CONSTITUENTADDRESS | Contains information about constituent addresses. |
| FACT_CONSTITUENTADDRESS_STAGE | Intermediate storage table for constituent addresses. |
| FACT_CONSTITUENTADDRESSATTRIBUTE | Contains information from constituent address attributes. |
| FACT_CONSTITUENTADDRESSATTRIBUTE_STAGE | Contains information from constituent address attributes. |
| FACT_CONSTITUENTAPPEAL | The Constituent Appeal fact table lists every constituent for each appeal. |
| FACT_CONSTITUENTAPPEAL_STAGE | The Constituent Appeal fact table lists every constituent for each appeal. |
| FACT_CONSTITUENTATTRIBUTE | Contains information from constituent attributes. |
| FACT_CONSTITUENTATTRIBUTE_STAGE | Contains information from constituent attributes. |
| FACT_CONSTITUENTEMAILADDRESS | Contains information about constituent email addresses |
| FACT_CONSTITUENTEMAILADDRESS_STAGE | Intermediate storage for constituent email addresses |
| FACT_CONSTITUENTETHNICITY | Lists the ethnicities listed for constituents. |
| FACT_CONSTITUENTETHNICITY_STAGE | Lists the ethnicities listed for constituents. |
| FACT_CONSTITUENTGROUPMEMBER | Stores information about constituent group members |
| FACT_CONSTITUENTGROUPMEMBER_STAGE | Intermediate storage table for FACT_CONSTITUENTGROUPMEMBER |
| FACT_CONSTITUENTGROUPMEMBERROLE | Stores information about roles for constituent group members |
| FACT_CONSTITUENTGROUPMEMBERROLE_STAGE | Intermediate storage table for FACT_CONSTITUENTGROUPMEMBERROLE |
| FACT_CONSTITUENTMAILPREFERENCE | Stores mail preferences for constituents |
| FACT_CONSTITUENTMAILPREFERENCE_STAGE | Intermediate storage for the constituent mail preference fact |
| FACT_CONSTITUENTPHONE | Stores information about constituent phone numbers |
| FACT_CONSTITUENTPHONE_STAGE | Intermediate storage for constituent phone numbers |
| FACT_CONSTITUENTRELATIONSHIP | Contains information about constituent relationships. |
| FACT_CONSTITUENTRELATIONSHIP_STAGE | Intermediate storage table for constituent relationships. |
| FACT_CONSTITUENTSECURITYGROUPASSIGNMENT | Contains information about constituent security group assignments |
| FACT_CONSTITUENTSECURITYGROUPASSIGNMENT_STAGE | Intermediate storage table for constituent security group assignments |
| FACT_CONSTITUENTSITE | Contains information about sites associated with constituents. |
| FACT_CONSTITUENTSITE_STAGE | Intermediate storage table for constituent sites. |
| FACT_CONSTITUENTSMARTFIELD | Contains information from constituent smart fields. |
| FACT_CONSTITUENTSMARTFIELD_STAGE | Contains information from constituent smart fields. |
| FACT_CONSTITUENTSOLICITCODE | Stores information about constituent solicit codes |
| FACT_CONSTITUENTSOLICITCODE_STAGE | Intermediate storage table for FACT_CONSTITUENTSOLICITCODE |
| FACT_DATAFORMINSTANCESECURITY | Surrogate key for the dataform instance security fact |
| FACT_DATAFORMINSTANCESECURITY_STAGE | Intermediate storage table for data form instance security |
| FACT_DATALISTSECURITY | Surrogate key for the datalist security fact |
| FACT_DATALISTSECURITY_STAGE | Intermediate storage table for datalist security |
| FACT_DEFAULTREVENUEFILTER_STAGE | Intermediate storage for default revenue filter |
| FACT_DESIGNATIONATTRIBUTE | Contains information from designation attributes. |
| FACT_DESIGNATIONATTRIBUTE_STAGE | Contains information from designation attributes. |
| FACT_EDUCATIONATTRIBUTE | Contains information from education attributes. |
| FACT_EDUCATIONATTRIBUTE_STAGE | Contains information from education attributes. |
| FACT_EMAILACTIVITY | Email sent to constituents through Luminate Online. |
| FACT_EMAILACTIVITY_STAGE | Email sent to constituents through Luminate Online. |
| FACT_EVENTATTRIBUTE | Contains information from eventattributes. |
| FACT_EVENTATTRIBUTE_STAGE | Contains information from event attributes. |
| FACT_EVENTPRICE | The Event price fact table contains information about event prices (registration options). |
| FACT_EVENTPRICE_STAGE | The Event price fact table contains information about event prices (registration options). |
| FACT_EVENTREGISTRANT | Contains information about an event registrations. |
| FACT_EVENTREGISTRANT_STAGE | Contains information about an event registrations. |
| FACT_EVENTREGISTRANTATTRIBUTE | Contains information from event registrant attributes. |
| FACT_EVENTREGISTRANTATTRIBUTE_STAGE | Contains information from event registrant attributes. |
| FACT_EVENTREGISTRANTBENEFIT | Contains information about benefits. |
| FACT_EVENTREGISTRANTBENEFIT_STAGE | Intermediate storage table for benefits. |
| FACT_EVENTREGISTRANTBENEFITTOTAL | Intermediate storage table for benefits. |
| FACT_EVENTREGISTRANTBENEFITTOTAL_STAGE | Intermediate storage table for benefits. |
| FACT_EVENTREGISTRANTFEES_STAGE | Contains fee information about event registrations. |
| FACT_EVENTREGISTRANTPERSONALURL_STAGE | Contains personal URL. |
| FACT_EVENTREGISTRANTTOTAL | Contains aggregate information about event registrations. |
| FACT_EVENTREGISTRANTTOTALDONORRETENTION_STAGE | Contains donor retention summary data for registrants |
| FACT_EVENTREGISTRANTTOTALLASTLOGIN_STAGE | Contains donor retention summary data for registrants |
| FACT_EVENTREGISTRANTTOTALPENDING_STAGE | Contains pending gifts summary data |
| FACT_EVENTREGISTRATIONOPPORTUNITY | Relates opportunities to event registrations. |
| FACT_EVENTREGISTRATIONOPPORTUNITY_STAGE | Relates opportunities to event registrations. |
| FACT_EVENTSITE | Contains information about sites associated with events. |
| FACT_EVENTSITE_STAGE | Intermediate storage table for event sites. |
| FACT_FINANCIALTRANSACTION | Contains information about financialtransaction. |
| FACT_FINANCIALTRANSACTION_STAGE | Contains information about financialtransaction. |
| FACT_FINANCIALTRANSACTIONATTRIBUTE | Contains information from revenue attributes. |
| FACT_FINANCIALTRANSACTIONATTRIBUTE_STAGE | Contains information from revenue attributes. |
| FACT_FINANCIALTRANSACTIONLINEITEM | Contains information about financialtransactionlineitem. |
| FACT_FINANCIALTRANSACTIONLINEITEM_STAGE | Contains information about financialtransactionlineitem. |
| FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE | Contains information from financial transaction line item attributes. |
| FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE_STAGE | Staging table for the financial transaction line item attributes fact. |
| FACT_FINANCIALTRANSACTIONLINEITEMSITE | Stores information about the sites that have security rights to a financial transaction line item |
| FACT_FINANCIALTRANSACTIONLINEITEMSITE_STAGE | Intermediate storage table for FACT_FINANCIALTRANSACTIONLINEITEMSITE |
| FACT_FUNDINGREQUESTATTRIBUTE | Contains information from funding request attributes. |
| FACT_FUNDINGREQUESTATTRIBUTE_STAGE | Contains information from funding request attributes. |
| FACT_FUNDRAISERINTERACTIONADDITIONAL | Contains information about additional participants on an interaction. |
| FACT_FUNDRAISERINTERACTIONADDITIONAL_STAGE | Intermediate storage for additional participants on an interaction. |
| FACT_FUNDRAISERTEAMTOTAL | Contains aggregate information about group registrations. |
| FACT_FUNDRAISERTEAMTOTAL_STAGE | Contains aggregate group information. |
| FACT_FUNDRAISERTEAMTOTALEXTENSION_STAGE | Contains additional aggregate group information. |
| FACT_INSTALLMENT | Contains information about installments. |
| FACT_INSTALLMENT_STAGE | Intermediate storage table for FACT_INSTALLMENT. |
| FACT_INSTALLMENTPAYMENT | Contains information about installment payments. |
| FACT_INSTALLMENTPAYMENT_STAGE | Contains information about installment payments. |
| FACT_INSTALLMENTWRITEOFF | Contains information about installment write-offs. |
| FACT_INSTALLMENTWRITEOFF_STAGE | Contains information about installment write-offs. |
| FACT_INTERACTION | The Interaction fact relates information to constituent interactions. |
| FACT_INTERACTION_STAGE | The Interaction fact relates information to constituent interactions. |
| FACT_INTERACTIONATTRIBUTE | Contains information from interaction attributes. |
| FACT_INTERACTIONATTRIBUTE_STAGE | Contains information from interaction attributes. |
| FACT_INTERACTIONPARTICIPANT | Contains information about additional participants on an interaction. |
| FACT_INTERACTIONPARTICIPANT_STAGE | Intermediate storage table for interaction participants. |
| FACT_INTERACTIONRESPONSE | The Interaction Response fact relates responses to constituent interactions. |
| FACT_INTERACTIONRESPONSE_STAGE | Intermediate storage table for FACT_INTERACTIONRESPONSE |
| FACT_INTERACTIONSITE | Contains the sites for interactions. |
| FACT_INTERACTIONSITE_STAGE | Contains the sites for interactions. |
| FACT_MARKETINGCONSTITUENT | The Marketing Constituent fact table lists every constituent for each marketing effort. |
| FACT_MARKETINGCONSTITUENT_STAGE | The Marketing Constituent fact table lists every constituent for each marketing effort. |
| FACT_MARKETINGREFRESHPROCESS_STAGE | Contains the system IDs for the all the marketing efforts that have been refreshed since the last ETL refresh. |
| FACT_MARKETINGREVENUE_STAGE | The marketing revenue fact table lists the marketing information for revenue. |
| FACT_MARKETINGSEGMENTATIONDAILYRESPONSE | The Marketing Effort fact table lists every daily response for each marketing effort. |
| FACT_MARKETINGSEGMENTATIONDAILYRESPONSE_STAGE | Intermediate storage table for aFACT_MARKETINGSEGMENTATIONDAILYRESPONSE table. |
| FACT_MEMBER | Contains information about members. |
| FACT_MEMBER_STAGE | Intermediate storage table for members. |
| FACT_MEMBERSHIPADDON | Contains information about membership add-ons. |
| FACT_MEMBERSHIPADDON_STAGE | Intermediate storage table for membership add-ons. |
| FACT_MEMBERSHIPATTRIBUTE | Contains information from membership attributes. |
| FACT_MEMBERSHIPATTRIBUTE_STAGE | Contains information from membership attributes. |
| FACT_MEMBERSHIPRENEWALRULES | Contains information about membership renewal rules. |
| FACT_MEMBERSHIPRENEWALRULES_STAGE | Intermediate storage table for membership renewal rules. |
| FACT_MEMBERSHIPREVENUE | Contains information about membership revenue. This table is populated from dbo.[MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE] and dbo.[MEMBERSHIPTRANSACTION]. |
| FACT_MEMBERSHIPREVENUE_STAGE | Intermediate storage table for membership revenue. |
| FACT_MEMBERSHIPTRANSACTION | Contains information about membership transactions. |
| FACT_MEMBERSHIPTRANSACTION_STAGE | Intermediate storage table for membership transactions. |
| FACT_MODELINGANDPROPENSITYATTRIBUTE | Contains information from modeling and propensity attributes. |
| FACT_MODELINGANDPROPENSITYATTRIBUTE_STAGE | Contains information from MODELINGANDPROPENSITY attributes. |
| FACT_OLAPDATASOURCEATTRIBUTECATEGORY_STAGE | Contains the system IDs for the all the attributes to be brought into the warehouse for reporting. |
| FACT_OLAPDATASOURCESMARTFIELD_STAGE | Contains the system IDs for the all the smart fields to be brought into the warehouse for reporting. |
| FACT_OPPORTUNITY | Contains information on prospect opportunities. |
| FACT_OPPORTUNITY_STAGE | Intermediate storage table for prospect opportunities. |
| FACT_OPPORTUNITYATTRIBUTE | Contains information from opportunity attributes. |
| FACT_OPPORTUNITYATTRIBUTE_STAGE | Contains information from opportunity attributes. |
| FACT_OPPORTUNITYCAMPAIGN | Relates campaigns to opportunities. |
| FACT_OPPORTUNITYCAMPAIGN_STAGE | Intermediate storage for relating campaigns to opportunities. |
| FACT_OPPORTUNITYDESIGNATION | Link between Opportunities and Designations, based on the OPPORTUNITYDESIGNATION table. |
| FACT_OPPORTUNITYDESIGNATION_STAGE | Intermediate storage for link between Opportunities and Designations, based on the OPPORTUNITYDESIGNATION table. |
| FACT_OPPORTUNITYDESIGNATIONCAMPAIGN | Relates opportunities to campaigns, designations and campaign priorities. |
| FACT_OPPORTUNITYDESIGNATIONCAMPAIGN_STAGE | Intermediate storage for relating opportunities to campaigns, designations and campaign priorities. |
| FACT_OPPORTUNITYFUNDING | Relates opportunities to prospect funding interests. |
| FACT_OPPORTUNITYFUNDING_STAGE | Intermediate storage for relating opportunities to prospect funding interests. |
| FACT_PLANNEDGIFTADDITION | Stores information about planned gift additions. |
| FACT_PLANNEDGIFTADDITION_STAGE | Staging table for the planned gift addition fact. |
| FACT_PLANNEDGIFTATTRIBUTE | Contains information from planned gift attributes. |
| FACT_PLANNEDGIFTATTRIBUTE_STAGE | Staging table for the planned gift attributes fact. |
| FACT_PLANNEDGIFTDESIGNATION | Contains information about planned gift designation. |
| FACT_PLANNEDGIFTDESIGNATION_STAGE | Contains information about planned gift designation. |
| FACT_PROSPECTFUNDINGINTERESTSITE | Contains information about sites associated with prospect funding interests. |
| FACT_PROSPECTFUNDINGINTERESTSITE_STAGE | Intermediate storage table for prospect funding interest sites. |
| FACT_PROSPECTPLANATTRIBUTE | Contains information from prospect plan attributes. |
| FACT_PROSPECTPLANATTRIBUTE_STAGE | Contains information from prospect plan attributes. |
| FACT_PROSPECTPLANSITE | Contains information about sites associated with prospect plans. |
| FACT_PROSPECTPLANSITE_STAGE | Intermediate storage table for prospect plan sites. |
| FACT_PURPOSELEVELATTRIBUTE | Contains information from purpose level attributes. |
| FACT_PURPOSELEVELATTRIBUTE_STAGE | Contains information from purpose level attributes. |
| FACT_QUERYVIEWSECURITY | Intermediate storage table for query view security |
| FACT_QUERYVIEWSECURITY_STAGE | Intermediate storage table for query view security |
| FACT_RECURRINGGIFTAMENDMENT | Stores information about recurring gift amendments. |
| FACT_RECURRINGGIFTAMENDMENT_STAGE | Staging table for the recurring gift amendment fact. |
| FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS | Stores information about recurring gift amendment designations. |
| FACT_RECURRINGGIFTDEVELOPMENTHISTORY | DEPRECATED as of 4.0. Contains information about Recurring Gift Development History. |
| FACT_RECURRINGGIFTDEVELOPMENTHISTORY_STAGE | Intermediate storage table for recurring gift development history. |
| FACT_RECURRINGGIFTINSTALLMENT | Contains information about Recurring Gift Installments. |
| FACT_RECURRINGGIFTINSTALLMENT_STAGE | Intermediate storage table for recurring gift installments. |
| FACT_RECURRINGGIFTINSTALLMENTMISSED_STAGE | Contains information about missed recurring gift installments since the last processing. |
| FACT_RECURRINGGIFTINSTALLMENTPAYMENT | Contains information about recurring gift installment payments. |
| FACT_RECURRINGGIFTINSTALLMENTPAYMENT_STAGE | Contains information about recurring gift installment payments. |
| FACT_RECURRINGGIFTINSTALLMENTWRITEOFF | Contains information about recurring gift installment write-offs. |
| FACT_RECURRINGGIFTINSTALLMENTWRITEOFF_STAGE | Contains information about recurring gift installment write-offs. |
| FACT_REGISTRATIONTOTAL_STAGE | Contains aggregate information about event registrations. |
| FACT_REGISTRATIONTOTALCOMMUNICATIONS_STAGE | Contains aggregate information about event registrations. |
| FACT_REGISTRATIONTOTALGROUP_STAGE | Contains aggregate information about event registrations. |
| FACT_REGISTRATIONTOTALPARTICIPANTS_STAGE | Contains aggregate information about event registrations. |
| FACT_REGISTRATIONTOTALRAISED_STAGE | Contains aggregate information about event registrations. |
| FACT_REGISTRATIONTOTALSOCIALMEDIA_STAGE | Contains aggregate information about event registrations. |
| FACT_REPORTSECURITY | Surrogate key for the report security fact |
| FACT_REPORTSECURITY_STAGE | Intermediate storage table for report security |
| FACT_REVENUEATTRIBUTE | DEPRECATED as of 4.0. Please use the newer FACT_FINANCIALTRANSACTIONATTRIBUTE table. Contains information from revenue attributes. |
| FACT_REVENUEATTRIBUTE_STAGE | DEPRECATED as of 4.0. Please use the newer FACT_FINANCIALTRANSACTIONATTRIBUTE table. Contains information from revenue attributes. |
| FACT_REVENUECAMPAIGN | The Revenue Campaign fact contains campaign information about revenue. |
| FACT_REVENUECAMPAIGN_STAGE | The Revenue Campaign fact contains campaign information about revenue. |
| FACT_REVENUEFUNDRAISER | Contains information about fundraiser revenue. |
| FACT_REVENUEFUNDRAISER_STAGE | Contains information about fundraiser revenue. |
| FACT_REVENUELETTER | Stores information about revenue letters |
| FACT_REVENUELETTER_STAGE | Staging table for the revenue letter fact |
| FACT_REVENUEOPPORTUNITY | Relates opportunities to revenue applications. |
| FACT_REVENUEOPPORTUNITY_STAGE | Intermediate storage for relating opportunities to revenue applications. |
| FACT_REVENUERECOGNITION | Contains descriptive information about the revenue transaction. |
| FACT_REVENUERECOGNITION_STAGE | Contains descriptive information about the revenue transaction. |
| FACT_REVENUESPLITSMARTFIELD | Contains information from Revenue Detail Split smart fields. |
| FACT_REVENUESPLITSMARTFIELD_STAGE | Contains information from Revenue Detail Split smart fields. |
| FACT_REVENUETRIBUTE | Contains information about revenue tributes fact relationship. |
| FACT_REVENUETRIBUTE_STAGE | Contains information about revenue tributes fact relationship. |
| FACT_SITEPERMISSION | Contains information about site permissions |
| FACT_SITEPERMISSION_STAGE | Intermediate storage table for site permissions |
| FACT_SMARTQUERYSECURITY | Stores permissions for smart queries. |
| FACT_SMARTQUERYSECURITY_STAGE | Intermediate storage for smart query permissions. |
| FACT_SOLICITCODECHANNELOPTOUT | Information on solicit code channel opt-out. |
| FACT_SOLICITCODECHANNELOPTOUT_STAGE | Information on solicit code channel opt-out. |
| FACT_SPONSORSHIPATTRIBUTE | Contains information from sponsorship attributes. |
| FACT_SPONSORSHIPATTRIBUTE_STAGE | Staging table for the sponsorship attributes fact. |
| FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE | Contains information from sponsorship child opportunity attributes. |
| FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE_STAGE | Staging table for the sponsorship child opportunity attributes fact. |
| FACT_SPONSORSHIPRECURRINGADDITIONALGIFT | Stores information about sponsorship transactions |
| FACT_SPONSORSHIPRECURRINGADDITIONALGIFT_STAGE | Intermediate storage for sponsorship transactions |
| FACT_SPONSORSHIPTRANSACTION | Stores information about sponsorship transactions |
| FACT_SPONSORSHIPTRANSACTION_STAGE | Intermediate storage for sponsorship transactions |
| FACT_SYSTEMPRIVILEGESECURITY | Stores information about system privilege security. |
| FACT_SYSTEMPRIVILEGESECURITY_STAGE | Intermediate storage table for system privilege security. |
| FACT_SYSTEMROLEAPPUSER | Contains information about application user system roles |
| FACT_SYSTEMROLEAPPUSER_STAGE | Contains information about application user system roles |
| FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY | Contains information about the constituent security groups assigned to system role application users |
| FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY_STAGE | Intermediate storage table for system role application user constituent security groups |
| FACT_TRIBUTESITE | Contains information about sites associated with tributes. |
| FACT_TRIBUTESITE_STAGE | Intermediate storage table for tribute sites. |
| PACKAGEDEPENDENCIES | |
| PACKAGELIST | |
| PACKAGEQUEUE | |
| RECONCILIATIONEXCEPTION | |
| RECONCILIATIONSUMMARY | |
| RPT_GIVINGLISTDETAIL | The RPT_GIVINGLISTDETAIL table contains information from the list builder in the GivingList Summary Section. |
| RPT_GIVINGLISTDETAIL_CAMPAIGNS | Intermediate storage table for RPT_GIVINGLISTDETAIL |
| RPT_GIVINGLISTDETAIL_RECOGNITION | Intermediate storage table for RPT_GIVINGLISTDETAIL |
| RPT_GIVINGLISTDETAIL_SITES | Intermediate storage table for RPT_GIVINGLISTDETAIL |
| RPT_GIVINGLISTDETAIL_SOLICITORS | Intermediate storage table for RPT_GIVINGLISTDETAIL |
| RPT_RECOGNITIONGIVINGLISTDETAIL | The RPT_RECOGNITIONGIVINGLISTDETAIL table contains information for the recognition list builder in the GivingList. |
| STAGE_DELETEDID | |
| STAGE_EXPORTTABLE | Contains information about export tables. |
| STAGE_SELECTIONIDS | Temp list of IDs for importing selections. |
| VALIDATIONEXCEPTIONS |