Blackbaud Enterprise CRM Tables

This page provides a comprehensive listing of the tables available in Blackbaud CRM Database version 4.0SP39.

Table	Description
ACADEMICCATALOGCOLLEGE	An academic catalog college is represented by a row in this table.
ACADEMICCATALOGDEGREE	An academic catalog degree is represented by a row in this table.
ACADEMICCATALOGDEGREETYPE	An academic catalog degree type is represented by a row in this table.
ACADEMICCATALOGDEGREETYPECODE	Indicates the type of degree.
ACADEMICCATALOGDEPARTMENT	An academic catalog department is represented by a row in this table.
ACADEMICCATALOGDIVISION	An academic catalog division is represented by a row in this table.
ACADEMICCATALOGPROGRAM	This table contains information about an affiliated educational institution's academic catalog.
ACADEMICCATALOGSUBDEPARTMENT	An academic catalog sub department is represented by a row in this table.
ACADEMICYEAR	Academic years for schools.
ACADEMICYEARNAMECODE	Names for academic years
ACCOUNTATTACHMENTTYPECODE	Stores translations of ledger account attachment types.
ACCOUNTCODE	General Ledger Account Code table.
ACCOUNTCODEMEDIALINKTYPECODE	Stores translations of account code media link types.
ACCOUNTCODENOTETYPECODE	Stores translations of account code note types.
ACCOUNTCODESTATUSCODE	Stores translations for account code statuses.
ACCOUNTINGELEMENTRELATIONSHIP	This table holds main information about the accounting element relationship.
ACCOUNTINGELEMENTRELATIONSHIPDETAIL	This table holds details about all accounting element relationships.
ACCOUNTINGELEMENTRELATIONSHIPELEMENTPARAMETER	This table holds details about the selected element parameters for all accounting element relationships.
ACCOUNTINGELEMENTRELATIONSHIPQUERYPARAMETER	This table holds details about the query parameters for all accounting element relationships.
ACCOUNTINGELEMENTSECURITYGROUP	This table contains the security groups that will be assigned to accounting elements.
ACCOUNTINGELEMENTSECURITYGROUPELEMENT	This table contains accounting elements and what groups they belong to.
ACCOUNTSTRUCTURE	Accounting element definition
ACCTCODEATTACHMENTTYPECODE	Stores translations of account code attachment types.
ACKNOWLEDGEMENTPREFERENCE	Stores information pertaining to acknowledgement preferences.
ACKNOWLEDGEMENTPROCESS	Contains information pertaining to the acknowledgement business process.
ACKNOWLEDGEMENTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the ACKNOWLEDGEMENTPROCESS table.
ACKNOWLEDGEMENTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ACKNOWLEDGEMENTPROCESS table.
ACTION_ITEM	ActionItem used in advocacy
ACTIONCENTER	Advocacy Action center
ACTIONITEM_TARGET	Stores targets for action item
ACTIONITEMFOLDER	Action Item Folder
ACTIONITEMIMAGE	Action Item Image
ACTIONITEMMEDIATARGET	Stores media target categories for action item
ACTIONITEMMESSAGETEXT	Action Item Message Text
ACTIONITEMPART	Action Item Part
ACTIONITEMPETITION	Action Item Petition
ACTIVEUSERMONITORINGLOG
ADDON
ADDONCODE
ADDOPPORTUNITIESPROCESS	Contains parameter information for the Add Opportunities business process.
ADDOPPORTUNITIESPROCESSOPPORTUNITYDESIGNATION	Stores designations to use for opportunities created through the Add Opportunities business process.
ADDOPPORTUNITIESPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADDOPPORTUNITIESPROCESS table.
ADDPROSPECTPLANSPROCESS	Contains parameter information for the Add Prospect Plans business process.
ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION	Stores designations to use for opportunities created through the Add Prospect Plans business process.
ADDPROSPECTPLANSPROCESSSECONDARYFUNDRAISER	Stores secondary fundraisers to use for the associated Add Prospect Plans process parameter set.
ADDPROSPECTPLANSPROCESSSITE	Stores sites to use for the associated Add Prospect Plans process parameter set.
ADDPROSPECTPLANSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADDPROSPECTPLANSPROCESS table.
ADDREQUESTSFORMULTIPLESTUDENTSPROCESS	Add requests for multiple students process parameters.
ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCOURSE	Add Student Requests Process Course
ADDREQUESTSFORMULTIPLESTUDENTSPROCESSCURRICULUM	Add Student Requests Process Curriculum Table
ADDREQUESTSFORMULTIPLESTUDENTSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADDREQUESTSFORMULTIPLESTUDENTSPROCESS table.
ADDRESS	Stores address information for each constituent.
Addressbook
AddressBookContacts
ADDRESSBOOKFAF	Participant Address book
ADDRESSCOORDINATES	Contains a list of longitude and latitude values for a given address.
ADDRESSPROCESSINGOPTION	Defines a set of criteria for processing addresses.
ADDRESSPROCESSINGOPTIONORGCONTACTTYPE	Maps Address Processing Options to Contact Types for the processing of organizational addresses.
ADDRESSPROPERCASEEXCEPTION
ADDRESSTOKEN
ADDRESSTYPECODE	This code table stores translations of address types.
ADDRESSVALIDATION	Represents the address validation data tune-up process.
ADDRESSVALIDATIONPROCESS	Represents the address validation process options.
ADDRESSVALIDATIONPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADDRESSVALIDATIONPROCESS table.
ADDRESSVALIDATIONUPDATE	Stores address validation and update information for each address record.
ADDSTEWARDSHIPPLANSPROCESS	Add stewardship plans process parameters.
ADDSTEWARDSHIPPLANSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADDSTEWARDSHIPPLANSPROCESS table.
ADDSTEWARDSHIPPLANSTEPSPROCESS	Add stewardship plan steps process parameters.
ADDSTEWARDSHIPPLANSTEPSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADDSTEWARDSHIPPLANSTEPSPROCESS table.
ADHOCQUERY	Each row in the ADHOCQUERY table corresponds to a user-defined query definition, including all of the information required to build a valid sql statement.
ADHOCQUERYDEPENDENCY
ADHOCQUERYDEPENDENCYBUSINESSPROCESS
ADHOCQUERYDEPENDENCYBUSINESSPROCESSSTATUS
ADHOCQUERYFOLDER	Represents the folders that contain ad-hoc queries.
ADHOCQUERYFOLDERDEFAULTQUERYROLE	Stores the default roles for a folder's queries.
ADHOCQUERYIDSETDEPENDENCY
ADHOCQUERYRUNINFO
ADHOCQUERYSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ADHOCQUERY table.
ADJUSTMENT	Stores adjustments made to posted revenues.
ADJUSTMENTATTACHMENTTYPECODE	Stores translations of bank account adjustment attachment types.
ADJUSTMENTHISTORY	Stores information on historic adjustments.
ADJUSTMENTHISTORYDETAIL	Stores detail information on historic adjustments.
ADJUSTMENTHISTORYDISTRIBUTION	Stores GL distribution information for historic adjustments.
ADJUSTMENTHISTORYDISTRIBUTIONSNAPSHOT	Stores a snapshot of the GL distributions for a revenue item at the time of an adjustment.
ADJUSTMENTHISTORYGIFTINKIND	Stores information on historic adjustments to sold gift-in-kind information.
ADJUSTMENTHISTORYGIFTINKINDDISTRIBUTION	Stores GL distribution information for historic sold gift-in-kind adjustments.
ADJUSTMENTHISTORYGIFTINKINDDISTRIBUTIONSNAPSHOT	Stores a snapshot of the GL distributions for a sold gift-in-kind item at the time of an adjustment.
ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAIL	Stores detail information on historic sold gift-in-kind adjustments.
ADJUSTMENTHISTORYGIFTINKINDPAYMENTMETHODDETAILSNAPSHOT	Stores a snapshot of relevant gift-in-kind detail information at the time of an adjustment.
ADJUSTMENTHISTORYPROPERTY	Stores information on historic adjustments to sold property information.
ADJUSTMENTHISTORYPROPERTYDETAIL	Stores detail information on historic sold property adjustments.
ADJUSTMENTHISTORYPROPERTYDISTRIBUTION	Stores GL distribution information for historic sold property adjustments.
ADJUSTMENTHISTORYPROPERTYDISTRIBUTIONSNAPSHOT	Stores a snapshot of the GL distributions for a sold property item at the time of an adjustment.
ADJUSTMENTHISTORYPROPERTYSNAPSHOT	Stores a snapshot of relevant property detail information at the time of an adjustment.
ADJUSTMENTHISTORYREVENUE	Stores a snapshot of the revenue streams for a revenue item at the time of an adjustment.
ADJUSTMENTHISTORYREVENUETRANSACTION	Stores a snapshot of relevant revenue information at the time of an adjustment.
ADJUSTMENTHISTORYSPLIT	Stores a snapshot of relevant split information for a revenue item at the time of an adjustment.
ADJUSTMENTHISTORYSTOCK	Stores information on historic adjustments to sold stock information.
ADJUSTMENTHISTORYSTOCKDETAIL	Stores detail information on historic sold stock adjustments.
ADJUSTMENTHISTORYSTOCKDISTRIBUTION	Stores GL distribution information for historic sold stock adjustments.
ADJUSTMENTHISTORYSTOCKDISTRIBUTIONSNAPSHOT	Stores a snapshot of the GL distributions for a sold stock item at the time of an adjustment.
ADJUSTMENTHISTORYSTOCKSNAPSHOT	Stores a snapshot of relevant stock detail information at the time of an adjustment.
ADJUSTMENTHISTORYWRITEOFF	Stores historic information on posted write-off deletions.
ADJUSTMENTHISTORYWRITEOFFDETAIL	Stores detail information on historic write-off adjustments.
ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION	Stores GL distribution information for historic write-offs.
ADJUSTMENTHISTORYWRITEOFFDISTRIBUTIONSNAPSHOT	Stores a snapshot of the GL distributions for a write-off at the time of an adjustment.
ADJUSTMENTMEDIALINKTYPECODE	Stores translations of bank account adjustment media link types.
ADJUSTMENTNOTETYPECODE	Stores translations of bank account adjustment note types.
ADJUSTMENTREASONCODE	This table contains reason codes for adjustments.
ADORGANIZATIONALUNIT	Contains a row for each Active Directory organizational unit defined for the system
ADVOCACY_CUSTOM	Used to Store Advocacy Custom Target Info
ADVOCACY_GROUP	Advocacy Group Lookup table
ADVOCACYACTIVITY	Advocacy Activity
ADVOCACYLOG	Advocacy message queue
ADVOCACYPETITION	Advocacy Petition
ADVOCATERDATERANGE	Contains the date ranges for which constituents are Advocates.
AGINGBUCKET	This contains all aging buckets.
ALERTTYPE	Stores information about email alerts defined by the system.
ALERTTYPESTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ALERTTYPE table.
ALIAS	This table contains aliases for constituents.
ALIASTYPECODE	This code table stores translations of alias types.
ALTERNATELOOKUPID	This table contains alternate lookup IDs for constituents.
ALTERNATELOOKUPIDTYPECODE	This code table stores translations of alternate lookup ID types.
ALTRUANNOTATIONNOTIFICATION
ALTRUNOTIFICATION
AMPROIMPORTCONFIG	Stores a per-auction configuration for AuctionMaestro Pro imports.
ANALYTICSMODEL
ANALYTICSPROJECT
ANALYTICSPROJECTDISTRIBUTION
ANNOTATIONTABLEMAPPING	Maps the table name used to store annotations for a specific record type.
ANONYMOUSEMAILPREFERENCE	Describes communication preference settings for constituents.
ANONYMOUSEMAILSUBSCRIBER	Information about anonymous email subscribers
AnonymousNewsletterPart
APEXFORM	Stores the layout of web forms
APEXFORMCONTENT	Part content data for the Apex form part.
APEXFORMTYPE	Form type
APISUBSCRIPTIONKEY
APPEAL	Stores information pertaining to appeal records.
APPEALATTACHMENT	This table contains attachments belonging to appeals.
APPEALATTACHMENTTYPECODE	Stores translations of appeal attachment types.
APPEALBENEFIT	This table contains the benefit levels for an appeal.
APPEALBENEFITDETAIL	The benefit items associated with a benefit level on an appeal.
APPEALBUSINESSUNIT	This table stores the relationship between appeals and business units.
APPEALCATEGORYCODE	Stores translations for appeal category codes.
APPEALDESIGNATION	Stores default designations for appeal records.
APPEALMAILING	Stores information pertaining to appeal mailings.
APPEALMAILINGACTIVATEEMAILJOBSCHEDULE	Associates a start time for the email job of an activated appeal mailing.
APPEALMAILINGACTIVATEPROCESSOFFERCOUNT	Stores offer counts by channel for segmentation activate process runs.
APPEALMAILINGSETUP	Stores information for setting up an appeal mailing before activation.
APPEALMAILINGSETUPLETTER	This table holds letters associated with each appeal mailing.
APPEALMAILINGSETUPLETTERSELECTION	The selections associated with an appeal mailing letter.
APPEALMAILINGSETUPSELECTION	Stores selections to be used in an as part of setting up an appeal mailing before activation.
APPEALMAILINGTASK	Stores tasks for a particular appeal mailing.
APPEALMAILINGTASKREMINDER	Contains information pertaining to appeal mailing task reminders.
APPEALMEDIALINK	This table contains media links belonging to appeals.
APPEALMEDIALINKTYPECODE	Stores translations of appeal media link types.
APPEALNOTE	This table contains notes belonging to appeals.
APPEALNOTETYPECODE	Stores translations of appeal note types.
APPEALREPORT1CODE	Stores translations of the generic appeal report codes.
ApplicationFields
APPLICATIONRULES	This table contains the application defaults of the system.
Applications
ApplicationTasks
APPLICATIONURLPARTS	This table stores information about the location of the application needed by system alerts features to build links. It is NOT functional and needs to be kept in sync with the installation location.
APPSETTING
APPUSER
APPUSERACCOUNTSYSTEM	Associates an application user with an account system.
APPUSERADHOCQUERYFAVORITE	Stores user specific adhoc query favorites
APPUSERALERTSETTING	Stores application user alert settings.
APPUSERALERTTYPESETTING	Stores information about an application user's alert settings.
APPUSERARCHIVE
APPUSERCLAIMS
APPUSERCLAIMSLINK
APPUSERCURRENCYSET	Associates an application user with a currency set.
APPUSERFEATURETIP
APPUSERFEEDALERTINSTANCE	Stores a list of custom email alert instances assigned to a user
APPUSERINACTIVECODE
APPUSERINACTIVEDEFAULTREASONMAPPING
APPUSERINACTIVEDETAIL
APPUSERKPIINSTANCEFAVORITE
APPUSERPASSWORDRESET
APPUSERPASSWORDRESETREQUESTEXCEPTION
APPUSERSESSION	This table contains information about the current academic scheduling session for a specified user.
APPUSERSITEBRANCH	Stores the flattened version of an application user's default site branchsite permissions. This table was created so that the sql would not have to walk the site hierarchy when querying on the default site branch.
APPUSERSMARTQUERYINSTANCEFAVORITE	Stores user specific smart query favorites
APPUSERSUMMARYTILECONTEXT
APPUSERTHIRDPARTYAUTH
ARCHIVEDAPPEALMAILINGCONTENT	This table retains archived appeal mailing mail content from version 2.9 and earlier which is no longer supported. This content can be is to be downloaded and converted into HTML content for the new Altru mailing paradigm.
ARCHIVEDCMSTRANSACTIONS
ARRIVALAREACODE	Stores areas used in reservations.
ASSETTYPECODE	Code table for types of assets.
ASSETVALUATIONMETHODCODE	Code table for asset valuation methods.
ASSIGNCONSTITSECURITYATTRIBUTESPROCESS	Contains information pertaining to the assign constituent security attributes business process.
ASSIGNCONSTITSECURITYATTRIBUTESPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ASSIGNCONSTITSECURITYATTRIBUTESPROCESS table.
ASSIGNLETTERCODESPROCESS	Contains information pertaining to the assign letters business process.
ASSIGNLETTERCODESPROCESSLETTERCODES	Contains information pertaining to letter parameters for the assign letters process.
ASSIGNLETTERCODESPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ASSIGNLETTERCODESPROCESS table.
ASSIGNMENT	This table contains information about educational assignments.
ASSIGNMENTATTACHMENT	This table contains attachments belonging to assignments.
ASSIGNMENTMEDIALINK	This table contains media links belonging to assignments.
ASSIGNPLANNEDGIFTLETTERCODESPROCESS	Contains information pertaining to the assign planned gift letter codes process.
ASSIGNPLANNEDGIFTLETTERCODESPROCESSLETTERCODES	Contains information pertaining to letter code parameters for the assign planned gift letter codes process.
ASSIGNPLANNEDGIFTLETTERCODESPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ASSIGNPLANNEDGIFTLETTERCODESPROCESS table.
ATHLETICS_CONTACTINFO
ATHLETICS_EECOACHES
ATHLETICS_EVENTS
ATHLETICS_LOCATIONS
ATHLETICS_ROSTERS
ATHLETICS_SETTINGS
ATHLETICS_TEAMS
ATTRIBUTECATEGORY	Contains data describing the available attribute record types.
ATTRIBUTECATEGORYBATCHTYPEEXTENSIONS	Stores the batch type extensions for a give attribute category.
ATTRIBUTEFORMEXTENSION	Stores a list of attribute form extensions.
ATTRIBUTEGROUPCODE	Stores translations of attribute group codes.
ATTRIBUTERECORDTYPE	Contains data describing the available attribute record types.
AUCTIONITEM	Items sold in auctions.
AUCTIONITEMCATEGORY	Contains categories that can be used by auction items.
AUCTIONITEMPURCHASE	Revenue splits associated with auction items.
AUCTIONITEMRESERVATION	Pre-synch reservation for an auction item.
AUCTIONITEMREVENUEPURCHASE	Revenue associated with auction items.
AUCTIONITEMSUBCATEGORY	Contains subcategories that can be used by auction items.
AUCTIONPURCHASEADJUSTMENT	Stores adjustments made to posted auction purchases.
AUCTIONPURCHASEGLDISTRIBUTIONTEMP	Table to store the GL distribution of purchased auction items.
AuditCodes
Audits
AuditsLog
AVAILABLESUMMARYTILE
AWARDMANAGEMENTCONFIGURATION
AWARDMANAGEMENTINTEGRATIONERROR
AWARDMANAGEMENTINTEGRATIONPROCESS
AWARDMANAGEMENTINTEGRATIONPROCESSEXPORTFORMAT
AWARDMANAGEMENTINTEGRATIONPROCESSSTATUS
AWARDMANAGEMENTSYNCEDRECORD
BackOfficeCodeTables
BackOfficeSystemPeople
BackOfficeSystems
BackOfficeSystemUsers
BackOfficeUserImportErrRecords
BACSHEADER	Contains information pertaining to the BACS transmission file header.
BALANCINGENTRY	This table stores description about created balancing entries.
BALANCINGENTRYELEMENT	This table stores balancing entry details.
BANK	This table extends the constituent table and contains bank-specific fields.
BANKACCOUNT	This table contains information about a bank account.
BANKACCOUNTADJUSTMENT	This stores bank account adjustment-specific fields.
BANKACCOUNTADJUSTMENTATTACHMENT	Stores bank account adjustment attachment specific fields.
BANKACCOUNTADJUSTMENTCATEGORY	Stores bank account adjustment category specific fields.
BANKACCOUNTADJUSTMENTMEDIALINK	This table contains media links belonging to bank account adjustments.
BANKACCOUNTADJUSTMENTNOTE	This table contains notes belonging to bank account adjustments.
BANKACCOUNTAUTHORIZEDSIGNATURE	This table contains authorized signatures for a bank account
BANKACCOUNTDEPOSIT	This specifies the characteristics of the bank account deposit table.
BANKACCOUNTDEPOSITATTACHMENT	Stores bank account deposit attachment specific fields.
BANKACCOUNTDEPOSITCORRECTION_EXT
BANKACCOUNTDEPOSITCORRECTIONATTACHMENT	Stores bank account deposit correction attachment specific fields.
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTIONTEMP	Store the GL distribution for a bank account's deposit correction
BANKACCOUNTDEPOSITCORRECTIONMEDIALINK	This table contains media links belonging to bank account deposits.
BANKACCOUNTDEPOSITCORRECTIONNOTE	This table contains notes belonging to bank account deposit corrections.
BANKACCOUNTDEPOSITCORRECTIONTEMP	This table contains corrections belonging to bank account deposits.
BANKACCOUNTDEPOSITCREDITPAYMENT	Links credit payment records with deposits.
BANKACCOUNTDEPOSITMEDIALINK	This table contains media links belonging to bank account deposits.
BANKACCOUNTDEPOSITNOTE	This table contains notes belonging to bank account deposits.
BANKACCOUNTDEPOSITNOTETYPECODE	Stores translations of bank account deposit note types.
BANKACCOUNTDEPOSITPAYMENT	Links payment records with deposits.
BANKACCOUNTEFTINFO	EFT information for a bank account
BANKACCOUNTSEPAINFO
BANKACCOUNTSITE	This contains information pertaining to an bank account's sites.
BANKACCOUNTTRANSACTION_EXT
BANKACCOUNTTRANSACTIONAUDITORIGINAL	This table contains the audit trail for rows in the dbo.BANKACCOUNTTRANSACTION table.
BANKACCOUNTTRANSACTIONGLDISTRIBUTIONTEMP	Store the GL distribution for a bank account's transaction
BANKACCOUNTTRANSACTIONTEMP	This specifies the fields for the bank account transaction table.
BANKINGSYSTEM
BANNERMESSAGE
BATCH	The BATCH table stores batch instances that are used to view and update batches throughout the system.
BATCHADDRESSVALIDATION	Stores the submitted/validated address information for the address validation process
BATCHADDRESSVALIDATIONBATCHSYSTEMMESSAGES
BATCHADDRESSVALIDATIONBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHADDRESSVALIDATION batch table
BATCHAMPRODATA	Adds information necessary for the AuctionMaestro Pro import to the system Batch table.
BATCHAMPROIMPORT	Stores rows for AuctionMaestro Pro import batches.
BATCHAMPROIMPORTBATCHSYSTEMMESSAGES
BATCHAMPROIMPORTBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHAMPROIMPORT batch table
BATCHAMPROIMPORTCONSTITUENT	Stores rows relating to constituents which are imported from AuctionMaestro Pro.
BATCHAMPROIMPORTEVENT	Stores rows relating to auction events which are imported from AuctionMaestro Pro.
BATCHAMPROIMPORTITEM	Stores rows relating to items which are imported from AuctionMaestro Pro.
BATCHAMPROIMPORTMESSAGE	Stores messages generated by the AuctionMaestro Pro import process.
BATCHAMPROIMPORTPACKAGE	Stores rows relating to packages which are imported from AuctionMaestro Pro.
BATCHAMPROIMPORTPURCHASE	Stores rows relating to purchases which are imported from AuctionMaestro Pro.
BATCHAMPROIMPORTPURCHASEDETAIL	Stores rows relating to purchase details which are imported from AuctionMaestro Pro.
BATCHAMPROIMPORTREGISTRANT	Stores rows relating to items which are imported from AuctionMaestro Pro.
BATCHAUCTIONITEM	Stores rows for auction item batches.
BATCHAUCTIONITEMBATCHSYSTEMMESSAGES
BATCHAUCTIONITEMBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHAUCTIONITEM batch table
BATCHAUCTIONITEMCONSTITUENT	Stores data for constituents added to auction item batches.
BATCHAUCTIONITEMCONSTITUENTGROUPMEMBER	Stores group members for groups/households added to auction item batch.
BATCHAUCTIONITEMCONSTITUENTRELATION	Stores relation information for constituents added in auction item batch.
BATCHBBNCDONATION	Stores Blackbaud Internet Solutions donation transaction batch information.
BATCHBBNCDONATIONBATCHSYSTEMMESSAGES
BATCHBBNCDONATIONBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCDONATION batch table
BATCHBBNCDONATIONGIFTAPPLICATION	Stores gift applications for Blackbaud Internet Solutions donation transaction batch information.
BATCHBBNCDONATIONSOLICITOR	Stores solicitors for Blackbaud Internet Solutions donation transaction batch information.
BATCHBBNCDONATIONSPLIT	Stores splits for Blackbaud Internet Solutions donation transaction batch information.
BATCHBBNCEVENTREGISTRATION	Stores Blackbaud Internet Solutions event registration transaction batch information.
BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGES
BATCHBBNCEVENTREGISTRATIONBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCEVENTREGISTRATION batch table
BATCHBBNCFUNDRAISER	Stores Blackbaud Internet Solutions fundraiser transaction batch information.
BATCHBBNCFUNDRAISERBATCHSYSTEMMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCFUNDRAISER batch table
BATCHBBNCFUNDRAISERBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCFUNDRAISER batch table
BATCHBBNCMEMBERSHIP	Stores Blackbaud Internet Solutions membership transaction batch information.
BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGES
BATCHBBNCMEMBERSHIPBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCMEMBERSHIP batch table
BATCHBBNCMEMBERSHIPMEMBER	Stores member data for Blackbaud Internet Solutions membership batches.
BATCHBBNCPROFILE	Stores Blackbaud Internet Solutions profile update transaction batch information.
BATCHBBNCPROFILEBATCHSYSTEMMESSAGES
BATCHBBNCPROFILEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCPROFILE batch table
BATCHBBNCSIGNUP	Stores Blackbaud Internet Solutions signup transaction batch information.
BATCHBBNCSIGNUPBATCHSYSTEMMESSAGES
BATCHBBNCSIGNUPBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHBBNCSIGNUP batch table
BATCHCOAUPDATE	Stores
BATCHCOAUPDATEBATCHSYSTEMMESSAGES
BATCHCOAUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHCOAUPDATE batch table
BATCHCONSTITUENT	Stores constituent batch information.
BATCHCONSTITUENTADDRESSUPDATE	Stores constituent address update batch information.
BATCHCONSTITUENTADDRESSUPDATEBATCHSYSTEMMESSAGES
BATCHCONSTITUENTADDRESSUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHCONSTITUENTADDRESSUPDATE batch table
BATCHCONSTITUENTALTERNATELOOKUPID	This table contains constituent batch alternate lookup IDs for constituents.
BATCHCONSTITUENTBATCHSYSTEMMESSAGES
BATCHCONSTITUENTBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHCONSTITUENT batch table
BATCHCONSTITUENTCONSTITUENCY	Stores the constituent batch user-defined constituency information.
BATCHCONSTITUENTCONSTITUENCYSYSTEM	Stores the constituent batch system constituency information.
BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION	Stores additional education information for a constituent batch.
BATCHCONSTITUENTEDUCATIONALINVOLVEMENT	This table contains information about a constituent's educational involvement.
BATCHCONSTITUENTEDUCATIONALMAJOR	Stores constituent batch educational major information.
BATCHCONSTITUENTEDUCATIONALMINOR	Stores constituent batch educational minor information.
BATCHCONSTITUENTGROUPMEMBER	Stores batch information about constituent group members.
BATCHCONSTITUENTINTEREST	Stores constituent batch interest information.
BATCHCONSTITUENTPHONE	Stores constituent phone batch information.
BATCHCONSTITUENTSOCIALMEDIAACCOUNT
BATCHCONSTITUENTSOLICITCODE	Stores solicit code records for batch constituent records.
BATCHCONSTITUENTTAXDECLARATION	Stores tax declarations for a constituent batch record.
BATCHCONSTITUENTUPDATE	Stores constituentupdate batch information.
BATCHCONSTITUENTUPDATEADDRESSES	Stores addresses for constituent update batch.
BATCHCONSTITUENTUPDATEALTERNATELOOKUPIDS	Stores alternate lookup IDs for constituent update batch.
BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES
BATCHCONSTITUENTUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHCONSTITUENTUPDATE batch table
BATCHCONSTITUENTUPDATEBBNCINFO
BATCHCONSTITUENTUPDATECONSTITUENCIES	Stores constituencies for constituent update batch.
BATCHCONSTITUENTUPDATECONSTITUENCIESSYSTEM
BATCHCONSTITUENTUPDATEEMAILADDRESSES	Stores email addresses for constituent update batch.
BATCHCONSTITUENTUPDATEINTERESTS	Stores interests for constituent update batch.
BATCHCONSTITUENTUPDATENAMEFORMATS
BATCHCONSTITUENTUPDATEPHONES	Stores phones for constituent update batch.
BATCHCONSTITUENTUPDATERELATIONSHIPS
BATCHCONSTITUENTUPDATESECURITYATTRIBUTES	Stores security attributes for constituent update batch.
BATCHCONSTITUENTUPDATESITES	Stores sites for constituent update batch.
BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT
BATCHCONSTITUENTUPDATESOLICITCODE
BATCHCONSTITUENTUPDATESPOUSEALTERNATELOOKUPIDS	Stores spouse alternate lookup IDs for constituent update batch.
BATCHCURRENCYEXCHANGERATE	Stores currency exchange rate batch information
BATCHCURRENCYEXCHANGERATEBATCHSYSTEMMESSAGES
BATCHCURRENCYEXCHANGERATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHCURRENCYEXCHANGERATE batch table
BATCHDECEASEDFINDER	Stores rows for DeceasedRecordFinder batch
BATCHDECEASEDFINDERBATCHSYSTEMMESSAGES
BATCHDECEASEDFINDERBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHDECEASEDFINDER batch table
BATCHDESIGNATIONLEVELFINANCIALINFO	Stores designation level financial batch information.
BATCHDESIGNATIONLEVELFINANCIALINFOBATCHSYSTEMMESSAGES
BATCHDESIGNATIONLEVELFINANCIALINFOBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHDESIGNATIONLEVELFINANCIALINFO batch table
BATCHDIRECTDEBITRETURN	Stores batch info
BATCHDIRECTDEBITRETURNBATCHSYSTEMMESSAGES
BATCHDIRECTDEBITRETURNBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHDIRECTDEBITRETURN batch table
BATCHDIRECTMARKETINGEFFORT	Stores Direct Marketing Effort batch information.
BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGES
BATCHDIRECTMARKETINGEFFORTBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHDIRECTMARKETINGEFFORT batch table
BATCHDIRECTMARKETINGEFFORTLIST	Stores list information for Direct Marketing Effort batches.
BATCHDIRECTMARKETINGEFFORTPACKAGE	Stores package information for Direct Marketing Effort batches.
BATCHDIRECTMARKETINGEFFORTSEGMENT	Stores segment information for Direct Marketing Effort batches.
BATCHDIRECTMARKETINGEFFORTTESTSEGMENT	Stores test segment information for Direct Marketing Effort batches.
BATCHEDUCATIONALHISTORYUPDATE	Stores educational history update batch information.
BATCHEDUCATIONALHISTORYUPDATEAFFILIATEDADDITIONALINFORMATION	Stores educational history update batch academic catalog additional information.
BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES
BATCHEDUCATIONALHISTORYUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHEDUCATIONALHISTORYUPDATE batch table
BATCHEDUCATIONALHISTORYUPDATEEDUCATIONALINVOLVEMENTS	Stores educational history update batch educational involvements information.
BATCHEDUCATIONALHISTORYUPDATEUNAFFILIATEDADDITIONALINFORMATION	Stores educational history update batch educational additional information.
BATCHEMAILFINDER	Stores EmailFinder batch information.
BATCHEMAILFINDERBATCHSYSTEMMESSAGES
BATCHEMAILFINDERBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHEMAILFINDER batch table
BATCHESCOMMITPROCESS	Stores parameter sets associated with the batches commit business process.
BATCHESCOMMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the BATCHESCOMMITPROCESS table.
BATCHEVENT	Stores batch event information.
BATCHEVENTBATCHSYSTEMMESSAGES
BATCHEVENTBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHEVENT batch table
BATCHEVENTCOORDINATOR	Stores batch event coordinator information.
BATCHEVENTDESIGNATION	Stores batch event designation information
BATCHEVENTEXPENSE	Stores batch event expense information.
BATCHEVENTPRICE	Stores batch event price information.
BATCHEVENTREGISTRANT	Stores event registrant batch information.
BATCHEVENTREGISTRANTBATCHSYSTEMMESSAGES
BATCHEVENTREGISTRANTBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHEVENTREGISTRANT batch table
BATCHEVENTREGISTRANTGUEST	Stores event registrant guest batch information.
BATCHEVENTSITE	Contains information pertaining to an event's sites.
BATCHEVENTSPONSORSHIP	Stores Sponsorship batch information
BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGES
BATCHEVENTSPONSORSHIPBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHEVENTSPONSORSHIP batch table
BATCHEVENTSPONSORSHIPENEWSLETTER	Stores event sponsorship batch eNewsletter subscription info
BATCHEVENTTASK	Stores batch event task information.
BATCHGIVINGSUMMARYUPDATE	Stores giving summary update batch information.
BATCHGIVINGSUMMARYUPDATEBATCHSYSTEMMESSAGES
BATCHGIVINGSUMMARYUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHGIVINGSUMMARYUPDATE batch table
BATCHIGNOREDUPLICATE	Stores batch rows whose duplicate information has been evaluated.
BATCHINTERACTION	Stores interaction batch information
BATCHINTERACTIONBATCHSYSTEMMESSAGES
BATCHINTERACTIONBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHINTERACTION batch table
BATCHINTERACTIONPARTICIPANTS	Stores interaction participants batch information.
BATCHINTERACTIONSITES	Stores interaction sites batch information.
BATCHMEMBERSHIP	Stores membership batch information.
BATCHMEMBERSHIPBATCHSYSTEMMESSAGES
BATCHMEMBERSHIPBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHMEMBERSHIP batch table
BATCHMEMBERSHIPDUES
BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGES
BATCHMEMBERSHIPDUESBATCHUSERMESSAGE
BATCHMEMBERSHIPDUESBBNCINFO
BATCHMEMBERSHIPDUESBENEFIT
BATCHMEMBERSHIPDUESCAMPAIGN
BATCHMEMBERSHIPDUESDONATIONDESIGNATION
BATCHMEMBERSHIPDUESDONATIONRECOGNITION
BATCHMEMBERSHIPDUESDONATIONSOLICITOR
BATCHMEMBERSHIPDUESMEMBER
BATCHMEMBERSHIPDUESMEMBERSHIPCARD
BATCHMEMBERSHIPDUESMEMBERSHIPRECOGNITION
BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON
BATCHMEMBERSHIPDUESPERCENTAGEBENEFIT
BATCHMEMBERSHIPDUESPLEDGEINSTALLMENT
BATCHMEMBERSHIPDUESRESTRICTED
BATCHMEMBERSHIPDUESSOLICITCODE
BATCHMEMBERSHIPMEMBER	Stores membership members batch information.
BATCHMEMBERSHIPTRANSACTION	Stores membership transactions batch information.
BATCHMERCHANDISEINVENTORY
BATCHMERCHANDISEINVENTORYBATCHSYSTEMMESSAGES
BATCHMERCHANDISEINVENTORYBATCHUSERMESSAGE
BATCHMERCHANDISEINVENTORYLOOKUPCODE
BATCHMODELINGANDPROPENSITY	Modeling and Propensity Ratings Table
BATCHMODELINGANDPROPENSITYBATCHSYSTEMMESSAGES
BATCHMODELINGANDPROPENSITYBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHMODELINGANDPROPENSITY batch table
BATCHMODELINGANDPROPENSITYUPDATE	Stores modeling and propensity update batch information.
BATCHMODELINGANDPROPENSITYUPDATEBATCHSYSTEMMESSAGES
BATCHMODELINGANDPROPENSITYUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHMODELINGANDPROPENSITYUPDATE batch table
BATCHNUMBERINGSCHEME	The BATCHNUMBERINGSCHEME table stores the numbering information for automatically generated batch numbers.
BATCHPDACCOUNTSEGMENTMAPPING	Batch table for account segment mappings
BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES
BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHPDACCOUNTSEGMENTMAPPING batch table
BATCHPEOPLEFINDER	Stores PeopleFinder batch information.
BATCHPEOPLEFINDERBATCHSYSTEMMESSAGES
BATCHPEOPLEFINDERBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHPEOPLEFINDER batch table
BATCHPHONEFINDER	Stores PhoneFinder batch information.
BATCHPHONEFINDERBATCHSYSTEMMESSAGES
BATCHPHONEFINDERBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHPHONEFINDER batch table
BATCHPLEDGEWRITEOFF
BATCHPLEDGEWRITEOFFBATCHSYSTEMMESSAGES
BATCHPLEDGEWRITEOFFBATCHUSERMESSAGE
BATCHPLEDGEWRITEOFFINSTALLMENT
BATCHPLEDGEWRITEOFFRECOGNITIONCREDITS
BATCHRE7INTEGRATIONGIVINGSUMMARY	RE7 Integration Giving Summary Table.
BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGES
BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHRE7INTEGRATIONGIVINGSUMMARY batch table
BATCHREVENUE	Stores batch info
BATCHREVENUEADDITIONALAPPLICATIONBUSINESSUNIT	Stores business units associated with revenue batch applications.
BATCHREVENUEADDITIONALAPPLICATIONCAMPAIGN	Stores campaigns associated with a revenue batch additional application.
BATCHREVENUEADDITIONALAPPLICATIONS	Stores additional applications info for batch
BATCHREVENUEAPPLICATION	Stores batch information.
BATCHREVENUEAPPLICATIONBUSINESSUNIT	Stores business units associated with revenue batch applications.
BATCHREVENUEAPPLICATIONMEMBERSHIP	Stores information about memberships records added during the revenue batch process.
BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBER
BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBERMEMBERSHIPCARD
BATCHREVENUEAPPLICATIONPLEDGE	Stores information about new pledges added during the revenue batch process.
BATCHREVENUEAPPLICATIONPLEDGEBENEFIT	Stores benefit information for new pledges added during the revenue batch process.
BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENT	Stores installment information for a pledge added during the revenue batch process.
BATCHREVENUEAPPLICATIONPLEDGEINSTALLMENTSPLIT
BATCHREVENUEAPPLICATIONPLEDGEPERCENTAGEBENEFIT	Stores percentage benefit information for new pledges added during the revenue batch process.
BATCHREVENUEAPPLICATIONPLEDGESPLIT	Stores split information about a new pledge added during the revenue batch process.
BATCHREVENUEBATCHSYSTEMMESSAGES
BATCHREVENUEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHREVENUE batch table
BATCHREVENUEBBNCINFO
BATCHREVENUEBENEFIT	Stores benefits for batch rows.
BATCHREVENUEBENEFITPCT	Stores percentage benefits for batch rows.
BATCHREVENUEBUSINESSUNIT	Stores business units associated with a single revenue application.
BATCHREVENUECONSTITUENT	Stores data for constituents added to revenue batch.
BATCHREVENUECONSTITUENTACCOUNT	This table contains information about constituent accounts.
BATCHREVENUECONSTITUENTAPPEAL	Stores information relating appeal and constituent records for revenue batch.
BATCHREVENUECONSTITUENTEDITINFO
BATCHREVENUECONSTITUENTGROUPMEMBER	Stores group members for groups/households added to revenue batch.
BATCHREVENUECONSTITUENTRELATION	Stores relation information for constituents added in revenue batch.
BATCHREVENUECONSTITUENTSOLICITCODE
BATCHREVENUEENHANCEDMATCHINGGIFTS	Table holds matching gift information for batch transactions in the enhanced revenue batch.
BATCHREVENUEENHANCEDMATCHINGGIFTSPLIT	Stores designations for matching gift claims added in the enhanced revenue batch.
BATCHREVENUEFINANCIALINSTITUTION
BATCHREVENUEINSTALLMENT	Stores installments for batch rows.
BATCHREVENUEINSTALLMENTSPLIT	Stores splits for batch installments (currently used in revenue update batch only).
BATCHREVENUEINSTALLMENTSPLITPAYMENT
BATCHREVENUEINSTALLMENTSPLITWRITEOFF
BATCHREVENUELETTER	Stores letters for revenue update batch
BATCHREVENUEMATCHINGGIFTSPLIT	Stores designations for matching gift claims added in batch.
BATCHREVENUENOTE	This table contains notes belonging to revenue details in the revenue update batch.
BATCHREVENUERECOGNITION	Stores recognition credits for batch rows.
BATCHREVENUEREGISTRANT	Stores event registrations which have payments applied to them in revenue batch.
BATCHREVENUEREGISTRANTBENEFIT	Contains benefit information pertaining to a registrant.
BATCHREVENUEREGISTRANTPACKAGE	Contains information pertaining to registrant package fees.
BATCHREVENUEREGISTRANTPREFERENCE	Contains information pertaining to registrant preferences.
BATCHREVENUEREGISTRANTPREFERENCEMAP	Contains information pertaining to the link between registrant preferences and registrant registration mappings.
BATCHREVENUEREGISTRANTREGISTRATION	Contains information pertaining to registrant registration fees.
BATCHREVENUEREGISTRANTREGISTRATIONMAP	Contains information pertaining to the link between registrants and registrant registration fees.
BATCHREVENUESOLICITOR	Stores solicitors for batch rows.
BATCHREVENUESPLIT	Stores batch info
BATCHREVENUESPLITBUSINESSUNIT	Stores business units associated with revenue splits.
BATCHREVENUESPLITCAMPAIGN	Stores campaigns associated with a revenue batch split.
BATCHREVENUETAXDECLARATION	Stores tax declarations for a revenue batch record.
BATCHREVENUETRANSACTIONMAPPING
BATCHREVENUETRIBUTE	Stores tributes for batch rows.
BATCHREVENUEUNAPPLIEDMATCHINGGIFTSPLIT	Stores unapplied designations for matching gift claims added in batch.
BATCHSPONSORSHIP	Stores information about a sponsorship batch
BATCHSPONSORSHIPBATCHSYSTEMMESSAGES
BATCHSPONSORSHIPBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHSPONSORSHIP batch table
BATCHSPONSORSHIPCONSTITUENT	Stores data for constituents added to sponsorship batch.
BATCHSPONSORSHIPCONSTITUENTACCOUNT	This table contains information about constituent accounts.
BATCHSPONSORSHIPCONSTITUENTGROUPMEMBER	Stores group members for groups/households added to sponsorship batch.
BATCHSPONSORSHIPCONSTITUENTRELATION	Stores relation information for constituents added in sponsorship batch.
BATCHSTATISTICS	Stores information about users batch operations.
BATCHSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the BATCH table.
BATCHSTEWARDSHIPPLANSTEPUPDATE	Stores stewardship plan step update batch information.
BATCHSTEWARDSHIPPLANSTEPUPDATEASSOCIATEDPLAN	Stores stewardship plan step update associated plan batch information.
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGES
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHSTEWARDSHIPPLANSTEPUPDATE batch table
BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT	Stores stewardship plan step update plan participant batch information.
BATCHTEMPLATE	The BATCHTEMPLATE table stores batch instances that are used to view and update batches throughout the system.
BATCHTICKETPRINTJOB
BATCHTICKETPRINTJOBTICKETLINK
BATCHTIMESHEET	Stores data for the timesheet batch.
BATCHTIMESHEETBATCHSYSTEMMESSAGES
BATCHTIMESHEETBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the BATCHTIMESHEET batch table
BATCHTYPEADDINCATALOG
BATCHTYPEATTRIBUTERECORDTYPEMAP	Stores which attribute record types should create batch extensions for which batch types.
BATCHTYPECATALOG	The BATCHTYPECATALOG table stores batch types that can be used to create batches that allow for viewing and updating data throughout the system.
BATCHTYPEEXTENSIONCATALOG	Stores extensions for batch type specs.
BATCHUSERSETTINGS	Stores user settings for batch.
BATCHWORKFLOW	The BATCHWORKFLOW table stores the workflows that are used for the various batches in the system.
BATCHWORKFLOWSTATE	The BATCHWORKFLOWSTATE table stores the workflow states that are used for the various batch workflows in the system.
BATCHWORKFLOWSTATUS	The BATCHWORKFLOWSTATUS table stores the workflow statuses that are used for a given batch.
BATCHWORKFLOWTASK	The BATCHWORKFLOWTASK table stores the workflow tasks that are used for the various batch workflows in the system.
BATSGUID
BBAIMPORTFILES	This table contains the files used by Target Analytics for importing tables.
BBDM_Fields
BBIS_TRANSBATCHUPGRADEINFO
BBMARTDEPLOYLOG_1_0_0
BBNCAPPEALIDMAP
BBNCATTRIBUTECATEGORYIDMAP
BBNCCODETABLECATALOGIDMAP
BBNCCODETABLEIDMAP
BBNCCONSTITACCOUNTIDMAP
BBNCDESIGNATIONIDMAP
BBNCDESIGNATIONLEVELIDMAP
BBNCDOWNLOADEDTRANSACTION
BBNCEDUCATIONALHISTORYIDMAP
BBNCEVENTIDMAP
BBNCEVENTPRICEIDMAP
BBNCIDSETIDMAP
BBNCRELATIONSHIPIDMAP
BBNCREVENUEIDMAP
BBNCREVENUERECOGNITIONIDMAP
BBNCREVENUESPLITIDMAP
BBNCTEAMFUNDRAISERIDMAP
BBNCTEAMFUNDRAISINGTEAMIDMAP
BBNCTRANSACTIONDOWNLOADEXCEPTION
BBNCTRANSACTIONDOWNLOADEXCEPTIONSTATUS
BBNCTRIBUTEIDMAP
BBNCUNSUCCESSFULDOWNLOADTRANSACTION
BBNCUSERMAP	Associates a Blackbaud Internet Solutions user name with a row in the dbo.APPUSER table
BBPAYENVIRONMENTTEMPLATE
BBPSLOGIN	Stores the Blackbaud Payment System login.
BBWEBAUTHENTICATIONTOKEN
BBWORKFLOW_QUEUEMESSAGE_ERROR	Contains messages that generated an error when trying to deliver them.
BBWORKFLOWALERT
BBWORKFLOWBUSINESSACTIVITY	Information about a Workflow instance business activity
BBWORKFLOWCATALOG	Available workflow definitions and their urls
BBWORKFLOWDATAITEM	Contains arbitrary data payloads that can be associated with a workflow instance for use by the workflow logic
BBWORKFLOWINBOX	An inbox that workflow tasks can be routed to.
BBWORKFLOWINBOXASSIGNMENT	Defines what users or roles are assigned to a Workflow Inbox
BBWORKFLOWINSTANCEINFO	Information about a specific Blackbaud workflow instance
BBWORKFLOWINSTANCETRACKING	Records information captured from Workflow Instance Tracking Records
BBWORKFLOWLOG	Log table used to trace workflow instances
BBWORKFLOWTASK	Contains tasks that have been assigned to workflow inboxes
BBWORKFLOWTASKDATAITEM
BENEFICIARYTYPECODE	Stores beneficiary type code table entries.
BENEFIT	Stores information pertaining to a benefit.
BENEFITADJUSTMENT	Stores adjustments made to posted benefit distributions.
BENEFITBENEFITOPTION	Benefit Option linking table for Benefit and Benefit Option
BENEFITCATEGORYCODE	Benefit Category
BENEFITCONSTITUENTDECLINED	Links a Benefit to a Constituent that has been declined by the Constituent.
BENEFITEXTENSION	Benefit Extension for FAF event
BENEFITGLDISTRIBUTIONTEMP	Table to store the GL distribution of Benefit Details.
BENEFITOPTION	Benefit Option for FAF event
BENEFITSITE	This table contains info about sites for benefit catalog items.
BILLING_ADDATRANSACTIONTOAGROUP_EXCEPTION
BILLING_ADDATRANSACTIONTOAGROUP_OUTPUT
BILLINGGENERATETRANSACTIONSCHARGEPROCESSBILLINGITEMS	Generate Transactions Charge Process Billing Items Table
BILLINGGENERATETRANSACTIONSPROCESS	This table contains parameter sets for generate transactions business processes.
BILLINGGENERATETRANSACTIONSPROCESSSCHOOL	Generate Transaction Process School Table
BILLINGGENERATETRANSACTIONSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the BILLINGGENERATETRANSACTIONSPROCESS table.
BILLINGITEM	This table contains billing items.
BILLINGITEMDATES	This table contains billing item dates by grade level or school.
BILLINGITEMPRICE	This table contains billing item prices.
BILLINGITEMPRICEBYGRADELEVEL	This table contains billing item prices by grade level.
BILLINGITEMPRICEBYSCHOOL	This table contains billing item prices by school.
BOARDMEMBERDATERANGE	Contains the date ranges for which constituents are board members.
BUSINESSPROCESSCATALOG	The BUSINESSPROCESSCATALOG table is used to catalogue business processes
BUSINESSPROCESSCOMMPREF	Contains communication preference settings for all business processes.
BUSINESSPROCESSCOMMPREFEXCLUSIONS	Contains business process communication preferences exclusions.
BUSINESSPROCESSCOMMPREFINCLUSIONS	Contains business process communication preferences inclusions.
BUSINESSPROCESSEXPORTFORMAT	Defines the format in which data from a business process's output will be displayed when exported.
BUSINESSPROCESSINSTANCE	The BUSINESSPROCESSINSTANCE table stores business process instances that exist throughout the system.
BUSINESSPROCESSJOBSCHEDULECONVERSIONEXCEPTION
BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS
BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESSSTATUS
BUSINESSPROCESSJOBSCHEDULEUSERMAPPING
BUSINESSPROCESSOUTPUT	Contains data describing the output of a particular business process run.
BUSINESSPROCESSOUTPUTTEMPLATE	Contains information pertaining to letter and label templates associated with business process outputs.
BUSINESSPROCESSRUNTIMEINFO
BUSINESSPROCESSSCHEDULE	Specifies a schedule for a business process.
BUSINESSPROCESSSCHEDULELASTRUN
BUSINESSPROCESSSTATUS	Contains information pertaining to the business process status information
BUSINESSPROCESSSTATUS_EXT
BUSINESSPROCESSVIEW	Contains information pertaining to views used for output for a given business process
BUSINESSUNITCODE	Business units used for appeals.
CACHEDDISCOUNTRESULT
CACHEDDISCOUNTRESULTAPPLICATION
CacheItems
CALENDARCATALOG	Contains the meta information for calendar specs.
CALENDARDATALISTCOLOR	Contains the meta information for color selection by calendar specs.
CalendarEvent
CalendarEvtCategoryPicks
CalendarEvtRecur
CALENDARITEM	Describes a calendar item.
CAMPAIGN	Stores information about campaigns .
CAMPAIGNATTACHMENT	This table contains attachments belonging to campaigns.
CAMPAIGNATTACHMENTTYPECODE	Stores translations of campaign attachment types.
CAMPAIGNFUNDRAISER	This table stores information pertaining to fundraisers working on a campaign.
CAMPAIGNFUNDRAISERPOSITIONCODE	This table stores the different positions a fundraiser can occupy on a campaign.
CAMPAIGNFUNDRAISERTASKCODE	This table stores the different tasks a fundraiser can perform on a campaign.
CAMPAIGNGOAL	A goal for a campaign.
CAMPAIGNHIERARCHYGOAL	Describes a campaign hierarchy goal.
CAMPAIGNMEDIALINK	This table contains media links belonging to campaigns.
CAMPAIGNMEDIALINKTYPECODE	Stores translations of campaign media link types.
CAMPAIGNNOTE	This table contains notes belonging to campaigns.
CAMPAIGNNOTETYPECODE	Stores translations of campaign note types.
CAMPAIGNPRIORITY	Stores information about priorities assigned to campaigns.
CAMPAIGNPRIORITYTYPECODE	Stores translations of campaign priority types.
CAMPAIGNSITE	Contains information pertaining to a campaign's sites.
CAMPAIGNSUBPRIORITY	Stores information about sub priorities assigned to campaigns.
CAMPAIGNSUBPRIORITYNAMECODE	Stores translations of a campaign sub priority's name.
CAMPAIGNTEAM	This table stores information about organizational teams assigned to campaigns.
CAMPAIGNTYPECODE	This table stores information about campaign type codes.
CapWizTransactions
CAREERLEVELCODE	Stores translations of career levels
CASHFLOWCODE	Code tables holds the Account Code Cash Flow.
CASHPAYMENTMETHODDETAIL	Stores cash detail information for a revenue record when the payment method is cash.
CATEGORYDEFINITION	Configuration for account categories.
CHANGEAGENT	The applications/users upon whose behalf changes occur to data. This table allows tracking of changes to data by processes that do not necessarily connect through the application and thus may not have an application user name. Any process that changes data should first create a row in this table to identify itself before changing data.
CHANNELCODE	Indicates the inbound channel for revenue.
ChapterEmail
ChapterPages
ChapterRoles
Chapters
ChapterSite
CHARGE	This table contains charge records.
CHARGEDEFAULTS	This table contains the information of charge defaults.
CHARGELINEITEM	Extends the financial transaction line item to add charge information to the line items.
CHARGELINEITEMRESPONSIBILITY	Contains information about charge responsibility.
CHARGERECEIVABLECREDITLINEITEMS	Contains information about credit line item which is created by reversing a charge line item.
CHARITYCLAIMREFERENCENUMBER	Stores charity claim information.
CHARITYCLAIMREFERENCENUMBERSITE	Contains information pertaining to a charity claim reference number's sites.
CHECKPAYMENTMETHODDETAIL	Stores check detail information for a revenue record when the payment method is check.
CHURCHAFFILIATIONCODE	This code table stores translations of church affiliation codes.
CLASS	This table contains information about a class. A class is an instance of a course.
CLASSASSIGNMENT	This table contains information about the assignments associated with classes.
CLASSCATEGORY	Contains assignment categories for a particular class.
CLASSMEETING	This table contains information about the class meetings.
CLASSMEETINGGROUP	This table contains information about the meetings associated with a class.
CLASSMEETINGTEMPLATE	This table contains information about how class meetings should be created.
ClassYearNotes
CLEARMATCHINGGIFTCLAIMSPROCESS	Contains parameter information for the Clear Matching Gift Claims business process.
CLEARMATCHINGGIFTCLAIMSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CLEARMATCHINGGIFTCLAIMSPROCESS table.
ClientClassYears
ClientContentTypes
ClientDonations
ClientEvents
ClientMemberships
ClientMerchantAccounts
CLIENTROLECHILD	Defines the client roles that are children of a given client role.
ClientRoles
Clients
ClientSites
ClientSSO
ClientUserCalendarFilters
ClientUserDashboardPanel
CLIENTUSERFEATURETOUR
ClientUserFieldPrivacy
CLIENTUSERIDENTITYINFO
ClientUserImages
ClientUserMailForwarding
ClientUserMRU
ClientUserPasswordHistory
ClientUserProfile
ClientUserReport
ClientUsers
CLIENTUSERSBANNERMESSAGESSEEN
CLIENTUSERSCIPHER
CLIENTUSERSCIPHERHISTORY
ClientUsersDeletedRERecordMap
CLIENTUSERSEMAILHISTORY
CLIENTUSERSEXTENSION	BBNC client users extension table
CLIENTUSERSFAILEDLOGININFO
CLIENTUSERSLOGINHISTORY
CLIENTUSERSSALTCIPHER
CLIENTUSERSSALTCIPHERHISTORY
CLIENTUSERSTIPSSEEN
CLOSEDRAWERCONFIGURATION
CLOSEDRAWERDENOMINATION
CLOSINGREQUIREMENT	This table stores high level fields for closing requirements.
CLOSINGREQUIREMENTDETAIL	This table holds details of the closing requirement.
CLOUDCATALOGDEFINITION	Stores the available cloud catalogs that can be accessed to download custom catalogs
CMS_DIRECTORYPARAMETER
CMS_SESSIONVARIABLEBACKUP
CMS_UNPROCESSEDBBSPTRANSACTION
CMSALLOWEDDOMAIN
CMSDELIVERYCHANNEL	A delivery channel represents different methods of delivering CMS content, such as a PC, mobile device, or printer.
CMSEVENTOPTION
CMSEVERYONESECURITYPRIVS	Exceptions defined for a given object for the everyone role.
CMSNOTIFICATIONEMAILADDRESS
CMSNOTIFICATIONROLE
CMSOBJECTINTERESTTAG	Tags CMS objects with an interest
CMSOBJECTTASK	This table defines all the tasks available for CMS object security.
CMSOBJECTTYPEOBJECTTASK	Defines the object tasks associated with each CMS object type.
CMSOBJETSECURITYEXCEPTION	Contains the security exceptions for each CMS object.
CMSQUERYPUBLISHING
CMSREDIRECT
CMSRESERVEDITEMS
CMSSECURITYGROUP	Groups CMS Security task rights
CMSSECURITYGROUPCLIENTROLECLIENTSITE	Associates a CMS Security Group with a CMS Role and a CMS Site
CMSSECURITYGROUPCONTENTTYPE
CMSSECURITYGROUPTASK	Associates a CMS Task with a CMS Security Group
CMSSITEPAGEBBPAYTEMPLATEVERSION
CMSSITESETTING	Settings for asdf CMS Sites
CMSSITEURLS
CMSSQLJOBSCHEDULES
CMSTEMPLATELAYOUT	Specifies the layout ID that a template uses for a particular delivery channel.
CMSTRANSACTIONS
CMSTRANSACTIONSTATE
CMSUSERCULTURELANGUAGE	Store the culture language string for each CMS user
CMSUSERSALESORDER	Associates an active sales order with a CMS user.
CMSUSERSOCIALMEDIAACCOUNT
CMSUSERSOCIALPROFILE	Contains social profile information for a CMS user.
COAUPDATE	The AddressFinder is represented by this table.
COAUPDATEABBREVIATION	Contains the abbreviations and translations from the USPS for the AddressFinder process.
COAUPDATECREATEPROCESS
COAUPDATECREATEPROCESSEXPORTFORMAT
COAUPDATECREATEPROCESSSTATUS
COAUPDATEFILE	Stores the files for the AddressFinder process.
COAUPDATEGETPROCESS	The AddressFinder get process is represented by this table.
COAUPDATEGETPROCESSEXPORTFORMAT
COAUPDATEGETPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the COAUPDATEGETPROCESS table.
COAUPDATERESUBMITPROCESS	The AddressFinder resubmit process is represented by this table.
COAUPDATERESUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the COAUPDATERESUBMITPROCESS table.
COAUPDATESUBMITPROCESS	The AddressFinder submit process is represented by this table.
COAUPDATESUBMITPROCESSEXPORTFORMAT
COAUPDATESUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the COAUPDATESUBMITPROCESS table.
CODETABLECATALOG	The CODETABLECATALOG table is used to catalogue all code tables in the system
CODETABLECATEGORY	Stores the available code table categories.
CODETABLESECURITY	Stores information pertaining to code table security.
COMBINATION	Stores information for combinations.
COMBINATION_MICROSITEEMAILTEMPLATE
COMBINATIONAVAILABILITY	Stores availability for combination.
COMBINATIONAVAILABILITYCONSTITUENCY	Combination constituency availability.
COMBINATIONAVAILABILITYMEMBER	Combination membership availability.
COMBINATIONAVAILABILITYSALESMETHOD	Contains combination availability sales method information
COMBINATIONCONSTITUENCY	Combination constituency eligibility.
COMBINATIONMEMBER	Combination membership eligibility.
COMBINATIONPRICETYPE	Stores price types available for combination.
COMMENT_TEXT	Table containing FAF user comments, made on participants or media
Comments
COMMITMENTREVALUATION	Contains exchange rate information used by the Revalue Foreign-Denominated Commitments business process.
COMMITTEE	Contains the committee information.
COMMITTEEDATERANGE	Contains the date ranges for which constituents are committees.
COMMUNICATIONEXCLUSIONCOMMUNICATIONTYPES	Describes the communication types to be used when defining 'recent' communications for communication exclusions.
COMMUNICATIONEXCLUSIONS	Describes the communication exclusion criteria.
COMMUNICATIONLETTER	This table holds letters associated with Altru communications.
COMMUNICATIONLETTERACTIVITYEXCLUSIONCOMMUNICATIONTYPES	Describes the communication types to be used when defining 'recent' communications for communication exclusions.
COMMUNICATIONLETTERACTIVITYEXCLUSIONS	Describes the activity exclusion criteria for a given communication letter.
COMMUNICATIONLETTEREXCLUDEDSOLICITCODE	This table stores solicit codes to be excluded from a given communication letter.
COMMUNICATIONLETTERSELECTION	The selections included and excluded from a communication letter.
Condition
CONDITIONALCONTENTRECIPIENT	Holds recipient info for conditional content email
ConditionBlock
ConditionBlockCondition
ConditionBlockConditionMergeHTML
ConditionBlockParentCondition
ConditionList
ConditionRecipientStatistics
CONDITIONSETTING	Stores conditions and their states for controlling the display and behavior of features.
CONFIDENCERATING	Contains user defined confidence ratings.
CONFIDENCERATINGINSTALLEDPRODUCT	Stores lists of installed products for Confidence Ratings.
CONFIGURATIONDATACATALOG	Contains ConfigurationDataSpec definitions.
CONFIGURATIONEXPORTINSTANCE	Stores parameter settings for a specific step in the configuration export business process.
CONFIGURATIONEXPORTPROCESS	Stores parameter settings for the configuration export business process.
CONFIGURATIONEXPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CONFIGURATIONEXPORTPROCESS table.
CONFIGURATIONIMPORTPROCESS	Stores parameter settings for the configuration import business process.
CONFIGURATIONIMPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CONFIGURATIONIMPORTPROCESS table.
CONGRESSIONALDISTRICTCODE	This code table stores the translations of congressional districts.
CONSENTOPTION
CONSENTTRANSACTIONSTATUS
CONSTIT_SECURITY_ATTRIBUTE	This tables contains the security attributes that will be assigned to constituents.
CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT	This table contains the constituent security attributes for constituents.
CONSTITUENCY	Stores the constituent code information for constituents.
CONSTITUENCYCODE	Stores translations of constituency codes.
CONSTITUENCYCRITERIASPOUSE	Contains constituency criteria information.
CONSTITUENCYDATERANGE
CONSTITUENCYDEFINITION
CONSTITUENCYDISPLAYORDER	This table holds the sequence for displaying system and user-defined constituencies.
CONSTITUENCYREFRESHPROCESS
CONSTITUENCYREFRESHPROCESSCONSTITUENCY
CONSTITUENCYREFRESHPROCESSSELECTIONRESULT
CONSTITUENCYREFRESHPROCESSSTATUS
CONSTITUENT	Every individual or organization, constituent or non-constituent, is represented by a row in the CONSTITUENT table. Each row in the CONSTITUENT table identifies that entity as an individual or organization, a constituent or non-constituent, and contains that entity's name and its various properties, such as gender or matching gift limits.
CONSTITUENTACCOUNT	This table contains information about constituent accounts.
CONSTITUENTAPPEAL	Stores information relating appeal and constituent records.
CONSTITUENTAPPEALRESPONSE	Associates interactions with constituent appeal responses.
CONSTITUENTATTACHMENT	This table contains attachments belonging to constituents.
CONSTITUENTATTACHMENTTYPECODE	Stores translations of constituent attachment types.
CONSTITUENTBUSINESSRULESSETTINGS
CONSTITUENTCORRESPONDENCE	This table contains information about constituent correspondence.
CONSTITUENTCORRESPONDENCERESPONSE	Associates interactions with constituent correspondence responses.
CONSTITUENTDATAREVIEWROLLBACK	Records of rollbacks from the constituent data review page.
CONSTITUENTDATAREVIEWROLLBACKREASON	Reasons why user edits were rolled back from the constituent data review page.
CONSTITUENTDISPLAYNAMEFORMAT	Constituent Display Name Format
CONSTITUENTDUPLICATESEARCHPROCESS	Contains information pertaining to the Constituent Duplicate Search Process.
CONSTITUENTDUPLICATESEARCHPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the CONSTITUENTDUPLICATESEARCHPROCESS table.
CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS
CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS_RAWDATA
CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS
CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS_RAWDATA
CONSTITUENTDUPLICATESEARCHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CONSTITUENTDUPLICATESEARCHPROCESS table.
CONSTITUENTDUPLICATESEARCHSETTINGS	This table stores settings used by the constituent duplicate search algorithm.
CONSTITUENTHOUSEHOLD	This table stores the current household information for a constituent.
CONSTITUENTINACTIVEDETAIL	Stores details about why a constituent was marked inactive.
CONSTITUENTINACTIVITYREASONCODE	This table contains options for constituent inactivity
CONSTITUENTINTEREST	This table contains a list of a constituent's interests.
CONSTITUENTINTERESTCODE	Stores translations of constituent interest codes.
CONSTITUENTJOBINFO	Job information for a constituent.
CONSTITUENTMATCHLOGICALRESULTMAPPING
CONSTITUENTMATCHSCORERESULT
CONSTITUENTMEDIALINK	This table contains media links belonging to constituents.
CONSTITUENTMEDIALINKTYPECODE	Stores translations of constituent media link types.
CONSTITUENTMERGEOPERATIONS	This table keeps a record of all the merge operations that have been executed by constituent merge processes.
CONSTITUENTMERGEPROCESS	This table contains parameter sets for use when executing the constituent merge process.
CONSTITUENTMERGEPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the CONSTITUENTMERGEPROCESS table.
CONSTITUENTMERGEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CONSTITUENTMERGEPROCESS table.
CONSTITUENTNOTE	This table contains notes belonging to constituents.
CONSTITUENTNOTEATTACHMENT
CONSTITUENTNOTEBBIS
CONSTITUENTNOTETYPECODE	Stores translations of constituent note types.
CONSTITUENTORIGINATION	Holds addition information pertaining to all constituents
CONSTITUENTRECOGNITION	Stores constituent recognition records.
CONSTITUENTRECOGNITIONBENEFIT	Stores benefits for a constituent recognition.
CONSTITUENTRECOGNITIONDECLINEDLEVEL	Table to hold all of the declined recognition program levels for constituents
CONSTITUENTRECOGNITIONDECLINEDPROGRAM
CONSTITUENTRECOGNITIONPROCESS	Contains information pertaining to the Constituent Recognition Process.
CONSTITUENTRECOGNITIONPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CONSTITUENTRECOGNITIONPROCESS table.
CONSTITUENTRECOGNITIONREVENUE	Stores revenue records that relate to constituent recognition programs.
CONSTITUENTRESTRICTIONOPTION	Links a constituent to an event restriction option.
CONSTITUENTSEGMENT
CONSTITUENTSITE	Contains information pertaining to a constituent's sites.
CONSTITUENTSOLICITCODE	Stores all of the solicit codes associated with constituents.
CONSTITUENTSOURCEANALYSISCACHEADDRESS	Enables the caching of old constituent address values for source analysis.
CONSTITUENTSOURCEANALYSISCACHECOMMUNITYMEMBER	Enables the caching of the Blackbaud Internet Solutions Member constituency for source analysis.
CONSTITUENTSOURCEANALYSISCACHEDONOR	Enables the caching of the donor constituency for source analysis.
CONSTITUENTSOURCEANALYSISCACHEMEMBERSHIPMEMBER	Enables the caching of the Membership Member constituency for source analysis.
CONSTITUENTSOURCEANALYSISCACHEMGORG	Enables the caching of the Matching Gift Organization constituency for source analysis.
CONSTITUENTSOURCEANALYSISCACHESMARTFIELDLIFETIMEGIFTSONFILE	Enables the caching of old 'Constituent Lifetime Gifts on File' smartfield values for source analysis.
CONSTITUENTSOURCEANALYSISCACHESMARTFIELDLIFETIMEGIVING	Enables the caching of old 'Constituent Lifetime Giving' smartfield values for source analysis.
CONSTITUENTSOURCEANALYSISCACHESMARTFIELDYEARSASDONOR	Enables the caching of old 'Constituent Consecutive Years as Donor' smartfield values for source analysis.
CONSTITUENTTYPECODE	This table stores translations of the built-in constituent types.
ContactGroup
CONTACTTYPECODE	This code table stores translations of contact types.
ContentComparisonCookiedUsers
ContentComparisonDonationTransactions
ContentComparisonPart
ContentComparisons
ContentComparisonStats
ContentTabs
CONTENTTYPECATEGORIZATION	Links CMS Content Types to their corresponding categories in SiteFolders
ContentTypes
CONTROLACCOUNT	This table stores details about the control accounts for all subsidiary ledgers.
CONTROLACCOUNTELEMENT	This table stores all the elements used for control accounts
CONTROLACCOUNTTREASURY	This extends the control account table for treasury cash accounts.
CORECURRICULUM	Core Curriculum
CORECURRICULUMCOURSE	Core Curriculum Courses
CORPORATESTRUCTUREFILTER	This table contains filter options for the Corporate Structure tree for each application user.
CORPORATESTRUCTURESELECTION	This table contains selected nodes in the Corporate Structure tree for each application user.
CORRECTIONATTACHMENTTYPECODE	Stores translations of bank account deposit correction types
CORRECTIONMEDIALINKTYPECODE	This stores translations of bank account deposit correction media link types.
CORRESPONDENCECATEGORYCODE	This table stores translations of the built-in correspondence categories.
CORRESPONDENCECODE	Stores the correspondence code information.
CORRESPONDENCEPROCESS	Contains information pertaining to the Correspondence process.
CORRESPONDENCEPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the CORRESPONDENCEPROCESS table.
CORRESPONDENCEPROCESSRUNHISTORY	This table stores information about correspondence process statuses for historical purposes.
CORRESPONDENCEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CORRESPONDENCEPROCESS table.
Countries
COUNTRY	Contains definitions of countries.
COUNTRYADDRESSFORMAT	Contains various address formats for a given countries.
COUNTRYADDRESSLABEL	Contains custom labels for use in address forms when dealing with a specific country.
COUNTRYVALIDATIONINFO	Contains validation information per country.
COUNTYCODE	This code table stores translations of county codes.
COURSE	This table contains information about a course.
COURSEACADEMICCATALOGDEPARTMENT	Course Academic Catalog Departments
COURSEASSIGNMENT	This table contains information about the assignments associated with courses.
COURSEATTACHMENT	This table contains attachments belonging to course.
COURSEATTACHMENTTYPECODE	Stores translations of course attachment types.
COURSEGRADELEVEL	Course Grade Levels
COURSEGRADING	Grading information for one course
COURSEGRADINGMARKINGCOLUMN	Marking columns for a grading information on a course.
COURSEMEDIALINK	This table contains notes belonging to course.
COURSEMEDIALINKTYPECODE	Stores translations of course media link types.
COURSENOTE	This table contains notes belonging to course.
COURSENOTETYPECODE	Stores translations of course note types.
COURSERESTRICTION	This table contains schedule restrictions for a course in a date range.
COURSERESTRICTIONSTARTTERM	This table contains start and end dates for terms in which a course is restricted to start.
COURSETYPE	Course Types
COURSETYPECODE	Types of courses
CREDIT_EXT
CREDITCARD	Holds all credit card details.
CREDITCARDPAYMENTMETHODDETAIL	Stores credit card detail information for a revenue record when the payment method is credit card.
CREDITCARDPROCESSING	Contains parameter information for the Credit Card Processing business process.
CREDITCARDPROCESSINGEXPORTFORMAT
CREDITCARDPROCESSINGHISTORY	Stores detail information for credit card processing runs.
CREDITCARDPROCESSINGMERCHANTACCOUNT	Stores the merchant accounts defined for a credit card processing business process.
CREDITCARDPROCESSINGRETRYBATCH
CREDITCARDPROCESSINGSTATE	Stores the state of a Credit Card Processing business process.
CREDITCARDPROCESSINGSTATEBBPSPROCESS	Stores the BBPS process IDs for a credit card process.
CREDITCARDPROCESSINGSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CREDITCARDPROCESSING table.
CREDITCARDPROCESSINGTRANSACTIONOUTCOME
CREDITCARDREFUNDCONFIGURATION	Stores configuration settings used to handle credit card refunds.
CREDITCARDUPDATE
CREDITGLDISTRIBUTIONtemp	Table to store the GL distribution of credit items.
CREDITITEM_EXT
CREDITITEMEVENTREGISTRATION	Stores event registration information for a credit item.
CREDITITEMITEMDISCOUNT	Stores sales order item item discounts associated with a credit item.
CREDITITEMMEMBERSHIP	Stores membership transaction information for a credit item.
CREDITITEMMEMBERSHIPITEMPROMOTION	Stores sales order item membership item promotions associated with a credit item.
CREDITITEMTEMP	Credit Items belonging to a credit record.
CREDITITEMTICKET	Stores data for a ticket on a credit.
CREDITMEMO	All credit memo records.
CREDITORDERPAYMENTMAP	Stores the mapping of credit payments to order payments and vice-versa
CREDITPAYMENT	Stores payments for a credit
CREDITPAYMENTCHECKPAYMENTMETHODDETAIL	Holds detailed check information of a credit payment.
CREDITREASONCODE	Reason Code to be used for a Credit item
CREDITTEMP	Stored credits.
CREDITTYPECODE	This code table stores translations of credit type codes.
CRMBBENVIRONMENT
CRMBBPAYTEMPLATE	Defines BBPay Templates for BBNC.
CSSClasses
CURRENCY	This table contains information about currency types.
CURRENCYDENOMINATION
CURRENCYEXCHANGERATE	Stores information pertaining to currency exchange rates.
CURRENCYEXCHANGERATEDOWNLOADPROCESS	Stores information pertaining to a currency exchange rate download process parameter set.
CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE	Stores information pertaining to the currency exchange rates to be downloaded by a currency exchange rate download process parameter set.
CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the CURRENCYEXCHANGERATEDOWNLOADPROCESS table.
CURRENCYEXCHANGERATEPROVIDER	Stores information pertaining to a third-party currency exchange rate provider.
CURRENCYEXCHANGERATESOURCECODE	Stores the different sources of currency exchange rates.
CURRENCYSET	Stores information pertaining to currency sets.
CURRENCYSETTRANSACTIONCURRENCY	Associates currency sets with currencies as transaction currencies.
CustomFormAutoSavedForms
CUSTOMFORMDASHBOARDCONFIGURATION
CUSTOMFORMDASHBOARDFORMENTRY
CUSTOMFORMDASHBOARDGRADELEVEL
CUSTOMFORMDASHBOARDUSERFILTER
CustomFormDataSource
CustomFormElement
CustomFormEntry
CustomFormEntryAttribute
CUSTOMFORMENTRYDOCUMENT	Contains the documents that are linked to a Custom Form Entries
CUSTOMFORMFEE
CustomFormFieldValidators
CustomFormFolder
CustomFormMappingSchema
CustomFormPaymentSetting
CUSTOMFORMRULEACTION
CUSTOMFORMRULETARGET
CustomFormSettings
CUSTOMMODELING	Contains values for an individual associated with a custom modeling field.
CUSTOMMODELINGFIELD	Contains field information for custom modeling data.
CustomTransactions
CustomTransactionTypes
CYCLE	Cycle.
CYCLEDAY	Cycle Days
DAILYSALEITEM	Holds data about daily sale items.
DAILYSALEITEMCOMBINATION	Holds data relative to a daily sale item combination.
DAILYSALEITEMDISCOUNT	Holds data relative to a daily sale discount item.
DAILYSALEITEMDONATION	Holds data relative to a daily sale donation.
DAILYSALEITEMEVENTREGISTRATION	Holds data relative to a daily sale event registration item.
DAILYSALEITEMMEMBERSHIP	Holds data relative to a daily sale membership.
DAILYSALEITEMMEMBERSHIPPROMO	Holds data relative to a daily sale membership promotion item.
DAILYSALEITEMPROGRAM	Holds data relative to a daily sale program item.
DAILYSALESGENERICACTION	Contains data indicating whether a generic action should be visible on the Daily Sales screen.
DASHBOARDCATALOG
DATABASEGROWTHANALYSISPROCESS
DATABASEGROWTHANALYSISPROCESSSTATUS
DATABASEMAILSETTINGS	This table stores information needed to send alerts using Database Mail.
DATABASESPACEUSED
DATABASESPACEUSEDHISTORY
DATAELEMENT	Parent table for all accounting element types.
DATAFORMADDINCATALOG	The DATAFORMADDINCATALOG table stores custom addins for data form instances.
DATAFORMEXTENSION	The DATAFORMEXTENSION table stores extensions for data form instances.
DATAFORMFIELDCHARACTERISTIC	Contains customized field characteristics.
DATAFORMFIELDCHARACTERISTICCAPTION	Per culture captions for data form field characteristics.
DATAFORMINSTANCECATALOG	The DATAFORMINSTANCECATALOG table stores data forms that are used to view and update data throughout the system.
DATAFORMTEMPLATECATALOG	The DATAFORMTEMPLATECATALOG table stores data form templates that can be used to create data forms that allow for viewing and updating data throughout the system.
DATAFORMWORKFLOWTRIGGER	Stores a list of data forms that trigger workflows.
DATALISTCATALOG	The DATALISTCATALOG table stores datalist definitions that can be used to return filtered rows of data
DATANETTEASEREMAILCONTENT
DATANETTEASEREMAILTRACKING
DATANETTEASERTRACKING
DATAPROTECTIONEVIDENCESOURCECODE
DATASOURCEPRODUCT
DataSources
DATATUNEUP	The data tune-up settings are represented by this table.
DATATUNEUPFOOTNOTEREASONMAP	Defines a mapping from COA DPV footnote codes to do not mail reason codes.
DDISOURCECODE	Stores all of the DDI source codes.
Debug
DECEASEDCONSTITUENT	Indicates that a constituent is deceased.
DECEASEDFINDER	The DeceasedRecordFinder process is represented by this table.
DECEASEDFINDERCREATEPROCESS
DECEASEDFINDERCREATEPROCESSSTATUS
DECEASEDFINDERFILE	Stores files for the DeceasedRecordFinder process.
DECEASEDFINDERGETPROCESS	The DeceasedRecordFinder get process is represented by this table.
DECEASEDFINDERGETPROCESSDATA	Stores data from DeceasedRecordFinder get process
DECEASEDFINDERGETPROCESSEXPORTFORMAT
DECEASEDFINDERGETPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the DECEASEDFINDERGETPROCESS table.
DECEASEDFINDERRESUBMITPROCESS	The DeceasedRecordFinder resubmit process is represented by this table.
DECEASEDFINDERRESUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the DECEASEDFINDERRESUBMITPROCESS table.
DECEASEDFINDERSUBMITPROCESS	The DeceasedRecordFinder submit process is represented by this table.
DECEASEDFINDERSUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the DECEASEDFINDERSUBMITPROCESS table.
DECEASEDSOURCECODE	This code table stores translations of deceased source codes.
DECEASINGOPTION	Contains system deceasing options.
DECEASINGRULE	Contains global deceasing rules.
DECLARATIONSOURCECODE	This code table stores translations of declaration source codes.
DEFAULTATTRIBUTECATEGORIES
DEFAULTCOMMENT	This table contains the default comments.
DefaultTemplatesx
DefaultText
DELIVERYMETHOD	Methods of delivering tickets to constituents
DELIVERYMETHODFEE	Links a delivery method to more than one fee
DEMOGRAPHIC	This table stores additional demographic information for constituents.
DEMOGRAPHICETHNICITY	This table stores multiple ethnicities for a individual.
DENOMINATIONCODE	This code table stores translations of religious denomination codes.
DEPARTMENTCODE	This code table stores translations of departments.
DEPOSITATTACHMENTTYPECODE	Stores translations of bank account deposit attachment types.
DEPOSITCORRECTIONNOTETYPECODE	Stores translations of bank account deposit correction note types.
DEPOSITGLDISTRIBUTIONLINK	Link between a deposit and the GL transaction it created on another record.
DEPOSITMEDIALINKTYPECODE	This stores translations of bank account deposit media link types.
DESIGNATION	Stores a flat representation of the giving hierarchy.
DESIGNATION_MICROSITEEMAILTEMPLATE
DESIGNATIONALTLOOKUPID	Stores alternate lookup IDs for designations.
DESIGNATIONALTLOOKUPIDTYPECODE	This code table stores translation of alternate lookup ID types for designations.
DESIGNATIONCAMPAIGN	Defines campaigns to default on to revenue for designations.
DESIGNATIONDETAILSLINK	This table contains links to more information about a designation.
DESIGNATIONGOAL	Stores goal information pertaining to designations.
DESIGNATIONIMAGE	This table contains an image associated with a designation.
DESIGNATIONLEVEL	Stores information pertaining to a Fundraising Purpose.
DESIGNATIONLEVELATTACHMENT	This table contains attachments belonging to a Fundraising Purpose.
DESIGNATIONLEVELATTACHTYPECODE	Stores translations of fundraising purpose attachment types.
DESIGNATIONLEVELCATEGORYCODE	Categories that are associated to a fundraising purpose.
DESIGNATIONLEVELDECAPITALIZATION	Contains information pertaining to purpose decapitalization.
DESIGNATIONLEVELDISBURSEMENT	Stores information pertaining to fundraising purpose disbursements.
DESIGNATIONLEVELDONORINFORMATION	This table contains donor information belonging to a Fundraising Purpose.
DESIGNATIONLEVELFINANCIALINFO	Stores information pertaining to Fundraising Purpose Financial Information.
DESIGNATIONLEVELGIFTFEEAPPLICATIONTYPE	This table contains application types processed for gift fees on a designation level
DESIGNATIONLEVELGIFTFEEOPTION	This table contains override options for gift fees on a designation level
DESIGNATIONLEVELGIFTFEEOVERRIDE	This table contains override options for gift fees on a designation level
DESIGNATIONLEVELGIFTFEESTRUCTURE	This table contains override fee structures for gift fees on a designation
DESIGNATIONLEVELGOAL	Stores goal information pertaining to a Fundraising Purpose.
DESIGNATIONLEVELMEDIALINK	This table contains media links belonging to fundraising purposes.
DESIGNATIONLEVELMEDLINTYPECODE	Stores translations of fundraising purpose media link types.
DESIGNATIONLEVELNOTE	This table contains notes belonging to a Fundraising Purpose.
DESIGNATIONLEVELNOTETYPECODE	Stores translations of fundraising purpose note types.
DESIGNATIONLEVELRECIPIENT	Stores information pertaining to fundraising purpose recipients.
DESIGNATIONLEVELRELATEDSTAFF	Contains information on staff related to a fundraising purpose.
DESIGNATIONLEVELREVENUEINFORMATION	This table contains revenue information belonging to a Fundraising Purpose.
DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS	This table contains stewardship recipients belonging to a Fundraising Purpose.
DESIGNATIONLEVELTYPE	Holds records that describe types of fundraising purposes and their associated UI characteristics.
DESIGNATIONLEVELTYPEHIERARCHY	Stores the instance of designation level type hierarchy templates.
DESIGNATIONLEVELTYPEHIERARCHYITEM	This table stores items in a designation level type hierarchy.
DESIGNATIONLEVELTYPEHIERARCHYTEMPLATE	This table stores designation level type hierarchy templates.
DESIGNATIONLEVELTYPEHIERARCHYTEMPLATEITEM	This table stores items in a designation level type hierarchy template.
DESIGNATIONREPORT1CODE	Stores translations of the first generic designation report codes.
DESIGNATIONREPORT2CODE	Stores translations of the second generic designation report codes.
DESIGNATIONTAG	Represents a tag on a designation.
DESIGNATIONUSECODE	Usage code for designations.
DEVSPACESETTINGS	Contains system-level configuration rules for the uploading and validation of custom assemblies
DIFFERENTIALDUPLICATECONSTITUENTSRUNDATE	Stores the last run date for the find differential duplicate constituents SSIS package.
DIRECTDEBITPAYMENTMETHODDETAIL	Stores direct debit detail information for a revenue record when the payment method is direct debit.
DIRECTORYMESSAGESTATS
DIRECTORYOPTSTATUS
DIRECTORYSEARCHSTATS
DISABLEDWEALTHUPDATES	Contains IDs of constituents that have been disabled from WealthPoint updates.
DISBURSEMENTFORMAT	Disbursement format records that are used to create disbursement processes.
DISBURSEMENTHISTORY	History of actions taken on a disbursement record.
DISBURSEMENTPROCESS	Disbursement Process
DISBURSEMENTPROCESSDISBURSEMENT	Place holder disbursement for the disbursement process
DISBURSEMENTPROCESSFORMAT	Holds the list of formats to use in each process
DISBURSEMENTPROCESSPRINTFINALIZERANGE	Disbursement Process Print Finalize Range
DISBURSEMENTPROCESSSIGNATURE	Signatures assigned to a disbursement process
DISBURSEMENTPROCESSTEMPLATE	Templates to create disbursement processes
DISBURSEMENTPROCESSTEMPLATEFORMAT	Holds the list of formats to use in each process template
DISBURSEMENTPROCESSTEMPLATESIGNATURE	Signatures assigned to a disbursement process template
DISCOUNT	Stores information for discounts.
DISCOUNTADDRESS	Stores information for discount address restrictions.
DISCOUNTAVAILABILITY	Stores availability for discount.
DISCOUNTAVAILABILITYCONSTITUENCY	Discount constituency availability.
DISCOUNTAVAILABILITYMEMBER	Discount membership availability.
DISCOUNTAVAILABILITYSALESMETHOD	Contains discount availability sales method information
DISCOUNTCONSTITUENCY	Discount constituency eligibility.
DISCOUNTGLMAPPING	Stores the GL mapping for a discount.
DISCOUNTGROUP	Stores link between discount information and qualifying and discounted item groupings.
DISCOUNTGROUPDETAIL	Stores qualifying and discounted item information.
DISCOUNTGROUPDETAILMERCHANDISEDEPARTMENT	Contains all the merchandise departments associated with a discount.
DISCOUNTGROUPDETAILMERCHANDISEITEM	Contains the merchandise items associated with a discount.
DISCOUNTGROUPDETAILPROGRAM	Stores program information for a discount group detail item.
DISCOUNTMEMBER	Discount membership eligibility.
DISCOUNTPRICETYPE	Stores information for price types that receive discounts.
DISCOUNTQUALIFYINGPRICETYPE	Stores information for qualifying discount price types.
DISCOUNTREASONCODE	Describes why a discount was given
DISCOUNTTAX	Links a discount to more than one tax.
DiscussionGroups
DiscussionPosts
DiscussionTopics
DISSOLVEDGROUP	Indicates that a group is dissolved.
DISSOLVEREASONCODE	This code table stores translations of dissolved reason codes.
DOCUMENT	A printable document
DOCUMENTPRINTINGHISTORY	Printing history for sales documents for an order.
DOCUMENTPRINTINGRULE	Holds printing rule information for a document.
DOCUMENTPRINTINGRULESALESMETHOD	Holds the sales methods valid for the printing rule of a document.
DOCUMENTSVGTEMPLATE
DOCUMENTTYPECODE	Contains different Document Types
DocUploadFiles
DocUploadPart
Domains
DONATIONBATCH	Stores donation batch information
DONATIONBATCHBATCHSYSTEMMESSAGES
DONATIONBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the DONATIONBATCH batch table
DONATIONBATCHENEWSLETTER	Stores donation batch eNewsletter subscription info
DonationDesignations
DonationEReceipt
DonationGivingLevels
DONATIONPOS	Stores defaults for adding a donation to a sales order.
DonationSources
DonationTransactions
DONORCHALLENGE	Stores information pertaining to donor challenges.
DONORCHALLENGEATTACHMENT	This table contains attachments belonging to donor challenges.
DONORCHALLENGEATTACHMENTTYPECODE	Stores translations for donor challenge attachment types.
DONORCHALLENGEDESIGNATIONMAP	Stores designations associated with donor challenges.
DONORCHALLENGEENCUMBERED	Stores revenue splits for donor challenges.
DONORCHALLENGEENCUMBERPROCESS	Stores parameters for donor challenge encumber process
DONORCHALLENGEENCUMBERPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the DONORCHALLENGEENCUMBERPROCESS table.
DONORCHALLENGEEXCLUDEDAPPLICATIONTYPE	Stores application types excluded from matching gifts with donor challenges.
DONORCHALLENGEMEDIALINK	This table contains media links belonging to donor challenges
DONORCHALLENGEMEDIALINKTYPECODE	Stores translations for donor challenge media link types.
DONORCHALLENGEMEMBERSHIPLEVELMAP	Stores membership levels associated with donor challenges.
DONORCHALLENGENOTE	This table contains notes belonging to donor challenges.
DONORCHALLENGENOTETYPECODE	Stores translations for donor challenge note types.
DONORCHALLENGESPLIT	Stores designation splits for donor challenges.
DONORCHALLENGESPONSORCODE	Stores internal donor challenge sponsors.
DONORINFORMATIONFIELDS
DonorScrollers
DONOTCALLREASONCODE	Stores translations for do not call reasons.
DONOTEMAILREASONCODE
DONOTMAILREASONCODE	Stores translations for Do Not Mail reason
DUPLICATECONSTITUENTSEARCHRESULTSTABLE	Contains the names of all the tables in the database that contain duplicate constituent search results.
EA7_AssignmentDocuments
EA7_CustomFormApplicationChecklistSetting
EA7_REVISIONS
EA7_UserFieldPrivacy
ECard
ECardPart
ECardPartTemplate
ECardTemplate
ECardTemplateFolder
EDUCATIONADDITIONALINFORMATION	Each row represents additional education information for a constituent's educational history record.
EDUCATIONALAWARDCODE	Educational award for an educational history record.
EDUCATIONALCOLLEGECODE	Educational college for an unaffiliated educational history record.
EDUCATIONALCONFIGURATION	This table contains configuration information related to educational history records.
EDUCATIONALDEGREECODE	Stores translations of educational degrees.
EDUCATIONALDEGREECODEEXTENSION	Extended fields to EDUCATIONALDEGREECODE table.
EDUCATIONALDEGREETYPECODE	Educational degree type for an unaffiliated educational history record.
EDUCATIONALDEPARTMENTCODE	Educational department for an unaffiliated educational history record.
EDUCATIONALDEPARTMENTCODEEXTENSION	Extended fields to EDUCATIONALDEPARTMENTCODE table.
EDUCATIONALDIVISIONCODE	Educational division for an unaffiliated educational history record.
EDUCATIONALHISTORY	This table contains information about constituent's educational history.
EDUCATIONALHISTORYLEVELCODE	Indicates the level of the educational history record.
EDUCATIONALHISTORYREASONCODE	Indicates the reason an educational history record's status is unknown.
EDUCATIONALHISTORYSTATUS	Allows the user to store a set of educational history statuses for use when working with educational histories.
EDUCATIONALHISTORYSTATUSCODE	Stores translations of educational history record status.
EDUCATIONALHISTORYSTATUSHISTORY	This table stores the status information for an enrollment.
EDUCATIONALHISTORYTYPECODE	Stores translations of education history type.
EDUCATIONALINSTITUTION	This table contains information about educational institutions.
EDUCATIONALINSTITUTIONLOCATIONCODE	Stores location of educational institution.
EDUCATIONALINVOLVEMENT	This table contains information about a constituent's educational involvement.
EDUCATIONALINVOLVEMENTNAME	Indicates the name of an educational involvement.
EDUCATIONALINVOLVEMENTTYPECODE	Indicates the type of educational involvement.
EDUCATIONALMAJOR	Contains a constituent's educational major history.
EDUCATIONALMAJORCODE	Stores translations of educational majors.
EDUCATIONALMINOR	Contains a constituent's educational minor history.
EDUCATIONALPROGRAMCODE	Educational program for an unaffiliated educational history record.
EDUCATIONALREASONLEFTCODE	Indicates the reason for leaving.
EDUCATIONALSOURCECODE	Educational source for an educational history record.
EDUCATIONALSUBDEPARTMENTCODE	Educational sub department for an unaffiliated educational history record.
EDUCATIONALSUBDEPARTMENTCODEEXTENSION	Extended fields to EDUCATIONALSUBDEPARTMENTCODE table.
EducationEdit
EDUCATIONINVOLVEMENTAWARDCODE	Award for an educational involvement record.
EDUCATIONMEETING	Date and time information for education related meetings.
EFTHEADER	Contains information pertaining to the EFT transmission file header.
Email
Email_EmailList
EMAIL_INACTIVERECIPIENT
Email_Recipient
Email_Recipient_Source
Email_Stats
EMAILACTIVECHUNK	Contains thread ids and insertion order of active chunks
EMAILADDRESS	The EMAILADDRESS table stores email addresses associated with a given constituent.
EMAILADDRESSTYPECODE	This code table stores translations of email address type codes.
EMAILCATEGORYPRIORITY	Email Type Priorities
EmailConditionBlock
EMAILEXTERNALSERVERSTATUS	This table tracks update dates from the external email service
EMAILFINDER	The EmailFinder process is represented by this table.
EMAILFINDERFILE	Stores files for the EmailFinder process.
EMAILFINDERGETPROCESS	The EmailFinder get process is represented by this table.
EMAILFINDERGETPROCESSEXPORTFORMAT
EMAILFINDERGETPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EMAILFINDERGETPROCESS table.
EMAILFINDERRESUBMITPROCESS	The EmailFinder resubmit process is represented by this table.
EMAILFINDERRESUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EMAILFINDERRESUBMITPROCESS table.
EMAILFINDERSUBMITPROCESS	The EmailFinder submit process is represented by this table.
EMAILFINDERSUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EMAILFINDERSUBMITPROCESS table.
EmailInvalidAccount
EmailInvalidAccountRecipient
EMAILINVALIDRECIPIENT	This table holds all email addresses we have sent to as well as information such as validity number of sends etc.
EmailJob
EmailJob_Recipient
EMAILJOB_RECIPIENT_DONATED
EmailJobConditionBlockCondition
EMAILJOBDATA	Merge data for an email job.
EMAILJOBEXTENSION	Email Job Extension
EmailJobStatus
EMAILJOBTEMPORARYMETATDATA	Stores metadata about dynamically created tables that are used in email jobs.
EmailLink
EmailList
EmailList_GlobalSubscription
EmailList_People
EmailList_Query
EmailList_Subscription
EmailList_UserDefined
EmailListUploadMasterList
EMAILPROCESSTRACKING	Table tracks number of currently running email processes
EmailProject
EmailProjectAppeal
EmailProjectAppeal_Duplicates
EmailProjectAppeal_EmailList
EmailProjectAppeal_ListEmail
EMAILQUEUEGENERALPURPOSE	Holds pending transactional emails. Since this is a queue, no audit trail is required.
EMAILQUEUETRANSACTIONAL	Holds pending transactional emails. Since this is a queue, no audit trail is required.
EMailRecipients
EMAILSCHEDULE	Stores the data for Scheduled Email jobs
EMAILSCHEDULE_EMAILLIST	Relational table for mapping Email lists to EmailSchedules
EMAILSTATUSCODE	This table holds email status translations.
EMAILSTATUSGENERALPURPOSE	Holds live and historical information on emails that have are or were in the EMAILQUEUEGENERALPURPOSE table. Allowing auditing so that change history is preserved.
EMAILSTATUSTRANSACTIONAL	Holds live and historical information on emails that have are or were in the EMAILQUEUETRANSACTIONAL table. Allowing auditing so that change history is preserved.
EmailTemplate
EmailTemplate_DataSources
EmailTemplate_EmailList
EmailTemplateConditionBlock
EMAILTEMPLATEEXTENSION	EmailTemplateExtension
EMAILTESTADDRESSES
EMPLOYEECORPORATERELATIONSHIPTYPE	This table contains the employee relationships designated as corporate relationship types.
ENCRYPTEDFILE	Stores information about an encrypted file.
ENQUEUESETTINGS
ENTITLEMENTCACHE
Error
ESTIMATEDWEALTH	Contains estimated wealth ranges.
ETHNICITYCODE	This code table stores translations of ethnicity codes.
ETICKETSPARTSETTINGS
ETLCONFIGURATION	Stores information pertaining to ETL source.
ETLCONFIGURATIONREVENUETYPES	Holds data pertaining to the revenue types to process in the ETL.
ETLHISTORY	History of the SSIS packages that have run for OLAP data sources
ETLREFRESHPROCESS	Holds parameters needed by the ETL Refresh process.
ETLREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the ETLREFRESHPROCESS table.
EVENT	Contains information pertaining to an event.
EVENT_MICROSITEEMAILTEMPLATE
EVENTAPPEAL	Contains information pertaining to event appeals.
EVENTATTACHMENT	This table contains attachments belonging to events.
EVENTATTACHMENTTYPECODE	Stores translations of event attachment types.
EVENTATTRIBUTES	Friends Asking Friends event attributes
EVENTAUCTION	Links an auction to an event.
EVENTAUTOMATCHSITE
EVENTBATCH	Link batch with event
EventCalendar
EventCalendarHighlight
EventCalendarHighlightDetail
EventCalendarView
EventCalendarViewDetail
EVENTCAMPAIGN	Associates events with campaigns
EVENTCATEGORYCODE	Event Category Code Table
EVENTCATEGORYCODESITE
EVENTCONFLICT	This table stores the event conflicts during scheduling.
EVENTCOORDINATOR	Contains information pertaining to event coordinators.
EVENTDESIGNATION	Links events and event designations.
EVENTDONOR	This table includes information about constituent who donate in a specific event
EVENTEMAILTEMPLATE	Store confirmation and notification templates for a given event
EVENTEXPENSE	Contains information pertaining to an event expense.
EVENTEXPENSETYPECODE	Stores translations of event expense types.
EVENTEXTENSION	Extended fields to EVENT Table
EVENTFAFCONFIG	Event Faf Config for an event
EVENTGLMAPPING	Stores the GL mapping for event.
EVENTGOAL	Event Goal
EVENTGROUP	Contains information pertaining to event groups.
EVENTGROUPMEMBER	Contains information pertaining to event group members.
EVENTHIERARCHY	This table stores information pertaining to event hierarchies.
EVENTHOLD	Connects a hold code to a event hold list
EVENTHOLDLIST	Contains information for a hold list for an event.
EVENTIMPORT
EVENTINSTRUCTOR	Contains information pertaining to event instructors.
EventItemCapacity
EventItemPrices
EventItems
EVENTLABEL	Label of the Event
EVENTLOCATION	Contains information pertaining to an event location.
EVENTLOCATIONROOM	Contains data about rooms at event locations.
EVENTLODGING	Links events and event lodging locations which are many to many relationships.
EVENTLODGINGLOCATION	This table stores the location information for a lodging associated with an event.
EVENTLODGINGLOCATIONROOMTYPE	Stores the room types available for an event lodging location.
EVENTLODGINGROOM	Contains data about event lodging rooms.
EVENTLODGINGROOMINSTANCE	Represents a single instance of a lodging room.
EVENTLODGINGROOMTYPECODE	Stores translations of event lodging room types.
EVENTMANAGEMENTINSTANCE	Stores information for event management instances.
EVENTMANAGEMENTLEVELINSTANCE	Stores information for an instance of an event management level.
EVENTMANAGEMENTLEVELTEMPLATE	Stores information for event management level templates.
EVENTMANAGEMENTOPTIONS	Stores management rules for an event in an event hierarchy (created from event management templates).
EVENTMANAGEMENTTEMPLATE	Stores information for event management property group templates.
EVENTMANAGEMENTTEMPLATESITE	Contains information pertaining to an event management template's sites.
EVENTMEDIALINK	This table contains media links belonging to events.
EVENTMEDIALINKTYPECODE	Stores translations of event media link types.
EVENTNOTE	This table contains notes belonging to events.
EVENTNOTETYPECODE	Stores translations of event note types.
EVENTPLAN	Contains information pertaining to event plan template.
EVENTPLANTASK	Contains information pertaining to event plan template tasks.
EVENTPREFERENCE	Contains information pertaining to event preferences.
EVENTPREFERENCEGROUP	Contains incorporation pertaining to event preference groups.
EVENTPRICE	Contains information pertaining to event prices.
EVENTPRICEBENEFIT	Contains information relating event benefits with event prices.
EVENTPRICELIST	Contains the name of a Event PriceList and ID linking to Event.
EVENTREGISTRANTITINERARY	Stores information about a registrants travel and lodging.
EVENTREGISTRANTPAYMENT	Indicates which event registrants have been paid by which revenue detail records.
EVENTREGISTRANTTRAVELNAMECODE	Stores the translations of registrant travel names.
EVENTREGISTRANTTRAVELTYPECODE	Stores translations of registrant travel types.
EVENTREGISTRATIONEXPRESSPARTSETTINGS
EVENTREGISTRATIONOPPORTUNITY
EVENTREGISTRATIONTYPE	Contains information pertaining to event registration types.
EVENTRESOURCE	Contains the resources and quantity of those resources used for an event.
EVENTRESTRICTIONOPTION	Holds options for event restrictions
EVENTRESTRICTIONTYPE	Event Restriction Type table
EVENTSALESMETHOD	Connects an Event to a Sales Method
EVENTSEATING	Contains information pertaining to the event seating layout.
EVENTSEATINGSEAT	Contains information pertaining to the event seating seat.
EVENTSEATINGSECTION	Contains information pertaining to the event seating sections.
EVENTSEATINGSUBSECTION	Contains information pertaining to the event seating sub-sections.
EVENTSITE	Contains information pertaining to an event's sites.
EVENTSPEAKER	Contains information pertaining to event speaker.
EVENTSPONSOR	This table includes details about constituents who perform a sponsorship for a specific event.
EVENTSPONSORSHIPTYPE	Event Sponsorship type
EVENTSPONSORSHIPTYPEBENEFIT	Event Sponsorship Benefit Type Linking Table
EVENTSTAFFRESOURCE	Contains the resources and quantity of those staff resources needed for an event.
EVENTSTAFFRESOURCEASSIGNMENT	Allows the assignment of constituents to event staff resources.
EVENTTASK	Contains information pertaining to an event task.
EVENTTASKREMINDER	Contains information pertaining to event task reminders.
EVENTTEAMFAFCONFIG	Faf Team settings for an event
EventTransactions
EVENTVENDOR	Indicates that a constituent is a vendor and contains vendor-specific fields.
EVENTWIDGET	Widgets available in the Event for Admin
EXCHANGEADDRESSMAPPING	Contains a list of mapped address types to be used for exchange integration.
EXCHANGEAPPUSEREMAILADDRESS	Contains application user email address information. The email address is used for identification when the exchange server is not on the domain running the CRM application.
EXCHANGECALENDARITEM	Contains a list of interactions added as calendar items to the exchange server.
EXCHANGECALENDARITEMBATCH	Batch table containing Exchange calendar item record updates.
EXCHANGECALENDARITEMBATCHASSIGNMENT	Contains exchange calendar item batch assignments used during the exchange download process.
EXCHANGECALENDARITEMBATCHBATCHSYSTEMMESSAGES
EXCHANGECALENDARITEMBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the EXCHANGECALENDARITEMBATCH batch table
EXCHANGECALENDARSYNC	Contains parameter values for the Exchange calendar synchronization process.
EXCHANGECALENDARSYNCSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EXCHANGECALENDARSYNC table.
EXCHANGECONTACT	Contains a list of constituents added as contacts to the exchange server.
EXCHANGECONTACTBATCH	Batch table containing exchange contact record updates.
EXCHANGECONTACTBATCHASSIGNMENT	Contains exchange contact batch assignments used during the exchange download process.
EXCHANGECONTACTBATCHBATCHSYSTEMMESSAGES
EXCHANGECONTACTBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the EXCHANGECONTACTBATCH batch table
EXCHANGECONTACTCATEGORYCODE	Stores translations of exchange contact categories.
EXCHANGECONTACTSYNC	Contains parameter values for the Exchange contact synchronization process.
EXCHANGECONTACTSYNCSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EXCHANGECONTACTSYNC table.
EXCHANGEDOWNLOADPROCESS	Contains parameter values for the exchange download process.
EXCHANGEDOWNLOADPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EXCHANGEDOWNLOADPROCESS table.
EXCHANGEEMAILADDRESSMAPPING	Contains a list of mapped email address types to be used for exchange integration.
EXCHANGEEMAILBATCH	Batch table containing Exchange Email records.
EXCHANGEEMAILBATCHASSIGNMENT	Contains exchange email batch assignments used during the exchange download process.
EXCHANGEEMAILBATCHBATCHSYSTEMMESSAGES
EXCHANGEEMAILBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the EXCHANGEEMAILBATCH batch table
EXCHANGEEMAILBATCHSITE	Expresses exchange email batch entry/site relationships. Only used for exchange email batch entries that are to be added as interactions.
EXCHANGEINTEGRATION	Contains configuration settings used for exchanged integration.
EXCHANGEPHONEMAPPING	Contains a list of mapped phone types to be used for exchange integration.
EXCHANGESERVER	Contains configuration settings used for an Exchange server.
EXCHANGESERVERAPPUSER	Contains a list of application users that are assigned to a specific Exchange server.
EXCHANGEUSER	Contains a list of users that have BBEC contact information.
EXPORTDEFINITION	Each row in the EXPORTDEFINITION table corresponds to a user-defined export definition.
EXPORTHEADERABBREVIATION	Contains abbreviations used for queryview tree nodes when building export column header names.
EXPORTPROCESS	Contains information for the export business process .
EXPORTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the EXPORTPROCESS table.
EXPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the EXPORTPROCESS table.
EXTERNALSERVICECONFIGURATION	Holds setup data for email services
FacebookClientUsers
FACILITY	Table that holds facility rental information for event locations.
FACULTY	Indicates that a constituent is a faculty member and contains faculty-specific fields.
FACULTYACADEMICCATALOGDEPARTMENT	This table links Faculty with Academic Catalog Departments
FACULTYCLASSMEETINGGROUP	This table contains information about the class meetings associated to a faculty member.
FACULTYCOURSE	This table contains information about the relationship between faculty and courses.
FACULTYSECURITYSTUDENTACCESS	Determines which students and which features a faculty has access to.
FACULTYSTATUSCODE	Stores translations for the faculty status
FAFACCOUNTSETTINGSCONTENT	Part content data for the FAF account settings part.
FAFADDRESSBOOKCATEGORY	FAF Address Book Custom Category
FAFADDRESSBOOKCUSTOMTYPE	Custom address types created by registrant
FAFCOMMENTS	Table containing FAF user comments
FAFCOMMENTSAPPROVAL	Comments approval
FAFCOMMUNICATIONSLOG	FAF Participant communications log
FAFDONATION
FAFEVENTADHOCQUERY	Adhoc queries in fafevent
FAFEVENTBATCH
FAFEVENTBATCHBATCHSYSTEMMESSAGES
FAFEVENTBATCHBATCHUSERMESSAGE
FAFEVENTCOMMUNICATIONCHANNEL	Store Communication Channel tracking data
FAFEVENTCOMMUNICATIONCHANNELREGISTRANT	Store Communication Channel tracking data for registration
FAFEVENTCOMMUNICATIONCHANNELREVENUE	Store Communication Channel tracking data for donation
FAFEVENTDATACACHE
FAFEVENTDONATIONOPTIONSCONFIG	Friends Asking Friends Donation Options
FAFEVENTEMAIL	Store all FAF event marketing messages
FAFEVENTEMAILREADY
FAFEVENTFORMTEMPLATE	Friends Asking Friends Event Form Template
FAFEVENTINQUIRY	Store event contact info.
FAFEVENTPAGETEMPLATE	Friends Asking Friends Event Page Template
FAFEVENTSOCIALNETWORKPOST	Store logs of sent social network post from participation HQ
FAFEVENTSOCIALNETWORKPROPERTY
FAFFRIENDLYURLPARAMS	Extra parameters for FAF participant friendly url
FAFFUNDRAISINGGAUGE	Fundraising Gauge on FAF Page
FAFFUNDRAISINGROLESCONTENT	Part content data for the FAF fundraising roles part.
FAFGIFTACKNOWLEDGEMENT	FAF gift acknowledgement
FAFGOALTYPE	Goal types for Faf Event
FAFGROUPDIRECTHIERARCHY
FAFGROUPSUMMARYINFORMATION
FAFGROUPSUMMARYINFORMATION_CATEGORIZED
FAFHELPCONFIG	Configuration table for the FAF Help parts
FAFIMAGES	Table containing images/photos uploaded by the constituents/participants of a fundraising event.
FAFINCENTIVELEVEL	Incentive Level FAF event
FAFINCENTIVELEVELBENEFIT	Incentive Level Benefit for FAF event
FAFMARKETTYPECODE
FAFMENUDISPLAYCACHE
FAFNFGCAMPAIGN
FAFNFGCAMPAIGNDISPLAYSITE
FAFNFGCAMPAIGNLEVEL
FAFNFGCAMPAIGNLEVELDISPLAYSITE
FAFNFGLEVELSUMMARY
FAFNFGTYPECODE
FAFOFFLINEFORMCONTENT	Part content data for the FAF offline form part.
FAFOFFLINEFORMTEMPLATE	Friends Asking Friends offline form template
FAFORGANIZATIONINDIVIDUALRELATION
FAFPARTICIPANTGALLERYIMAGES	Store images here to be used in the participant's image gallery
FAFPARTICIPANTPAGECONTENT	Part content data for the FAF participant page part.
FAFPROGRAM
FAFPROGRAMSITE
FAFRAISEDTOTAL	Precalculated raised totals for participants and teams in FAF events
FAFRAISEDTOTAL_CATEGORIZED
FAFREGISTRANTBENEFITSUMMARY
FAFREGISTRANTPENDINGSUMMARY
FAFREGISTRANTPREVIOUSSUMMARY
FAFREGISTRATIONCATEGORY	Faf Registration Category
FAFREGISTRATIONTYPE	Eventprice Extension for FAF event
FAFREGISTRATIONTYPEGOAL	Goal section of FAFREGISTRATIONTYPE
FAFRELATIONSHIPTYPE	For relationship types specific to FAF
FAFRSSFEED	Table to store RSS Feeds
FAFSEASONTYPECODE
FAFSYSTEMDEFAULTLABEL	System Default Label for FAF Event
FAFTASK
FAFTOPFUNDRAISERDISPLAYOPTION	Friends Asking Friends event FAF Top Fundraiser Display Option
FEATUREASSOCIATEDWITHPRODUCT
FEATUREGROUPCATALOG
FEATUREGROUPFEATURE
FEATUREUNLOCKEDBYPRODUCTFLAGS
FEE	Stores information for fees.
FEEDALERTINSTANCE	Stores the values for a custom email alert instance.
FEEDALERTINSTANCEWORKFLOWTRIGGER	Stores a list of feed alert instances that trigger workflows.
FEEGLMAPPING	Stores the GL mapping for a fee.
FEETAX	Links a fee to more than one tax.
FENXTACCOUNT
FENXTACCOUNTCODE
FENXTACCOUNTFUNDREQUIREMENT
FENXTACCOUNTSTRUCTURE
FENXTFISCALPERIOD
FENXTFISCALYEAR
FENXTFISCALYEARSTAGING
FENXTINTEGRATION
FENXTPROJECT
FENXTSYNCPROCESS
FENXTSYNCPROCESSEXCEPTIONS
FENXTSYNCPROCESSSTATUS
FENXTTOKEN
FEPDATA	This table stores the latest copy of the anonymized data from the Fundraising Effectiveness Project.
FEPPROCESS	Contains information about the FEP process.
FEPSUBMITPROCESS	Contains FEP submit process data
FEPSUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the FEPSUBMITPROCESS table.
FILEVIEWDATA
FINANCIALBATCH	Financial Batch
FINANCIALINSTITUTION	This table contains information about financial institutions.
FINANCIALINSTITUTIONREJECTIONCODE	Stores rejection codes for financial institutions.
FINANCIALSYSTEM	This table stores all the systems developed for financials.
FINANCIALSYSTEMSETTINGS	Financial System Settings Table
FINANCIALSYSTEMTRANSACTIONTYPE	Ties financial systems with their transaction types
FINANCIALTRANSACTION	All financial transaction records.
FINANCIALTRANSACTION1099BOXNUMBER	Holds financial transaction's 1099 box number information
FINANCIALTRANSACTION1099DISTRIBUTION	Holds financial transaction's 1099 distribution information
FINANCIALTRANSACTIONAPPLICATION	Applies a financial transaction to the schedule of another
FINANCIALTRANSACTIONAPPLICATION1099DISTRIBUTION	Holds financial transaction application's 1099 distribution information
FINANCIALTRANSACTIONATTACHMENT	This table contains attachments belonging to financial transactions.
FINANCIALTRANSACTIONATTACHMENTTYPECODE	Stores translations of financial transaction attachment types.
FINANCIALTRANSACTIONLINEITEM	The table that contains a
FINANCIALTRANSACTIONLINEITEMADJUSTMENT
FINANCIALTRANSACTIONMEDIALINK	This table contains media links belonging to financial transactions.
FINANCIALTRANSACTIONMEDIALINKTYPECODE	Stores translations of financial transaction media link types.
FINANCIALTRANSACTIONNOTE	Stores financial transaction notes.
FINANCIALTRANSACTIONNOTETYPECODE	Stores translations of financial transaction note types.
FINANCIALTRANSACTIONSCHEDULE	Separates the balance of a transaction onto multiple due dates
FIRSTNAMEMATCH
FIRSTNAMES	Used to help determine gender code by first name
FLAGGEDPROSPECT	Contains flagged prospects and the user who they are flagged for.
FormDisplayForms
FUNCTIONALAREACATALOG	A Functional Area is a branding or categorizing of a suite of features within the system.
FUNDINGPLAN	Each funding plan in the system is represented by a row in the Funding Plan table.
FUNDINGPLANATTACHMENT	This table contains attachments belonging to funding plan.
FUNDINGPLANATTACHMENTTYPECODE	Stores translations of funding plan attachment types.
FUNDINGPLANDEPARTMENTCODE	The funding plan department.
FUNDINGPLANMEDIALINK	This table contains notes belonging to funding plan.
FUNDINGPLANMEDIALINKTYPECODE	Stores translations of funding plan media link types.
FUNDINGPLANNOTE	This table contains notes belonging to funding plan.
FUNDINGPLANNOTETYPECODE	Stores translations of funding plan note types.
FUNDINGPLANPROGRAMCODE	The funding plan program.
FUNDINGREQATTACHMENTTYPECODE	Stores translations of funding request attachment types.
FUNDINGREQMEDIALINKTYPECODE	Stores translations of funding request media link types.
FUNDINGREQNOTETYPECODE	Stores translations of funding request note types.
FUNDINGREQUEST	Each funding request for a funding purpose is represented by a row in the Funding Request table.
FUNDINGREQUESTATTACHMENT	This table contains attachments belonging to funding request.
FUNDINGREQUESTDESIGNATION	Contains a list of designations associated to a funding request.
FUNDINGREQUESTMEDIALINK	This table contains notes belonging to funding request.
FUNDINGREQUESTNOTE	This table contains notes belonging to funding request.
FUNDINGREQUESTOUTLINE	Each funding request outline is represented by a row in the funding request outline table.
FUNDINGREQUESTOUTLINESTEP	Each funding request outline step is represented by a row in the funding request outline step table.
FUNDINGREQUESTROLECODE	The funding request's participant's role.
FUNDINGREQUESTSPONSOR	A funding request sponsor is represented by a row in the funding request sponsor table.
FUNDINGREQUESTSTAGECODE	Stores translations of funding request stages
FUNDINGREQUESTSTATUSCODE	The funding request's status.
FUNDINGREQUESTTYPECODE	Stores translations of funding request types
FUNDINGTYPECODE	The funding type code table.
FUNDRAISERDATERANGE	Contains the date ranges for which constituents are fundraisers.
FundRaiserDonations
FundraiserEmail
FundRaiserEventRegistrations
FundRaiserPages
FundRaisers
FundraiserSolicitorContact
FundraiserSolicitorContactAction
FundraiserSolicitorEmail
FundRaiserSolicitors
FundRaiserTeams
FUZZYDATE	This table stores fuzzy dates for financial date fields.
GENDERCODE
GENDERCODEDEFAULTMAPPING
GENERATEBACSFILEPROCESS	Contains information pertaining to the generate BACS file process.
GENERATEBACSFILEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GENERATEBACSFILEPROCESS table.
GENERATEBATCHPROCESS	This table contains information pertaining to the generate batch business process.
GENERATEBATCHPROCESSCUB
GENERATEBATCHPROCESSCUBSTATUS
GENERATEBATCHPROCESSOVERWRITE	This table contains the overwrite values of a generate batch business process.
GENERATEBATCHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GENERATEBATCHPROCESS table.
GENERATEEFTFILEPROCESS	Contains information pertaining to the generate direct debit file business process.
GENERATEEFTFILEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GENERATEEFTFILEPROCESS table.
GENERATESTEPUPDATEBATCHPROCESS	This table contains information pertaining to the generate step batch business process.
GENERATESTEPUPDATEBATCHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GENERATESTEPUPDATEBATCHPROCESS table.
GENERATETRANSACTIONSPROCESS	Contains parameter information for the Generate Payments business process.
GENERATETRANSACTIONSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GENERATETRANSACTIONSPROCESS table.
GenericData
GIFTAIDDISQUALIFIEDBYAPPEAL	This table list all appeals that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYATTRIBUTE	This table list all attributes that are disqualified for Gift Aid.
GIFTAIDDISQUALIFIEDBYCAMPAIGN	This table list all campaigns that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE	This table list all credit card types that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYDESIGNATION	This table list all designations that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYEVENT	This table list all events that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYMEMBERSHIPPROGRAM	This table list all membership programs that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYOTHERPAYMENTTYPE	This table list all other payment types that are disqualified for Gift Aid.
GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD	This table list all payment methods that are disqualified for gift aid.
GIFTAIDDISQUALIFIEDBYREVENUECATEGORY	This table list all revenue categories that are disqualified for Gift Aid.
GIFTAIDGLDISTRIBUTIONTEMP	Table to store gift aid GL distributions.
GIFTAIDREFRESHPROCESS
GIFTAIDREFRESHPROCESSSTATUS
GIFTAIDTAXRATE	stores effective tax rates by date.
GIFTFEEADJUSTMENT	Stores adjustments made to posted gift fees.
GIFTFEEAPPLICATIONTYPE	This table contains application types processed for gift fees
GIFTFEECONSTITUENCY	This table contains excluded constituencies for gift fees
GIFTFEEGLDISTRIBUTIONTEMP	Table to store the GL distribution of gift fees entered by user to override the system-generated distribution. For other gift fee records this table will store the system-generated entries after post.
GIFTFEEOPTION	This table contains options for gift fees
GIFTFEEOVERRIDEREASONCODE	This table contains options for gift fees
GIFTFEEPAYMENTMETHOD	This table contains payment methods that are excluded from gift fees
GIFTFEESTRUCTURE	This table contains fee structures for gift fees
GIFTINKINDAPPRAISAL	Stores appraisals of gift-in-kind payments.
GIFTINKINDAPPRAISALSETTINGS	Stores the settings for gift-in-kind appraisals.
GIFTINKINDPAYMENTMETHODDETAIL	Stores gift in kind detail information for a revenue record when the payment method is gift in kind.
GIFTINKINDSALE_EXT
GIFTINKINDSALEADJUSTMENT	Stores details about a gift-in-kind sale.
GIFTINKINDSALEGLDISTRIBUTIONTEMP	Table to store the GL distribution of sold gift-in-kind entered by user to override the system-generated distribution. For other sold gift-in-kind records this table will store the system-generated entries after post.
GIFTINKINDSALETEMP	Stores details about a gift-in-kind sale.
GIFTINKINDSUBTYPECODE	Gift-in-kind Subtypes
GivingHistory
GivingHistory2
GivingHistorySchemaFields
GivingHistoryUsedFields
GIVINGLEVELPROGRAM	This table contains information about giving level programs.
GIVINGLEVELPROGRAMLEVEL	This table contains info about giving level program levels.
GIVINGLEVELPROGRAMSITE	This table contains info about sites for a giving level program.
GIVINGLISTMODE
GIVINGLISTSUMMARYCURRENCYTYPESETTING
GIVINGLISTSUMMARYSETTINGS
GIVINGLISTSUMMARYTRANSACTIONTYPEFILTER
GLACCOUNT	Account information
GLACCOUNTALIAS
GLACCOUNTBATCH	Table used for account batch entry.
GLACCOUNTBATCHBATCHSYSTEMMESSAGES
GLACCOUNTBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the GLACCOUNTBATCH batch table
GLACCOUNTCODEATTACHMENT	This table contains attachments belonging to account code.
GLACCOUNTCODEMEDIALINK	This table contains notes belonging to account code.
GLACCOUNTCODENOTE	This table contains notes belonging to account code.
GLACCOUNTMAPPINGERROR	Log file for errors generated for default account mapping
GLACCOUNTMAPPINGERRORUPDATEPROCESS	List of errors that will be fixed by the update process
GLACCOUNTMAPPINGERRORUPDATEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GLACCOUNTMAPPINGERRORUPDATEPROCESS table.
GLACCOUNTTYPEMAPPING	Provides a mapping between different account types and GL codes.
GLBATCH	Stores information pertaining to GL batches.
GLDEPARTMENT	Stores information pertaining to a GL department.
GLFISCALPERIOD	General ledger fiscal period table
GLFISCALYEAR	General ledger fiscal year table
GLOBALCHANGE	Contains data describing global change instances.
GLOBALCHANGECATALOG	Contains GlobalChangeSpec definitions.
GLOBALCHANGERECORDCOUNT	Stores information about a specific global change run.
GLOBALCHANGESTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GLOBALCHANGE table.
GLOBALDUPLICATESEARCHSETTINGS	Stores global duplicate search settings.
GLOBALRELATIONSHIPSETTINGS
GLPAYMENTMETHODREVENUETYPEMAPPING	Stores mapping of Payment Methods and/or Revenue Type to Account Types (defined in GLAccountTypeMapping)
GLPOSTPROCESS	Post parameter file for Financial Transaction Model posting
GLPOSTPROCESSPOSTMETHOD	Defines how (detail or summary) transactions will be posted to GL.
GLPOSTPROCESSPOSTMETHODTRANSLATION	Summarizes post methods for display on the generic GL post page.
GLPOSTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the GLPOSTPROCESS table.
GLPOSTPROCESSTRANSACTIONCRITERIA	Selection criteria for FTM Posting Processes
GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION	Summarizes transaction criteria for display on the generic GL post page.
GLPREFERENCEINFO	Stores information pertaining to GL preferences.
GLREVENUECATEGORYMAPPING	Provides a mapping between different revenue categories and GL codes.
GLREVERSAL	Stores schedule details for a revenue detail record.
GLTRANSACTIONTEMP	Stores information pertaining to GL transactions.
GRADEBOOKSPECIALCHARACTER	Table of special characters used for grading assignments in gradebook.
GRADELEVEL	Describes the grade levels used throughout the system for tracking education information.
GRADINGAPPUSERSESSION	This table contains information about the current academic grading session for a specified user.
GRADINGSCALE	Table of grading scales used for grading assignments in gradebook.
GRADINGSCALEGRADE	The grades and numeric equivalents of a grading scale.
GRANTDEADLINE	Each grant deadline in the system is represented by row in the Grant Deadline table.
GRANTFUNDINGTYPE	Contains a list of funding types for a given grant.
GRANTOR	Contains the date ranges for which a constituent is a grantor.
GRANTORTYPECODE	The grantor type.
GRANTS	Each grant in the system is represented by a row in the Grant table.
GROUPDATA	This table contains data that is specific to group constituents.
GROUPGOAL	Group goals and their attributes
GROUPGOALUNITCODE	The unit (or type) of goal that may be assigned to groups and committees
GROUPMEMBER	This table track which constituents are members in which groups.
GROUPMEMBERDATERANGE	This table stores the date ranges for which constituents are members of groups.
GROUPMEMBERROLE	Role information for a group member
GROUPMEMBERROLECODE	Roles that may be assigned to members of groups
GROUPSALESCAPACITYSETUP	Group sales capacity setup information.
GROUPSALESDEFAULT	This table contains group sales setup defaults.
GROUPSALESGROUPTYPECODE	Stores a list of the group sales group types that are used for setting up itineraries.
GROUPSALESPAYMENTDEFAULT	Default values for deposit and final payment dates on reservations.
GROUPSIZEDISCOUNT	Stores group size information for a given discount
GROUPTYPE	This table contains custom constituent group type records.
GROUPTYPEREQUIREDRESOURCE	Provides a way to select the required resources and resource quantities for a group type.
GROUPTYPEREQUIREDSTAFFRESOURCE	Provides a way to select the required staffing resources and staffing resource quantities for a group type.
HOLD	Connects a hold code to a hold list
HOLDCODE	Hold Code to be used for a Hold List
HOLDLIST	Contains information for a hold list.
HOUSEHOLDINCOMEESTIMATECODE
HOUSEHOLDINFO	This table contains system configuration options for households.
HOUSEHOLDRECOGNITIONSETTINGS	Stores recognition settings for a household.
HTMLTEMPLATEMERGETODOCXOUTPUT	Contains the results of successful Html Template to Docx Merge processes, tied to process status instances.
HTMLTEMPLATETODOCXMERGEPROCESS	Parameter table for the Html Template To Docx Merge Process
HTMLTEMPLATETODOCXMERGEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the HTMLTEMPLATETODOCXMERGEPROCESS table.
HTMLWhiteList
IATSACCOUNT	Stores merchant account information for Ticketmaster's IATS service.
IBANREGISTRY
IDMAPPERCATALOG
IDSETREGISTER	Each row in the IDSetRegister table corresponds to a view or table-valued function that returns a list of IDs and a sequence. The table is primarily populated through query.
IDSETREGISTERADHOCQUERY
IDSETREGISTERDYNAMICIDSET	Maps a static selection to a backing dynamic selection
IDSETREGISTERMERGE	Stores information about merged selections.
IDSETREGISTERSMARTQUERYINSTANCE
ImageAlbum
ImageAlbum_Images
IMAGEALBUMEXTENSION	Image Album Extension
IMPORTENCRYPTIONKEY	Stores encryption keys for import files.
IMPORTFILETEMPLATE
IMPORTFIXEDWIDTHFILETEMPLATE
IMPORTPROCESS	Contains information for the import business process.
IMPORTPROCESSBATCH	Contains the batch ID created by an import process
IMPORTPROCESSEXCEPTION	Contains a list of exceptions that occurred during the execution of an import process.
IMPORTPROCESSOPTIONS	Contains the import file path along with the username and password needed to access the path.
IMPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the IMPORTPROCESS table.
IMPORTSELECTIONPROCESS	Stores information for the import selection process.
IMPORTSELECTIONPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the IMPORTSELECTIONPROCESS table.
IMPORTSELECTIONPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the IMPORTSELECTIONPROCESS table.
IMPORTSOURCE
INCOMECODE	This code table stores translations of income codes.
IncompatibleContentTypes
INDIVIDUALINFO	This table contains system configuration options for individuals.
INDUSTRYCODE	This code table stores translations of industry codes.
INFOSOURCECODE	This code table stores translations of address info source codes.
INSTALLATIONINFO	The INSTALLATIONINFO table stores configuration details. There is only 1 row in this table and its ID is 1.
INSTALLEDPRODUCTLIST
INSTALLMENT	Stores installment information for each pledge, MG pledge, or recurring gift.
INSTALLMENTSPLIT	Contains installment split information for a given pledge installment record.
INSTALLMENTSPLITPAYMENT	Contains installment split payment information for a given pledge payment record.
INSTALLMENTSPLITWRITEOFF	Contains installment split writeoff information for a given pledge writeoff record.
INTERACTION	Contains data about prospect interactions.
INTERACTIONADDITIONALFUNDRAISER	Holds additional fundraisers for an interaction.
INTERACTIONATTACHMENT	This table contains attachments belonging to interactions.
INTERACTIONATTACHMENTTYPECODE	Stores translations of interaction attachment types.
INTERACTIONCATEGORY	Contains prospect interaction categories.
INTERACTIONMEDIALINK	This table contains media links belonging to constituents.
INTERACTIONMEDIALINKTYPECODE	Stores translations of interaction media link types.
INTERACTIONNOTE	Contains notes for interactions.
INTERACTIONNOTETYPECODE	Stores translations of interaction note types.
INTERACTIONPARTICIPANT	Holds interaction participants.
INTERACTIONRESPONSE	Associates interactions with interaction responses.
INTERACTIONSITE	Expresses interaction/site relationships. Only used for interactions that are not prospect plan steps.
INTERACTIONSUBCATEGORY	Contains interaction subcategories.
INTERACTIONTYPECODE	Stores translations of interaction types
INTERNATIONALIZATIONINFO	Contains internationalization settings.
INVITATION	Contains information pertaining to invitations sent for events.
INVITATIONEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the INVITATION table.
INVITATIONHISTORY	Contains history information pertaining to invitations already sent for events.
INVITATIONSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the INVITATION table.
INVITEE	Contains information pertaining to constituents invited to events.
INVITEEHISTORY	Contains information pertaining to constituents that were sent invitations to events.
INVITEERESEND	Contains invitees that need an invitation to be resent.
INVOICE	Defines invoices.
INVOICESCHEDULEINFORMATION	Invoice Schedule Information
IRSFORM1099MISCPROCESSTEMPLATE	Templates to create form 1099 MISC processes
IRSFORM1099MISCPROCESSTEMPLATEEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the IRSFORM1099MISCPROCESSTEMPLATE table.
IRSFORM1099MISCPROCESSTEMPLATESTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the IRSFORM1099MISCPROCESSTEMPLATE table.
ITINERARY	An itinerary that exists in a reservation.
ITINERARYATTENDEE	An attendee belonging to an itinerary on a reservation.
ITINERARYITEM	This table contains information for an itinerary item.
ITINERARYITEMLOCATION	This table contains information for a location on an itinerary custom item.
ITINERARYITEMRESOURCE	Contains the resources and quantity of those resources used for an itinerary item.
ITINERARYITEMSTAFFRESOURCE	Describes the staff resources used by the itinerary item.
ITINERARYITEMSTAFFRESOURCEASSIGNMENT	Assigns board members or staff to a itinerary item staff resources.
ITINERARYRESOURCE	Lists the resources used by an itinerary.
ITINERARYSTAFFRESOURCE	Describes the staff resources used by the itinerary.
ITINERARYSTAFFRESOURCEASSIGNMENT	Gives the staff or board members associated with a given itinerary staff resource.
JOB	Stores information pertaining to a job to be performed by volunteers.
JOBADMINISTRATIVE	Administrative information for a job.
JOBATTACHMENT	This table contains attachments belonging to jobs.
JOBATTACHMENTTYPECODE	Stores translations of volunteer attachment types.
JobBoards
JOBCATEGORYCODE	Stores translations of job categories
JOBCERTIFICATION	Certifications for a Job.
JOBCOURSE	Courses for a job.
JOBINTEREST	Interests for a job.
JOBLICENSE	Licenses for a job.
JOBMEDIALINK	This table contains media links belonging to jobs.
JOBMEDIALINKTYPECODE	Stores translations of constituent media link types.
JOBMEDICAL	Medical information for a job.
JOBNOTE	This table contains notes belonging to jobs.
JOBNOTETYPECODE	Stores translations of job note types.
JOBOCCURRENCE	Stores information pertaining to an occurrence of a job.
JobPosts
JOBSCHEDULECODE	Stores translations of job schedules.
JOBSKILL	Skills and levels for a job.
JOBSPECIALNEED	Special Needs for a Job.
JOURNALCODE	Stores translations of transaction journals.
JOURNALENTRY	Contains journal entries.
JOURNALENTRY_EXT
JOURNALENTRYANNOTATION	Contains journal entry annotations.
JOURNALENTRYBATCH	Stores Journal Entry batch information.
Kpi
KPICATALOG	Contains various KPI (key progress indicator) specs.
KPIDASHBOARDPAGE	Contains a list of pages for a user's KPI dashboard.
KPIDASHBOARDPAGETAB	Contains a list of tabs a user has created for his customized KPI dashboard.
KPIDASHBOARDPAGETABKPIINSTANCE	Contains a list of KPI instances for a tab on a user's KPI dashboard.
KPIINSTANCE	Contains KPI goal, trigger, and alert settings for various KPIs.
KPIINSTANCEFOLDER
KPIINSTANCEHISTORY	Contains a history of KPI instance values.
KPIINSTANCEMILESTONE	Contains a list of values and dates which represent milestones on the way toward reaching the ultimate goal.
KPIINSTANCESITE	Stores the selected sites for a KPI instance.
KPIINSTANCESTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the KPIINSTANCE table.
KPIINSTANCESTATUSHISTORY	Contains a history of the values and the threshold values for a given KPI instance.
LANGUAGE_RESOURCES	Holds culture-specific text values used throughout BBNC
LANGUAGE_RESOURCES_OVERRIDES	Holds custom values for text values in BBNC
LanguageGuid
LEDGERACCOUNT	Contains account information for general ledger accounts.
LEDGERACCOUNTATTACHMENT	This table contains attachments belonging to ledger account.
LEDGERACCOUNTMEDIALINK	This table contains notes belonging to ledger account.
LEDGERACCOUNTMEDIALINKTYPECODE	Stores translations of ledger account media link types.
LEDGERACCOUNTNOTE	This table contains notes belonging to ledger account.
LEDGERACCOUNTNOTETYPECODE	Stores translations of ledger account note types.
LEDGERACCOUNTWORKFLOWSTAGECODE	Contains workflow stages for ledger accounts.
LEDGERPREFERENCE	This table stores configuration preferences for the ledger.
LETTERCODE	Stores information pertaining to acknowledgement letters.
LETTERCODESITE	Information regarding the sites associated with a revenue letter.
LETTERTEMPLATE	Stores letter templates and their output format settings in the system .
LIFECYCLETYPE	Stores life cycle type information
LIKELIHOODPERCENT	Maps likelihood type codes to numerical percentages.
LIKELIHOODTYPECODE	Code table for likelihood an opportunity will result in a gift.
LISTBUILDERINSTANCE
LISTSORTMETHOD	Contains the sort method for various lists like code tables, states, countries, funds, etc.
LOADSPECLOG
LOCALCORP	Contains the zip code to merchant account mappings
LOCALE	This table contains information about Microsoft Windows locales.
LOCALPRECINCTCODE	This code table stores the translations of local precincts.
LOCKBOX	Contains information pertaining to lockboxes.
LUMINATEONLINEDATACONNECTOR
LUMINATEONLINEDATACONNECTOREXCEPTION
LUMINATEONLINEDATACONNECTORPARAMETERSET
LUMINATEONLINEDATACONNECTORPARAMETERSETSTATUS
LUMINATEONLINEDATACONNECTORSETTINGS
MACINDEXKEY	The MACINDEXKEY table stores a unique Message Authentication Code for each table that contains a searchable encrypted field.
MAILPREFERENCE	Describes mailing preference settings for constituents.
MAILPREFERENCEGROUPCONTACT	Defines which constituent group members a mail preference applies to.
MAILPREFERENCEORGCONTACTTYPE	Maps Mail Preferences to Contact Types.
MAJORGIVINGCAPACITY	Contains major giving capacity ranges.
MAJORGIVINGCONFIGURATION	Contains configuration info for use in the major giving functional area.
MAPCATEGORYCODE	Represents the various categories to which a saved map instance may belong.
MAPDISTANCEUNIT	Stores the unit of distance used by mapping for this system.
MAPENTITYCATALOG	Contains MapEntitySpec definitions.
MAPINSTANCE	Contains an XML definition of the state of a map at the time it was saved.
MAPPINGCREDENTIALS	Contains the credentials for the mapping web service.
MARITALSTATUSCODE	This code table stores translations of marital status codes.
MARKETINGSURVEYANSWER	Answers to survey questions.
MARKETINGSURVEYQUESTION	Marketing survey questions.
MARKINGCOLUMN	This table contains information about a marking column.
MARKINGCOLUMNDESCRIPTIONCODE	Description for a marking column.
MARKINGCOLUMNSET	This table contains sets of marking columns.
MARKINGCOLUMNTERM	This table contains terms which are associated with marking columns.
MARRIAGEADDITIONALRELATIONSHIP	Marriage additional relationships
MARRIAGEADDITIONALRELATIONSHIPASSOCIATION	Marriage additional relationship Associations
MARRIAGEOPTION	Contains system marriage options.
MARRIAGERELATIONSHIP	Marriage relationships
MARRIAGERELATIONSHIPASSOCIATION	Marriage relationship Associations
MARRIAGERULE	Contains global marriage rules.
MATCHCODE	Contains all Wealth Match Codes.
MATCHFINDERCONFIGURATION	Stores configuration information for integrating with the MatchFinder Online service.
MATCHFINDERCONSTITUENT	Links a MatchFinder Online record to a constituent.
MATCHINGGIFTCONDITION	This table contains an organization's conditions for matching gifts.
MATCHINGGIFTCONDITIONRELATIONSHIP	This table contains relationship mappings to an organization's conditions for matching gifts.
MATCHINGGIFTCONDITIONTYPECODE	This code table stores translations of matching gift type codes.
MATCHINGGIFTPREFERENCEINFO	Stores information pertaining to matching gift preferences.
MEMBER	Stores member information for a membership
MEMBERATTACHMENT	This table contains attachments belonging to member.
MEMBERATTACHMENTTYPECODE	Stores translations of member attachment types.
MEMBERMEDIALINK	This table contains notes belonging to member.
MEMBERMEDIALINKTYPECODE	Stores translations of member media link types.
MEMBERNOTE	This table contains notes belonging to member.
MEMBERNOTETYPECODE	Stores translations of member note types.
MEMBERSHIP	Stores membership records.
MEMBERSHIPADDON
MEMBERSHIPCANCELLATIONCODE
MEMBERSHIPCARD	Stores membership card data for members.
MEMBERSHIPCARDFORMAT	Stores the various membership card formats.
MEMBERSHIPCONTRIBUTIONPORTION
MEMBERSHIPEXPRESSPARTSETTINGS	Stores Membership Express part settings.
MEMBERSHIPGLMAPPING	Stores the GL mapping for membership.
MEMBERSHIPINSTALLMENTPLANORIGINALAMOUNT
MEMBERSHIPLEVEL	This table stores information related to a membership program level.
MEMBERSHIPLEVEL_MICROSITEEMAILTEMPLATE
MEMBERSHIPLEVELBENEFIT	Stores benefits for a membership level.
MEMBERSHIPLEVELCAMPAIGN	Associates membership program levels with campaigns
MEMBERSHIPLEVELCONTRIBUTION
MEMBERSHIPLEVELCONTRIBUTIONEXPIRATIONDATERANGE
MEMBERSHIPLEVELDESIGNATION
MEMBERSHIPLEVELRENEWAL
MEMBERSHIPLEVELRENEWALRULES	Stores historical data of membership level renewal rules.
MEMBERSHIPLEVELTERM	This table holds the terms for a specific membership level.
MEMBERSHIPLEVELTYPE	This table holds the membership types for a specific membership level.
MEMBERSHIPLEVELTYPECODE	Stores translation of membership types.
MEMBERSHIPPROGRAM	Stores data pertaining to membership programs.
MEMBERSHIPPROGRAM_MICROSITEEMAILTEMPLATE
MEMBERSHIPPROGRAMADDON
MEMBERSHIPPROGRAMCAMPAIGN	Associates membership programs with campaigns
MEMBERSHIPPROGRAMCONTRIBUTION
MEMBERSHIPPROGRAMCONTRIBUTIONEXPIRATIONDATERANGE
MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
MEMBERSHIPPROGRAMCONTRIBUTIONPROCESSSTATUS
MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE
MEMBERSHIPPROGRAMDESIGNATION
MEMBERSHIPPROGRAMENDDATE	The expiration dates for a membership program.
MEMBERSHIPPROGRAMRENEWAL
MEMBERSHIPPROMO	Provides a way for organizations to extend terms of or reduce prices of memberships
MEMBERSHIPPROMOAVAILABILITY
MEMBERSHIPPROMOCODE	Promotion codes for membership promotions
MEMBERSHIPTRANSACTION	Stores transaction records that occur for a membership.
MembershipTransactions
MenuItems
MERCHANDISEADJUSTMENTREASONCODE
MERCHANDISEDEPARTMENT	A department to which specific merchandise items belong.
MERCHANDISEDEPARTMENTCATEGORY	A category within a department to which specific merchandise items belong.
MERCHANDISEPRODUCT	A retail item for which instances can be sold.
MERCHANDISEPRODUCTATTACHMENT	Represents an item attachment and it's metadata.
MERCHANDISEPRODUCTATTACHMENTTYPECODE	Stores merchandise attachment types.
MERCHANDISEPRODUCTINSTANCE	An actual instance of an item which can be sold.
MERCHANDISEPRODUCTINSTANCEHISTORY
MERCHANDISEPRODUCTINSTANCELOOKUPCODE
MERCHANDISEPRODUCTINSTANCEOPTIONVALUE	Holds the merchandise item option values for a product instance.
MERCHANDISEPRODUCTINSTANCEVENDOR
MERCHANDISEPRODUCTLABLEPRINTHISTORY	Holds the history for inventory item label printing.
MERCHANDISEPRODUCTMEDIALINK	Represents a merchandise item media link and it's metadata.
MERCHANDISEPRODUCTMEDIALINKTYPECODE	Stores merchandise media link types.
MERCHANDISEPRODUCTNOTE	Represents a merchandise item note and it's metadata.
MERCHANDISEPRODUCTNOTETYPECODE	Stores merchandise item note types.
MERCHANDISEPRODUCTOPTION	Holds the option groups for a merchandise item.
MERCHANDISEPRODUCTOPTIONVALUE	Holds the available values for a merchandise item option
MERCHANDISEPRODUCTSALESMETHOD	A mapping table between sales method and merchandise item record types.
MERCHANTACCOUNT	Stores merchant account details.
MERCHANTACCOUNTSITE	Contains information pertaining to a merchant account's sites.
MERGECONFIGURATION	Contains the definitions for merge configurations.
MERGETASKCATALOG	Contains merge task specs
Message
MESSAGEFAILUREREASON	Message failure reason
MessageFolder
MESSAGEQUEUE	A table to support app communications via message queue
MICROSITECONTENT	Part content data for Microsite header and footer parts.
MICROSITEMEMBERSHIPLEVEL	Membership levels that are available through web forms.
MICROSITEPAGE	Roster of pages generated by microsite.
MICROSITESETTING	Microsite Settings Table
MISCELLANEOUSPAYMENT	All miscellaneous payment records.
MKTACKNOWLEDGEMENTMAILINGPROCESS	Contains information pertaining to the marketing acknowledgement business process.
MKTACKNOWLEDGEMENTMAILINGPROCESSSEGMENTATION	Contains information pertaining to the marketing acknowledgement created for each marketing acknowledgement business process status.
MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTACKNOWLEDGEMENTMAILINGPROCESS table.
MKTACKNOWLEDGEMENTMAILINGTEMPLATE	Stores information pertaining to a marketing acknowledgement template.
MKTACKNOWLEDGEMENTMAILINGTEMPLATEAPPEAL	Stores appeals associated with a marketing acknowledgement template.
MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE	Stores a list of ask ladder overrides.
MKTACKNOWLEDGEMENTMAILINGTEMPLATEEMAILOPTIONS	Stores email information pertaining to an acknowledgement template.
MKTACKNOWLEDGEMENTMAILINGTEMPLATEEXPORT	Stores export information pertaining to an acknowledgement template.
MKTACKNOWLEDGEMENTMAILINGTEMPLATEFILTERSELECTION	Stores information pertaining to the selections in marketing acknowledgement template's universe and its exclusion filters.
MKTACKNOWLEDGEMENTMAILINGTEMPLATEKPI	Stores information pertaining to acknowledgement mailing KPIs to create when creating an marketing acknowledgement template.
MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE	Stores information pertaining to a marketing acknowledgement template rule.
MKTACKNOWLEDGEMENTMAILINGTEMPLATESEED	Stores the seeds for a marketing acknowledgement template.
MKTAPPEALRECORDSOURCE	Stores information pertaining to a person record source's appeal record source.
MKTASKLADDER	Stores information pertaining to an ask ladder.
MKTASKLADDERITEM	Stores the value information for an ask ladder.
MKTATTACHMENTTYPECODE	Stores translations of attachment types.
MKTCOMMUNICATIONEFFORTUSERSETTINGS
MKTCOMMUNICATIONNAMESCHEME
MKTCOMMUNICATIONNAMESCHEMEEXAMPLE
MKTCOMMUNICATIONNAMESCHEMEPART
MKTCOMMUNICATIONTEMPLATE
MKTCOMMUNICATIONTEMPLATEDEFAULT
MKTCOMMUNICATIONTEMPLATEDEFAULTAPPEAL
MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE
MKTCOMMUNICATIONTEMPLATEDEFAULTBUSINESSUNIT
MKTCOMMUNICATIONTEMPLATEDEFAULTFILTERSELECTION
MKTCOMMUNICATIONTEMPLATEDEFAULTKPI
MKTCOMMUNICATIONTEMPLATEDEFAULTSEED
MKTCOMMUNICATIONTEMPLATEDEFAULTSOLICITCODES
MKTCOMMUNICATIONTEMPLATEEXAMPLE
MKTCONSOLIDATEDQUERYVIEWSPEC	Stores information pertaining to consolidated query view spec for a given query view.
MKTCONSTITUENTFILECATEGORYCODE	Stores translations of segmented house file categories.
MKTCONSTITUENTFILEIMPORTPROCESS	Stores information pertaining to a segmented house file import.
MKTCONSTITUENTFILEIMPORTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTCONSTITUENTFILEIMPORTPROCESS table.
MKTCONSTITUENTFILEIMPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTCONSTITUENTFILEIMPORTPROCESS table.
MKTCREATIVE	Stores information pertaining to a creative.
MKTCREATIVEATTACHMENT	Stores attachments pertaining to a creative.
MKTCREATIVETYPECODE	Stores translations of creative types.
MKTDOCUMENT	Stores information pertaining to a marketing document.
MKTDOCUMENTTYPECODE	Stores translations of marketing document types.
MKTDUPLICATE	Contains information used to identify duplicate records.
MKTDUPLICATEFIELD	Contains the information used to identify duplicate records.
MKTEXPENSE	Stores information pertaining to a marketing expense.
MKTEXPENSECATEGORYCODE	Stores translations of marketing plan expense categories.
MKTEXPENSETYPECODE	Stores translations of marketing expense types.
MKTEXPORTDEFINITION	Stores information pertaining to an export definition.
MKTEXPORTDEFINITIONOUTPUTFIELD	Stores information pertaining to an export definition output field.
MKTFINDERFILECATEGORYCODE	Stores translations of finder file categories.
MKTFINDERFILEIMPORTPROCESS	Stores information pertaining to a find file.
MKTFINDERFILEIMPORTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTFINDERFILEIMPORTPROCESS table.
MKTFINDERFILEIMPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTFINDERFILEIMPORTPROCESS table.
MKTFINDERNUMBER	Contains information about the current finder number definition. The finder number is the unique number assigned to each record in an activated marketing effort.
MKTFINDERNUMBERCONSTITUENT	Stores data for constituents added by a finder number.
MKTFINDERNUMBERCONSTITUENTAPPEAL	Stores information relating appeal and acquisition list member records with finder numbers.
MKTFINDERNUMBERCONSTITUENTSITE
MKTGIFTRECORDSOURCE	Stores information pertaining to a person record source's gift record source.
MKTGROUPSEGMENTS	Stores information pertaining to a segment/group relationship.
MKTLIST	Contains information about acquisition lists.
MKTLISTCATEGORYCODE	Stores translations of acquisition list categories.
MKTLISTLAYOUT	Contains information about each list layout.
MKTLISTLAYOUTFIELD	Contains the definition of each field in a file layout.
MKTMAILINGPREACTIVATIONPROCESS	Stores the marketing efforts that are valid for the Marketing Effort Record Count business process.
MKTMAILINGPREACTIVATIONPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTMAILINGPREACTIVATIONPROCESS table.
MKTMAILINGPREACTIVATIONPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTMAILINGPREACTIVATIONPROCESS table.
MKTMARKETINGPLAN	Stores information pertaining to the overall marketing plan.
MKTMARKETINGPLANBRIEF	Stores the marketing plan segment summary information.
MKTMARKETINGPLANINCOMEFORECASTPREFERENCES	Stores preferences for viewing the plan income forecast report.
MKTMARKETINGPLANITEM	Stores information pertaining to an instance of a level in a marketing plan.
MKTMARKETINGPLANITEMATTACHMENT	Stores attachments pertaining to a marketing plan item.
MKTMARKETINGPLANITEMEXPENSE	Stores information pertaining to an instance of a level in a marketing plan.
MKTMARKETINGPLANITEMSPEC	Stores specification information for a marketing plan.
MKTMARKETINGPLANITEMTASK	Stores tasks required for a particular plan item.
MKTMARKETINGPLANITEMTEMPLATEITEM	Stores attributes of a marketing plan layout; copied from the Template table when a plan is created.
MKTMARKETINGPLANTEMPLATE	Stores information pertaining to a marketing plan template, which defines roll-up levels and level names.
MKTMARKETINGPLANTEMPLATEITEM	Stores attributes of a marketing plan template.
MKTMATERIAL	Stores information pertaining to a marketing material.
MKTMATERIALTYPECODE	Stores translations of marketing material types.
MKTMEMBERSHIPMAILINGACTIVE	Stores information pertaining to an activated membership renewal effort.
MKTMEMBERSHIPMAILINGPROCESS	Contains information pertaining to the membership renewal effort business process.
MKTMEMBERSHIPMAILINGPROCESSSEGMENTATION	Contains information pertaining to the effort created for each membership renewal effort business process status.
MKTMEMBERSHIPMAILINGPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTMEMBERSHIPMAILINGPROCESS table.
MKTMEMBERSHIPMAILINGSEGMENTACTIVE	Stores information pertaining to an activated membership renewal effort segment.
MKTMEMBERSHIPMAILINGTEMPLATE	Stores information pertaining to a membership renewal effort template.
MKTMEMBERSHIPMAILINGTEMPLATEAPPEAL	Stores appeals associated with membership renewal effort template.
MKTMEMBERSHIPMAILINGTEMPLATEASKLADDEROVERRIDE	Stores a list of the ask ladder overrides associated with a membership renewal effort template.
MKTMEMBERSHIPMAILINGTEMPLATEEXPORT	Stores export information pertaining to a membership template.
MKTMEMBERSHIPMAILINGTEMPLATEFILTERSELECTION	Stores information pertaining to the selections in a membership renewal effort template's universe and exclusion filters.
MKTMEMBERSHIPMAILINGTEMPLATEKPI	Stores information pertaining to membership mailing KPIs to create when creating a membership renewal effort template.
MKTMEMBERSHIPMAILINGTEMPLATERULE	Stores information pertaining to a membership renewal effort template rule.
MKTMEMBERSHIPMAILINGTEMPLATESEED	Stores the seeds for a membership renewal effort template.
MKTMEMBERSHIPRECORDSOURCE	Stores information pertaining to a donor record source's membership record source.
MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS	Stores information linking the instance of membership renewal effort process and mailing process.
MKTMEMBERSHIPRENEWALEFFORTPROCESS	Contains information pertaining to the membership renewal effort business process.
MKTMEMBERSHIPRENEWALEFFORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTMEMBERSHIPRENEWALEFFORTPROCESS table.
MKTPACKAGE	Stores information pertaining to package records.
MKTPACKAGECATEGORYCODE	This code table stores translations of package categories.
MKTPACKAGECREATIVE	Stores the link between a packages and its creatives.
MKTPACKAGEDOCUMENT	Stores the link between a packages and its documents.
MKTPACKAGEEXPENSE	Stores the link between a packages and its expenses.
MKTPACKAGEMATERIAL	Stores the link between a packages and their materials.
MKTPLANITEMCATEGORYCODE	Stores translations of marketing plan item categories.
MKTPLANITEMSPECCODE	Stores translations of marketing plan specification.
MKTPOSTALTEMPLATE	Stores information pertaining to a Satori postal template.
MKTPREACTIVATION	Stores relationship information between a given business process status record and a marketing effort.
MKTRECORDSOURCE	Stores information pertaining to marketing record sources.
MKTRECORDSOURCEFIELDMAPPINGS	Stores information pertaining to a person record source's field mappings.
MKTSEED	Stores information pertaining to a seed person.
MKTSEGMENT	Stores information pertaining to a segment.
MKTSEGMENTATION	Stores information pertaining to a marketing effort.
MKTSEGMENTATIONACTIVATE	Stores information pertaining to an activated marketing effort.
MKTSEGMENTATIONACTIVATEDEFAULTKPI	Stores information pertaining to the default KPIs to be created at activation for a marketing effort type.
MKTSEGMENTATIONACTIVATEEXPORTLINK	Stores a link between an activation status ID and an export status ID for rolling up output tables to an activation status.
MKTSEGMENTATIONACTIVATEKPI	Stores information pertaining to mailing KPIs to create when activating a marketing effort.
MKTSEGMENTATIONACTIVATEPROCESS	Stores information pertaining to all marketing efforts that are ready to be activated.
MKTSEGMENTATIONACTIVATEPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTSEGMENTATIONACTIVATEPROCESS table.
MKTSEGMENTATIONACTIVATEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONACTIVATEPROCESS table.
MKTSEGMENTATIONACTIVE	Stores information pertaining to an activated marketing effort.
MKTSEGMENTATIONASKLADDEROVERRIDE	Stores a list of ask ladder overrides.
MKTSEGMENTATIONBUDGET	Stores information pertaining to a marketing effort's budget.
MKTSEGMENTATIONBUSINESSUNIT	This table stores the business units associated with a marketing effort.
MKTSEGMENTATIONCOMPARETOEFFORTS
MKTSEGMENTATIONDAILYRESPONSE
MKTSEGMENTATIONEXCLUSION	Stores information pertaining to a remove member process.
MKTSEGMENTATIONEXCLUSIONSELECTION	Stores information pertaining to removed members selections.
MKTSEGMENTATIONEXCLUSIONSPROCESS	Stores information pertaining to a marketing effort exclusion parameter set.
MKTSEGMENTATIONEXCLUSIONSPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTSEGMENTATIONEXCLUSIONSPROCESS table.
MKTSEGMENTATIONEXCLUSIONSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONEXCLUSIONSPROCESS table.
MKTSEGMENTATIONEXPORTPROCESS	Stores information pertaining to a marketing effort export parameter set.
MKTSEGMENTATIONEXPORTPROCESS2	Stores information pertaining to a marketing effort export parameter set.
MKTSEGMENTATIONEXPORTPROCESS2EXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTSEGMENTATIONEXPORTPROCESS2 table.
MKTSEGMENTATIONEXPORTPROCESS2STATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONEXPORTPROCESS2 table.
MKTSEGMENTATIONEXPORTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTSEGMENTATIONEXPORTPROCESS table.
MKTSEGMENTATIONEXPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONEXPORTPROCESS table.
MKTSEGMENTATIONFILTERSEGMENTATION	Stores information pertaining to a marketing effort's previous marketing effort exclusion filters.
MKTSEGMENTATIONFILTERSELECTION	Stores information pertaining to the selections in a marketing effort's universe and its exclusion filters.
MKTSEGMENTATIONFINDERNUMBER	Stores information about finder numbers used in marketing efforts.
MKTSEGMENTATIONLISTACTIVE	Information about the lists in a marketing effort is cached here when the marketing effort is activated, and used to generate various reports.
MKTSEGMENTATIONMERGEDORIGINALCONSTITUENTS
MKTSEGMENTATIONPACKAGE	Stores information pertaining to a marketing effort's packages.
MKTSEGMENTATIONREFRESHPROCESS	Stores information pertaining to a marketing effort refresh parameter set.
MKTSEGMENTATIONREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONREFRESHPROCESS table.
MKTSEGMENTATIONSEED	Stores the seeds for a marketing effort.
MKTSEGMENTATIONSEGMENT	Stores information pertaining to a marketing effort segment.
MKTSEGMENTATIONSEGMENTACTIVE	Stores information pertaining to an activated marketing effort segment.
MKTSEGMENTATIONSEGMENTBUSINESSUNIT	This table stores the business units associated with a marketing effort segment.
MKTSEGMENTATIONSEGMENTCACHEINFO
MKTSEGMENTATIONSEGMENTCALCULATEPROCESS	Stores information pertaining to the calculation of record counts for a marketing effort's segments.
MKTSEGMENTATIONSEGMENTCALCULATEPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTSEGMENTATIONSEGMENTCALCULATEPROCESS table.
MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONSEGMENTCALCULATEPROCESS table.
MKTSEGMENTATIONSEGMENTLIST	Stores information pertaining to a marketing effort's list segments.
MKTSEGMENTATIONSEGMENTREFRESHPROCESS	Stores information pertaining to a marketing effort segment refresh parameter set.
MKTSEGMENTATIONSEGMENTREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTATIONSEGMENTREFRESHPROCESS table.
MKTSEGMENTATIONTESTSEGMENT	Stores information pertaining to a marketing effort test segment.
MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT	This table stores the business units associated with a marketing effort test segment.
MKTSEGMENTCATEGORYCODE	Stores translations of segment categories.
MKTSEGMENTGROUP	Stores information pertaining to a segment group.
MKTSEGMENTGROUPREFRESHPROCESS	Stores information pertaining to a segment group refresh parameter set.
MKTSEGMENTGROUPREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTGROUPREFRESHPROCESS table.
MKTSEGMENTLIST	This table contains segment information specific to list segments.
MKTSEGMENTLISTDATA
MKTSEGMENTLISTDEDUPEPROCESS	This table contains list segment deduplication process parameter sets.
MKTSEGMENTLISTDEDUPEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTLISTDEDUPEPROCESS table.
MKTSEGMENTLISTHISTORICAL	This table contains historical list and segment information about list segments.
MKTSEGMENTLISTIMPORTPROCESS	This table contains list segment import process parameter sets.
MKTSEGMENTLISTIMPORTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTSEGMENTLISTIMPORTPROCESS table.
MKTSEGMENTLISTIMPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTLISTIMPORTPROCESS table.
MKTSEGMENTPASSIVE	This table contains segment information specific to media outlets, time slots and marketing locations.
MKTSEGMENTREFRESHPROCESS	Stores information pertaining to a segment refresh parameter set.
MKTSEGMENTREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTREFRESHPROCESS table.
MKTSEGMENTSELECTION	Stores information pertaining to a segment's selections.
MKTSEGMENTSREFRESHPROCESS	Stores information pertaining to a segments refresh parameter set.
MKTSEGMENTSREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTSREFRESHPROCESS table.
MKTSEGMENTWHITEMAIL	Stores information pertaining to a white mail segment.
MKTSEGMENTWHITEMAILCACHE	Caches calculations pertaining to a white mail segment's performance.
MKTSEGMENTWHITEMAILREFRESHALLPROCESS	Stores information pertaining to the refresh all white mail segments parameter set.
MKTSEGMENTWHITEMAILREFRESHALLPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTWHITEMAILREFRESHALLPROCESS table.
MKTSEGMENTWHITEMAILREFRESHPROCESS	Stores information pertaining to a white mail segment refresh parameter set.
MKTSEGMENTWHITEMAILREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSEGMENTWHITEMAILREFRESHPROCESS table.
MKTSERVICE	Stores information about the services provided by vendors.
MKTSERVICECATEGORYCODE	Stores translations of vendor service categories.
MKTSOURCEANALYSISRULEFIELDS	List of the fields captured on a source analysis rule.
MKTSOURCEANALYSISRULES	Stores a source analysis rule for each record source.
MKTSOURCEANALYSISRULESSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSOURCEANALYSISRULES table.
MKTSOURCECODE	Stores information pertaining to a source code layout.
MKTSOURCECODEITEM	Stores information for an element in a source code format.
MKTSOURCECODEMAP	Stores all of the unique source codes for a given marketing effort.
MKTSOURCECODEMAPPART	Stores all of the unique source code parts for a given source code in a marketing effort.
MKTSOURCECODEPART	Stores a value for a source code item associated with a specific marketing effort.
MKTSOURCECODEPARTDEFINITION	Stores information for a source code part.
MKTSOURCECODEPARTDEFINITIONVALUES	Stores source code part values.
MKTSOURCECODEVALIDPARTVALUES	Stores information relating a source code part to its valid values.
MKTSPONSORSHIPMAILINGPROCESS	Contains information pertaining to the sponsorship effort business process.
MKTSPONSORSHIPMAILINGPROCESSSEGMENTATION	Contains information pertaining to the effort created for each sponsorship effort business process status.
MKTSPONSORSHIPMAILINGPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTSPONSORSHIPMAILINGPROCESS table.
MKTSPONSORSHIPMAILINGTEMPLATE	Stores information pertaining to a sponsorship effort template
MKTSPONSORSHIPMAILINGTEMPLATEACTIVATED	Stores a combination of sponsorship effort templates and sponsorships that have been 'Activated'.
MKTSPONSORSHIPMAILINGTEMPLATEAPPEAL	Stores appeals associated with sponsorship effort template.
MKTSPONSORSHIPMAILINGTEMPLATEASKLADDEROVERRIDE	Stores a list of the ask ladder overrides associated with a sponsorship effort template.
MKTSPONSORSHIPMAILINGTEMPLATEEXPORT	Stores export information pertaining to a sponsorship template.
MKTSPONSORSHIPMAILINGTEMPLATEFILTERSELECTION	Stores information pertaining to the selections in a sponsorship effort template's universe and exclusion filters.
MKTSPONSORSHIPMAILINGTEMPLATEKPI	Stores information pertaining to sponsorship mailing KPIs to create when creating a sponsorship effort template.
MKTSPONSORSHIPMAILINGTEMPLATERULE	Stores information pertaining to a sponsorship effort template rule.
MKTSPONSORSHIPMAILINGTEMPLATESEED	Stores the seeds for a sponsorship effort template.
MKTSPONSORSHIPRECORDSOURCE	Stores information pertaining to a donor record source's sponsorship record source.
MKTUPDATEMAILINGCOUNTSPROCESS	Stores information pertaining to a remove member parameter set.
MKTUPDATEMAILINGCOUNTSPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the MKTUPDATEMAILINGCOUNTSPROCESS table.
MKTUPDATEMAILINGCOUNTSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the MKTUPDATEMAILINGCOUNTSPROCESS table.
MKTVENDORSERVICE	Stores information about the additional, client-defined services a vendor provides.
MKTVENDORSERVICETYPE	Stores information about the system-defined services a vendor provides.
MODELINGANDPROPENSITY	Contains all default Modeling and Propensity types.
MODELINGANDPROPENSITYATTRIBUTEORIGIN
MODELINGANDPROPENSITYDELIVERY
MULTICURRENCYCONFIGURATION	Stores information pertaining to multicurrency configuration settings.
NAMEFORMAT	Stores addressees and salutations associated with a given constituent.
NAMEFORMATDEFAULT	Contains name format defaults that will be created for new constituents.
NAMEFORMATFIELD	Contains addressee/salutation formats.
NAMEFORMATFUNCTION	Contains addressee/salutation formats.
NAMEFORMATFUNCTION_USERDEFINED	Contains user-defined addressee/salutation formats.
NAMEFORMATFUNCTIONDETAIL	Contains function detail for user defined name formats.
NAMEFORMATPARAMETER	Contains saved name format parameter sets used by various business processes.
NAMEFORMATPARAMETERGRPADDRESSEE	Contains saved name format parameter group addressee settings.
NAMEFORMATPARAMETERGRPSALUTATION	Contains saved name format parameter group salutation settings.
NAMEFORMATPARAMETERINDADDRESSEE	Contains saved name format parameter individual addressee settings.
NAMEFORMATPARAMETERINDSALUTATION	Contains saved name format parameter individual salutation settings.
NAMEFORMATPARAMETERORGADDRESSEE	Contains saved name format parameter organization addressee settings.
NAMEFORMATPARAMETERORGSALUTATION	Contains saved name format parameter organization salutation settings.
NAMEFORMATTYPECODE	This code table stores translations of name format type codes.
NAMINGOPPATTACHMENTTYPECODE	Stores translations of naming opportunity attachment types.
NAMINGOPPLOCATIONSTATUSCODE	Indicates the status of a naming opportunity recognition installed location.
NAMINGOPPMEDIALINKTYPECODE	Stores translations of naming opportunity media link types.
NAMINGOPPNOTETYPECODE	Stores translations of naming opportunity note types.
NAMINGOPPORTUNITY	Stores information for each naming opportunity.
NAMINGOPPORTUNITYAREACODE	Indicates the geographic location of a naming opportunity.
NAMINGOPPORTUNITYATTACHMENT	This table contains attachments belonging to naming opportunities.
NAMINGOPPORTUNITYFACILITY	Contains information pertaining to a naming opportunity facility.
NAMINGOPPORTUNITYFACILITYCODE	The specific facility location of a naming opportunity.
NAMINGOPPORTUNITYMEDIALINK	This table contains media links belonging to naming opportunities.
NAMINGOPPORTUNITYMGOPPORTUNITY	Links a naming opportunity to a major giving opportunity.
NAMINGOPPORTUNITYNOTE	This table contains notes belonging to naming opportunities.
NAMINGOPPORTUNITYRECOGNITION	Stores information for each naming opportunity recognition.
NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATION	Stores installed locations associated with a naming opportunity recognition record.
NAMINGOPPORTUNITYRECOGNITIONMGLINK	Links a naming opportunity recognition to a naming opportunity/major giving opportunity link.
NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT	Links naming opportunity recognitions to revenue split records.
NAMINGOPPORTUNITYTYPECODE	Indicates the type for naming opportunities.
NAMINGOPPORTUNITYUNITCODE	The ara or unit location of a naming opportunity.
NavBarItems
NC_Notification
NetAccount
NetAccountRelation
NETCOMMUNITYBATCHPROCESSORSPLITMAPPING
NETCOMMUNITYCLIENTUSER	Contains information pertaining to NetCommunity user accounts.
NETCOMMUNITYCONTENTTYPEMAPPING	Stores a mapping from guids to integers for Blackbaud Internet Solutions content types.
NETCOMMUNITYDEFAULTCODEMAP	The NETCOMMUNITYDEFAULTCODEMAP table maps various default code table entries for Blackbaud Internet Solutions transactions.
NETCOMMUNITYEMAILINFO	Contains email information of Blackbaud Internet Solutions users.
NETCOMMUNITYEMAILJOBRECIPIENT	Contains information pertaining to recipients of Blackbaud Internet Solutions email jobs.
NETCOMMUNITYINTEGRATION	The NETCOMMUNITYINTEGRATION table holds setup information for integration with Blackbaud Internet Solutions.
NETCOMMUNITYMAPPINGRULE	Stores the mapping rules used to download data for a Blackbaud Internet Solutions transaction processor.
NETCOMMUNITYMAPPINGRULEBATCH	Maps a batch to the Blackbaud Internet Solutions processor rule that led to its creation.
NETCOMMUNITYMAPPINGRULEOWNER	Stores the owners that will be assigned to according to Blackbaud Internet Solutions processor filter rules.
NETCOMMUNITYMAPPINGRULEPAGEID	Stores the page IDs associated with a specific filter rule for a Blackbaud Internet Solutions transaction processor type.
NETCOMMUNITYMAPPINGRULESITEID	Stores the BBIS site IDs associated with a specific filter rule for a Blackbaud Internet Solutions transaction processor type.
NETCOMMUNITYNEWSLETTERSUBSCRIPTION	Contains newsletter subscriptions of Blackbaud Internet Solutions users.
NETCOMMUNITYPAGEMAPPING	Stores a mapping from guids to integers for Blackbaud Internet Solutions pages.
NETCOMMUNITYPLUGINSERVICE	The NETCOMMUNITYPLUGINSERVICE table holds setup information for integration with Blackbaud Internet Solutions.
NETCOMMUNITYPROCESSORSPLIT	The NETCOMMUNITYPROCESSORSPLIT table contains a list of unique owners into which transactions will be downloaded.
NETCOMMUNITYTEAMFUNDRAISEREMAIL	Lists emails sent by Blackbaud Internet Solutions team fundraisers.
NETCOMMUNITYTRANSACTIONPROCESSOR	The NETCOMMUNITYTRANSACTIONPROCESSOR table maps a Blackbaud Internet Solutions transaction to a processor and a batch instance.
NETCOMMUNITYTRANSACTIONPROCESSORSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the NETCOMMUNITYTRANSACTIONPROCESSOR table.
NETCOMMUNITYWEBTRAFFIC	Contains information pertaining to Blackbaud Internet Solutions Web traffic.
NetGroup
NetGroupRelation
NetworkRanking
NewsChannels
NewsReaders
NewsStories
NONDEPOSITABLEPAYMENTMETHOD	Stores configuration information for other payment methods.
NOTIFICATION	Contains information about a Notification record
Notification_SiteContent
Notification_Workflow
NOTIFICATIONCACHE	Contains notification cache records.
NOTIFICATIONIDMAP	Contains information used to map an ID of one record type to another record type for use in implementing notifications.
NOTIFICATIONRECORDTYPE	Contains a list of record types that allow for page notifications.
NotificationSubscription
NotificationType
NUMBERS
ObjectTags
ObjectTypes	DO NOT MODIFY THE OBJECT TYPE INTEGERS!!!
ODATAQUERYRUNINFO
OLAPDATASOURCE	Contains one row for each Analysis Services OLAP/UDM data source that has been configured for they system.
OLAPDATASOURCEATTRIBUTECATEGORY
OLAPDATASOURCECATEGORYCODE	Olap Data Source Category code table.
OLAPDATASOURCERECORDTYPE
OLAPDATASOURCESMARTFIELD	Defines the smart fields that are enabled or disabled for the OLAP data mart
OLAPDATASOURCEVALIDATIONPARAMETERS
OLAPDATASOURCEVALIDATIONPARAMETERSSTATUS
OLAPREFRESHPROCESS	Holds parameters needed by the OLAP Refresh process.
OLAPREFRESHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the OLAPREFRESHPROCESS table.
OPPORTUNITY	Stores opportunity information for a plan.
OPPORTUNITYAMOUNTBRACKET	Contains thresholds and descriptions for each opportunity amount bracket.
OPPORTUNITYAMOUNTBRACKETGROUP	Represents groups of opportunity amount ranges.
OPPORTUNITYAMOUNTBRACKETSITES	Defines which opportunity amount bracket groups have which sites.
OPPORTUNITYCAMPAIGN	Associates an opportunity with a campaign.
OPPORTUNITYDESIGNATION	Stores Designation for an opportunity.
OPPORTUNITYDESIGNATIONCAMPAIGN	Associates an opportunity designation with a campaign.
OPPORTUNITYDESIGNATIONFMCODE	Funding method describes how the donor will use the fund.
OPPORTUNITYDESIGNATIONTYPECODE	Stores type to further categorize the designation.
OPPORTUNITYFUNDINGTYPE	Contains a list of funding types for a given opportunity.
OPPORTUNITYSOLICITOR
OPPORTUNITYTYPECODE	This code table stores translations of opportunity type codes.
ORDERPAYMENTSPLIT	Stores payment split links for an order
ORGANIZATIONDATA	This table contains constituent information specific to organizations.
ORGANIZATIONHIERARCHY	Organization Hierarchy
ORGANIZATIONINFORMATION	Organization information
ORGANIZATIONMERGERHISTORY	History of organization mergers.
ORGANIZATIONPARENTHISTORY	Parent history records for organizations.
ORGANIZATIONPOSITION	Organization Hierarchy Position details
ORGANIZATIONPOSITIONHOLDER	Organization Hierarchy
ORIGINATIONSETTING	This table contains settings for defaulting about constituent originations.
OTHERPAYMENTMETHODCODE	Stores translations of user definable payment method types.
OTHERPAYMENTMETHODDETAIL	Stores payment detail information for a revenue record when the payment method is other.
OVERALLRATINGCODE	Stores translations of overall rating codes.
PACKAGECATALOG	The PACKAGECATALOG table contains meta data about suites of catalog items added together.
PageContent
PAGEDEFINITIONCATALOG	The PAGEDEFINITIONCATALOG table stores page definitions for the system
PAGEEXPRESSIONVALIDATORWHITELIST
PAGEMODEL	Contains the page models loaded into each CMS site.
PAGEMODELDESIGN	Contains the page models under design.
PAGEMODELDESIGNITEM	Tracks each CMS artifact added to a Model Design.
PAGEMODELITEM	Tracks each CMS artifact created by a Page Model import.
PAGEVIEWDATA	Contains an XML document describing the viewing data for each user.
PAPERLESSMANDATESCONFIGURATION	Contains default configuration information for paperless mandates.
PAPERLESSMANDATESINSTRUCTIONPROCESS	Contains information pertaining to the paperless mandates instruction process.
PAPERLESSMANDATESINSTRUCTIONPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PAPERLESSMANDATESINSTRUCTIONPROCESS table.
PAPERLESSMANDATESSITECONFIGURATION	Contains configuration information for paperless mandates for specific sites.
PARTIALINFORMATIONSEARCHCONFIGURATION	Contains configuration information for Prospect Quick Search.
PARTIALINFORMATIONSEARCHCRITERIA	Contains criteria used in Prospect Quick Search.
PARTIALINFORMATIONSEARCHRESULT_BODETAIL_RELATIONSHIPS	Contains relationships portion of Prospect Quick Search business ownership detail results.
PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP	Contains Prospect Quick Search business ownership results.
PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL	Contains Prospect Quick Search business ownership detail results.
PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_BIOS	Contains bios portion of Prospect Quick Search business ownership detail results.
PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_EXECS	Contains executives portion of Prospect Quick Search business ownership detail results.
PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_OWNERSHIP	Contains ownership portion of Prospect Quick Search business ownership detail results.
PARTIALINFORMATIONSEARCHRESULT_REALESTATE	Contains Prospect Quick Search real estate results.
PARTIALINFORMATIONSEARCHRESULT_REALESTATEDETAIL	Contains Prospect Quick Search real estate detail results.
PARTICIPANTEMAILTEMPLATE	Participant Custom Templates
PARTICIPANTWIDGET	Widgets available for Participant
PATRONYMICEXCLUSION	Stores a list of words to exclude from the patronymic prefix format.
PATTERN	Pattern
PATTERNBLOCK	Pattern Blocks
PATTERNBLOCKMEETING	Pattern Block Meetings
PAYMENTGIFTFEEOVERRIDE	This table contains gift fee override details for payments
PAYMENTORIGINALAMOUNT	Holds the original amount for a payment.
PAYMENTTERM	Payment Term
PAYPALPAYMENTMETHODDETAIL
PDACCOUNTCODEMAPAPPLICATIONTYPE	A listing of Application Types
PDACCOUNTCODEMAPOFFICE	List of Office/Tab used in account code mapping
PDACCOUNTCODEMAPPAYMENTMETHODTYPE	A listing of Payment Methods
PDACCOUNTCODEMAPPING	Account code mapping for the all offices.
PDACCOUNTCODEMAPPINGSUBTYPE	Account code subtype mapping.
PDACCOUNTCODEMAPREVENUETYPE	A listing of Revenue Types
PDACCOUNTCODEMAPSUBLEDGER	Account code mapping subledger types table.
PDACCOUNTLOOKUPCACHE
PDACCOUNTSEGMENT	Segments making up the account string.
PDACCOUNTSEGMENTMAPPING	A mapping of segment long and short descriptions.
PDACCOUNTSEGMENTVALUE	Account segment values table.
PDACCOUNTSTRUCTURE	Account structure table.
PDACCOUNTSYSTEM	Account structure systems.
PDACCOUNTSYSTEMFORREVENUETEMP	Provides link between Revenue and Account System.
PDACCOUNTSYSTEMSITE	List of sites for each accounting system.
PDACCOUNTTABLESAVAILABLEFORSEGMENT	List of tables available to be included as a segment in the account string.
PDACCOUNTTABLESAVAILABLEFORSEGMENTPRODUCTFLAG	Product flags required for tables that segments can be mapped to.
PDAPPLICATIONSEGMENT	Holds application types for segment mapping.
PDCATEGORYDEFINITION	General Ledger Category Definition table
PDCOMPOSITESEGMENT	Holds Composite Segments and their definitions.
PDCOMPOSITESEGMENTMAPPING	Holds mapping parent for Composite Segments.
PDCOMPOSITESEGMENTMAPPINGENTRY	Holds various table mapping entries for Composite Segments.
PDCOMPOSITESEGMENTTABLELIST	Holds list of tables associated with Composite Segment.
PDCONSTITUENCYORDER	Stores the hierarchy of constituency codes used to pick a single constituency code for a constituent
PEOPLEFINDER	The PeopleFinder process is represented by this table.
PEOPLEFINDERFILE	Stores files for the PeopleFinder process.
PEOPLEFINDERGETPROCESS	The PeopleFinder get process is represented by this table.
PEOPLEFINDERGETPROCESSEXPORTFORMAT
PEOPLEFINDERGETPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PEOPLEFINDERGETPROCESS table.
PEOPLEFINDERRESUBMITPROCESS	The PeopleFinder resubmit process is represented by this table.
PEOPLEFINDERRESUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PEOPLEFINDERRESUBMITPROCESS table.
PEOPLEFINDERSUBMITPROCESS	The PeopleFinder submit process is represented by this table.
PEOPLEFINDERSUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PEOPLEFINDERSUBMITPROCESS table.
PEOPLELINKCONTACT	Contains PeopleFinder contact records.
PEOPLELINKORGANIZATION	Contains PeopleFinder organization records.
PERFORMANCECATEGORY	Used to define levels of student performance; eg. Honor Roll.
PERFORMANCECATEGORYLEVEL	Used to define a level of student performance for a performance category.
PERFORMANCECATEGORYLEVELGRADE	Used to define a grade range for a performance category level.
PERFORMANCECATEGORYLEVELSKILLCATEGORY	Used to define a skill category for a performance category level.
PERFORMANCECATEGORYLEVELSKILLCATEGORYRATING	Used to define a range of ratings for a skill category on a performance category level.
PERSONALACCESSTOKEN
PERSONALACCESSTOKENREVOKECODE
PERSONALACCESSTOKENREVOKEDEFAULTREASONMAPPING
PERSONALACCESSTOKENREVOKEDETAIL
PersonalizedContentData
PERSONALNOTESSETTINGS
PersonalPageData
PersonalPageElements
PHILANTHROPICGIFTCATEGORY
PHONE	The PHONE table stores phone numbers associated with a given constituent.
PHONEFINDER	Contains information about the PhoneFinder process.
PHONEFINDERGETPROCESS	Contains PhoneFinder get process data
PHONEFINDERGETPROCESSEXPORTFORMAT
PHONEFINDERGETPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PHONEFINDERGETPROCESS table.
PHONEFINDERRESUBMITPROCESS	Stores data pertaining to the PhoneFinder resubmit business process
PHONEFINDERRESUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PHONEFINDERRESUBMITPROCESS table.
PHONEFINDERSUBMITPROCESS	Contains PhoneFinder submit process data
PHONEFINDERSUBMITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PHONEFINDERSUBMITPROCESS table.
PHONETYPECODE	This code table stores translations of phone type codes.
PLANNEDGIFT	Planned gift table
PLANNEDGIFTACKNOWLEDGEMENTPROCESS	Contains information pertaining to the planned gift acknowledgement process.
PLANNEDGIFTACKNOWLEDGEMENTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the PLANNEDGIFTACKNOWLEDGEMENTPROCESS table.
PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PLANNEDGIFTACKNOWLEDGEMENTPROCESS table.
PLANNEDGIFTADDITION	Holds records for addins on planned gifts.
PLANNEDGIFTADDITIONASSET	Table of assets within each planned gift addition.
PLANNEDGIFTADDITIONASSETHOLDER	Table of owners of planned gift addition assets.
PLANNEDGIFTADDITIONDESIGNATION	Holds records for addition designations for planned gifts.
PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN	Stores the campaigns for each planned gift addition designation.
PLANNEDGIFTADDITIONREVENUE	Associates a planned gift addition record with a revenue record.
PLANNEDGIFTASSET	Table of assets within each planned gift.
PLANNEDGIFTASSETHOLDER	Table of owners of planned gift assets.
PLANNEDGIFTATTACHMENT	This table contains attachments belonging to planned gifts.
PLANNEDGIFTATTACHMENTTYPECODE	Stores translations of planned gift attachment types.
PLANNEDGIFTBENEFICIARY	Table of beneficiaries for each planned gift.
PLANNEDGIFTDESCATEGORYCODE	Stores categories of planned gift designations.
PLANNEDGIFTDESIGNATION	Stores the designation for each planned gift.
PLANNEDGIFTDESIGNATIONCAMPAIGN	Stores the campaigns for each planned gift designation.
PLANNEDGIFTFUNDINGTYPE	Contains a list of funding types for a given planned gift.
PLANNEDGIFTLETTER	Stores information pertaining to planned gift details and their corresponding letters.
PLANNEDGIFTLETTERCODE	Stores information pertaining to acknowledgement planned gift letters.
PLANNEDGIFTLETTERCODESITE	Information regarding the sites associated with a planned gift letter.
PLANNEDGIFTLINK	Stores the link to the gift object in the GiftWrap system, for each planned gift.
PLANNEDGIFTMEDIALINK	This table contains media links belonging to constituents.
PLANNEDGIFTMEDIALINKTYPECODE	Stores translations of planned gift media link types.
PLANNEDGIFTNOTE	Contains notes for planned gifts.
PLANNEDGIFTNOTETYPECODE	Stores translations of planned gift note types.
PLANNEDGIFTOTHERSUBTYPECODE	Stores subtypes of planned gifts with the Other vehicle type.
PLANNEDGIFTPAYOUTADJUSTMENT	Stores adjustments made to posted payouts.
PLANNEDGIFTPAYOUTGLDISTRIBUTIONTEMP	Table to store the GL distribution of Planned Gift Payout.
PLANNEDGIFTPAYOUTSPLITTEMP	Contains detail split information for a given payout detail record.
PLANNEDGIFTPAYOUTTEMP	Associates a planned gift record with a payout record.
PLANNEDGIFTRECEIPTVEHICLE	Stores the list of vehicles for planned gift receipt settings.
PLANNEDGIFTRECONCILE	This table holds data related to updates made to planned gift and planned gift additions revenue and payments.
PLANNEDGIFTRELATIONSHIP	Table of relationships for each planned gift.
PLANNEDGIFTREVENUE	Associates a planned gift record with a revenue record.
PLANNEDGIFTREVENUESPLIT	Associates a planned gift record with a revenue record.
PLANNEDGIFTSITE	Contains information pertaining to a planned gift's sites.
PLANNEDGIFTSUBTYPECONFIGURATION	Defines which planned gift subtypes are valid for which planned gift vehicle types.
PLANNEDGIFTTRIGGEREVENTCODE	Planned Gift Trigger Event Code Table
PLANNEDGIFTVEHICLEOPTIONS	Stores options for each of the planned gift vehicle types.
PLANOUTLINE	Contains major giving plan outlines.
PLANOUTLINESTEP	Contains plan outline step.
PLANPARTICIPANT	The participants in a prospect plan.
PLANPARTICIPANTROLECODE	Stores the roles which can be assigned to a plan participant.
PLEDGEGIFTFEEOVERRIDE	This table contains gift fee override details for pledges
PLEDGEINSTALLMENTOPTION
PLEDGEORIGINALAMOUNT	Holds the original amount for a pledge.
PLEDGEOVERPAYMENTOPTIONS	Contains default options for pledge overpayments.
PLEDGEREMINDERPROCESS	This table contains parameter sets for executions of the pledge reminder business process.
PLEDGEREMINDERPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the PLEDGEREMINDERPROCESS table.
PLEDGEREMINDERPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PLEDGEREMINDERPROCESS table.
PLEDGEREMINDERSENT	This table stores information pertaining to pledge reminders that have been sent.
PLEDGESUBTYPE	Stores subtypes for pledges.
PLEDGEWRITEOFFPROCESS	This table contains information pertaining to the pledge write-off business process.
PLEDGEWRITEOFFPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PLEDGEWRITEOFFPROCESS table.
POOLEDINCOMEFUNDCODE	Pooled Income Fund Code Table
POSTCODECOORDINATES	Contains a list of longitude and latitude values for the center of a given postal code.
POSTTOGLPROCESS	Contains information pertaining to the Post to GL business process.
POSTTOGLPROCESSBANKACCOUNTFILTER
POSTTOGLPROCESSCUSTOMJOURNAL	Holds journal reference specified by the user.
POSTTOGLPROCESSDEPOSITTEMPLATESFILTER
POSTTOGLPROCESSDETAIL	Contains posting detail information.
POSTTOGLPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the POSTTOGLPROCESS table.
POSTTOGLPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the POSTTOGLPROCESS table.
POSTTOGLPROCESSTRANSACTIONTYPEFILTER
PREFERENCECONFLICT	Contains preferences for event conflicts.
PREFERENCEGROUPCONFLICT	Contains information pertaining to preference groups for event conflicts.
PRENOTIFICATIONPROCESS	Contains information pertaining to the prenotification business process.
PRENOTIFICATIONPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PRENOTIFICATIONPROCESS table.
PRICE	Contains individual price information
PRICELIST	Contains the name of a PriceList.
PRICETYPECODE	Contains values for Price Type
PRINTERLIST	Defines a list of similar printers
PRINTERLISTITEM	Defines a printer in a printer list
PRINTERLOOKUPLIST	List of printers used by the Web ui to get around web limitations
PRINTMEMBERSHIPCARDSPROCESS	Contains parameters for the printing membership cards process.
PRINTMEMBERSHIPCARDSPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the PRINTMEMBERSHIPCARDSPROCESS table.
PRINTMEMBERSHIPCARDSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PRINTMEMBERSHIPCARDSPROCESS table.
PROCESSORTRANSACTIONCOLUMNMAPPING
PROCESSORTRANSACTIONSETTLEMENTIMPORT
PROCESSORTRANSACTIONSETTLEMENTIMPORTROW
PROCESSORTRANSACTIONSETTLEMENTIMPORTSTATUS
PRODUCT	This table contains products.
PRODUCTVENDOR	Defines an association between a product and a vendor.
ProfessionCodes
ProfileEditorFields
ProfileUpdateTransactions
PROGRAM	A program that contains a Manifest, PriceList, and one or more sales types
PROGRAM_MICROSITEEMAILTEMPLATE
PROGRAMCATEGORYCODE	Program category code table.
PROGRAMCATEGORYCODESITE
PROGRAMDISCOUNT	This table holds the discounts for a program.
PROGRAMDOCUMENT	Links a document to a program
PROGRAMEVENTLOCATION	Connects an Event to a Location.
PROGRAMEVENTPRICE	Contains individual price information for an event
PROGRAMEVENTREGISTRATIONSECTION
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION
PROGRAMFEE	This table holds the fees for a program.
PROGRAMGLMAPPING	Stores the GL mapping for a program.
PROGRAMGROUP	Stores program groups in combination.
PROGRAMGROUPPRICE	Stores prices belongs program group.
PROGRAMGROUPPROGRAM	Stores programs belongs to program group.
PROGRAMLOCATION	Connects an Event Location to a Program
PROGRAMPREFERENCE	Contains information pertaining to program preferences.
PROGRAMPREFERENCEGROUP	Contains information pertaining to program preference groups.
PROGRAMPRICE	Links an individual price to a program.
PROGRAMRESOURCE	Contains the resources and quantity of those resources used for a program.
PROGRAMSALESMETHOD	Links a program to one or more sales types and provides on-sale information
PROGRAMSTAFFRESOURCE	Contains the resources and quantity of those staff resources needed for a program.
PROGRAMTAX	This table holds the taxes for a program.
PROGRAMTICKETPARTCONTENT	Program Ticket part settings.
PROJECT	This stores project specific fields.
PROJECTATTACHMENT	This table contains attachments belonging to project.
PROJECTATTACHMENTTYPECODE	Stores translations of project attachment types.
PROJECTDEPARTMENTCODE	Stores translations of project departments.
PROJECTDIVISIONCODE	Stores translations of project divisions.
PROJECTLOCATIONCODE	Stores translations of project locations.
PROJECTMEDIALINK	This table contains notes belonging to project.
PROJECTMEDIALINKTYPECODE	Stores translations of project media link types.
PROJECTNOTE	This table contains notes belonging to project.
PROJECTNOTETYPECODE	Stores translations of project note types.
PROJECTSTATUSCODE	Stores translations of project statuses.
PROJECTTYPECODE	Stores translations of project types.
PROMOTIONALCODE	Contains promotion code information
PROMOTIONSCHEDULE	This table contains the schedules of grade promotion within and across schools.
PROMOTIONSCHEDULEENTRY	This table contains the entries of grade level promotions for a given promotion schedule.
PROPERTYDETAIL_EXT
PROPERTYDETAILADJUSTMENT	Stores adjustments made to posted sold property detail.
PROPERTYDETAILAUDITORIGINAL	This table contains the audit trail for rows in the dbo.PROPERTYDETAIL table.
PROPERTYDETAILGLDISTRIBUTIONTEMP	Table to store the GL distribution of sold property detail entered by user to override the system-generated distribution. For other sold property records this table will store the system-generated entries after post.
PROPERTYDETAILTEMP	Stores stock detail information for a revenue records with a payment type of Stock
PROPERTYSUBTYPECODE	Property Subtypes
PROSPECT	Indicates that a constituent is a prospect.
PROSPECTASSIGNMENTPROCESS	Contains parameter information for the Prospect Assignment business process.
PROSPECTASSIGNMENTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the PROSPECTASSIGNMENTPROCESS table.
PROSPECTASSIGNMENTREQUEST	Holds Prospect Assignment Requests
PROSPECTASSIGNMENTREQUESTPROSPECT	Holds Prospect Information Prospect Assignment Requests
PROSPECTASSIGNMENTREQUESTPROSPECTPLAN	Holds prospect plan information for assignment requests
PROSPECTDATERANGE	Contains the date ranges for which constituents are prospects.
PROSPECTFUNDINGINTEREST	Contains a list of funding interests for a given prospect.
PROSPECTFUNDINGINTERESTSITE	Defines which prospect funding interests have which sites.
PROSPECTMANAGERHISTORY	Stores historical information on prospect managers.
PROSPECTPLAN	Contains prospect plans.
PROSPECTPLANATTACHMENT	This table contains attachments belonging to plans.
PROSPECTPLANATTACHMENTTYPECODE	Stores translations of plan attachment types.
PROSPECTPLANMANAGERHISTORY	Stores historical information on prospect plan primary and secondary managers.
PROSPECTPLANMEDIALINK	This table contains media links belonging to prospect plans.
PROSPECTPLANMEDIALINKTYPECODE	Stores translations of prospect plan media link types.
PROSPECTPLANNOTE	This table contains notes belonging to prospect plans.
PROSPECTPLANNOTETYPECODE	Stores translations of prospect plan note types.
PROSPECTPLANREQUEST	Holds prospect plan requests
PROSPECTPLANSITE	Defines which prospect plans have which sites.
PROSPECTPLANSTATUSCODE	Stores translations of prospect plan stages
PROSPECTPLANTYPECODE	Stores translations of prospect plan types
PROSPECTRESEARCHREQUEST	This table contains information about prospect research requests.
PROSPECTRESEARCHREQUESTAPPUSERPERMISSION	This table contains permission information relating to prospect research request management for application users.
PROSPECTRESEARCHREQUESTATTACHMENT	This table contains attachments belonging to prospect research requests.
PROSPECTRESEARCHREQUESTATTACHMENTTYPECODE	Stores translations of prospect research request attachment types.
PROSPECTRESEARCHREQUESTCONFIGURATION	This table contains configuration information about prospect research requests.
PROSPECTRESEARCHREQUESTCONSTITUENT	This table contains information about prospect research request constituents.
PROSPECTRESEARCHREQUESTCONSTITUENTATTACHMENT	This table contains attachments belonging to prospect research request constituents.
PROSPECTRESEARCHREQUESTCONSTITUENTMEDIALINK	This table contains media links belonging to prospect research request constituents.
PROSPECTRESEARCHREQUESTCONSTITUENTNOTE	This table contains notes belonging to prospect research request constituents.
PROSPECTRESEARCHREQUESTMEDIALINK	This table contains media links belonging to prospect research requests.
PROSPECTRESEARCHREQUESTMEDIALINKTYPECODE	Stores translations of prospect research request media link types.
PROSPECTRESEARCHREQUESTNOTE	This table contains notes belonging to prospect research requests.
PROSPECTRESEARCHREQUESTNOTETYPECODE	Stores translations of prospect research request note types.
PROSPECTRESEARCHREQUESTPRIORITYCODE	Stores translations of prospect research request priorities.
PROSPECTRESEARCHREQUESTREASONCODE	Stores translations of prospect research request reasons.
PROSPECTRESEARCHREQUESTSITE	Contains information about sites assigned to prospect research requests.
PROSPECTRESEARCHREQUESTSOURCE	This table contains sources used in prospect research requests.
PROSPECTRESEARCHREQUESTSOURCECODE	Stores translations of prospect research request sources.
PROSPECTRESEARCHREQUESTSTATUSCHANGECODE	Stores translations of prospect research request status change reasons.
PROSPECTRESEARCHREQUESTTYPECODE	Stores translations of prospect research request types.
PROSPECTRESEARCHTEMPLATE	Contains Prospect Research report templates.
PROSPECTRESEARCHTEMPLATEDEFAULT	Contains app users default Prospect Research report template.
PROSPECTRESEARCHTEMPLATESECTION	Contains Sections selected for a Prospect Research report template.
PROSPECTSEARCH
PROSPECTSEARCHAVAILABLETILE
PROSPECTSEARCHAVAILABLETILEFORACCOUNTTYPE
PROSPECTSEARCHGIVINGCATEGORY
PROSPECTSEARCHMOSAIC
PROSPECTSEARCHSELECTEDTILE
PROSPECTSEGMENTATION	This table contains instances of the Prospect Analysis Prospect Segmentation dashboard.
PROSPECTSEGMENTATIONPROSPECT	This table contains prospects of the Prospect Segmentation, defined by the primary and secondary section IDs.
PROSPECTSEGMENTATIONSECTION	This table contains instances of the Prospect Segmentation sections.
PROSPECTSEGMENTATIONVARIABLE	This table contains instances of the Prospect Segmentation variables.
PROSPECTSTATUSCODE	Prospect Status Code
PROSPECTTEAM	Stores members of a prospect team
PROSPECTTEAMROLECODE	Descriptions of the Roles on a Prospect Team
PURPOSERECIPIENTSTATUSCODE	A status code that is associated with a fundraising purpose recipient.
PURPOSERECIPIENTTYPECODE	A type code that is associated with a fundraising purpose recipient.
QUERYCATEGORYCODE	Stores translations of query category codes.
QUERYHINT
QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS
QUERYVIEWADDATTRIBUTEEXTENSIONPROCESSSTATUS
QUERYVIEWCATALOG	The QUERYVIEWCATALOG table contains meta data about each of the objects used by query.
QUERYVIEWEXTENSIONCATALOG
QUERYVIEWRELATIONSHIP	The QUERYVIEWRELATIONSHIP table stores the relationship for each of the views used by query.
QUERYWITHDELETEERROR
QUEUEPROCESS	Contains information for the queue business process.
QUEUEPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the QUEUEPROCESS table.
QUEUEPROCESSRESULT	Stores information about queue process runs.
QUEUEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the QUEUEPROCESS table.
QuickSearchPart
R68	Contains parameter information for the R68 business process.
R68ARCHIVEDPARAMETERS	Contains parameter information for the R68 business process.
R68DETAIL	Contains tax claim detail information for the R68 business process.
R68ONLINESUBMISSIONGATEWAYSETTINGS
R68ONLINESUBMISSIONPARAMETERS
R68ONLINESUBMISSIONPARAMETERSSTATUS
R68ONLINESUBMISSIONSETTINGS
R68ONLINESUBMISSIONSETTINGSSENDERINFO
R68PROCESSCOMMITEXCEPTION
R68PROCESSCOMMITPARAMETERS	Stores parameters for the R68 Process Commit Process.
R68PROCESSCOMMITPARAMETERSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the R68PROCESSCOMMITPARAMETERS table.
R68REFUNDDETAIL	Contains tax claim refund detail information for the R68 business process.
R68STATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the R68 table.
RATESCALE	Rate scale for flat rate pricing in group sales
RATESCALEAPPLICATION	Percentage application for the price on a rate scale.
RATESCALEFEE	Fee included in the flat rate scale.
RATESCALEPRICE	Flat rate price for a group of a specific size.
RATESCALEPROGRAM	Program included in the flat rate scale.
RATESCALERESOURCE	Resource included in the flat rate scale.
RATESCALESTAFFRESOURCE	Staffing resource included in the flat rate scale.
RE7ATTRIBUTEPROCESS
RE7ATTRIBUTEPROCESSSTATUS
RE7INTEGRATIONAVAILABLEFIELD	This table contains fields that are available for adding to and from The Raiser's Edge.
RE7INTEGRATIONCONFIGURATION	This table contains the basic configuration information for integration with The Raiser's Edge.
RE7INTEGRATIONCONSTITUENTMAP	This table maps constituents in the database to The Raiser's Edge constituents.
RE7INTEGRATIONCREDENTIALS	Contains the credentials required for an appuser to access The Raiser's Edge
RE7INTEGRATIONERROR	Stores errors that happen during RE7 Integration imports.
RE7INTEGRATIONGIVINGSUMMARY	Giving summary data from The Raiser's Edge.
RE7INTEGRATIONGIVINGSUMMARYFILTERS
RE7INTEGRATIONIMPORTSTAGING
RE7INTEGRATIONPHONEMAP	Maps phone numbers in the database to The Raiser's Edge phone numbers.
RE7INTEGRATIONSELECTEDFIELD	This table contains the fields selected to use for RE7 integration.
Realm
RealmEmail
RECEIPTINGPROCESS	Contains information pertaining to the receipting business process.
RECEIPTINGPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the RECEIPTINGPROCESS table.
RECEIPTINGPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the RECEIPTINGPROCESS table.
RECEIPTPREFERENCEINFO	Stores information pertaining to receipt preferences.
ReceiptStack
RECEIPTSTACKCODE	A list of receipt stacks receipting process can use.
RECEIPTSTACKINFO	Defines Receipt Stack
RECEIVABLECREDIT	This table contains receivable credit records.
RECEIVABLECREDITLINEITEM	Extends the financial transaction line item to add receivable credit information to the line items.
RECEIVABLEPAYMENT	Payments in the financial system.
RECEIVABLEPAYMENTCHECK	Gives the check information attached to a given payment.
RECEIVABLEPAYMENTCREDITCARD	Gives the credit card details for a given payment.
RECEIVABLEPAYMENTDIRECTDEBIT	Gives the direct debit information associated with a given payment.
RECEIVABLEPAYMENTOTHERMETHOD	Gives the other payment details for a given payment.
RECOGNITIONCREDIT	Stores recognition credit credits for a constituent.
RECOGNITIONDECLINEDLEVELREASONCODE
RECOGNITIONDEFAULT	This table contains system configuration options for recognitions.
RECOGNITIONFILTER	Holds information for recognition filters.
RECOGNITIONFILTERRECOGNTIONTYPE	Holds recognition filter types for recognition filters.
RECOGNITIONLEVEL	Stores data pertaining to recognition program levels.
RECOGNITIONLEVELAMOUNT	Stores amounts for recognition levels.
RECOGNITIONLEVELBENEFIT	Stores benefits for a recognition level.
RECOGNITIONPROGRAM	Stores data pertaining to recognition programs.
RECOGNITIONPROGRAMCREDITTYPE	Stores recognition credit types which are associated with recognition programs
RECOGNITIONPROGRAMDESIGNATION	Stores designation filters for a recognition program.
RECOGNITIONRELATIONSHIPDEFAULT	This table contains system configuration options for relationship recognitions.
RECONCILIATION	Contains reconciliation information.
RECONCILIATIONCREDITDETAIL	Contains reconciliation refund detail information.
RECONCILIATIONDETAIL	Contains reconciliation detail information.
RECORDOPERATIONCATALOG	The RECORDOPERATIONCATALOG table stores information that maps record types to stored procedures that allow for non-dataform operations on records
RECORDOPERATIONWORKFLOWTRIGGER	Stores a list of record operations that trigger workflows.
RECORDSECURITYIDMAP	Contains information used to map an ID of one record type to another record type for use in implementing record level security.
RECORDTYPE	The RECORDTYPE table is used to define all of the primary record entities in the system.
RECORDTYPECOMPATIBILITYMAP	The RECORDTYPECOMPATIBILITYMAP table is used to express compatibility between two record types.
RECURRENCE	Holds the data needed to define when a recurring action will happen.
RECURRINGGIFTACTIVITY	Records payments and skipped transactions for recurring gifts.
RECURRINGGIFTAMENDMENT
RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY	For recurring gifts, where development functions may be represented by edits, the history of development function-related fields.
RECURRINGGIFTINSTALLMENT	Stores expected payment information for recurring gifts.
RECURRINGGIFTINSTALLMENTEVENT
RECURRINGGIFTINSTALLMENTPAYMENT	Contains recurring gift installment payment information.
RECURRINGGIFTINSTALLMENTWRITEOFF	Contains recurring gift installment write-off information.
RECURRINGGIFTSETTING	Configuration options for recurring gifts.
RECURRINGGIFTSTATUSREASONCODE
RECURRINGGIFTSTATUSUPDATEPROCESS
RECURRINGGIFTSTATUSUPDATEPROCESSOUTCOME
RECURRINGGIFTSTATUSUPDATEPROCESSSTATUS
RECURRINGGIFTWRITEOFF	Contains information about write-offs of recurring gift installments.
REGIONCODE	This code table stores translations of region codes.
REGISTRANT	Contains information pertaining to event registrants.
REGISTRANTBATCH	Stores registrant batch information
REGISTRANTBATCHBATCHSYSTEMMESSAGES
REGISTRANTBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the REGISTRANTBATCH batch table
REGISTRANTBATCHENEWSLETTER	Stores registrant batch eNewsletter subscription info
REGISTRANTBENEFIT	Contains benefit information pertaining to a registrant.
REGISTRANTBENEFITEXTENSION	Registrant Benefit Extension
REGISTRANTDESIGNATION	Contains designations and amounts for event registrants.
REGISTRANTDONATION	Registrant Donation
REGISTRANTEXTENSION	Extension table REGISTRANT for FAF
REGISTRANTLODGING	Lodging information for an event registrant.
REGISTRANTPACKAGE	Contains information pertaining to registrant package fees.
REGISTRANTPREFERENCE	Contains information pertaining to registrant preferences.
REGISTRANTPREFERENCEMAP	Contains information pertaining to the link between registrant preferences and registrant registration mappings.
REGISTRANTREGISTRATION	Contains information pertaining to registrant registration fees.
REGISTRANTREGISTRATIONINFORMATION
REGISTRANTREGISTRATIONMAP	Contains information pertaining to the link between registrants and registrant registration fees.
REGISTRANTRESTRICTIONOPTION	Links an event registrant to an event restriction option.
REGISTRANTROLE	Used to store Participant roles
REGISTRANTTRAVEL	Travel information for an event registrant.
REGISTRATIONDELETEHISTORY
REGISTRATIONINFORMATION
REGISTRATIONINFORMATIONOPTION
REGISTRATIONINFORMATIONPRICETYPE
REGISTRATIONPACKAGE	Contains information pertaining to a event registration packages.
REGISTRATIONPACKAGEPRICE	Contains information pertaining to a event registration package prices.
REGISTRATIONSECTIONCODE
REGISTRATIONWAIVER	Waiver for Registration form
REJECTIONCODE	Indicates the reason that a revenue batch record was rejected.
RELATEDSTAFFROLECODE	Stores roles for external staff related to a fundraising purpose.
RELATIONSHIP	This table stores relationships for constituents.
RELATIONSHIPBYMARRIAGE	Stores relationships linked by marriage.
RELATIONSHIPCONFIGURATION	Stores configuration information for each relationship type.
RELATIONSHIPCONFIGURATIONCORPORATE	This is a single row table that holds the corporate relationship settings
RELATIONSHIPJOBINFO	Job information for a constituent.
RELATIONSHIPMANAGER	Contains relationship managers for a constituent
RELATIONSHIPMAPCATALOG	Contains the metadata for relationship map specs.
RELATIONSHIPMAPINSTANCE	Stores relationship map instances.
RELATIONSHIPORGANIZATION
RELATIONSHIPSET	This table stores the set id for constituent relationships.
RELATIONSHIPTYPECODE	This code table stores translations of relationship type codes.
RELATIONSHIPTYPECODESITE
RELIGIONCODE	This code table stores translations of religion codes.
REMINDEROPTION	Stores options for reminders.
REMINDEROPTIONSOLICITCODES
REPORTCATALOG	A report that has been published to SQL Server Reporting Services.
ReportFundraiserTeamData
ReportFundraiserTeamData_Copy
ReportPanel
REPORTPARAMETERS	Stores a serialized DataFormItem that holds a report's parameters.
REPORTROOTFOLDERLIST	The REPORTROOTFOLDERLIST table contains a list of all Report Services root folders that will be displayed by the system.
REPORTSERVERCREDENTIALS	Stores basic authentication credentials to be used when connecting to the SQL Server Reporting Server.
REPORTSNAPSHOT	Stores data about report snapshots.
RERECEIPTREASONCODE	This table stores reason codes for receipts that have been re-receipted
RESCHEDULETICKETSHISTORY
RESEARCHGROUP	This table contains information about research groups.
RESEARCHGROUPCATEGORYCODE
RESEARCHGROUPCRITERIA
RESEARCHGROUPFAVORITE
RESEARCHGROUPLASTVISITED
RESEARCHGROUPMEMBER	This table contains the constituents who are in research groups.
RESEARCHGROUPPOPULATEPROCESS	Contains information pertaining to the research group populate process.
RESEARCHGROUPPOPULATEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the RESEARCHGROUPPOPULATEPROCESS table.
RESEARCHGROUPSITE	Contains information about sites assigned to research groups.
RESEARCHGROUPSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the RESEARCHGROUP table.
RESERVATION	Table that stores reservation information for group sales.
RESERVATIONATTACHMENT	This table contains attachments belonging to reservations.
RESERVATIONATTACHMENTTYPECODE	Stores translations of reservation attachment types.
RESERVATIONMEDIALINK	This table contains media links belonging to reservations.
RESERVATIONMEDIALINKTYPECODE	Stores translations of reservation media link types.
RESERVATIONNOTE	This table contains notes belonging to reservations.
RESERVATIONNOTETYPECODE	Stores translations of reservation note types.
RESERVATIONRATESCALE	The flat rate scale used for flat rate pricing on a reservation.
RESERVATIONRATESCALEAPPLICATION	Stores information related to an application for a rate scale on a reservation.
RESERVATIONRATESCALEFEE	Fee included in the flat rate scale for a reservation.
RESERVATIONRATESCALEPRICE	Flat rate price for a group of a specific size on a reservation.
RESERVATIONRATESCALEPROGRAM	Program included in the flat rate scale for a reservation.
RESERVATIONRATESCALERESOURCE	Resource included in the flat rate scale for a reservation.
RESERVATIONRATESCALESTAFFRESOURCE	Staffing resource included in the flat rate scale for a reservation.
RESERVATIONSECURITYDEPOSITPAYMENT	Stored payments for a reservation security deposit.
RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE	Reason code to be used for withholding a security deposit of a reservation.
RESERVATIONSTATUSHISTORY	This table contains the status history of a reservation.
RESOURCE	Stores information for resources.
RESOURCECATEGORYCODE	Category for a supply/equipment resource.
RESOURCEPRICING	Stores pricing information for resources.
RESOURCETAX	Links taxes to a supply/equipment resource.
RESPONSE	Contains responses.
RESPONSECATEGORY	Contains response categories.
REVALUECOMMITMENTSPROCESS	Contains information pertaining to the revalue foreign-denominated commitments business process.
REVALUECOMMITMENTSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the REVALUECOMMITMENTSPROCESS table.
REVENUE_EXT
REVENUEATTACHMENT	This table contains attachments belonging to revenue.
REVENUEATTACHMENTTYPECODE	Stores translations of revenue attachment types.
REVENUEAUCTIONDONATION	Stores information about auction donation revenue records.
REVENUEAUDITORIGINAL	This table contains the audit trail for rows in the dbo.REVENUE table.
REVENUEBATCHCONSTITUENTSECURITY	This table is used to store whether or not constituent security checks should be turned on for revenue batch commits.
REVENUEBBNC	Stores information about transactions downloaded from Blackbaud Internet Solutions.
REVENUEBENEFIT_EXT
REVENUEBENEFITAUDITORIGINAL	This table contains the audit trail for rows in the dbo.REVENUEBENEFIT table.
REVENUEBENEFITTEMP	Stores revenue benefit information.
REVENUECATEGORY	Stores revenue category information.
REVENUECOMMITMENTREVALUATION	Links revenue records to commitment revaluations.
REVENUEDEVELOPMENTFUNCTION	Revenue functions that a particular revenue transaction serves.
REVENUEDEVELOPMENTFUNCTIONCODE	Development functions which revenue items may serve.
REVENUEFILTER	Holds information for revenue filters.
REVENUEFUNDINGREQUEST	Associates a revenue record with a funding request.
REVENUEGLDISTRIBUTIONAUDITORIGINAL	This table contains the audit trail for rows in the dbo.REVENUEGLDISTRIBUTION table.
REVENUEGLDISTRIBUTIONREVENUESPLITMAPTEMP
REVENUEGLDISTRIBUTIONREVENUESPLITMAPTEMP2	Table to map revenue GL distribution records to revenue split records.
REVENUEGLDISTRIBUTIONTEMP	Table to store the GL distribution of revenue entered by user to override the system-generated distribution. For other revenue records this table will store the system-generated entries after post.
REVENUELETTER	Stores information pertaining to revenue details and their corresponding letters.
REVENUELETTERMARKETING	Stores information pertaining to revenue details and their corresponding marketing letters.
REVENUELIFECYCLE	Keeps track of the constituent's donor lifecycle value.
REVENUELIFECYCLECRITERIA	Contains the current constituent lifecycle criteria settings.
REVENUELIFECYCLEHISTORY	Keeps historical record of the constituent's donor lifecycle value.
REVENUELIFECYCLEPROCESS	Contains parameters used during the lifecycle value update business process.
REVENUELIFECYCLEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the REVENUELIFECYCLEPROCESS table.
REVENUELIFECYCLEREVENUECRITERIA	Contains a list of revenue types to be considered when calculating a constituent's donor lifecycle value.
REVENUELOCKBOX	Contains revenue information for a lockbox
REVENUEMATCHINGGIFT	Stores matching gifts for a revenue record.
REVENUEMEDIALINK	This table contains media links belonging to revenue details.
REVENUEMEDIALINKTYPECODE	Stores translations of revenue media link types.
REVENUEMIGRATEDCHUNK
REVENUENOTE	This table contains notes belonging to revenue details.
REVENUENOTETYPECODE	Stores translations of revenue note types.
REVENUEOFFLINEDONATION	Participant Offline Donation
REVENUEOPPORTUNITY	Associates a revenue record with an opportunity.
REVENUEOTHERTYPECODE	Stores translations for other revenue type descriptions
REVENUEPAYMENTMETHOD	Stores payment information for a revenue item
REVENUEPOSTEDDETAIL	Records details for posted transactions.
REVENUEPOSTEDTEMP	Stores the information for a posted revenue record.
REVENUERECEIPT	Stores receipt information for revenue records.
REVENUERECEIPTMARKETING	Stores marketing receipt information for revenue records.
REVENUERECEIPTRERECEIPTDETAIL	Stores details about why a receipt was re-receipted.
REVENUERECOGNITION	Stores recognition credits for a revenue entry.
REVENUERECOGNITIONDEFAULT	Stores recognition defaulting between constituents.
REVENUERECOGNITIONTYPECODE	Indicates the type of recognition credit a constituent is receiving.
REVENUEREFERENCEAUDITORIGINAL	This table contains the audit trail for rows in the dbo.REVENUEREFERENCE table.
REVENUEREFERENCETEMP	Stores reference information for revenue transactions.
REVENUESCHEDULE	Stores schedule details for a revenue detail record.
REVENUESCHEDULEDIRECTDEBITPAYMENT	Stores direct debit detail information for a pledge or recurring gift record when the payment method is direct debit.
REVENUESCHEDULESTANDINGORDERPAYMENT	Stores standing order detail information for a pledge or recurring gift record when the payment method is standing order.
REVENUESEGMENT
REVENUESOLICITOR	Stores solicitors for a revenue detail record.
REVENUESPLIT_EXT
REVENUESPLITAUDITORIGINAL	This table contains the audit trail for rows in the dbo.REVENUESPLIT table.
REVENUESPLITBUSINESSUNIT	Stores business units associated with revenue splits.
REVENUESPLITBUSINESSUNITOVERRIDECODE	Stores reasons for business unit override on a revenue split record.
REVENUESPLITCAMPAIGN	Associates a revenue split with campaigns.
REVENUESPLITGIFTAID	Stores gift aid information for each revenue split.
REVENUESPLITGIFTAIDAMOUNTS
REVENUESPLITGIFTAIDPOSTED	Stores the information for a posted revenue split gift aid record.
REVENUESPLITGIFTAIDREFUND	Stores Gift Aid refund information for each revenue split.
REVENUESPLITGIFTFEE	Contains revenue detail split gift fee information.
REVENUESPLITORDER	Stores information about order revenue applications.
REVENUESPLITOTHER	Stores information about other revenue applications
REVENUESPLITTEMP	Contains revenue detail split information for a given revenue detail record.
REVENUESTANDINGORDER	Stores data relevant for all revenue records with a standing order payment type.
REVENUETEMP	Stores revenue information for each constituent.
REVENUETRIBUTE	Stores information pertaining to revenue tributes.
REVENUETRIBUTELETTER	Stores information pertaining to revenue records and their corresponding tribute letters.
REVENUETRIBUTETAXCLAIMAMOUNT	Table to store the tax claim amount for tributes.
REVENUEVAT	Contains value added tax information for revenue records.
REVISIONLOG1	The REVISIONLOG1 table contains database revisions executed in revision number 1
REVISIONLOG10	The REVISIONLOG10 table contains database revisions executed in revision number 10
REVISIONLOG1000	The REVISIONLOG1000 table contains database revisions executed in revision number 1000
REVISIONLOG1010	The REVISIONLOG1010 table contains database revisions executed in revision number 1010
REVISIONLOG1012	The REVISIONLOG1012 table contains database revisions executed in revision number 1012
REVISIONLOG1020	The REVISIONLOG1020 table contains database revisions executed in revision number 1020
REVISIONLOG1030	The REVISIONLOG1030 table contains database revisions executed in revision number 1030
REVISIONLOG1035	The REVISIONLOG1035 table contains database revisions executed in revision number 1035
REVISIONLOG1036	The REVISIONLOG1036 table contains database revisions executed in revision number 1036
REVISIONLOG1040	The REVISIONLOG1040 table contains database revisions executed in revision number 1040
REVISIONLOG1050	The REVISIONLOG1050 table contains database revisions executed in revision number 1050
REVISIONLOG1060	The REVISIONLOG1060 table contains database revisions executed in revision number 1060
REVISIONLOG1068	The REVISIONLOG1068 table contains database revisions executed in revision number 1068
REVISIONLOG1069	The REVISIONLOG1069 table contains database revisions executed in revision number 1069
REVISIONLOG1080	The REVISIONLOG1080 table contains database revisions executed in revision number 1080
REVISIONLOG1081	The REVISIONLOG1081 table contains database revisions executed in revision number 1081
REVISIONLOG1090	The REVISIONLOG1090 table contains database revisions executed in revision number 1090
REVISIONLOG1091	The REVISIONLOG1091 table contains database revisions executed in revision number 1091
REVISIONLOG11	The REVISIONLOG11 table contains database revisions executed in revision number 11
REVISIONLOG1100	The REVISIONLOG1100 table contains database revisions executed in revision number 1100
REVISIONLOG1101	The REVISIONLOG1101 table contains database revisions executed in revision number 1101
REVISIONLOG1110	The REVISIONLOG1110 table contains database revisions executed in revision number 1110
REVISIONLOG1111	The REVISIONLOG1111 table contains database revisions executed in revision number 1111
REVISIONLOG1120	The REVISIONLOG1120 table contains database revisions executed in revision number 1120
REVISIONLOG1121	The REVISIONLOG1121 table contains database revisions executed in revision number 1121
REVISIONLOG1130
REVISIONLOG1140
REVISIONLOG1150
REVISIONLOG1160
REVISIONLOG1161
REVISIONLOG1171
REVISIONLOG1175
REVISIONLOG1180
REVISIONLOG1190
REVISIONLOG12	The REVISIONLOG12 table contains database revisions executed in revision number 12
REVISIONLOG1200
REVISIONLOG1201
REVISIONLOG1210
REVISIONLOG1211
REVISIONLOG13	The REVISIONLOG13 table contains database revisions executed in revision number 13
REVISIONLOG1300
REVISIONLOG1301
REVISIONLOG1310
REVISIONLOG1311
REVISIONLOG1320
REVISIONLOG1321
REVISIONLOG1330
REVISIONLOG1340
REVISIONLOG1341
REVISIONLOG1350
REVISIONLOG1360
REVISIONLOG1361
REVISIONLOG1370
REVISIONLOG1371
REVISIONLOG1380
REVISIONLOG1381
REVISIONLOG1390
REVISIONLOG1391
REVISIONLOG14	The REVISIONLOG14 table contains database revisions executed in revision number 14
REVISIONLOG1400
REVISIONLOG1401
REVISIONLOG1410
REVISIONLOG1411
REVISIONLOG1420
REVISIONLOG1421
REVISIONLOG1430
REVISIONLOG1431
REVISIONLOG1440
REVISIONLOG1441
REVISIONLOG1442
REVISIONLOG1450
REVISIONLOG1451
REVISIONLOG1460
REVISIONLOG1470
REVISIONLOG1471
REVISIONLOG1472
REVISIONLOG1480
REVISIONLOG1481
REVISIONLOG1482
REVISIONLOG1490
REVISIONLOG15	The REVISIONLOG15 table contains database revisions executed in revision number 15
REVISIONLOG1500
REVISIONLOG1510
REVISIONLOG1520
REVISIONLOG1530
REVISIONLOG1540
REVISIONLOG1550
REVISIONLOG1560
REVISIONLOG1570
REVISIONLOG1580
REVISIONLOG1590
REVISIONLOG16	The REVISIONLOG16 table contains database revisions executed in revision number 16
REVISIONLOG1600
REVISIONLOG1610
REVISIONLOG1620
REVISIONLOG1630
REVISIONLOG1640
REVISIONLOG1650
REVISIONLOG17	The REVISIONLOG17 table contains database revisions executed in revision number 17
REVISIONLOG18	The REVISIONLOG18 table contains database revisions executed in revision number 18
REVISIONLOG19	The REVISIONLOG19 table contains database revisions executed in revision number 19
REVISIONLOG1900
REVISIONLOG2	The REVISIONLOG2 table contains database revisions executed in revision number 2
REVISIONLOG20	The REVISIONLOG20 table contains database revisions executed in revision number 20
REVISIONLOG2000
REVISIONLOG21	The REVISIONLOG21 table contains database revisions executed in revision number 21
REVISIONLOG2100
REVISIONLOG22	The REVISIONLOG22 table contains database revisions executed in revision number 22
REVISIONLOG2200
REVISIONLOG23	The REVISIONLOG23 table contains database revisions executed in revision number 23
REVISIONLOG2300
REVISIONLOG24	The REVISIONLOG24 table contains database revisions executed in revision number 24
REVISIONLOG2400
REVISIONLOG25	The REVISIONLOG25 table contains database revisions executed in revision number 25
REVISIONLOG2500
REVISIONLOG26	The REVISIONLOG26 table contains database revisions executed in revision number 26
REVISIONLOG2600
REVISIONLOG27	The REVISIONLOG27 table contains database revisions executed in revision number 27
REVISIONLOG2700
REVISIONLOG28	The REVISIONLOG28 table contains database revisions executed in revision number 28
REVISIONLOG2800
REVISIONLOG29	The REVISIONLOG29 table contains database revisions executed in revision number 29
REVISIONLOG2900
REVISIONLOG3	The REVISIONLOG3 table contains database revisions executed in revision number 3
REVISIONLOG30	The REVISIONLOG30 table contains database revisions executed in revision number 30
REVISIONLOG3000
REVISIONLOG31	The REVISIONLOG31 table contains database revisions executed in revision number 31
REVISIONLOG3100
REVISIONLOG32	The REVISIONLOG32 table contains database revisions executed in revision number 32
REVISIONLOG3200
REVISIONLOG33	The REVISIONLOG33 table contains database revisions executed in revision number 33
REVISIONLOG3300
REVISIONLOG34	The REVISIONLOG34 table contains database revisions executed in revision number 34
REVISIONLOG3400
REVISIONLOG35	The REVISIONLOG35 table contains database revisions executed in revision number 35
REVISIONLOG3500
REVISIONLOG36	The REVISIONLOG36 table contains database revisions executed in revision number 36
REVISIONLOG3600
REVISIONLOG37	The REVISIONLOG37 table contains database revisions executed in revision number 37
REVISIONLOG3700
REVISIONLOG38	The REVISIONLOG38 table contains database revisions executed in revision number 38
REVISIONLOG3800
REVISIONLOG39	The REVISIONLOG39 table contains database revisions executed in revision number 39
REVISIONLOG3900
REVISIONLOG4	The REVISIONLOG4 table contains database revisions executed in revision number 4
REVISIONLOG40	The REVISIONLOG40 table contains database revisions executed in revision number 40
REVISIONLOG41	The REVISIONLOG41 table contains database revisions executed in revision number 41
REVISIONLOG42	The REVISIONLOG42 table contains database revisions executed in revision number 42
REVISIONLOG43	The REVISIONLOG43 table contains database revisions executed in revision number 43
REVISIONLOG44	The REVISIONLOG44 table contains database revisions executed in revision number 44
REVISIONLOG45	The REVISIONLOG45 table contains database revisions executed in revision number 45
REVISIONLOG46	The REVISIONLOG46 table contains database revisions executed in revision number 46
REVISIONLOG47	The REVISIONLOG47 table contains database revisions executed in revision number 47
REVISIONLOG48	The REVISIONLOG48 table contains database revisions executed in revision number 48
REVISIONLOG49	The REVISIONLOG49 table contains database revisions executed in revision number 49
REVISIONLOG5	The REVISIONLOG5 table contains database revisions executed in revision number 5
REVISIONLOG50	The REVISIONLOG50 table contains database revisions executed in revision number 50
REVISIONLOG51	The REVISIONLOG51 table contains database revisions executed in revision number 51
REVISIONLOG52	The REVISIONLOG52 table contains database revisions executed in revision number 52
REVISIONLOG53	The REVISIONLOG53 table contains database revisions executed in revision number 53
REVISIONLOG54	The REVISIONLOG54 table contains database revisions executed in revision number 54
REVISIONLOG55	The REVISIONLOG55 table contains database revisions executed in revision number 55
REVISIONLOG56	The REVISIONLOG56 table contains database revisions executed in revision number 56
REVISIONLOG57	The REVISIONLOG57 table contains database revisions executed in revision number 57
REVISIONLOG58	The REVISIONLOG58 table contains database revisions executed in revision number 58
REVISIONLOG59	The REVISIONLOG59 table contains database revisions executed in revision number 59
REVISIONLOG6	The REVISIONLOG6 table contains database revisions executed in revision number 6
REVISIONLOG60	The REVISIONLOG60 table contains database revisions executed in revision number 60
REVISIONLOG61	The REVISIONLOG61 table contains database revisions executed in revision number 61
REVISIONLOG62	The REVISIONLOG62 table contains database revisions executed in revision number 62
REVISIONLOG63	The REVISIONLOG63 table contains database revisions executed in revision number 63
REVISIONLOG64	The REVISIONLOG64 table contains database revisions executed in revision number 64
REVISIONLOG65	The REVISIONLOG65 table contains database revisions executed in revision number 65
REVISIONLOG7	The REVISIONLOG7 table contains database revisions executed in revision number 7
REVISIONLOG8	The REVISIONLOG8 table contains database revisions executed in revision number 8
REVISIONLOG9	The REVISIONLOG9 table contains database revisions executed in revision number 9
REVISIONRUNLOG	The REVISIONRUNLOG table contains information about a revision run, including the starting revision, the total number of revisions and any errors that may have been encountered.
REVISIONS
RoleObjectPrivs
RoleRefreshLog
SABOTEN
SALESDEPOSITPROCESS	Contains parameter information for the Sales Deposit business process.
SALESDEPOSITPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the SALESDEPOSITPROCESS table.
SALESDEPOSITPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SALESDEPOSITPROCESS table.
SALESDEPOSITTEMPLATE	Contains template information for a sales deposit.
SALESDEPOSITTEMPLATECURRENCY
SALESDEPOSITTEMPLATEPAYMENTMETHOD	Contains payment methods for a sales deposit template.
SALESDEPOSITTEMPLATESALESCHANNEL
SALESMETHOD	Sales method for a Program
SALESMETHODDELIVERYMETHOD	Contains Delivery Method for Sales Method
SALESMETHODDISCOUNT	This table links a sales type to one or more discounts.
SALESMETHODDOCUMENT	Contains Document Type and Template for Sales Channel
SALESMETHODEXCLUDEDPRICETYPE	A sales method's excluded price types.
SALESMETHODFEE	This table links a sales type to one or more fees.
SALESMETHODMARKETINGCONFIGURATION	Stores marketing configuration options for sales methods.
SALESMETHODMARKETINGSURVEYCONFIGURATION	Marketing survey questions configured for sales methods.
SALESMETHODPAYMENTMETHOD	Payment type used for a sales type
SALESORDER	This table stores information pertaining to a sales order.
SALESORDERADJUSTABLEDISCOUNT	Holds adjustable discount information for sales orders
SALESORDERALERTCONFIGURATION
SALESORDERALERTEMAILADDRESS
SALESORDERALERTEMAILSUBSCRIPTION
SALESORDERATTACHMENT	This table contains attachments belonging to sales orders.
SALESORDERATTACHMENTTYPECODE	Stores translations of sales order attachment types.
SALESORDERAVAILABLEDISCOUNTGROUPCOMBINATION	Support table for auto apply discounts - Available discount group price type combinations for the sales order.
SALESORDERBBPAYTRANSACTION
SALESORDERCLEANUPERRORLOG
SALESORDERDISCOUNTLIMITOVERRIDE	Stores information for manual override of discount limit.
SALESORDERDISCOUNTSCENARIOCOMBINATION	Support table for auto apply discounts - Valid combinations of discount scenarios for a sales order.
SALESORDERFEEDELETED	Stores fees deleted from an order.
SALESORDERITEM	Stores items that can be placed in a sales order.
SALESORDERITEMDISCOUNTOPTION	Support table for auto apply discounts - Discount options for a sales order.
SALESORDERITEMDONATION	Stores data for a donation on a sales order.
SALESORDERITEMEVENTREGISTRANTREGISTRATION	Stores static registration data with respect to when the registration was added to the order.
SALESORDERITEMEVENTREGISTRATION	Defines an order event registration on a sales order
SALESORDERITEMFACILITY	Contains facility information for a sales order item.
SALESORDERITEMFEE	Links a fee with a sales order item
SALESORDERITEMGROUP	Associates multiple Sales Order Items together.
SALESORDERITEMITEMDISCOUNT	Defines the link between a sales order item and an item-level discount
SALESORDERITEMITINERARYITEMRESOURCE	Links a supply/equipment resource with a sales order item
SALESORDERITEMITINERARYITEMSTAFFRESOURCE	Links a staffing resource with a sales order item
SALESORDERITEMITINERARYRESOURCE	Links a supply/equipment resource with a sales order item
SALESORDERITEMITINERARYSTAFFRESOURCE	Links a staffing resource with a sales order item
SALESORDERITEMMEMBER	Stores member information for a sales order item membership.
SALESORDERITEMMEMBERSHIP	Stores membership information for sales orders.
SALESORDERITEMMEMBERSHIPADDON	Stores membership add-on information for sales orders.
SALESORDERITEMMEMBERSHIPCARD	Stores membership card data for sales order item members.
SALESORDERITEMMEMBERSHIPITEMPROMOTION	Stores the item membership promotion.
SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM	Stores the sales order items that are applied to a membership promotion
SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET	Stores the tickets that are applied to a membership promotion
SALESORDERITEMMEMBERSHIPPROMO	Describes a membership promotion sales item
SALESORDERITEMMERCHANDISE	Represents a merchandise item sold as part of a sales order.
SALESORDERITEMMERCHANDISEUNIT
SALESORDERITEMORDERDISCOUNT	Defines an order discount on a sales order
SALESORDERITEMORDERDISCOUNTDETAIL	Contains a breakdown of SALESORDERITEM tickets and merchandise for order discounts.
SALESORDERITEMRE7DONATION	Stores data for a RE7 donation on a sales order.
SALESORDERITEMREVENUESCHEDULE	Schedule information for pledges and recurring gifts to be created as part of a sales order.
SALESORDERITEMSCENARIOSDONE	Support table for auto apply discounts - Keeps track of scenarios that have been completed so they are not duplicated.
SALESORDERITEMSPONSORSHIP	Sponsorship items that are part of sales orders.
SALESORDERITEMTAX	Stores data for a tax on a sales order.
SALESORDERITEMTICKET	Stores data for a ticket on a sales order.
SALESORDERITEMTICKETCOMBINATION	Stores data for a combination of tickets on a sales order.
SALESORDERITEMTICKETFEE
SALESORDERITEMTICKETREGISTRANT	Stores program event registrant information for sales orders.
SALESORDERMANUALDISCOUNT	Attaches discounts to orders
SALESORDERMARKETINGINFORMATION	Stores marketing information relative to a sales order.
SALESORDERMARKETINGSURVEYRESPONSE	Stores information about a marketing survey given in a sales order.
SALESORDERMEDIALINK	This table contains media links belonging to sales orders.
SALESORDERMEDIALINKTYPECODE	Stores translations of sales order media link types.
SALESORDERMEMBERSHIPPROMO	Holding area for membership promos added to an order
SALESORDERNOTE	This table contains notes belonging to sales orders.
SALESORDERNOTETYPECODE	Stores translations of sales order note types.
SALESORDERPAYMENT	Stores payments for a sales order.
SALESORDERRESERVEDITEM	Stores items that are reserved, how long they are reserved for, and whether they have expired
SALESORDERTAXEXEMPTINFO
SALESORDERTAXEXEMPTREASONCODE
SCHEDULE	Stores schedule information
SCHEDULEDATE	Date for a scheduled day in a school
SCHEDULEDATEADJUSTMENT	Adjustment for a scheduled day in a school
SCHEDULINGEXCEPTION	Scheduling Exceptions
SCHOLARSHIPTERM	This table contains information about a scholarship term.
SCHOOL	Indicates that a constituent is a school and has school specific fields
SCHOOLGRADELEVEL	Stores the grade levels associated with a given school.
SCREENPLAN	Plans used for screen volunteers.
SCREENPLANSTEP	Step required for completing a screening plan.
SCREENPLANSTEPCODE	This code table stores translations of screening plan steps.
Search
SEARCHCONSTITUENT
SEARCHCONSTITUENTALIASTYPE
SEARCHCONSTITUENTEXCLUDE
SEARCHLISTCATALOG	The SEARCHLISTCATALOG table stores search list definitions that define search list results and filters for a specific record type.
SEARCHLISTSETTINGS	Contains system-level configuration settings for search lists
SearchLog
SearchPart
SEARCHPART_CLIENTSITES	Association table between SearchPart records and the CMS Client Sites that they will search.
SearchType
SearchTypeContentType
SearchTypeField
SECONDARYFUNDRAISER	Stores secondary fundraisers for a prospect.
SECUREDCHILDQUERYVIEW
SECUREGATEWAYCREDENTIALS
SECUREPRINTER	Secure Printer
SELECTEDSUMMARYTILE
SEPAMANDATE
SEPAMANDATEACTIVITY
ServerStatus
SESSION	Sessions for an academic year.
SESSIONNAMECODE	Names for sessions
Setting
SFTPFINDERSERVICESCONFIGURATION
SharingPart
ShoppingCart
ShoppingCartDonation
ShoppingCartEvent
ShoppingCartMembership
ShoppingCartPart
SHOPPINGCARTSETTINGS	This table stores the settings of a shopping cart 2.0 part.
SHOPPINGCARTSETTINGSTHUMBNAILS	This table stores the category thumbnail associations for the shopping cart settings.
SHOPPINGCARTSOURCE	Holds the assemblies for the different implementations of the Payment Part 2.0
ShoppingCartSummaryPart
SIGNATURE	Signature
SIGNATUREAPPLICATION	Links a signature to one or more application types.
SIGNATUREAPPLICATIONTYPE	Application types for signatures
SignInProperties
SignOnControls
SignupTransactions
SIMPLEACKNOWLEDGEMENT	Stores information about simple acknowledgement instances.
SIMPLEACKNOWLEDGEMENTSOLICITCODES	Stores user defined solicit codes to be used to populate acknowledgement letter definition.
SIMPLEDATALISTCATALOG	The SIMPLEDATALISTCATALOG table stores simple datalist definitions that can be used to return small subsets of data for use in dropdown lists
SITE	Stores site information.
SiteCodeTableCategories
SiteCodeTableEntries
SiteCodeTables
SiteContent
SITECONTENTFOLDERS	Links CMS parts to categories for organization
SITECONTENTTAG	Represents a tag on a CMS part.
SiteContentVersion
SiteCopy
SiteCultures
SITEFILETAG
SiteFolders
SiteFolderTypes
SiteImageFolders
SiteImages
SITEIMAGESEXTENSION	Used to extend the siteimages table; link constituent id to siteimages
SITEIMAGETAG
SiteLayouts
SiteMenu
SiteNotes
SitePages
SITEPERMISSION	Stores the flattened version of a system role application user's site permissions. This table was created so that the sql would not have to walk the site hierarchy when querying on site permissions.
SitePollAnswers
SitePollResults
SitePolls
SiteProfilePhotoForm
SiteStyleSheets
SiteSurveyAnswerColumnData
SiteSurveyAnswerColumns
SiteSurveyAnswers
SiteSurveyQuestions
SiteSurveyQuestionTypes
SiteSurveyResponses
SiteSurveyResponsesDeleteTransactions
SiteSurveyResults
SiteSurveys
SITETYPECODE	Stores translations of site types.
SiteVolunteerOps
SKYACCESS
SMARTFIELD	Contains data describing smart field instances.
SMARTFIELDCATALOG	Contains SmartFieldSpec definitions.
SMARTFIELDCATEGORYCODE
SMARTFIELDSITE	Stores the selected sites for a smart field.
SMARTFIELDSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SMARTFIELD table.
SMARTFIELDVALUEGROUP	Contains data describing smart field value groups.
SMARTFIELDVALUEGROUPIDSETREGISTER	Stores associations between smart field value groups and selections.
SMARTQUERYCATALOG	The SMARTQUERYCATALOG table stores smart query definitions that define smart query results and filters for a specific record type.
SMARTQUERYINSTANCE	Each row in the SMARTQUERYINSTANCE table corresponds to a user-defined query definition, including all of the information required to build a valid sql statement.
SMARTQUERYINSTANCERUNINFO
SMARTQUERYINSTANCESTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SMARTQUERYINSTANCE table.
SOCIALMEDIAACCOUNT
SOCIALMEDIAACCOUNTTYPECODE
SOCIALMEDIASERVICE
SOCIALMEDIATEASER
SOCIALNETWORKSTATUSUPDATELOG	Log each status update to social networking sites
SOLICITCODE	Contains data describing the solicit codes.
SOLICITCODECHANNELOPTOUT
SOLICITORCREDITRULES	Stores default rules for crediting solicitors from an opportunity to new revenue.
SOLICITORROLECODE	Solicitor role code table. Used on secondary solicitors table.
SPONSOR	Indicates that the constituent is a sponsor.
SPONSORBENEFITEXTENSION	FAF Event Benefit Extension
SPONSORBENEFITOPTION
SPONSORDATERANGE	Contains the date ranges for which constituents are sponsors.
SPONSORDONATION	Sponsor Donation
SPONSORSHIP	Table that holds the relationship between a sponsor and a sponsorship opportunity
SPONSORSHIPAFFILIATEPROGRAM	Information specific to affiliate sponsorship programs.
SPONSORSHIPCANCELLATIONREPORTTENURECODE	Stores all the tenure date ranges
SPONSORSHIPCOMMITMENT	A commitment represents a history of continuous sponsorships for a constituent.
SPONSORSHIPFORMCMSSETTINGS	Settings table for the sponsor form
SPONSORSHIPGREATESTNEEDRULESET	Sponsorship greatest need rule sets.
SPONSORSHIPGREATESTNEEDRULESETREF	Table to store references from greatest need rule sets to other objects, to prevent their deletion.
SPONSORSHIPINFO	This table contains system configuration options for households.
SPONSORSHIPLOCATION	Locations for sponsorship opportunities, arranged in a hierarchy.
SPONSORSHIPLOCATIONCLOSEPROCESS	Sponsorship Location Close process parameters.
SPONSORSHIPLOCATIONCLOSEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SPONSORSHIPLOCATIONCLOSEPROCESS table.
SPONSORSHIPLOCATIONTYPECODE	Type codes for sponsorship locations.
SPONSORSHIPOPPORTUNITY	Represents generic sponsorship opportunity
SPONSORSHIPOPPORTUNITYAGERANGE	Stores age ranges for child sponsorship opportunities.
SPONSORSHIPOPPORTUNITYATTACHMENT	Stores attachments for a sponsorship opportunity
SPONSORSHIPOPPORTUNITYCHILD	Stores child sponsorship opportunities.
SPONSORSHIPOPPORTUNITYGROUP	Groups of sponsorship opportunities as needed for assignment by programs.
SPONSORSHIPOPPORTUNITYLOCK	Holds locking information for sponsorship opportunities.
SPONSORSHIPOPPORTUNITYMEDIALINK	Stores media links for a sponsorship opportunity
SPONSORSHIPOPPORTUNITYNOTE	Stores notes for a sponsorship opportunity.
SPONSORSHIPOPPORTUNITYPROJECT	Stores project sponsorship opportunities.
SPONSORSHIPOPPORTUNITYREASON	Represents reasons for pending opportunities
SPONSORSHIPOPPORTUNITYRESERVATIONCOUNTS	Table for holding the selection counts for reserving children.
SPONSORSHIPOPPORTUNITYRESERVATIONSTATUS	Table that holds status of existing reservation keys.
SPONSORSHIPOPPORTUNITYRESERVEPROCESS	Sponsorship opportunity reserve process parameters.
SPONSORSHIPOPPORTUNITYRESERVEPROCESSEXPORTFORMAT
SPONSORSHIPOPPORTUNITYRESERVEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SPONSORSHIPOPPORTUNITYRESERVEPROCESS table.
SPONSORSHIPOPPORTUNITYSEARCHCMSMASKINGIMAGES	Settings table for sponsorship opportunity search default images
SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS	Settings table for sponsorship opportunity search
SPONSORSHIPOPPORTUNITYTRANSFERPROCESS	Sponsorship opportunity transfer process parameters.
SPONSORSHIPOPPORTUNITYTRANSFERPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SPONSORSHIPOPPORTUNITYTRANSFERPROCESS table.
SPONSORSHIPPAYMENT	Relates payments made to a sponsorship commitment to a particular sponsorship.
SPONSORSHIPPROGRAM	Sponsorship Program
SPONSORSHIPREASON	Reasons for various states/actions within sponsorship.
SPONSORSHIPRECURRINGADDITIONALGIFT	Table that holds the link between the a sponsorship and the recurring additional gift.
SPONSORSHIPSTATUSCMSSETTINGS	This table stores the setting information of sponsorship display cms parts
SPONSORSHIPTERMINATEPROCESS	Sponsorship terminate process parameters.
SPONSORSHIPTERMINATEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SPONSORSHIPTERMINATEPROCESS table.
SPONSORSHIPTRANSACTION	Tracks information regarding a change to a sponsorship commitment.
SPONSORSHIPTRANSFERPROCESS	Sponsorship transfer process parameters.
SPONSORSHIPTRANSFERPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SPONSORSHIPTRANSFERPROCESS table.
SPROPPATTACHMENTTYPECODE	Specifies an attachment type for documentation on a sponsorship opportunity
SPROPPCHILDCONDITIONCODE	Condition Code for Child Sponsorship Opportunity
SPROPPMEDIALINKTYPECODE	Specifies a media link type for documentation on a sponsorship opportunity
SPROPPNOTETYPECODE	Specifies a note type for documentation on a sponsorship opportunity
SPROPPPROJECTCATEGORYCODE	Store project categories for a sponsorship opportunity of type project.
SQLFUNCTIONCATALOG	The SQLFUNCTIONCATALOG table contains meta data about application related stored functions added to the system.
SQLPROCEDURECATALOG	The SQLPROCEDURECATALOG table contains meta data about application related stored procedures added to the system.
SQLVIEWCATALOG	Catalog for SQL view spec
STAFFDATERANGE	Contains the date ranges for which constituents are staff.
STANDINGORDERPAYMENTMETHODDETAIL	Stores standing order detail information for a revenue record when the payment method is standing order.
STANDINGORDERREFERENCENUMBEROFFSET	Stores the offset for standing order reference numbers, set at deploy time.
STANDINGORDERSEXPORTPROCESS	Contains information pertaining to the standing orders export business process.
STANDINGORDERSEXPORTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the STANDINGORDERSEXPORTPROCESS table.
STANDINGORDERSEXPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the STANDINGORDERSEXPORTPROCESS table.
STANDINGORDERSIMPORTPROCESS	Contains information pertaining to the standing orders import business process.
STANDINGORDERSIMPORTPROCESSEXCEPTION	Contains a list of exceptions that occurred during the execution of a standing orders import process.
STANDINGORDERSIMPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the STANDINGORDERSIMPORTPROCESS table.
STANDINGORDERSIMPORTTEMPLATE	Template used for importing standing order files.
STANDINGORDERSIMPORTTEMPLATEFIELD	Fields to use in the standing orders import process.
STATE	Contains definitions of states.
STATEHOUSEDISTRICTCODE	This code table stores the translations of state house districts.
STATESENATEDISTRICTCODE	This code table stores the translations of state senate districts.
StatisticsDayPage
StatisticsDaySite
StatisticsMonthPage
StatisticsMonthSite
Stats
STEWARDSHIPATTACHMENT	This table contains attachments belonging to stewardship plans and steps.
STEWARDSHIPATTACHMENTTYPECODE	Stores translations of stewardship attachment types.
STEWARDSHIPEXCHANGECALENDARITEM	Contains a list of stewardship steps added as calendar items to the Exchange server.
STEWARDSHIPMEDIALINK	This table contains media linked to stewardship plans and steps.
STEWARDSHIPMEDIALINKTYPECODE	Stores translations of stewardship media link types.
STEWARDSHIPNOTE	Contains stewardship plan notes.
STEWARDSHIPNOTETYPECODE	Stores translations of stewardship note types.
STEWARDSHIPPACKAGEPROCESS	Contains information pertaining to the stewardship package business process.
STEWARDSHIPPACKAGEPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the STEWARDSHIPPACKAGEPROCESS table.
STEWARDSHIPPACKAGEPROCESSHISTORY	Contains history information pertaining to stewardship packages.
STEWARDSHIPPACKAGEPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the STEWARDSHIPPACKAGEPROCESS table.
STEWARDSHIPPLAN	Contains stewardship plans.
STEWARDSHIPPLANASSIGNMENTPROCESS	Stewardship plan assignment process parameters.
STEWARDSHIPPLANASSIGNMENTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the STEWARDSHIPPLANASSIGNMENTPROCESS table.
STEWARDSHIPPLANMANAGERHISTORY	Stores historical information on stewardship plan managers.
STEWARDSHIPPLANSITE	Contains sites associated with stewardship plans.
STEWARDSHIPPLANSTEP	Contains stewardship plan steps.
STEWARDSHIPPLANSTEPPARTICIPANT	The participants in a prospect plan.
STEWARDSHIPPLANSTEWARD	Contains stewardship plan stewards...
STEWARDSHIPPLANSUBTYPECODE	This table stores translations of stewardship plan subtypes.
STEWARDSHIPPLANTEMPLATE	Contains stewardship plan templates.
STEWARDSHIPPLANTEMPLATESITE	Information regarding the sites associated with a stewardship plan template
STEWARDSHIPPLANTEMPLATESTEP	Contains stewardship plan template steps.
STEWARDSHIPPLANTYPECODE	This table stores translations of stewardship plan types.
STEWARDSHIPRECIPIENTTYPECODE	A type code that is associated with a stewardship recipient.
STEWARDSHIPSTEPASSOCIATEDPLAN	Contains associations between stewardship steps and other major giving plans.
STEWARDSHIPSTEPCATEGORYCODE	Stores the stewardship plan step categories.
STEWARDSHIPSTEWARDROLECODE	Stores the roles which can be assigned to a stewardship plan steward.
STOCKDETAIL	Stores stock detail information for a revenue records with a payment type of Stock
STOCKSALE_EXT
STOCKSALEADJUSTMENT	Stores adjustments made to posted sold stock sale.
STOCKSALEAUDITORIGINAL	This table contains the audit trail for rows in the dbo.STOCKSALE table.
STOCKSALEGLDISTRIBUTIONTEMP	Table to store the GL distribution of sold stock entered by user to override the system-generated distribution. For other sold stock records this table will store the system-generated entries after post.
STOCKSALETEMP	Stores details about a stock sale.
STORY	Creates the story table
STUDENT	Indicates that a constituent is a Student and contains student-specific fields.
STUDENTADVISOR	This table contains the entries that map an advisor to a student progression.
STUDENTCHARGE	This table contains the student information of a charge record.
STUDENTCLASSMEETINGGROUP	This table contains information about the class meetings associated to a student.
STUDENTCONSTITUENCYSETTINGS	Contains a list of settings for the student constituency that need to be used across all users and within the database.
STUDENTCOURSE	This table contains information about the relationship between students and courses.
STUDENTCOURSEREQUEST	This table contains information about student requests for courses.
STUDENTMARKINGCOLUMNGRADE	Grade received by a student for a specific Student Class Meeting Group and Marking Column
STUDENTPAYMENTPARTEE7SETTINGS	Holds information about an instance of the student payment EE7 part.
STUDENTPROGRESSION	This table contains the progression information for each student.
STUDENTRELATIONCONSTITUENCYSETTINGS	Contains a list of settings to determine constituency for records with a relationship to a student.
STUDENTRELATIONCONSTITUENCYTYPES	Contains the relationship types that are considered to be constituents when related to a student
STUDENTSKILL	Information describing a student skill used for grading.
STUDENTSKILLCATEGORYCODE	The category for a student skill.
STUDENTSKILLCOURSE	This table links skills and courses that use them.
STUDENTSKILLCOURSEMARKINGCOLUMN	Link between a student skill on a course and marking column in which it is used.
STUDENTSKILLGRADELEVEL	This table links skills and grade levels that use them.
STUDENTSKILLRATING	The rating table describes scores available for student skills.
STUDENTSKILLRATINGGROUP	The rating group describes collections of the scores available for student skills.
STUDENTSKILLSCHOOL	This table links skills and schools that use them.
StyleSheetClasses
SUFFIXCODE	This code table stores translations of suffix codes.
SUGGESTEDMEMBERSHIPLEVEL	Contains the money ranges for the Suggested Membership Level BBA Score.
SUMMARYTILECONTEXT
SURVEY	Contains information about surveys.
SURVEYATTACHMENT	This table contains attachments belonging to survey.
SURVEYATTACHMENTTYPECODE	Stores translations of survey attachment types.
SURVEYCATEGORYCODE	Stores survey categories
SURVEYDOWNLOADPROCESS	Contains parameter settings used in the survey response download business process.
SURVEYDOWNLOADPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SURVEYDOWNLOADPROCESS table.
SURVEYMEDIALINK	This table contains notes belonging to survey.
SURVEYMEDIALINKTYPECODE	Stores translations of survey media link types.
SURVEYNOTE	This table contains notes belonging to survey.
SURVEYNOTETYPECODE	Stores translations of survey note types.
SURVEYRESPONSE	Contains information about survey questions and responses.
SYNCMERCHANTACCOUNTSPROCESS	Stores information pertaining to a sync merchant account parameter set.
SYNCMERCHANTACCOUNTSPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the SYNCMERCHANTACCOUNTSPROCESS table.
SYSTEMPRIVILEGECATALOG	Contains abstract system actions requiring permissions that are not directly associated with another object.
SYSTEMROLE
SYSTEMROLE_CONSTIT_SECURITY_ATTRIBUTE	This table contains the groups applied to system roles.
SYSTEMROLEADGROUP	Active Directory groups whose users will be granted access to this system role.
SYSTEMROLEADGROUPCONSTITUENTSECURITY	Contains data describing the constituent security group that an application user is assigned for a given system role.
SYSTEMROLEADGROUPSITE	Contains data describing the site that a system role group will be assigned when the group is synchronized.
SYSTEMROLEAPPUSER	Contains data describing what system role an application user has been assigned.
SYSTEMROLEAPPUSERACCOUNTINGELEMENTSECURITY	This table contains the accounting element security groups that an application user is assigned for a given system role.
SYSTEMROLEAPPUSERCONSTITUENTSECURITY	Contains data describing the constituent security group that an application user is assigned for a given system role.
SYSTEMROLEAPPUSERSITE	Contains data describing the site that an application is assigned for a given system role.
SYSTEMROLEKPIINSTANCE	System permissions for KPI instances.
SYSTEMROLEPERM_ADHOCQUERYFOLDER	System permissions for ad-hoc query folder.
SYSTEMROLEPERM_ADHOCQUERYINSTANCE	System permissions for Ad-hoc query instance
SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT	System permissions for editing Ad-hoc query instance
SYSTEMROLEPERM_ATTRIBUTECATEGORY	System permissions for attribute categories
SYSTEMROLEPERM_BATCHTEMPLATE	System permissions for Batch Template
SYSTEMROLEPERM_BATCHTEMPLATEAPPROVER	System permissions for Batch Approvers
SYSTEMROLEPERM_BATCHTEMPLATECUSTOMIZE	System permissions for customizing a Batch Template
SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR	System permissions for Batch Processors
SYSTEMROLEPERM_BATCHTYPE	System permissions for Batch Type
SYSTEMROLEPERM_BATCHWORKFLOWSTATE	System permissions for Batch Workflow State
SYSTEMROLEPERM_BUSINESSPROCESS	System permissions for BusinessProcessSpecs
SYSTEMROLEPERM_BUSINESSPROCESSINSTANCE	System permissions for business process instance
SYSTEMROLEPERM_CODETABLE	System permissions for CodeTableSpecs
SYSTEMROLEPERM_CODETABLEENTRY	System permissions for code table entries.
SYSTEMROLEPERM_DASHBOARD	System permissions for dashboard specs
SYSTEMROLEPERM_DATAFORMINSTANCE	System permissions for DATAFORMSpecs
SYSTEMROLEPERM_DATALIST	System permissions for DataList features
SYSTEMROLEPERM_FEATUREGROUP
SYSTEMROLEPERM_KPI	System permissions for KPI
SYSTEMROLEPERM_MAPENTITY	System permissions for Map Entities.
SYSTEMROLEPERM_QUERYVIEW	System permissions for QueryViewCatalog source views
SYSTEMROLEPERM_RECORDOPERATION	System permissions for RecordOperationSpecs
SYSTEMROLEPERM_REPORT	System permissions for Report features
SYSTEMROLEPERM_SEARCHLIST	System permissions for search lists
SYSTEMROLEPERM_SELECTION	System permissions for selections
SYSTEMROLEPERM_SMARTQUERY	System permissions for SmartQuerySpecs
SYSTEMROLEPERM_SMARTQUERYINSTANCE	System permissions for Smart Query instance
SYSTEMROLEPERM_SYSTEMPRIVILEGE	System permissions for System privileges
SYSTEMROLETASK	The SYSTEMROLETASK table indicates which tasks have been assigned to which system roles.
SYSTEMROLEWEBDASHBOARDPAGE	System edit and view permissions for shared web dashboard pages.
TABLECATALOG	The TABLECATALOG table contains meta data about each data table in the system.
TAGCODE	Stores tags that can be applied to records across record types.
TAIMPORTIDMAP	This table contains the TA Import IDs from the TA import process.
TARGETCODE	This code table stores translations of target codes.
TargetedContentChecks
TargetedContentPart
TARGETGIFTRANGE	Contains the money ranges for the Target Gift Range BBA Score.
TASKCATALOG	The TASKCATALOG table stores meta data about each task available in the system.
TASKWIZARDCATALOG	Catalog for Task Wizard specs
TAX	Contains Name and Description for a Tax
TAXDECLARATION	Stores tax declaration information for each constituent.
TAXENTITYCODE	This code table stores Tax Entities for a Tax
TAXGLMAPPING	Stores the GL mapping for a tax.
TAXID	This contains all tax IDs.
TAXITEM	An Item belonging to a specific Tax
TAXSTATUSCODE	This code table stores translations of tax status codes.
TEAMEXTENSION	Additional fields related to team
TEAMFUNDRAISER	Stores information pertaining to team fundraisers.
TEAMFUNDRAISINGTEAM	Stores information pertaining to team fundraising teams.
TEAMFUNDRAISINGTEAMCAPTAIN	Stores information pertaining to team captains in an team fundraising hierarchy.
TEAMFUNDRAISINGTEAMGROUP	Links teams from different appeals.
TEAMFUNDRAISINGTEAMMEMBER	Stores information pertaining to team fundraisers as they appear in a team fundraising hierarchy.
TEAMWIDGET	Widgets available for Team
TempData
TERM	Terms for a Session
TERMNAMECODE	Names for terms
THEME	A Theme represents a layout, a template, and one or more style sheets.
THEMELAYOUT	Layouts available to pages using this theme
THEMESTYLESHEET	Stylesheets to apply to pages using this theme
THIRDPARTYSUPPORT
TICKET	Stores data related to a ticket.
TICKETPRINTINFO	Holds information about an individual copy of a ticket
TICKETREPRINTREASONCODE	Describes why a reprint of a ticket was necessary
TICKETSCANNINGCONFIGURATION
TIERCODE	Stores translation of program tiers for membership and recognition programs.
TIMESHEET	Time sheets for a volunteer who worked on a job occurrence.
TIMETABLE	Timetable
TIMETABLEDAY	Timetable Days
TIMETABLEDAYPERIOD	Timetable Day Periods
TimeZone
TIMEZONEENTRY	Contains definitions of time zones.
TIMEZONEENTRYADJUSTMENTRULE	Contains daylight savings time rule information for time zones
TITLECODE	This code table stores translations of title codes.
TITLECODECONFIGURATION	Associate the title code table with additional information such as gender.
TOKENIZERUSERCONFIG
TRACK	Table to store basic track information.
TRACKITEM	Daily programs, events, and custom items for a track.
TRACKITEMRESOURCE	Contains the resources and quantity of those resources used for a track item.
TRACKITEMSTAFFRESOURCE	Describes the staff resources used by the track item.
TRACKRESOURCE	Lists the resources used by a track.
TRACKSTAFFRESOURCE	Describes the staff resources used by the track.
Transactions
TRANSLATIONFUNCTIONCATALOG	The TRANSLATIONFUNCTIONCATALOG table stores translation function definitions that allow IDs of a specific record type to be translated into a friendly name
TRANSLATIONTABLE	Holds translation tables which define numeric equivalents for non-numeric grades.
TRANSLATIONTABLEGRADE	Holds grades and their numeric equivalents.
TRIBUTE	Stores information pertaining to tributes.
TRIBUTEACKNOWLEDGEE	Stores information pertaining to tribute acknowledgees.
TRIBUTEACKNOWLEDGEMENTPROCESS	Contains information pertaining to the tribute acknowledgement business process.
TRIBUTEACKNOWLEDGEMENTPROCESSEXPORTFORMAT	Serves as a join table to the BUSINESSPROCESSEXPORTFORMAT table for the TRIBUTEACKNOWLEDGEMENTPROCESS table.
TRIBUTEACKNOWLEDGEMENTPROCESSNAMEFORMAT	Contains name format information pertaining to the tribute acknowledgement process.
TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the TRIBUTEACKNOWLEDGEMENTPROCESS table.
TRIBUTEEXTENSION	Extension to TRIBUTE table
TRIBUTELETTERCODE	Stores information pertaining to tribute letters.
TRIBUTELETTERCODESITE	Information regarding the sites associated with a tribute letter.
TRIBUTESITE	Contains information pertaining to a tribute's sites.
TRIBUTETYPECODE	Stores translations for tribute type codes.
TURBOPARSEDICTIONARY
UIWIDGETCATALOG	Stores metadata about UI widgets.
UIWIDGETCATEGORY	Contains categories to which UI widgets can be associated.
UIWIDGETCATEGORYLINK	Links a UI widget to one or more UI widget categories.
UNREALIZEDGAINLOSSADJUSTMENT	Stores adjustments made to posted unrealized gains and losses.
UNREALIZEDGAINLOSSGLDISTRIBUTIONTEMP	Table to store GL distributions for unrealized gains and losses.
UNSETTLEDCREDITCARDTRANSACTION
UNSUPPORTEDPAYMENTGATEWAYS
UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS	Contains parameter information for the Update Multiple Constituents from MatchFinder Online business process.
UPDATEMULTIPLECONSTITUENTFROMMFOPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS table.
UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH	Stores data for the Update Constituents From MatchFinder Online batch.
UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHSYSTEMMESSAGES
UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHUSERMESSAGE	Auto-generated table to handle error/rejection/exception messages for the UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH batch table
USAGEREPORTPROCESS	Contains parameters used for the application usage report process.
USAGEREPORTPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the USAGEREPORTPROCESS table.
USERDEFINEDATTACHMENTTYPECODE	Stores translations of user-defined element attachment types.
USERDEFINEDELEMENT	This holds all the user-defined element types.
USERDEFINEDELEMENTATTACHMENT	This table contains attachments belonging to user-defined element.
USERDEFINEDELEMENTMEDIALINK	This table contains notes belonging to user-defined element.
USERDEFINEDELEMENTNOTE	This table contains notes belonging to user-defined element.
USERDEFINEDMEDIALINKTYPECODE	Stores translations of user-defined element media link types.
USERDEFINEDNOTETYPECODE	Stores translations of user-defined element note types.
UserImport
userImportLog
UserImportMasterList
UserMap
USERPAGEHISTORY	The USERPAGEHISTORY table stores the recent history for each page by user
UserPageManager
UserPageManagerPageTemplates
UserPages
UserPagesEditors
UserPersonalPages
UserRoles
USERSETTINGS	The USERSETTINGS table stores application settings for each APPUSER
USERSETTINGSBATCHTEMPLATE
USERSETTINGSCALENDAR	Contains information about persisted calendar settings per user.
USERSETTINGSCONSTITUENTSUMMARYTILES
USERSETTINGSDATAFORM	Contains information about data form customizations per user.
USERSETTINGSDATALIST	Contains information about data list customizations per user.
USERSETTINGSINFORMATIONLIBRARYHIERARCHY
USERSETTINGSLISTBUILDER
USERSETTINGSPAGE
USERSETTINGSSEARCHLIST
USERSETTINGSSEARCHLISTTASKHISTORY	Contains information about a user's search list task history per user.
VanityURL
VATTAXRATE	Contains value added tax rates.
VENDOR	Payables Vendor
VENDOR1099ADJUSTMENT	All vendor 1099 adjustments
VENDOR1099DISTRIBUTION	All vendor 1099 distributions.
VENDOR1099SETTING	All vendor 1099 settings.
VENMOPAYMENTMETHODDETAIL
VIDEO	Links videos to participants
VOLUNTEER	Indicates that a constituent is a volunteer and contains volunteer-specific fields.
VOLUNTEERADMINISTRATIVE	Administrative information for a volunteer.
VOLUNTEERADMINISTRATIVECODE	This code table stores translations of administrative codes.
VOLUNTEERASSIGNMENT	Dates when a volunteer is assigned to a job occurrence.
VOLUNTEERATTACHMENT	This table contains attachments belonging to volunteers.
VOLUNTEERATTACHMENTTYPECODE	Stores translations of volunteer attachment types.
VOLUNTEERAVAILABILITY	Dates when a volunteer is available.
VOLUNTEERAWARD	Awards that can be assigned to volunteers
VOLUNTEERAWARDASSIGNMENT	Information about awards that have been assigned to volunteers
VOLUNTEERAWARDTYPECODE	Translations of the types of volunteer awards
VOLUNTEERCERTIFICATION	Certifications for a volunteer.
VOLUNTEERCERTIFICATIONCODE	This code table stores translations of certification codes.
VOLUNTEERCOURSE	Courses for a volunteer.
VOLUNTEERCOURSECODE	This code table stores translations of course codes.
VOLUNTEERDATERANGE	Contains the date ranges for which constituents are volunteers.
VOLUNTEERINTEREST	Interests for a volunteer.
VOLUNTEERINTERESTCODE	This code table stores translations of interest codes.
VOLUNTEERLICENSE	Licenses for a volunteer.
VOLUNTEERLICENSECODE	This code table stores translations of license codes.
VOLUNTEERLOCATIONCODE	This code table stores translations of location.
VOLUNTEERMEDIALINK	This table contains media links belonging to volunteers.
VOLUNTEERMEDIALINKTYPECODE	Stores translations of constituent media link types.
VOLUNTEERMEDICAL	Medical information for a volunteer.
VOLUNTEERMEDICALCODE	This code table stores translations of medical codes.
VOLUNTEERNOTE	This table contains notes belonging to volunteers.
VOLUNTEERNOTETYPECODE	Stores translations of volunteer note types.
VOLUNTEERSCREENPLAN	Screen Plan assigned to a volunteer.
VOLUNTEERSCREENPLANSTEP	Step required for completing a screen plan.
VOLUNTEERSKILL	Skills and levels for a volunteer.
VOLUNTEERSKILLCODE	This code table stores translations of skill codes.
VOLUNTEERSKILLLEVEL	Skill levels available.
VOLUNTEERSPECIALNEED	Special Needs for a volunteer.
VOLUNTEERSPECIALNEEDCODE	This code table stores translations of special needs.
VolunteerTransactions
VOLUNTEERTYPE	Type of volunteer.
VOLUNTEERTYPEPRICING	Stores pricing information for staffing resources.
VOLUNTEERTYPETAX	Links taxes to a staffing resource.
VOLUNTEERVOLUNTEERLOCATION	Department for a volunteer location.
VOLUNTEERVOLUNTEERTYPE	Department for a volunteer type.
VSECATEGORY	Table of VSE categories used by the VSE report.
VSECONSTITUENCY	Table of VSE constituencies used by the VSE report.
VSECONSTITUENCYMAP	Map constituencies to VSE constituencies.
VSESUBCATEGORY	Contains VSE subcategories for further organization of designations.
VSETYPE	Table to store the type of VSE report to run for this organization.
WEALTH	Contains wealth information about constituents.
WEALTHCAPACITY	Contains giving wealth information for a constituent.
WEALTHCAPACITYFORMULA	Contains the formulas defined for determining wealth capacity.
WEALTHCAPACITYFORMULABUSINESSOWNERSHIPSOURCE	Contains business ownership sources to use for a given Wealth Capacity formula.
WEALTHCAPACITYFORMULAINCOMECOMPENSATIONSOURCE	Contains income compensation sources to use for a given Wealth Capacity formula.
WEALTHCAPACITYFORMULANONPROFITAFFILIATIONSOURCE	Contains nonprofit affiliation sources to use for a given Wealth Capacity formula.
WEALTHCAPACITYFORMULAOTHERASSETSOURCE	Contains other asset sources to use for a given Wealth Capacity formula.
WEALTHCAPACITYFORMULAPHILANTHROPICGIFTSOURCE
WEALTHCAPACITYFORMULAPOLITICALDONATIONSOURCE
WEALTHCAPACITYFORMULAPRIVATEFOUNDATIONSOURCE	Contains private foundation sources to use for a given Wealth Capacity formula.
WEALTHCAPACITYFORMULAREALESTATESOURCE	Contains real estate sources to use for a given Wealth Capacity formula.
WEALTHCAPACITYFORMULASECURITIESSOURCE	Contains securities sources to use for a given Wealth Capacity formula.
WEALTHESTIMATORRATING	Contains the money ranges for the Wealth Estimator Rating BBA Score.
WEALTHPOINTCONFIGURATION	Contains WealthPoint configuration settings.
WEALTHPOINTCREDENTIALS	Contains the usernames and passwords for the WealthPoint service.
WEALTHPOINTDATAREFRESHNOTIFICATION	Contains all the active WealthPoint Data Refresh Notifications.
WEALTHPOINTDATAREFRESHNOTIFICATIONFIELD	Contains the WealthPoint fields for which a Data Refresh notification can be valid.
WEALTHPOINTSEARCHPARAMETERS	This table holds the parameters for a WealthPoint search business process.
WEALTHPOINTSEARCHPARAMETERSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the WEALTHPOINTSEARCHPARAMETERS table.
WEALTHSOURCE	Contains all of the built-in and custom wealth sources.
WEALTHSOURCEMAPPING	Contains mappings of Built-in Wealth sources to the wealth tables.
WEALTHSOURCEREFRESHDATE	Contains information on last refresh data for refreshable wealth sources.
WEBADDRESSTYPECODE	This code table stores translations of web address type codes.
WEBDASHBOARDCONTEXTRECORDHISTORY	Contains a list of recently viewed records for the web dashboard.
WEBDASHBOARDFOLDER	Contains a list of of folders to which dashboard pages can belong.
WEBDASHBOARDLAYOUT	Stores various layouts for use on a web dashboard.
WEBDASHBOARDPAGE	Stores pages for an individual's web dashboard.
WEBDASHBOARDPAGECATALOG	Stores pages for an individual's web dashboard.
WEBDASHBOARDPERSONALIZATIONALLUSERS	Contains the shared data for a web dashboard page.
WEBDASHBOARDPERSONALIZATIONPERUSER	Contains the individual user's personalization data for a web dashboard page.
WEBERRORLOG
WEBFORMSUSERREGISTRATIONPARTSETTING
WIDGETEXTENSION	Widget Extension Details - This is an extension table for EVENTWIDGET, PARTICIPANTWIDGET and TEAMWIDGET
WIDGETGALLERY	Widget Gallery
Workflow
WorkflowRoles
WORKINGCAPITALCODE	Code table hold the Account Code Working Capital.
WORKSTAGE	This holds work stage entries for each data element type.
WORKSTATION	Describes a computer on the network.
WORKSTATIONCASHDRAWEROPEN	Holds information for when a cash drawer was manually opened
WORKSTATIONCASHDRAWEROPENREASONCODE	Describes why opening a workstation cash drawer was necessary
WORKSTATIONCASHDRAWERPAYMENTMETHOD	Holds payment methods which cause the cash drawer on a workstation to open.
WORKSTATIONPRINTER	Describes a printer attached to a workstation.
WPAFFLUENCEINDICATOR	Contains WealthPoint Affluence Indicator data.
WPBATCHSCREENINGPROCESS	Contains information pertaining to the WealthPoint batch screening business process.
WPBATCHSCREENINGPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the WPBATCHSCREENINGPROCESS table.
WPBIOGRAPHICAL	Contains WealthPoint Biographical data.
WPBIOGRAPHICALDEMOGRAPHIC
WPBIOGRAPHICALHHMEMBER
WPBIOGRAPHICALHISTORY	Contains WealthPoint Biographical history data.
WPBUSINESSOWNERSHIP	Contains WealthPoint Business Ownership data.
WPBUSINESSOWNERSHIPBIOS	Contains WealthPoint Business Ownership Bios data.
WPBUSINESSOWNERSHIPBIOSHISTORY	WealthPoint Business Ownership Bios data history table.
WPBUSINESSOWNERSHIPHISTORY	Contains WealthPoint Business Ownership history data.
WPBUSINESSOWNERSHIPOWNERSHIP	Contains WealthPoint Business Ownership Ownership Information data.
WPBUSINESSOWNERSHIPOWNERSHIPHISTORY	WealthPoint Business Ownership Ownership Information data history table.
WPINCOMECOMPENSATION	Contains WealthPoint Income/Compensation data.
WPINCOMECOMPENSATION_WPSEARCHHISTORY
WPNONPROFITAFFILIATION	Contains WealthPoint Nonprofit Affiliations data.
WPNONPROFITAFFILIATIONHISTORY	Contains WealthPoint Nonprofit Affiliations history data.
WPOTHERASSET	Contains WealthPoint Other Asset data.
WPPARSINGERROR	Contains errors caught parsing the results of WealthPoint searches.
WPPHILANTHROPICGIFT	Contains WealthPoint Philanthropic Gift data.
WPPHILANTHROPICGIFTCATEGORY
WPPOLITICALDONATION	Contains WealthPoint Political Donation data.
WPPRIVATEFOUNDATION	Contains WealthPoint Private Foundation data.
WPPRIVATEFOUNDATIONHISTORY	Contains WealthPoint Private Foundation history data.
WPREALESTATE	Contains WealthPoint Real Estate data.
WPREALESTATE_WPSEARCHHISTORY
WPREALESTATEHISTORY	Contains WealthPoint Real Estate history data.
WPRELATIONSHIP_BO	Contains WealthPoint Business Ownership Relationship information.
WPRELATIONSHIP_BO_IND	Contains WealthPoint Business Ownership relationship individual information.
WPRELATIONSHIP_NPA	Contains WealthPoint Nonprofit Affiliation Relationship information.
WPRELATIONSHIP_NPA_IND	Contains WealthPoint Nonprofit Affiliation relationship individual information.
WPRELATIONSHIP_PF	Contains WealthPoint Private Foundation Relationship information.
WPRELATIONSHIP_PF_IND	Contains WealthPoint Private Foundation relationship individual information.
WPRESEARCHGROUPSEARCHPROCESS	Contains information pertaining to the WealthPoint research group search business process.
WPRESEARCHGROUPSEARCHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the WPRESEARCHGROUPSEARCHPROCESS table.
WPSEARCHHISTORY	Contains a record of each WealthPoint search.
WPSEARCHHISTORYSELECTEDCONSTITUENT
WPSEARCHPROCESS	Contains information pertaining to the WealthPoint search business process.
WPSEARCHPROCESSSTATUS	Serves as a join table to the BUSINESSPROCESSSTATUS table for the WPSEARCHPROCESS table.
WPSECURITIES	Contains WealthPoint Securities data.
WPSECURITIESHISTORY	Contains WealthPoint Securities history data.
WPSECURITIESTRANSACTION	Contains WealthPoint Securities Transactions data.
WPSOCIAL
WPSOCIALIMAGE
WPSOCIALPROFILE
WRITEOFF_EXT
WRITEOFFADJUSTMENT	Stores adjustments made to posted write-off.
WRITEOFFGLDISTRIBUTIONTEMP	Table to store the GL distribution of write-off entered by user to override the system-generated distribution. For other installment write-off records this table will store the system-generated entries after post.
WRITEOFFREASONCODE	Stores write-off reason codes.
WRITEOFFSPLITTEMP	Contains write-off split information for a given write-off record.
WRITEOFFTEMP	Stores write-off information for each pledge or MG pledge gift.
WSREQUESTLOG	The WSREQUESTLOG table is used to log web service request and reply message details.
ZIPCITYSTATE	Stores city and state information for zip codes.