Blackbaud Enterprise Data Warehouse Views
This page provides a comprehensive listing of the views available in Blackbaud Data Warehouse version 4.0SP39.
| View | Description |
|---|---|
| APPUSER | |
| CONSTITUENTSITE | |
| DIM_PROSPECTPLANSITE | Contains information about sites associated with prospect plans. Used for backward compatibility with previous [BBDW].[DIM_PROSPECTPLANSITE] table |
| FACT_REVENUE | |
| V_APPEAL_WITHNULLSITESECURITY | |
| V_CONSTITUENT_WITHNULLCONSTITSECURITY | |
| V_CONSTITUENT_WITHNULLSITESECURITY | |
| V_CONSTITUENTAPPEAL_WITHNULLCONSTITSECURITY | |
| V_CONSTITUENTAPPEAL_WITHNULLSITESECURITY | |
| v_DIM_ACCOUNTSYSTEM | Contains information about account systems. |
| v_DIM_ADDON | Contains information about membership program add-ons. |
| v_DIM_ADJUSTMENTREASON | Contains information about adjustment reasons. |
| v_DIM_APPEAL | The Appeal dimension contains information about the appeal. |
| v_DIM_APPUSER | Contains information about application users |
| v_DIM_ATTRIBUTE | Contains information about attribute. |
| v_DIM_BENEFIT | The benefit fact table contains information about benefits. |
| v_DIM_BENEFITTYPE | The event registration dimension contains information about event registrations. |
| v_DIM_BOOL | Has a value for true and false. |
| v_DIM_BUSINESSUNIT | Stores information about business units |
| v_DIM_CAMPAIGN | The campaign dimension contains information about campaigns. |
| v_DIM_CAMPAIGNPRIORITY | The campaign priority dimension contains information about campaign priorities. |
| v_DIM_CONDITIONSETTING | Contains conditions and their states. |
| v_DIM_CONSTITUENCY | The constituency dimension contains information about constituencies. |
| v_DIM_CONSTITUENT | The constituent dimension is used as an intermediate dimension for use in many to many relationships. |
| v_DIM_CONSTITUENTADDRESS | The constituent address dimension contains information about addresses. |
| v_DIM_CONSTITUENTADDRESSDETAIL | Contains additional information about constituent addresses. |
| v_DIM_CONSTITUENTADDRESSFLAG | Contains flags for constituent addresses. |
| v_DIM_CONSTITUENTADDRESSTYPE | Contains address types used for constituent addresses. |
| v_DIM_CONSTITUENTATTRIBUTE | The constituent attribute dimension contains attribute information about constituents. |
| v_DIM_CONSTITUENTDEMOGRAPHIC | The constituent demographic dimension contains demographic information for constituents. |
| v_DIM_CONSTITUENTEMAILADDRESS | The Constituent Email Address dimension contains information about constituent email addresses |
| v_DIM_CONSTITUENTEMAILADDRESSFLAG | The Constituent Email Address Flag dimension contains information about constituent email address flags |
| v_DIM_CONSTITUENTEMAILADDRESSTYPE | The Constituent Email Address Type dimension contains information about constituent email address types |
| v_DIM_CONSTITUENTGROUP | Stores information about constituent groups and households |
| v_DIM_CONSTITUENTGROUPMEMBERROLE | Stores information about constituent group members |
| v_DIM_CONSTITUENTINFORMATION | The constituent information dimension contains additional information about constituents. |
| v_DIM_CONSTITUENTINTEREST | Contains information about constituent interests. |
| v_DIM_CONSTITUENTLOOKUP | The constituent lookup dimension contains detail information about constituents. |
| v_DIM_CONSTITUENTPHONE | The Constituent Phone dimension contains information about constituent phone numbers |
| v_DIM_CONSTITUENTPHONEFLAG | The Constituent Phone Flag dimension contains flags for constituent phone numbers |
| v_DIM_CONSTITUENTPHONETYPE | The Constituent Phone Type dimension contains information about constituent phone types |
| v_DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT | Contains set used for constituent relationships. |
| v_DIM_CONSTITUENTRELATIONSHIPFLAG | Contains flags for constituent relationships. |
| v_DIM_CONSTITUENTRELATIONSHIPSET | Contains set used for constituent relationships. |
| v_DIM_CONSTITUENTRELATIONSHIPTYPE | Contains relationship types used for constituent relationships. |
| v_DIM_CONSTITUENTSECURITYGROUP | Contains information about constituent security groups |
| v_DIM_CONSTITUENTSMARTFIELD | The constituent smart field dimension contains information about constituent smart fields |
| v_DIM_CONTACTTYPE | Contains contact types used for constituent relationships. |
| v_DIM_COUNTRY | The Country dimension contains information about countries |
| v_DIM_CREDITCARDTYPE | Contains information about credit card types |
| v_DIM_CURRENCY | The currency dimension contains information about currencies. |
| v_DIM_DATE | The date dimension contains information about all valid dates. |
| v_DIM_DESIGNATION | The designation dimension contains information about designations |
| v_DIM_DESIGNATIONATTRIBUTE | The designation attribute dimension contains attribute information about designations. |
| v_DIM_DONOTCALLREASON | The Constituent Phone Do Not Call Reasons contains information about Constituent Phone Do Not Call Reasons |
| v_DIM_DONOTMAILREASON | Contains the do not mail reason used for constituent addresses. |
| v_DIM_EDUCATION | The education dimension contains education information about constituents |
| v_DIM_EDUCATIONADDITIONALINFORMATION | The education additional information dimension contains additional education information about constituents. |
| V_DIM_EDUCATIONALINVOLVEMENT | Educational involvement View, based on the EDUCATIONALINVOLVEMENT dimension. |
| v_DIM_EDUCATIONATTRIBUTE | The education attribute dimension contains attribute information about education histories. |
| v_DIM_EMAILCAMPAIGN | Email sent to constituents through Luminate Online. |
| v_DIM_EMAILMESSAGE | Email sent to constituents through Luminate Online. |
| v_DIM_ETHNICITY | The ethnicity dimension contains information about ethnicities. |
| v_DIM_EVENT | The event dimension contains information about events. |
| v_DIM_EVENTATTRIBUTE | The event attribute dimension contains attribute information about events. |
| v_DIM_EVENTGOALTYPE | The event goal type dimension contains information about event goals. |
| v_DIM_EVENTREGISTRANTATTRIBUTE | The event registrant attribute dimension contains attribute information about event registrants. |
| v_DIM_EVENTREGISTRATION | The event registration dimension contains information about event registrations. |
| v_DIM_EVENTREGISTRATIONCODES | Contains information about inbound and recruitment channels and roles. |
| v_DIM_FINANCIALTRANSACTIONATTRIBUTE | The financial transaction attribute dimension contains attribute information about revenue. |
| v_DIM_FUNDINGREQUEST | contains information about funding requests. |
| v_DIM_FUNDINGREQUESTOUTLINESTEP | Contains information about the funding request outline step dimension. |
| v_DIM_FUNDRAISER | The fundraiser dimension contains information about fundraisers. |
| v_DIM_FUNDRAISERCAMPAIGN | The dimension relates fundraisers to campaigns |
| v_DIM_FUNDRAISERSECONDARY | Relates additional fundraisers to a prospect plan. |
| v_DIM_FUNDRAISERTEAM | The fundraiser team dimension contains information about teams. |
| v_DIM_FUNDRAISERTEAMMEMBER | contains information about fundraising team members. |
| v_DIM_GLREVENUECATEGORY | The GL revenue category dimension contains information about GL revenue categories. |
| v_DIM_IDSETREGISTER | Contains information about selections. |
| v_DIM_INSTALLMENT | Contains information about an installment. |
| v_DIM_INSTALLMENTSTATUS | The installment status dimension describes when an installment is due relative to the current date. |
| v_DIM_INTERACTION | The interaction dimension contains information about interactions. |
| v_DIM_INTERACTIONATTRIBUTE | The interaction attribute dimension contains attribute information about interactions. |
| v_DIM_LETTER | Stores information about letters |
| v_DIM_MAILPREFERENCE | Stores information about mailing preferences |
| v_DIM_MARKETINGSEGMENT | The marketing segment dimension contains information about marketing efforts, segments, packages, and letters. |
| v_DIM_MARKETINGSEGMENTATION | The marketing effort dimension contains information about marketing efforts. |
| v_DIM_MARKETINGSOURCECODE | The marketing source code dimension breaks out all the marketing source code parts for marketing source codes. |
| v_DIM_MARKETINGSOURCECODEPART | The Marketing Source Code Part dimension contains information about source code parts used in marketing source codes. |
| v_DIM_MEMBERFLAG | The member flag dimension contains information about flags for a member. |
| v_DIM_MEMBERSHIP | The membership dimension contains information about memberships. |
| v_DIM_MEMBERSHIPACTION | The membership action contains information about actions on memberships. |
| v_DIM_MEMBERSHIPATTRIBUTE | The membership attribute dimension contains attribute information about memberships. |
| v_DIM_MEMBERSHIPPROGRAM | The membership program dimension contains information about membership programs. |
| v_DIM_MEMBERSHIPSTATUS | The membership status dimension contains information about the status of a membership. |
| v_DIM_MODELINGANDPROPENSITYATTRIBUTE | The modeling and propensity attribute dimension contains attribute information about constituent's modeling and propensity. |
| v_DIM_OTHERPAYMENTMETHOD | Stores information about other payment method |
| v_DIM_PLANNEDGIFT | Stores information about planned gifts. |
| v_DIM_PLANOUTLINESTEP | Contains informationabout prospect plan outline steps. |
| v_DIM_PLANPARTICIPANT | Contains information on plan participants. |
| v_DIM_PROCESS | Stores information about various processes |
| v_DIM_PROSPECT | Contains information about prospects. |
| v_DIM_PROSPECTFUNDINGINTEREST | Contains information about prospect funding interests. |
| v_DIM_PROSPECTPLAN | Contains information about prospect plans. |
| v_DIM_PROSPECTPLANREQUESTASSIGNMENT | Contains information about prospect plan assignment requests |
| v_DIM_PROSPECTPLANSITE | Contains information about sites associated with prospect plans. Used for backward compatibility with previous [BBDW].[DIM_PROSPECTPLANSITE] table |
| v_DIM_PROSPECTPLANSTATUS | Contains information about prospect plant status codes. |
| v_DIM_PURPOSELEVEL | The purpose level dimension contains information about designation levels. |
| v_DIM_RECURRINGGIFTDEVELOPMENT | The recurring gift development dimension contains information about a recurring gift's development. |
| v_DIM_RECURRINGGIFTFLAG | The recurring gift flag dimension contains boolean information about recurring gifts. |
| v_DIM_RECURRINGGIFTSTATUSREASON | Stores information about recurring gift STATUSREASONs. |
| v_DIM_RESPONSE | The response dimension contains information about constituent responses. |
| v_DIM_REVENUEATTRIBUTE | The revenue attribute dimension contains attribute information about revenue. |
| v_DIM_REVENUECHANNEL | The revenue channel dimension contains information about a revenue's channel. |
| v_DIM_REVENUECODE | The revenue code dimension contains a collection of codes that describe a revenue record. |
| v_DIM_REVENUEFLAG | The revenue flag dimension contains boolean information about revenue. |
| v_DIM_REVENUEOTHERTYPECODE | Stores information about other revenue type |
| v_DIM_REVENUERECOGNITIONTYPE | The revenue recognition type dimension contains the types of recognition revenue. |
| v_DIM_REVENUESCHEDULE | The revenue schedule dimension contains information about a revenue's payment schedule. |
| v_DIM_REVENUESMARTFIELD | The revenue smart field dimension contains information about revenue smart fields. |
| v_DIM_SITE | Contains information about sites |
| v_DIM_SMARTFIELD | Contains information about smart fields. |
| v_DIM_SOLICITCODE | Stores information about solicit codes |
| v_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. |
| v_DIM_SPONSOR | Stores information about sponsors |
| v_DIM_SPONSORSHIP | Stores information about sponsorship |
| v_DIM_SPONSORSHIPLOCATION | Stores information about sponsorship location |
| v_DIM_SPONSORSHIPOPPORTUNITYCHILD | Stores information about sponsorship opportunity children |
| v_DIM_SPONSORSHIPOPPORTUNITYPROJECT | Stores information about sponsorship opportunity children |
| v_DIM_SPONSORSHIPREASON | Stores information about sponsorship reason |
| v_DIM_SYSTEMROLE | Contains information about system roles |
| v_DIM_TIME | Contains times |
| v_DIM_TIMEZONE | Stores information about time zones |
| v_DIM_TRIBUTE | Contains information about tributes associated with revenues. |
| v_DIM_WEEK | The week dimension lists weeks for a 2 year period. 1 - 104 and 105+. |
| v_DIM_WRITEOFF | The write-off dimension contains information about revenue write-offs. |
| v_FACT_ACCOUNTSYSTEMSITE | Contains information about sites associated with account systems. |
| v_FACT_APPEALATTRIBUTE | The appeal fact table relates appeals to their attributes. |
| v_FACT_BENEFITATTRIBUTE | The benefit attribute fact table relates benefits to their attributes. |
| v_FACT_CAMPAIGNGOAL | Contains information about the campaign goals and campaign hierarchy goals. |
| v_FACT_CAMPAIGNSITE | Contains information about sites associated with campaigns. |
| v_FACT_CONSTITUENCY | The constituency fact table relates constituents to their constituencies. |
| v_FACT_CONSTITUENTADDRESS | Contains information about constituent addresses. |
| v_FACT_CONSTITUENTADDRESS_FULL | Contains all of the information about constituent addresses. |
| v_FACT_CONSTITUENTADDRESSATTRIBUTE | The constituent address attribute fact table relates constituent address to their attributes. |
| v_FACT_CONSTITUENTAPPEAL | The constituent appeal fact table contains information about constituents in appeals. |
| v_FACT_CONSTITUENTATTRIBUTE | The constituent attribute fact table relates constituents to their attributes. |
| v_FACT_CONSTITUENTEMAILADDRESS | The Constituent Email Address fact tables contains information about constituent email addresses |
| v_FACT_CONSTITUENTEMAILADDRESS_FULL | The Constituent Email Address fact tables contains information about constituent email addresses |
| v_FACT_CONSTITUENTETHNICITY | The constituent ethnicity fact table relates constituents to their ethnicities. |
| v_FACT_CONSTITUENTGROUPMEMBER | Stores information about constituent group members |
| v_FACT_CONSTITUENTGROUPMEMBERROLE | Stores information about roles for constituent group members |
| v_FACT_CONSTITUENTMAILPREFERENCE | Stores mail preferences for constituents |
| v_FACT_CONSTITUENTPHONE | The Constituent Phone Fact table stores information about constituent phone numbers |
| v_FACT_CONSTITUENTPHONE_FULL | The Constituent Phone full view stores information about constituent phone numbers |
| v_FACT_CONSTITUENTRELATIONSHIP | Contains information about constituent relationships. |
| v_FACT_CONSTITUENTSECURITYGROUPASSIGNMENT | Contains information about constituent security group assignments |
| v_FACT_CONSTITUENTSITE | Contains information about sites associated with constituents. |
| v_FACT_CONSTITUENTSMARTFIELD | The constituent smart field fact table relates constituents to their smart fields. |
| v_FACT_CONSTITUENTSOLICITCODE | Stores information about constituent solicit codes |
| v_FACT_CURRENTCONSTITUENCY | The current constituency fact table relates constituents to their current constituency. |
| v_FACT_DATAFORMINSTANCESECURITY | Surrogate key for the data form instance security fact |
| v_FACT_DATALISTSECURITY | Surrogate key for the datalist security fact |
| v_FACT_DESIGNATIONATTRIBUTE | The designation attribute fact table relates designations to their attributes. |
| v_FACT_EDUCATIONATTRIBUTE | The education attribute fact table relates education records to their attributes. |
| v_FACT_EMAILACTIVITY | Email sent to constituents through Luminate Online. |
| v_FACT_EVENTATTRIBUTE | The event attribute fact table relates events to their attributes. |
| v_FACT_EVENTPRICE | Contains information about event prices and registration options |
| v_FACT_EVENTREGISTRANT | The event registrant fact table contains information event registrants. |
| v_FACT_EVENTREGISTRANTATTRIBUTE | The event registrant attribute fact table relates event registrants to their attributes. |
| v_FACT_EVENTREGISTRANTBENEFIT | The benefit registrant fact table contains information about benefit registrant relationships. |
| v_FACT_EVENTREGISTRANTBENEFITTOTAL | The event registrant benefit totalfact table contains aggregated information about registrant benefits. |
| v_FACT_EVENTREGISTRANTTOTAL | Contains aggregate information about event registrations. |
| v_FACT_EVENTREGISTRATIONOPPORTUNITY | Stores information about event registrations and opportunity links |
| v_FACT_EVENTSITE | Contains information about sites associated with EVENTs. |
| v_FACT_FINANCIALTRANSACTION | Contains information about financialtransactions |
| v_FACT_FINANCIALTRANSACTIONATTRIBUTE | The financial transaction attribute fact table relates FINANCIALTRANSACTION to their attributes. |
| v_FACT_FINANCIALTRANSACTIONLINEITEM | Contains information about financialtransactionlineitems |
| v_FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE | The financial transaction line item fact table relates financial transaction line items to their attributes. |
| v_FACT_FINANCIALTRANSACTIONLINEITEMSITE | Stores information about the sites that have security rights to a financial transaction line item |
| v_FACT_FUNDINGREQUESTATTRIBUTE | The funding request attribute fact table relates funding requests to their attributes. |
| v_FACT_FUNDRAISERINTERACTIONADDITIONAL | Contains information about additional participants on an interaction. |
| v_FACT_FUNDRAISERTEAMTOTAL | Contains aggregate and factual information about fundraising teams. |
| v_FACT_INSTALLMENT | The installment fact table contains information about pledge, matching gift claim, and planned giving installments. |
| v_FACT_INSTALLMENTPAYMENT | The installment payment fact table contains information about pledge, matching gift claim, and planned giving installment payments. |
| v_FACT_INSTALLMENTWRITEOFF | The installment write-off fact table contains information about pledge, matching gift claim, and planned giving installment write-offs. |
| v_FACT_INTERACTION | The interaction fact table contains information about constituent interactions. |
| v_FACT_INTERACTIONATTRIBUTE | The interaction attribute fact table relates interactions to their attributes. |
| v_FACT_INTERACTIONPARTICIPANT | Contains information about additional participants on an interaction. |
| v_FACT_INTERACTIONRESPONSE | The interaction response fact table relates responses back to interactions. |
| v_FACT_INTERACTIONSITE | Contains the sites for interactions. |
| v_FACT_MARKETINGCONSTITUENT | The marketing constituent fact table contains information about constituents in marketing efforts. |
| v_FACT_MARKETINGSEGMENTATIONDAILYRESPONSE | The marketing effort fact table contains information about marketing efforts. |
| v_FACT_MEMBER | The member fact table contains information about constituent members. |
| v_FACT_MEMBERSHIPADDON | Contains information about add-ons associated with memberships. |
| v_FACT_MEMBERSHIPATTRIBUTE | The financial transaction attribute fact table relates MEMBERSHIP to their attributes. |
| v_FACT_MEMBERSHIPRENEWALRULES | Contains information about membership renewal rules. |
| v_FACT_MEMBERSHIPREVENUE | Contains information about revenue associated with memberships. |
| v_FACT_MEMBERSHIPTRANSACTION | The membership transaction fact table contains information about transactions for a membership. |
| v_FACT_MODELINGANDPROPENSITYATTRIBUTE | The modeling and propensity attribute fact table relates constituent's modeling and propensities to their attributes. |
| v_FACT_OPPORTUNITY | Contains information about prospect opportunities. |
| v_FACT_OPPORTUNITYATTRIBUTE | The opportunity attribute fact table relates opportunities to their attributes. |
| v_FACT_OPPORTUNITYCAMPAIGN | Relates campaigns to opportunities. |
| v_FACT_OPPORTUNITYDESIGNATION | Link between Opportunities and Designations, based on the OPPORTUNITYDESIGNATION table. |
| v_FACT_OPPORTUNITYDESIGNATIONCAMPAIGN | Relates opportunities to campaigns, designations and campaign priorities. |
| v_FACT_OPPORTUNITYFUNDING | Relates opportunities to prospect funding interests. |
| v_FACT_PLANNEDGIFTADDITION | Stores information about planned gift additions. |
| v_FACT_PLANNEDGIFTATTRIBUTE | Contains information from planned gift attributes. |
| v_FACT_PLANNEDGIFTDESIGNATION | Contains information about planned gift designation |
| v_FACT_PROSPECTFUNDINGINTERESTSITE | Contains information about sites associated with PROSPECTFUNDINGINTERESTs. |
| v_FACT_PROSPECTPLANATTRIBUTE | The prospect plan attribute fact table relates prospect plans to their attributes. |
| v_FACT_PROSPECTPLANSITE | Contains information about sites associated with prospect plans. |
| v_FACT_PURPOSELEVELATTRIBUTE | The purpose level attribute fact table relates purpose levels to their attributes. |
| v_FACT_QUERYVIEWSECURITY | Intermediate storage table for query view security |
| v_FACT_RECURRINGGIFTAMENDMENT | Stores information about recurring gift amendments. |
| v_FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS | Stores information about recurring gift amendment designations. |
| v_FACT_RECURRINGGIFTDEVELOPMENTHISTORY | The recurring gift development history fact table contains development history of recurring gifts. |
| v_FACT_RECURRINGGIFTINSTALLMENT | The recurring gift installment fact table contains information about recurring gift installments. |
| v_FACT_RECURRINGGIFTINSTALLMENTPAYMENT | The recurring gift installment payment fact table contains information about recurring gift installment payments. |
| v_FACT_RECURRINGGIFTINSTALLMENTWRITEOFF | The recurring gift installment write-off fact table contains information about recurring gift installments write-off. |
| v_FACT_REPORTSECURITY | Surrogate key for the report security fact |
| v_FACT_REVENUE | The revenue fact table contains information about revenue. |
| v_FACT_REVENUEATTRIBUTE | The revenue attribute fact table relates revenue to their attributes. |
| v_FACT_REVENUECAMPAIGN | The revenue campaign fact table campaigns to revenue. |
| v_FACT_REVENUEFUNDRAISER | The revenue fundraiser fact table relates fundraisers to their revenue. |
| v_FACT_REVENUELETTER | Stores information about revenue letters |
| v_FACT_REVENUEOPPORTUNITY | Relates opportunities to revenue applications. |
| v_FACT_REVENUERECOGNITION | The revenue recognition fact table contains information revenue recognitions. |
| v_FACT_REVENUESPLITSMARTFIELD | The revenue smart field fact table relates revenue to their smart fields. |
| v_FACT_REVENUETRIBUTE | Contains revenue and tribute fact |
| v_FACT_SITEPERMISSION | Contains information about site permissions |
| v_FACT_SMARTQUERYSECURITY | Stores permissions for smart queries. |
| v_FACT_SOLICITCODECHANNELOPTOUT | Information on solicit code channel opt-out. |
| v_FACT_SPONSORSHIPATTRIBUTE | The sponsorship fact table relates sponsorships to their attributes. |
| v_FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE | The sponsorship opportunity child attribute fact table relates sponsorship opportunity children to their attributes. |
| v_FACT_SPONSORSHIPRECURRINGADDITIONALGIFT | Stores information about sponsorship transactions |
| v_FACT_SPONSORSHIPTRANSACTION | Stores information about sponsorship transactions |
| v_FACT_SYSTEMPRIVILEGESECURITY | View that displays information about for system privilege security. |
| v_FACT_SYSTEMROLEAPPUSER | Contains information about application user system roles |
| v_FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY | Contains information about the constituent security groups assigned to system role application users |
| v_FACT_TRIBUTESITE | Contains information about sites associated with prospect plans. |
| V_QUERY_BBDW_ADDRESSES | |
| V_QUERY_BBDW_APPEAL | |
| V_QUERY_BBDW_APPEALS | |
| V_QUERY_BBDW_CONSTITUENCY | |
| V_QUERY_BBDW_CONSTITUENT | |
| V_QUERY_BBDW_CONSTITUENT_INTERACTION | |
| V_QUERY_BBDW_CONSTITUENT_NOPROSPECT | |
| V_QUERY_BBDW_CONSTITUENT_NORECOGNITION | |
| V_QUERY_BBDW_CONSTITUENT_NORELATIONSHIPS | |
| V_QUERY_BBDW_CONSTITUENT_NORELATIONSHIPSNORECOGNITION | |
| V_QUERY_BBDW_CONSTITUENT_NOREVENUE | |
| V_QUERY_BBDW_CONSTITUENT_NOSPONSOR | |
| V_QUERY_BBDW_CONSTITUENT_NOSPOUSE | |
| V_QUERY_BBDW_CONSTITUENT_SITE | |
| V_QUERY_BBDW_DATE | |
| V_QUERY_BBDW_DESIGNATION | |
| V_QUERY_BBDW_EDUCATION | |
| V_QUERY_BBDW_EDUCATIONADDITIONALINFORMATION | |
| V_QUERY_BBDW_EDUCATIONALINVOLVEMENT | |
| V_QUERY_BBDW_EMAILACTIVITY | |
| V_QUERY_BBDW_EMAILADDRESS | |
| V_QUERY_BBDW_EVENT | |
| V_QUERY_BBDW_EVENTREGISTRANT | |
| V_QUERY_BBDW_EVENTREGISTRATIONOPPORTUNITY | |
| v_QUERY_BBDW_FACT_CONSTITUENTSMARTFIELD | This is used for query views on constituent attributes in the warehouse. |
| v_QUERY_BBDW_FACT_REVENUESPLITSMARTFIELD | This is used for query views on revenue split attributes in the warehouse. |
| V_QUERY_BBDW_GROUPMEMBER | |
| V_QUERY_BBDW_HOUSEHOLDMEMBER | |
| V_QUERY_BBDW_HOUSEHOLDMEMBERSHIP | |
| V_QUERY_BBDW_INSTALLMENT | |
| V_QUERY_BBDW_INTERACTION_STEPS | |
| V_QUERY_BBDW_INTERACTIONADDITIONALFUNDRAISER | |
| V_QUERY_BBDW_INTERACTIONPARTICIPANT | |
| V_QUERY_BBDW_INTERACTIONRESPONSE | |
| V_QUERY_BBDW_MAILPREFERENCE | |
| V_QUERY_BBDW_MEMBERSHIP | |
| V_QUERY_BBDW_MEMBERSHIPINSTALLMENTPLANSUMMARY | |
| V_QUERY_BBDW_MEMBERSHIPTRANSACTION | |
| V_QUERY_BBDW_OPPORTUNITY | |
| V_QUERY_BBDW_PAYMENT | |
| V_QUERY_BBDW_PHONE | |
| V_QUERY_BBDW_PLANNEDGIFT | |
| V_QUERY_BBDW_PLANNEDGIFT_NOREVENUE | |
| V_QUERY_BBDW_PLANNEDGIFTADDITION | |
| V_QUERY_BBDW_PLEDGESUMMARY | |
| V_QUERY_BBDW_PROSPECT | |
| V_QUERY_BBDW_PROSPECTFUNDINGINTEREST | |
| V_QUERY_BBDW_PROSPECTPLAN | |
| V_QUERY_BBDW_PROSPECTPLANPARTICIPANT | |
| V_QUERY_BBDW_PURPOSELEVEL | |
| V_QUERY_BBDW_RECOGNITIONCREDIT | |
| V_QUERY_BBDW_RECURRINGGIFTAMENDMENT | |
| V_QUERY_BBDW_RECURRINGGIFTINSTALLMENT | |
| V_QUERY_BBDW_RECURRINGGIFTPAYMENT | |
| V_QUERY_BBDW_RECURRINGGIFTSUMMARY | |
| V_QUERY_BBDW_RECURRINGGIFTWRITEOFF | |
| V_QUERY_BBDW_RELATIONSHIP | |
| V_QUERY_BBDW_REVENUE | |
| V_QUERY_BBDW_REVENUE_MEMBERSHIP | |
| V_QUERY_BBDW_REVENUE_MEMBERSHIPTRANSACTION | |
| V_QUERY_BBDW_REVENUE_NOCONSTITUENT_NOAPPPLICATION | |
| V_QUERY_BBDW_REVENUE_NOCONSTITUENT_NOPLANNEDGIFT | |
| V_QUERY_BBDW_REVENUE_NOCONSTITUENT_NOSPONSORSHIP | |
| V_QUERY_BBDW_REVENUE_NORECOGNITION | |
| V_QUERY_BBDW_REVENUE_PAYMENT | |
| V_QUERY_BBDW_REVENUE_REVENUEAPPLICATION | |
| V_QUERY_BBDW_REVENUE_REVENUEAPPLICATION_NORECOGNITION | |
| V_QUERY_BBDW_REVENUE_SITE | |
| V_QUERY_BBDW_REVENUEAPPLICATION | |
| V_QUERY_BBDW_REVENUEAPPLICATION_NOMEMBERSHIP | |
| V_QUERY_BBDW_REVENUEAPPLICATIONOTHER | |
| V_QUERY_BBDW_REVENUECAMPAIGN | |
| V_QUERY_BBDW_REVENUELETTER | |
| V_QUERY_BBDW_REVENUEOPPORTUNITY | |
| V_QUERY_BBDW_REVENUERECOGNITION | |
| V_QUERY_BBDW_REVENUEREVENUERECOGNITION | |
| V_QUERY_BBDW_REVENUEROOT | |
| V_QUERY_BBDW_REVENUESOLICITOR | |
| V_QUERY_BBDW_SOLICITCODE | |
| V_QUERY_BBDW_SOLICITCODECHANNELOPTOUT | |
| V_QUERY_BBDW_SPONSOR | |
| V_QUERY_BBDW_SPONSORSHIP | |
| V_QUERY_BBDW_SPONSORSHIP_NOTRANSACTION | |
| V_QUERY_BBDW_SPONSORSHIPLOCATION | |
| V_QUERY_BBDW_SPONSORSHIPOPPORTUNITYCHILD | |
| V_QUERY_BBDW_SPONSORSHIPOPPORTUNITYPROJECT | |
| V_QUERY_BBDW_SPONSORSHIPRECURRINGADDITIONALGIFT | |
| V_QUERY_BBDW_SPONSORSHIPTRANSACTION | |
| V_QUERY_BBDW_TRIBUTE | |
| V_QUERY_BBDW_WRITEOFF | |
| v_QUERY_FACT_APPEALATTRIBUTE | Contains information from appeal attributes. |
| v_QUERY_FACT_BENEFITATTRIBUTE | Stores information about benefit attributes for use in ad-hoc query |
| v_QUERY_FACT_CONSTITUENTADDRESSATTRIBUTE | Stores information about address attributes for use in ad-hoc query |
| v_QUERY_FACT_CONSTITUENTATTRIBUTE | Stores information about constituent attributes for use in ad-hoc query |
| v_QUERY_FACT_DESIGNATIONATTRIBUTE | Stores information about designation attributes for use in ad-hoc query |
| v_QUERY_FACT_EDUCATIONATTRIBUTE | Stores information about education attributes for use in ad-hoc query |
| v_QUERY_FACT_EVENTATTRIBUTE | Stores information about event attributes for use in ad-hoc query |
| v_QUERY_FACT_EVENTREGISTRANTATTRIBUTE | Stores information about event registrant attributes for use in ad-hoc query |
| v_QUERY_FACT_FINANCIALTRANSACTIONATTRIBUTE | Stores information about revenue attributes for use in ad-hoc query |
| v_QUERY_FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE | Contains information from financial transaction line item attributes. |
| v_QUERY_FACT_FUNDINGREQUESTATTRIBUTE | Stores information about funding request attributes for use in ad-hoc query |
| v_QUERY_FACT_INTERACTIONATTRIBUTE | Stores information about interaction attributes for use in ad-hoc query |
| v_QUERY_FACT_MEMBERSHIPATTRIBUTE | Stores information about membership attributes for use in ad-hoc query |
| v_QUERY_FACT_MODELINGANDPROPENSITYATTRIBUTE | Stores information about modeling and propensity attributes for use in ad-hoc query |
| v_QUERY_FACT_OPPORTUNITYATTRIBUTE | Stores information about modeling and propensity attributes for use in ad-hoc query |
| v_QUERY_FACT_PLANNEDGIFTATTRIBUTE | Contains information from planned gift attributes. |
| v_QUERY_FACT_PROSPECTPLANATTRIBUTE | Stores information about prospect plan attributes for use in ad-hoc query |
| v_QUERY_FACT_PURPOSELEVELATTRIBUTE | Stores information about purpose level attributes for use in ad-hoc query |
| v_QUERY_FACT_SPONSORSHIPATTRIBUTE | Contains information from sponsorship attributes. |
| v_QUERY_FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE | Contains information from sponsorship child opportunity attributes. |
| V_REVENUE_WITHNULLCONSTITUENTSECURITY | |
| V_REVENUE_WITHNULLSITESECURITY | |
| v_SECURITY_SYSTEMROLEASSIGNMENT_USER_DATALIST | |
| v_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM | |
| v_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW | |
| v_SECURITY_SYSTEMROLEASSIGNMENT_USER_REPORT | |
| V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY | |
| v_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE | Intermediate storage table for system privilege security. |