Blackbaud Enterprise CRM Views

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

View Description
AUCTIONPURCHASEGLDISTRIBUTION
BANKACCOUNTDEPOSITCORRECTION
BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION
BANKACCOUNTTRANSACTION
BANKACCOUNTTRANSACTIONGLDISTRIBUTION
BATCHADDRESSVALIDATIONBATCHSYSTEMMESSAGE
BATCHAMPROIMPORTBATCHSYSTEMMESSAGE
BATCHAUCTIONITEMBATCHSYSTEMMESSAGE
BATCHBBNCDONATIONBATCHSYSTEMMESSAGE
BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGE
BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE
BATCHBBNCPROFILEBATCHSYSTEMMESSAGE
BATCHBBNCSIGNUPBATCHSYSTEMMESSAGE
BATCHCOAUPDATEBATCHSYSTEMMESSAGE
BATCHCONSTITUENTADDRESSUPDATEBATCHSYSTEMMESSAGE
BATCHCONSTITUENTBATCHSYSTEMMESSAGE
BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGE
BATCHCURRENCYEXCHANGERATEBATCHSYSTEMMESSAGE
BATCHDECEASEDFINDERBATCHSYSTEMMESSAGE
BATCHDESIGNATIONLEVELFINANCIALINFOBATCHSYSTEMMESSAGE
BATCHDIRECTDEBITRETURNBATCHSYSTEMMESSAGE
BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGE
BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGE
BATCHEMAILFINDERBATCHSYSTEMMESSAGE
BATCHEVENTBATCHSYSTEMMESSAGE
BATCHEVENTREGISTRANTBATCHSYSTEMMESSAGE
BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGE
BATCHGIVINGSUMMARYUPDATEBATCHSYSTEMMESSAGE
BATCHINTERACTIONBATCHSYSTEMMESSAGE
BATCHMEMBERSHIPBATCHSYSTEMMESSAGE
BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGE
BATCHMERCHANDISEINVENTORYBATCHSYSTEMMESSAGE
BATCHMODELINGANDPROPENSITYBATCHSYSTEMMESSAGE
BATCHMODELINGANDPROPENSITYUPDATEBATCHSYSTEMMESSAGE
BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGE
BATCHPEOPLEFINDERBATCHSYSTEMMESSAGE
BATCHPHONEFINDERBATCHSYSTEMMESSAGE
BATCHPLEDGEWRITEOFFBATCHSYSTEMMESSAGE
BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGE
BATCHREVENUEBATCHSYSTEMMESSAGE
BATCHSPONSORSHIPBATCHSYSTEMMESSAGE
BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGE
BATCHTIMESHEETBATCHSYSTEMMESSAGE
BENEFITGLDISTRIBUTION
CONSTITUENCYSYSTEMNAME
CONSTITUENTSUMMARYAVAILABLETILE
CONSTITUENTSUMMARYSELECTEDTILE
CREDIT
CREDITGLDISTRIBUTION
CREDITITEM
DONATIONBATCHBATCHSYSTEMMESSAGE
EXCHANGECALENDARITEMBATCHBATCHSYSTEMMESSAGE
EXCHANGECONTACTBATCHBATCHSYSTEMMESSAGE
EXCHANGEEMAILBATCHBATCHSYSTEMMESSAGE
FAFEVENTBATCHBATCHSYSTEMMESSAGE
GIFTAIDGLDISTRIBUTION
GIFTFEEGLDISTRIBUTION
GIFTINKINDSALE
GIFTINKINDSALEGLDISTRIBUTION
GLACCOUNTBATCHBATCHSYSTEMMESSAGE
GLTRANSACTION
INSTALLMENTPAYMENT
INSTALLMENTWRITEOFF
MerchantAccountFormUsage
MerchantAccountUsage
NEWGUID
PDACCOUNTSEGMENTMAPPINGVIEW
PDACCOUNTSYSTEMFORREVENUE
PDCOMPOSITESEGMENTMAPPINGVIEW
PLANNEDGIFTPAYOUT
PLANNEDGIFTPAYOUTGLDISTRIBUTION
PLANNEDGIFTPAYOUTSPLIT
PROPERTYDETAIL
PROPERTYDETAILAUDIT
PROPERTYDETAILGLDISTRIBUTION
REGISTRANTBATCHBATCHSYSTEMMESSAGE
REVENUE
REVENUEAUDIT
REVENUEBENEFIT
REVENUEBENEFITAUDIT
REVENUEGLDISTRIBUTION
REVENUEGLDISTRIBUTIONAUDIT
REVENUEGLDISTRIBUTIONREVENUESPLITMAP
REVENUEPOSTED
REVENUEREFERENCE
REVENUEREFERENCEAUDIT
REVENUESPLIT
REVENUESPLITAUDIT
STOCKSALE
STOCKSALEAUDIT
STOCKSALEGLDISTRIBUTION
UNREALIZEDGAINLOSSGLDISTRIBUTION
UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHSYSTEMMESSAGE
USR_V_QUERY_ACTION_ITEM Provides support for querying on Action Item information.
USR_V_QUERY_ACTIONITEMFOLDER Provides support for querying on Action Item Folder information.
USR_V_QUERY_ACTIONITEMMESSAGETEXT Provides support for querying on Action Item Message Text information.
USR_V_QUERY_APEXFORM Provides support for querying on ApexForm information.
USR_V_QUERY_ASSIGNMENT Provides support for querying on Assignment information.
USR_V_QUERY_BBWORKFLOWINSTANCETRACKING Provides support for querying on Workflow Instance Tracking Record information.
USR_V_QUERY_CLIENTUSERSEXTENSION Provides support for querying on Client Users Extension information.
USR_V_QUERY_CLOSINGREQUIREMENT Provides support for querying on closing requirement information.
USR_V_QUERY_COURSE Provides support for querying on Course information.
USR_V_QUERY_COURSE_RESTRICTION Provides support for querying on Course Restriction information.
USR_V_QUERY_FAFFRIENDLYURLPARAMS Provides support for querying on FAF Friendly Url Parameters information.
USR_V_QUERY_MEMBERSHIPPROMO Provides support for querying on Membership Promotion information.
USR_V_QUERY_MICROSITECONTENT Provides support for querying on Microsite Content Data information.
USR_V_QUERY_MISCELLANEOUSPAYMENT This provides the ability to query for miscellaneous payments
USR_V_QUERY_STUDENT Provides support for querying on Student information.
USR_V_QUERY_USR_FAFIMAGES Provides support for querying on FAF Images information.
USR_V_QUERY_USR_FAFPARTICIPANTGALLERYIMAGES Provides support for querying on FAF Participant Gallery Images information.
V_ADHOCQUERY_DISPLAYORDERUNIQUE Used to ensure that set ad-hoc query display order values are unique.
V_ADHOCQUERYDEPENDENCYBUSINESSPROCESS_UNIQUE_NAME
V_ADORGANIZATIONALUNIT_UNIQUE_USERNAMESUFFIX Used to enforce unique values on the ADORGANIZATIONALUNIT.USERNAMESUFFIX field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the ADORGANIZATIONALUNIT table.
V_ALLCMSCONTENTTYPES
V_ALLCMSSITECONTENT
V_APPCATALOG_CATALOGITEMS
V_APPEAL_WITHNULLSITESECURITY
V_APPUSER_UNIQUE_CONSTITUENTID
V_ARCHIVEDCMSTRANSACTIONS_UNIQUE_ORDERID
V_BASECURRENCYFORFINANCIALTRANSACTION_I
V_BATCH_ISLOCKED
V_BBWORKFLOWCATALOG_SPECNAMES A list of all workflow specs that have been loaded into the catalog
V_BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS_UNIQUE_NAME
V_BUSINESSPROCESSPARAMETERSETS
V_CMSSECURABLEOBJECTS
V_CMSTRANSACTIONS_UNIQUE_ORDERID
V_CMSTRANSACTIONSTATE_UNIQUE_ORDERID
V_Constituency
V_CONSTITUENCYDISPLAYORDER This view returns all system and user-defined constituencies with their display name and sequence.
V_CONSTITUENT_INTERACTION
V_CONSTITUENT_WITHNULLSITESECURITY
V_CONSTITUENTALLNAMES
V_CONSTITUENTAPPEAL_WITHNULLCONSTITUENTSECURITY
V_CONSTITUENTAPPEAL_WITHNULLSITESECURITY
V_COURSEGRADING A SQL view of course grading records.
V_COURSERESTRICTION A SQL view of course restriction records.
V_CREDITCARDTOKENUNIQUE Used to ensure that non-null credit card tokens are unique.
V_CRMBBENVIRONMENT_UNIQUE_DESCRIPTIONTEXT
V_CUSTOMFORM_REVIEWPAYMENTS
V_CUSTOMMODELINGFIELD_UNIQUE_CAPTION Used to enforce unique values on the CUSTOMMODELINGFIELD.CAPTION field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the CUSTOMMODELINGFIELD table.
V_DATAFORMTEMPLATECATALOG_UNIQUE_LOADPROCEDURE
V_DATAFORMTEMPLATECATALOG_UNIQUE_SAVEPROCEDURE
V_DATALISTCATALOG_UNIQUE_PROCEDURENAME
V_DISBURSEMENT_SHOWTRANSACTIONS
V_DONORCHALLENGEENCUMBERPROCESS_UNIQUE_NAME Used to enforce unique values on the DONORCHALLENGEENCUMBERPROCESS.NAME field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the DONORCHALLENGEENCUMBERPROCESS table.
V_EDUCATIONALINSTITUTION_UNIQUE_FICECODE Used to enforce unique values on the EDUCATIONALINSTITUTION.FICECODE field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the EDUCATIONALINSTITUTION table.
V_EXPORTPROCESS_UNIQUE_NAME Used to enforce unique values on the EXPORTPROCESS.NAME field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the EXPORTPROCESS table.
V_FAF_DONATION
V_FENXTINTEGRATION_MAPPEDDESIGNATION
V_GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD_UNIQUE_DESCRIPTION Used to enforce unique values on the GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.DESCRIPTION field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD table.
V_IDMAPPERCATALOG_UNIQUE_PROCEDURENAME
V_INSTALLED_BATCHTYPECATALOG
V_INSTALLED_BBWORKFLOWCATALOG
V_INSTALLED_BBWORKFLOWINBOX
V_INSTALLED_BUSINESSPROCESSCATALOG
V_INSTALLED_CODETABLECATALOG
V_INSTALLED_DASHBOARDCATALOG
V_INSTALLED_DATAFORMTEMPLATECATALOG
V_INSTALLED_DATALISTCATALOG
V_INSTALLED_KPICATALOG
V_INSTALLED_MAPENTITYCATALOG
V_INSTALLED_PAGEDEFINITIONCATALOG
V_INSTALLED_QUERYVIEWCATALOG
V_INSTALLED_RECORDOPERATIONCATALOG
V_INSTALLED_REPORTCATALOG
V_INSTALLED_SEARCHLISTCATALOG
V_INSTALLED_SMARTFIELDCATALOG
V_INSTALLED_SMARTQUERYCATALOG
V_INSTALLED_SQLFUNCTIONCATALOG
V_INSTALLED_SQLPROCEDURECATALOG
V_INSTALLED_TABLECATALOG
V_INSTALLED_TASKCATALOG
V_KPICATALOG_UNIQUE_SPNAME Used to enforce unique values on the KPICATALOG.SPNAME field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the KPICATALOG table.
V_LEDGERACCOUNT_UNIQUE_DESCRIPTION Used to enforce unique values on the LEDGERACCOUNT.DESCRIPTION field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the LEDGERACCOUNT table.
V_MEMBERSHIPLEVEL
V_MKTLIST_UNIQUE_CODE Used to enforce unique values on the MKTLIST.CODE field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the MKTLIST table.
V_MKTPACKAGE_UNIQUE_CODE Used to enforce unique values on the MKTPACKAGE.CODE field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the MKTPACKAGE table.
V_MKTRECORDSOURCE_UNIQUE_CODE Used to enforce unique values on the MKTRECORDSOURCE.CODE field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the MKTRECORDSOURCE table.
V_MKTREVENUELETTER
V_MKTREVENUELETTERAUDIT
V_MKTREVENUERECEIPT
V_MKTREVENUERECEIPTAUDIT
V_NEWID
V_NFG_SUMMARYINFO
V_NFGLEVEL_SUMMARYINFO
V_OPPORTUNITYSOLICITOR
V_PDAPPLICATIONSEGMENT
V_PDCONSTANTSEGMENT
V_PLANNEDGIFTREVENUE_WITHADDITIONS
V_PROCESSORTRANSACTIONSETTLEMENTIMPORT_UNIQUE_MD5SUM
V_PROGRAMEVENT_TICKETCOUNTS
V_PROSPECTRESEARCHREQUESTCONSTITUENT_UNIQUE_REQUESTNO Used to enforce unique values on the PROSPECTRESEARCHREQUESTCONSTITUENT.REQUESTNO field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the PROSPECTRESEARCHREQUESTCONSTITUENT table.
V_PROSPECTTEAM
V_PROSPECTTEAM_FORINSERT
V_QUERY_ACCOUNT Query on accounts.
V_QUERY_ACCOUNTCODE This provides the ability to query for account codes.
V_QUERY_ACKNOWLEDGEMENT Provides the ability to query acknowledgements.
V_QUERY_ACKNOWLEDGEMENTPROCESS View used for standard output for the acknowledgement process.
V_QUERY_ACKNOWLEDGEMENTPROCESS_SEASONALADDRESSOUTPUT View used for seasonal address output for the acknowledgement process.
V_QUERY_ACKNOWLEDGEMENTPROCESSPLEDGEOUTPUT View used for pledge output for the acknowledgement process.
V_QUERY_ACKNOWLEDGEMENTPROCESSPLEDGEOUTPUTEXTENDED View used for pledge output for the acknowledgement process.
V_QUERY_ACKNOWLEDGEMENTSEXPORTROOT Export definition used with the acknowledgement process.
V_QUERY_ACTIONCENTER Provides support for querying on Action Center information.
V_QUERY_ACTIONITEM_TARGET Provides support for querying on ACTIONITEMTARGET information.
V_QUERY_ACTIONITEMMEDIATARGET Provides support for querying on Action Item Media Target information.
V_QUERY_ACTIVEUSERMONITORINGLOG
V_QUERY_ADDON
V_QUERY_ADDRESSBOOKFAF Provides support for querying on AddressBookFAF information.
V_QUERY_ADDRESSCOORDINATES This provides the ability to query address coordinate information.
V_QUERY_ADDRESSEE_SALUTATION This provides the ability to query for addressee and\or salutation information.
V_QUERY_ADDRESSPROCESSING_ADDRESSES This provides the ability to query for address information using address processing parameters.
V_QUERY_ADDRESSPROCESSINGOPTIONADDRESSES Returns the addresses selected by address processing options.
V_QUERY_ADDRESSVALIDATIONBATCHCONTROLREPORT View used for output for the address validation batch control report.
V_QUERY_ADDRESSVALIDATIONBATCHEXCEPTIONREPORT View used for output for address validation batch exception report.
V_QUERY_ADHOCQUERY Provides the ability to query ad-hoc queries.
V_QUERY_ADVOCACY_CUSTOM Provides support for querying on Advocacy Custom information.
V_QUERY_ADVOCACY_GROUP Provides support for querying on AdvocacyGroup information.
V_QUERY_ADVOCACYACTIVITY Provide support for query on advocacy attributes.
V_QUERY_ADVOCACYLOG Provides support for querying advocacy information
V_QUERY_ADVOCACYPETITION Provides support for querying on Advocacy Petition information.
V_QUERY_ALTERNATELOOKUPID This provides the ability to query alternate lookup ID information.
V_QUERY_ALTERNATESTUDENTID This provides the ability to query student alternate ID information.
V_QUERY_AMRPOIMPORTBATCHCONTROLREPORT
V_QUERY_AMRPOIMPORTBATCHEXCEPTIONREPORT
V_QUERY_ANALYTICSMODEL
V_QUERY_ANALYTICSPROJECT
V_QUERY_ANALYTICSPROJECTDISTRIBUTION
V_QUERY_APPEAL Query view for Appeal records.
V_QUERY_APPEALATTACHMENT This provides to ability to query for appeal attachments.
V_QUERY_APPEALBENEFIT Appeal benefit information
V_QUERY_APPEALBENEFITDETAIL Appeal benefit detail information
V_QUERY_APPEALBUSINESSUNIT Query view used for appeal business unit information.
V_QUERY_APPEALDESIGNATION Appeal designation information
V_QUERY_APPEALEVENT This provides the ability to query for appeal events.
V_QUERY_APPEALMAILING This provides the ability to query for mailings associated with appeals
V_QUERY_APPEALMAILINGCONSTITUENTAPPEAL Query view for Constituent Appeal records for a particular Appeal Mailing.
V_QUERY_APPEALMAILINGTASK Provides the ability to query appeal mailing tasks.
V_QUERY_APPEALMEDIALINK This provides to ability to query for appeal media links.
V_QUERY_APPEALNOTE This provides to ability to query for appeal notes.
V_QUERY_APPLICATION Queries information about applications.
V_QUERY_APPLICATIONUSERS
V_QUERY_APPUSER List of all Application users.
V_QUERY_APPUSERALERTSETTING Provides the ability to query an application user's email alert settings.
V_QUERY_APPUSERALERTTYPESETTING Provides the ability to query an application user's email alerts.
V_QUERY_APPUSERFEEDALERTINSTANCE Provides the ability to query an application user's custom email alerts.
V_QUERY_APPUSERPASSWORDRESETREQUESTEXCEPTION
V_QUERY_APPUSERSYSTEMROLE Joins Application Users to System roles.
V_QUERY_AUCTIONITEM Provides the ability to query information about auction items.
V_QUERY_AUCTIONITEMBATCHCONTROLREPORT View used for output of the Auction Item Batch Control Report.
V_QUERY_AUCTIONITEMBATCHEXCEPTIONREPORT View used for output of the Auction Item Batch Exception Report.
V_QUERY_AUCTIONITEMCATEGORY Auction Item Category Query
V_QUERY_AUCTIONITEMGAINLOSS Provides the ability to query gain/loss information for auction items.
V_QUERY_AUCTIONITEMPURCHASES Returns the .
V_QUERY_AUCTIONITEMSITE Auction Item Site Query
V_QUERY_AUCTIONITEMSUBCATEGORY Auction Item Subcategory Query
V_QUERY_AUDITTABLES Used to query audit tables for the system.
V_QUERY_BANKACCOUNT This provides the ability to query for bank accounts.
V_QUERY_BANKACCOUNTADJUSTMENT This provides the ability to query for bank account adjustments.
V_QUERY_BANKACCOUNTADJUSTMENT_ATTACHMENT This provides the ability to query for bank account adjustment attachments
V_QUERY_BANKACCOUNTADJUSTMENT_MEDIALINK This provides the ability to query for bank account adjustment media links.
V_QUERY_BANKACCOUNTADJUSTMENT_NOTE This provides query capabilities for a bank account adjustment notes
V_QUERY_BANKACCOUNTADJUSTMENTCATEGORY This provides the ability to query for bank account adjustment categories.
V_QUERY_BANKACCOUNTDEPOSIT This provides the ability to query for deposits.
V_QUERY_BANKACCOUNTDEPOSITATTACHMENT This provides the ability to query for bank account deposit attachments
V_QUERY_BANKACCOUNTDEPOSITCORRECTION Provides the ability to query for bank account deposit correction.
V_QUERY_BANKACCOUNTDEPOSITCORRECTIONATTACHMENT This provides the ability to query for bank account deposit correction attachments
V_QUERY_BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION Provides the ability to query for bank account deposit correction GL distribution.
V_QUERY_BANKACCOUNTDEPOSITCORRECTIONMEDIALINK This provides the ability to query for bank account deposit correction media links.
V_QUERY_BANKACCOUNTDEPOSITCORRECTIONNOTE This provides query capabilities for a bank account deposit correction notes
V_QUERY_BANKACCOUNTDEPOSITMEDIALINK This provides the ability to query for bank account deposit media links.
V_QUERY_BANKACCOUNTDEPOSITNOTE This provides query capabilities for a bank account deposit notes
V_QUERY_BANKACCOUNTTRANSACTIONGLDISTRIBUTION Provides the ability to query for bank account transaction GL distribution.
V_QUERY_BATCH Provides the ability to query Batch.
V_QUERY_BATCHDESIGN Provides the ability to query batch designs.
V_QUERY_BATCHMEMBERSHIPDUES_CONTROLREPORT
V_QUERY_BATCHMEMBERSHIPDUES_EXCEPTIONREPORT
V_QUERY_BATCHMERCHANDISEINVENTORY_CONTROLREPORT
V_QUERY_BATCHMERCHANDISEINVENTORY_EXCEPTIONREPORT
V_QUERY_BATCHNUMBERINGSCHEME
V_QUERY_BATCHWORKFLOW
V_QUERY_BATCHWORKFLOWSTATE Provides the ability to query batch workflow states.
V_QUERY_BATCHWORKFLOWTASKS Provides the ability to query batch workflow tasks.
V_QUERY_BBNCDONATIONBATCHCONTROLREPORT View used for output by the Blackbaud Internet Solutions Donation Transaction Batch Control Report.
V_QUERY_BBNCDONATIONBATCHEXCEPTIONREPORT View used for output by the Blackbaud Internet Solutions Donation Transaction Batch Exception Report.
V_QUERY_BBNCEVENTREGISTRATIONBATCHCONTROLREPORT View used for output by the Blackbaud Internet Solutions Event Registration Batch Control Report.
V_QUERY_BBNCEVENTREGISTRATIONBATCHEXCEPTIONREPORT View used for output by the Blackbaud Internet Solutions Event Registration Batch Exception Report.
V_QUERY_BBNCFUNDRAISERBATCHCONTROLREPORT View used for output by the Blackbaud Internet Solutions Fundraiser Batch Control Report.
V_QUERY_BBNCFUNDRAISERBATCHEXCEPTIONREPORT View used for output by the Blackbaud Internet Solutions Fundraiser Batch Exception Report.
V_QUERY_BBNCMEMBERSHIPBATCHCONTROLREPORT View used for output by the Blackbaud Internet Solutions Membership Transaction Batch Control Report.
V_QUERY_BBNCMEMBERSHIPBATCHEXCEPTIONREPORT View used for output by the Blackbaud Internet Solutions Membership Transaction Batch Exception Report.
V_QUERY_BBNCPROFILEBATCHCONTROLREPORT View used for output by the Blackbaud Internet Solutions Profile Update Transaction Batch Control Report.
V_QUERY_BBNCPROFILEBATCHEXCEPTIONREPORT View used for output by the Blackbaud Internet Solutions Profile Update Transaction Batch Exception Report.
V_QUERY_BBNCSIGNUPBATCHCONTROLREPORT View used for output by the Blackbaud Internet Solutions Signup Batch Control Report.
V_QUERY_BBNCSIGNUPBATCHEXCEPTIONREPORT View used for output by the Blackbaud Internet Solutions Signup Batch Exception Report.
V_QUERY_BBWORKFLOWINSTANCEINFO Provides support for querying on Workflow Instance Info information.
V_QUERY_BBWORKFLOWTASK Provides support for querying on Workflow Task information.
V_QUERY_BENEFIT Query view for Benefit records.
V_QUERY_BENEFITCONSTITUENTDECLINED Query view for benefit records declined by a constituent.
V_QUERY_BENEFITSITE Query view used for Benefit site information.
V_QUERY_BILLINGINDIVIDUALINFORMATION Return billing information about individuals.
V_QUERY_BILLINGITEM Allows the user to query for information about billing items.
V_QUERY_BILLINGITEMCOSTHISTORY Lets a user query the cost history of a
V_QUERY_BILLINGTRANSACTION Lets a user query for billing transactions.
V_QUERY_BOARDMEMBERCONSTITUENCY This provides the ability to query board member constituency information.
V_QUERY_BUSINESSPROCESS Provides support for querying on Business Process metadata from the application catalog.
V_QUERY_BUSINESSPROCESSOUTPUT
V_QUERY_BUSINESSPROCESSPARAMETERS Provides support for querying on the parameters for business processes from the application catalog.
V_QUERY_BUSINESSPROCESSPARAMETERSET
V_QUERY_BUSINESSPROCESSSTATUS
V_QUERY_CAMPAIGN Provides the ability to query campaigns.
V_QUERY_CAMPAIGNATTACHMENT Provides the ability to query campaign attachments.
V_QUERY_CAMPAIGNFUNDRAISER Provides the ability to query campaign fundraisers.
V_QUERY_CAMPAIGNGOAL Provides the ability to query campaign goals.
V_QUERY_CAMPAIGNMEDIALINK Provides the ability to query campaign media links.
V_QUERY_CAMPAIGNNOTE Provides the ability to query campaign notes.
V_QUERY_CAMPAIGNOPPORTUNITY Provides the ability to query a campaign's opportunities.
V_QUERY_CAMPAIGNPRIORITY Provides the ability to query campaign priorities.
V_QUERY_CAMPAIGNSITE Query view used for campaign site information.
V_QUERY_CAMPAIGNSUBPRIORITY Provides the ability to query campaign subpriorities.
V_QUERY_CAMPAIGNTEAM Provides the ability to query campaign teams.
V_QUERY_CATALOGITEM Used to query catalog items loaded in the system.
V_QUERY_CATALOGITEMELEMENTLEVELINSTALLEDPRODUCTLIST Used to query element-level product flags of loaded catalog items.
V_QUERY_CATALOGITEMFEATURELEVELINSTALLEDPRODUCTLIST Used to query feature-level product flags of loaded catalog items.
V_QUERY_CHARGE Queries the charge objects in the system.
V_QUERY_CHARGELINEITEM Returns information about charge line items.
V_QUERY_CHARGELINEITEMRESPONSIBILITY Queries for charge line item responsibility information.
V_QUERY_CLASS Provides support for querying on Class information.
V_QUERY_CLASSMEETING Provides support for querying on Class Meeting information.
V_QUERY_CLASSMEETINGGROUP Provides support for querying on the records associated to a Class.
V_QUERY_CLASSMEETINGGROUPENROLLMENT Provides support for querying enrollment information on the records associated to a Class.
V_QUERY_CLASSMEETINGTEMPLATE Provides support for querying on Class Meeting Template information.
V_QUERY_COAUPDATEBATCHCONTROLREPORT View used for output for the AddressFinder batch control report.
V_QUERY_COAUPDATEBATCHEXCEPTIONREPORT View used for output for AddressFinder batch exception report.
V_QUERY_CODETABLE Provides support for querying on code table metadata from the application catalog.
V_QUERY_COMBINATION Provides the ability to query combinations.
V_QUERY_COMBINATIONAVAILABILITY Provides the ability to query COMBINATION availabilities.
V_QUERY_COMBINATIONCONSTITUENCY Provides the ability to query constituent membership eligibility requirements for combinations.
V_QUERY_COMBINATIONMEMBER Provides the ability to query constituent membership eligibility requirements for combinations.
V_QUERY_COMBINATIONPRICETYPE Provides the ability to query price types of combinations.
V_QUERY_COMMENT_TEXT Provides support for querying on Comments information.
V_QUERY_COMMITMENTREVALUATION Provides the ability to query for commitment revaluation records.
V_QUERY_COMMITTEE This provides the ability to query committee constituency information.
V_QUERY_COMMITTEEGROUPGOAL Provides the ability to query constituent group goal fields.
V_QUERY_COMMUNICATIONLETTER Provides the ability to query for communication letters associated with mailings.
V_QUERY_COMMUNICATIONLETTERACTIVITYEXCLUSIONCOMMUNICATIONTYPES Provides the ability to query for communication types associated with communication letter activity exclusions.
V_QUERY_COMMUNICATIONLETTERACTIVITYEXCLUSIONS Provides the ability to query for activity exclusions associated with communication letters.
V_QUERY_COMMUNICATIONLETTEREXCLUDEDSELECTIONS Provides the ability to query for excluded selections associated with communication letters.
V_QUERY_COMMUNICATIONLETTEREXCLUDEDSOLICITCODE Provides the ability to query for excluded solicit codes associated with communication letters.
V_QUERY_COMMUNICATIONLETTERINCLUDEDSELECTIONS Provides the ability to query for included selections associated with communication letters.
V_QUERY_COMPANYGOALS Query view used for company goals.
V_QUERY_CONSOLIDATEDRECEIPTS_SUMMARYOUTPUT View used for consolidated gift summary output for constituents.
V_QUERY_CONSTITASSIGNEDSECURITYATTRIBUTES Provides the ability to query security attributes assigned to a constituent.
V_QUERY_CONSTITUENCY This provides the ability to query constituency information.
V_QUERY_CONSTITUENCY_LATENT
V_QUERY_CONSTITUENT Provides the ability to query all constituent fields.
V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATECRITERIA This view returns the full list of constituents by which duplicate constituents will be identified in a differential search.
V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATECRITERIAEMAILINPUT This view returns the input constituents and email addresses in which duplicate constituents will be identified in a differential search.
V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATECRITERIAEMAILREFERENCE This view returns the full list of constituents and email addresses by which duplicate constituents will be identified in a differential search.
V_QUERY_CONSTITUENT_DIFFERENTIALDUPLICATEINPUTCRITERIA This view returns the input constituents in which duplicate constituents will be identified in a differential search.
V_QUERY_CONSTITUENT_DUPLICATECRITERIA This view returns the fields by which duplicate constituents will be identified.
V_QUERY_CONSTITUENT_DUPLICATECRITERIAEMAIL This view returns the constituent ID, name and email address so that duplicate constituents can be identified.
V_QUERY_CONSTITUENTACCOUNT This provides the ability to query constituent financial account information.
V_QUERY_CONSTITUENTADDRESS This provides the ability to query address information.
V_QUERY_CONSTITUENTADDRESSNORELATIONSHIPS This provides the ability to query address information.
V_QUERY_CONSTITUENTADDRESSUPDATEBATCHCONTROLREPORT View used for output for Constituent Address Update Batch Control Report.
V_QUERY_CONSTITUENTADDRESSUPDATEBATCHEXCEPTIONREPORT View used for output for Constituent Address Update Batch Exception Report.
V_QUERY_CONSTITUENTALIAS This provides the ability to query alias information.
V_QUERY_CONSTITUENTALIAS_ORGANIZATION This provides the ability to query alias information in organizations.
V_QUERY_CONSTITUENTALIAS_PERSON This provides the ability to query alias information.
V_QUERY_CONSTITUENTAPPEAL Query view for Constituent Appeal records.
V_QUERY_CONSTITUENTAPPEALRESPONSE Provides the ability to query constituent appeal response fields.
V_QUERY_CONSTITUENTATTACHMENT This provides to ability to query for constituent attachments.
V_QUERY_CONSTITUENTBATCHCONTROLREPORT View used for output for Constituent Batch Control Report.
V_QUERY_CONSTITUENTBATCHEXCEPTIONREPORT View used for output for Constituent Batch Exception Report.
V_QUERY_CONSTITUENTCORRESPONDENCE Provides the ability to query general constituent correspondence.
V_QUERY_CONSTITUENTCORRESPONDENCEALL Provides the ability to query all constituent correspondence.
V_QUERY_CONSTITUENTCORRESPONDENCERESPONSE Provides the ability to query constituent correspondence response fields.
V_QUERY_CONSTITUENTDECLINEDRECOGNITION Provides the ability to query constituent declined recognition.
V_QUERY_CONSTITUENTEMAILADDRESS This provides the ability to query for email address information.
V_QUERY_CONSTITUENTEVENTCOORDINATOR This provides the ability to query for constituents who are event coordinators.
V_QUERY_CONSTITUENTEVENTSPEAKER This provides the ability to query for a constituent's event speaker records.
V_QUERY_CONSTITUENTGROUP Provides the ability to query constituent group fields.
V_QUERY_CONSTITUENTGROUPMEMBER Provides the ability to query constituent group member fields.
V_QUERY_CONSTITUENTGROUPMEMBERSHIP Provides the ability to query groups a constituent belongs to.
V_QUERY_CONSTITUENTINTEREST This provides the ability to query for constituent interest information.
V_QUERY_CONSTITUENTINVITATIONHISTORY This provides the ability to query for invitation runs associated with a constituent.
V_QUERY_CONSTITUENTINVITEE This provides the ability to query for a constituent's invitee records.
V_QUERY_CONSTITUENTINVITEEHISTORY This provides the ability to query for a constituent's invitee history.
V_QUERY_CONSTITUENTLETTEROUTPUT Provides the ability to query constituent fields that are used in mailings.
V_QUERY_CONSTITUENTMAIL This provides the ability to query constituent fields that are used in mailing.
V_QUERY_CONSTITUENTMAIL_SEASONALADDRESSOUTPUT View used for seasonal address output for the correspondence process.
V_QUERY_CONSTITUENTMAILPREFERENCE Provides the ability to query a constituent's mail preferences.
V_QUERY_CONSTITUENTMAILPREFERENCEORGCONTACTTYPE Provides the ability to query a organization's mail preference contact types.
V_QUERY_CONSTITUENTMARKETING This query is used as a record source for the marketing component.
V_QUERY_CONSTITUENTMARKETING_OPTIMIZED This query is used by the marketing component behind the scenes to improve performance by removing unnecessary fields and joins.
V_QUERY_CONSTITUENTMEDIALINK This provides to ability to query for constituent media links.
V_QUERY_CONSTITUENTNAMEFORMAT This provides the ability to query for name format information.
V_QUERY_CONSTITUENTNOTE This provides to ability to query for constituent notes.
V_QUERY_CONSTITUENTNOTEBBIS
V_QUERY_CONSTITUENTORIGINATION This provides the ability to query the constituent infosource field.
V_QUERY_CONSTITUENTPHONE This provides the ability to query for phone information.
V_QUERY_CONSTITUENTPRIMARYADDRESS Includes only addresses marked as Primary.
V_QUERY_CONSTITUENTPRIMARYEDUCATION Provides the ability to query the primary educational record for a given constituent.
V_QUERY_CONSTITUENTRECOGNITION Provides the ability to query constituent recognition.
V_QUERY_CONSTITUENTRECOGNITIONBENEFIT
V_QUERY_CONSTITUENTREGISTRANT This provides the ability to query for a constituent's registrant records.
V_QUERY_CONSTITUENTRESEARCHGROUPMEMBERSHIP This provides the ability to query a constituent's research group membership.
V_QUERY_CONSTITUENTRESTRICTIONOPTION Constituent Restriction Option Query
V_QUERY_CONSTITUENTSEGMENT Provides the ability to query marketing information (such as mailings, segments, and source code parts) related to a constituent from the 'Constituent Marketing Information' source view.
V_QUERY_CONSTITUENTSITE Query view used for constituent site information.
V_QUERY_CONSTITUENTSOCIALMEDIAACCOUNT
V_QUERY_CONSTITUENTSOLICITCODE Provides the ability to query for solicit code information.
V_QUERY_CONSTITUENTUPDATEBATCHCONTROLREPORT View used for output for Constituent Update Batch Control Report.
V_QUERY_CONSTITUENTUPDATEBATCHEXCEPTIONREPORT View used for output for Constituent Update Batch Exception Report
V_QUERY_CORRESPONDENCE Provides the ability to query correspondences.
V_QUERY_CORRESPONDENCECODE Provides the ability to query correspondence codes.
V_QUERY_CORRESPONDENCEPROCESSRUNHISTORY Provides the ability to query correspondence process run history.
V_QUERY_COUNTRY
V_QUERY_COUNTRYADDRESSFORMAT
V_QUERY_COURSE Provides support for querying on Course information.
V_QUERY_COURSE_GRADING Provides support for querying on Course Grading information.
V_QUERY_COURSE_GRADING_MARKINGCOLUMN Provides support for querying on Course Grading Marking Column information.
V_QUERY_COURSE_RESOURCE This query view spec definition provides the ability to query for faculty resources for a course.
V_QUERY_COURSE_RESTRICTION Provides support for querying on Course Restriction information.
V_QUERY_COURSE_RESTRICTION_STARTTERMS Provides support for querying on Course Restriction Start Term information.
V_QUERY_COURSE_STUDENTSKILL Provides support for querying on Course skill information.
V_QUERY_COURSE_STUDENTSKILL_MARKINGCOLUMN Provides support for querying on Course skill marking column information.
V_QUERY_COURSEACADEMICCATALOGDEPARTMENT Provides support for querying on departments a course is in.
V_QUERY_COURSEATTACHMENT This query view spec definition provides the ability to query for course attachments.
V_QUERY_COURSEGRADELEVEL This query view spec definition provides the ability to query for course grade levels.
V_QUERY_COURSEMEDIALINK This query view spec definition provides the ability to query for course media links.
V_QUERY_COURSENOTE This query view spec definition provides the ability to query for course notes.
V_QUERY_COURSETYPE This query view spec definition provides the ability to query for course types.
V_QUERY_CREDITCARDPROCESSINGREJECTIONEXPORTROOT
V_QUERY_CREDITCARDUPDATES
V_QUERY_CREDITMEMO Query for credit memos.
V_QUERY_CURRENCY Provides the ability to query on currencies.
V_QUERY_CURRENCYEXCHANGERATE Provides the ability to query on currency exchange rates.
V_QUERY_CURRENCYEXCHANGERATEBATCHCONTROLREPORT View used for output for the currency exchange rate batch control report.
V_QUERY_CURRENCYEXCHANGERATEBATCHEXCEPTIONREPORT View used for output for the currency exchange rate batch exception report.
V_QUERY_CURRENCYSET Provides the ability to query on currency sets.
V_QUERY_CURRENCYSETTRANSACTIONCURRENCY Provides the ability to query on currency set transaction currencies.
V_QUERY_DASHBOARD Provides support for querying on Dashboard metadata from the application catalog.
V_QUERY_DATAELEMENT This provides the ability to query for accounting elements.
V_QUERY_DATAFORMINSTANCE Provides the ability to query Data Form Instance.
V_QUERY_DATAFORMINSTANCE_ADDINS
V_QUERY_DATAFORMINSTANCE_EXTENSIONS
V_QUERY_DATAFORMINSTANCEEXPECTEDCONSTRAINTEXCEPTIONS Provides support for querying on the expected constraint exceptions for data form instances in the application catalog.
V_QUERY_DATAFORMINSTANCEEXPECTEDCUSTOMEXCEPTIONS Provides support for querying on the expected custom exceptions for data form instances in the application catalog.
V_QUERY_DATALIST Provides support for querying on Data List metadata from the application catalog.
V_QUERY_DATALISTFILTER Provides support for querying on the filters for data lists from the application catalog.
V_QUERY_DATALISTOUTPUT Provides support for querying on the output for data lists from the application catalog.
V_QUERY_DECEASEDFINDERBATCHCONTROLREPORT View used for output for the DeceasedRecordFinder batch control report.
V_QUERY_DECEASEDFINDERBATCHEXCEPTIONREPORT View used for output for DeceasedRecordFinder batch exception report.
V_QUERY_DECLINEDRECOGNITION
V_QUERY_DELIVERYMETHOD Provides the ability to query delivery methods.
V_QUERY_DELIVERYMETHODFEE Provides the ability to query delivery method fees.
V_QUERY_DEMOGRAPHIC This provides the ability to query constituent demographic information.
V_QUERY_DEMOGRAPHICETHNICITY This provides the ability to query individual ethnicity information.
V_QUERY_DESIGNATION This provides the ability to query all designation fields.
V_QUERY_DESIGNATIONALTERNATELOOKUPID This provides the ability to query designation alternate lookup ID information.
V_QUERY_DESIGNATIONCAMPAIGN Provides the ability to query designation campaigns.
V_QUERY_DESIGNATIONGOAL This provides to ability to query for designation goals.
V_QUERY_DESIGNATIONLEVEL Query view used for fundraising purpose information.
V_QUERY_DESIGNATIONLEVELATTACHMENT This provides to ability to query for fundraising purpose attachments.
V_QUERY_DESIGNATIONLEVELDECAPITALIZATION This provides the ability to query for fundraising purpose decapitalizations.
V_QUERY_DESIGNATIONLEVELDISBURSEMENT This provides to ability to query for fundraising purpose disbursements.
V_QUERY_DESIGNATIONLEVELDONORS Provides the ability to query fundraising purpose donor information.2
V_QUERY_DESIGNATIONLEVELFINANCIALINFO This provides to ability to query for fundraising purpose financial information.
V_QUERY_DESIGNATIONLEVELFINANCIALINFOBATCHCONTROLREPORT View used for output of designation level financial information control report.
V_QUERY_DESIGNATIONLEVELFINANCIALINFOBATCHEXCEPTIONREPORT View used for output for Designation Level Financial Info Batch Exception Report.
V_QUERY_DESIGNATIONLEVELGOAL This provides to ability to query for fundraising purpose goals.
V_QUERY_DESIGNATIONLEVELMEDIALINK This provides to ability to query for fundraising purpose media links.
V_QUERY_DESIGNATIONLEVELNOTE This provides to ability to query for fundraising purpose notes.
V_QUERY_DESIGNATIONLEVELRECIPIENT This provides to ability to query for fundraising purpose recipients.
V_QUERY_DESIGNATIONLEVELRELATEDSTAFF This provides to ability to query for fundraising purpose related staff.
V_QUERY_DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS This provides to ability to query for fundraising purpose stewardship recipients.
V_QUERY_DESIGNATIONREVENUESPLIT This provides the ability to query for revenue associated with designations
V_QUERY_DESIGNATIONREVENUESPLITINFO Provides the ability to query for details of a designation split.
V_QUERY_DESIGNATIONTAG This provides to ability to query for designation tags.
V_QUERY_DIRECTMARKETINGEFFORTBATCHCONTROLREPORT View used for output for Direct Marketing Effort Batch Control Report.
V_QUERY_DIRECTMARKETINGEFFORTBATCHEXCEPTIONREPORT View used for output for Direct Marketing Effort Batch Exception Report.
V_QUERY_DISBURSEMENT_FINANCIALTRANSACTION Query for disbursement financial transactions.
V_QUERY_DISCOUNT Provides the ability to query discounts.
V_QUERY_DISCOUNTADDRESS Provides the ability to query constituent address eligibility requirements for a discount.
V_QUERY_DISCOUNTAVAILABILITY Provides the ability to query discount availabilities.
V_QUERY_DISCOUNTAVAILABILITYSALESMETHOD Provides the ability to query discount availability's' valid sales methods.
V_QUERY_DISCOUNTCONSTITUENCY Provides the ability to query discount taxes.
V_QUERY_DISCOUNTGROUP Provides the ability to query discount groups.
V_QUERY_DISCOUNTGROUPDETAIL Provides the ability to query discount group details.
V_QUERY_DISCOUNTGROUPDETAILMERCHANDISEDEPARTMENT Provides the ability to query discount group detail merchandise departments.
V_QUERY_DISCOUNTGROUPDETAILMERCHANDISEITEM Provides the ability to query discount group detail merchandise.
V_QUERY_DISCOUNTGROUPDETAILPROGRAM Provides the ability to query discount group detail programs.
V_QUERY_DISCOUNTMEMBER Provides the ability to query constituent membership eligibility requirements for discounts.
V_QUERY_DISCOUNTQUALIFYINGPRICETYPE Provides the ability to query the valid discounts price types .
V_QUERY_DISCOUNTTAX Provides the ability to query discount taxes.
V_QUERY_DOCUMENT Provides the ability to query sales documents.
V_QUERY_DOCUMENTPRINTINGHISTORY DocumentPrintingHistory
V_QUERY_DOCUMENTPRINTINGRULE Provides the ability to query sales document printing rules.
V_QUERY_DOCUMENTPRINTINGRULESALESMETHOD Provides the ability to query sales document printing rule sales methods.
V_QUERY_DONORCHALLENGE Provides the ability to query donor challenges.
V_QUERY_DONORCHALLENGEATTACHMENT This provides to ability to query for donor challenge attachments.
V_QUERY_DONORCHALLENGEDESIGNATIONMAP Query view for Donor challenges designation mappings
V_QUERY_DONORCHALLENGEENCUMBERED Query view for Donor challenges
V_QUERY_DONORCHALLENGEEXCLUDEDAPPLICATIONTYPE Query view for Donor challenge excluded application types
V_QUERY_DONORCHALLENGEMEDIALINK This provides to ability to query for appeal media links.
V_QUERY_DONORCHALLENGEMEMBERSHIPLEVELMAP Query view for Donor challenge membership level map
V_QUERY_DONORCHALLENGENOTE This provides to ability to query for donor challenge notes.
V_QUERY_DONORCHALLENGESPLIT Query view for Donor challenge lump sum applications
V_QUERY_DONORCHALLENGETOPAYMENT Provides a connection between donor challenge claims and their payments.
V_QUERY_EDUCATIONADDITIONALINFORMATION Provides the ability to query additional education information.
V_QUERY_EDUCATIONALHISTORY This provides the ability to query constituent educational history information.
V_QUERY_EDUCATIONALHISTORYUPDATEBATCHCONTROLREPORT View used for output for educational history update batch control report.
V_QUERY_EDUCATIONALHISTORYUPDATEBATCHEXCEPTIONREPORT View used for output for educational history update batch exception report.
V_QUERY_EDUCATIONALINSTITUTION Provides the ability to query educational institution information.
V_QUERY_EDUCATIONALINVOLVEMENT Provides the ability to query a constituent's educational involvement.
V_QUERY_EDUCATIONALMAJOR Provides the ability to query constituent educational majors.
V_QUERY_EDUCATIONALMINOR Provides the ability to query constituent educational minors.
V_QUERY_EDUCATIONDEMOGRAPHIC This provides the ability to query individual demographic information.
V_QUERY_EMAILADDRESSWITHEMAILTYPE
V_QUERY_EMAILFINDERBATCHCONTROLREPORT View used for output for the EmailFinder batch control report.
V_QUERY_EMAILFINDERBATCHEXCEPTIONREPORT View used for output for EmailFinder batch exception report.
V_QUERY_ENROLLMENT_CURRENTENROLLMENTS Provides support for querying on current student enrollment information.
V_QUERY_EVENT Query view used for event information.
V_QUERY_EVENTAPPEAL This provides the ability to query for event appeals.
V_QUERY_EVENTATTACHMENT This provides to ability to query for event attachments.
V_QUERY_EVENTAUCTION Provides the ability to query information about auctions.
V_QUERY_EVENTBATCHCONTROLREPORT View used for output for Event Batch Control Report
V_QUERY_EVENTBATCHEXCEPTIONREPORT View used for output for Event Batch Exception Report
V_QUERY_EVENTCAMPAIGN Provides the ability to query event campaigns.
V_QUERY_EVENTCONFLICT Query view used for event conflict information.
V_QUERY_EVENTCOORDINATOR This provides the ability to query for event coordinators.
V_QUERY_EVENTDESIGNATION
V_QUERY_EVENTDONOR Query view used for event donor.
V_QUERY_EVENTDONOR_GIFT Query view used for gift of event donor.
V_QUERY_EVENTDONOR_MATCHINGGIFT Query view used for matching gift of event donors.
V_QUERY_EVENTEXPENSE This provides the ability to query for event expenses.
V_QUERY_EVENTGROUP This provides the ability to query for event groups.
V_QUERY_EVENTGROUPMEMBER This provides the ability to query for event group members.
V_QUERY_EVENTHIERARCHYBYREGISTRANT Query to relate a registrant to all events in a multi-level event and other registrant records for this constituent.
V_QUERY_EVENTINVITATION This provides the ability to query for invitations.
V_QUERY_EVENTLOCATION This provides the ability to query for event locations.
V_QUERY_EVENTLOCATIONROOM This provides the ability to query for event location rooms.
V_QUERY_EVENTLODGINGLOCATIONROOMS This provides the ability to query for event lodging location room info.
V_QUERY_EVENTLODGINGLOCATIONS This provides the ability to query for event lodging locations.
V_QUERY_EVENTMEDIALINK This provides to ability to query for event media links.
V_QUERY_EVENTNOTE This provides the ability to query for event notes.
V_QUERY_EVENTPREFERENCE This provides the ability to query for event preferences.
V_QUERY_EVENTPREFERENCEGROUP This provides the ability to query for event preference groups.
V_QUERY_EVENTPRICE This provides the ability to query for registration options.
V_QUERY_EVENTPRICEBENEFIT Provides the ability to query benefits associated with a registration option.
V_QUERY_EVENTREGISTRANT This provides the ability to query for registrants on events.
V_QUERY_EVENTREGISTRANT_BALANCE This provides the ability to query for balances for event registrants.
V_QUERY_EVENTREGISTRANTBATCHCONTROLREPORT View used for output for Event Registrant Batch Control Report
V_QUERY_EVENTREGISTRANTBATCHEXCEPTIONREPORT View used for output for Event Registrant Batch Exception Report
V_QUERY_EVENTREGISTRATIONINFORMATION
V_QUERY_EVENTREGISTRATIONOPPORTUNITY
V_QUERY_EVENTREGISTRATIONTYPE Provides the ability to query for event registration types.
V_QUERY_EVENTRESOURCE
V_QUERY_EVENTRESTRICTIONOPTION Event Restriction Option Query
V_QUERY_EVENTRESTRICTIONTYPE Event Restriction Type Query
V_QUERY_EVENTSALESMETHOD Provides the ability to query event sales methods.
V_QUERY_EVENTSITE Query view used for event site information.
V_QUERY_EVENTSPEAKER This provides the ability to query for event speakers.
V_QUERY_EVENTSPONSOR Query view used for event sponsor.
V_QUERY_EVENTSPONSOR_LOGOUPLOAD Query view used for logo upload of event sponsors.
V_QUERY_EVENTSPONSOR_SPONSORSHIP Query view used for sponsorship options of event sponsors.
V_QUERY_EVENTSTAFFRESOURCE
V_QUERY_EVENTSUMMARY Query view used for event information derived from various aspects of events.
V_QUERY_EVENTTASK This provides the ability to query for event tasks.
V_QUERY_EVENTTOTALS Query view used for event totals.
V_QUERY_EVENTWEBSITE Query view used for the faf event related web site.
V_QUERY_EVNETSPONSOR_DONATION Query view used for additional donation of event sponsor.
V_QUERY_EXCHANGECALENDARITEM Provides the ability to query on constituent interactions that have been added as Exchange calendar items.
V_QUERY_EXCHANGECALENDARITEM_STEWARDSHIP Provides the ability to query on constituent stewardship steps that have been added as Exchange calendar items.
V_QUERY_EXCHANGECALENDARITEMBATCHCONTROLREPORT View used for output of the Exchange calendar item batch control report.
V_QUERY_EXCHANGECALENDARITEMBATCHEXCEPTIONREPORT View used for output of the Exchange calendar item batch exception report.
V_QUERY_EXCHANGECONTACT Provides the ability to query on constituents that have been added as Exchange contacts.
V_QUERY_EXCHANGECONTACTBATCHCONTROLREPORT View used for output of the Exchange contact batch control report.
V_QUERY_EXCHANGECONTACTBATCHEXCEPTIONREPORT View used for output of the Exchange contact batch exception report.
V_QUERY_EXCHANGEEMAILBATCHCONTROLREPORT View used for output of the exchange email batch control report.
V_QUERY_EXCHANGEEMAILBATCHEXCEPTIONREPORT View used for output of the Exchange email batch exception report.
V_QUERY_EXPORTDEFINITION Provides the ability to query export definitions.
V_QUERY_FACILITY Provides the ability to query facility information for an event location.
V_QUERY_FACULTY Provides support for querying on Faculty information.
V_QUERY_FACULTY_COURSE_RESOURCE This query view spec definition provides the ability to query for courses for which a faculty member is listed as a resource.
V_QUERY_FACULTYACADEMICCATALOGDEPARTMENT Provides support for querying on departments a faculty member is in.
V_QUERY_FACULTYCLASSMEETINGGROUP Provides support for querying on the class records associated to a Faculty.
V_QUERY_FAFADDRESSBOOKCATEGORY Provides support for querying on FAFAddressBookCategory information.
V_QUERY_FAFADDRESSBOOKCUSTOMTYPE Provides support for querying on FAFAddressBookCustomType information.
V_QUERY_FAFCOMMENTS Provides support for querying on FAF Comments information.
V_QUERY_FAFCOMMUNICATIONSLOG Provides support for querying on FAF Communications Log information.
V_QUERY_FAFIMAGES Provides support for querying on FAF Images information.
V_QUERY_FAFOFFLINEFORMCONTENT Provides support for querying on FAF Offline Form Content information.
V_QUERY_FAFPARTICIPANTGALLERYIMAGES Provides support for querying on FAF Participant Gallery Images information.
V_QUERY_FAFPARTICIPANTPAGECONTENT Provides support for querying on FAF Participant Page Content information.
V_QUERY_FAFRSSFEED Provides support for querying on RSS Feed information.
V_QUERY_FEE Provides the ability to query fees.
V_QUERY_FEEDALERTINSTANCE Provides the ability to query custom email alert instances.
V_QUERY_FEEDALERTTYPE Provides the ability to query custom email alerts.
V_QUERY_FEEPROGRAM Query view for programs on fees.
V_QUERY_FEETAX Provides the ability to query fee taxes.
V_QUERY_FINANCIAL_TRANSACTION_1099_DISTRIBUTION Query for financial transactions 1099 distributions
V_QUERY_FINANCIALINSTITUTION This provides the ability to query for constituent financial institutions.
V_QUERY_FINANCIALINSTITUTIONREJECTIONCODE This provides the ability to query for financial institution rejection codes.
V_QUERY_FINANCIALSPONSORSHIPDATERANGE Returns all financial sponsorship date ranges.
V_QUERY_FINANCIALTRANSACTIONATTACHMENT This provides to ability to query for financial transaction attachments.
V_QUERY_FINANCIALTRANSACTIONMEDIALINK This provides to ability to query for financial transaction media links.
V_QUERY_FINANCIALTRANSACTIONNOTE This provides to ability to query for financial transaction notes.
V_QUERY_FUNDINGPLAN Provides the ability to query funding plan fields.
V_QUERY_FUNDINGPLANATTACHMENT This query view spec definition provides the ability to query for funding plan attachments.
V_QUERY_FUNDINGPLANMEDIALINK This query view spec definition provides the ability to query for funding plan media links.
V_QUERY_FUNDINGPLANNOTE This query view spec definition provides the ability to query for funding plan notes.
V_QUERY_FUNDINGREQUEST Provides the ability to query funding request fields.
V_QUERY_FUNDINGREQUESTATTACHMENT This query view spec definition provides the ability to query for funding request attachments.
V_QUERY_FUNDINGREQUESTDESIGNATION Provides the ability to query funding request designation fields.
V_QUERY_FUNDINGREQUESTMEDIALINK This query view spec definition provides the ability to query for funding request media links.
V_QUERY_FUNDINGREQUESTNOTE This query view spec definition provides the ability to query for funding request notes.
V_QUERY_FUNDINGREQUESTSECONDARYSOLICITOR Provides the ability to query funding request secondary solicitor fields.
V_QUERY_FUNDINGREQUESTSTEP Provides the ability to query funding request step fields.
V_QUERY_FUNDRAISER Query view spec for Fundraisers.
V_QUERY_FUNDRAISINGGOALS
V_QUERY_FUNDRAISINGGROUPS Query view used for the fundraising group configuration of FAF events.
V_QUERY_FUNDRAISINGGRUP_GOALS Query view used for fundraising groups goals.
V_QUERY_GIFTFEEADJUSTMENT Provides the ability to query gift fee adjustment data.
V_QUERY_GIFTINKINDAPPRAISAL Returns a list of appraisals for a gift-in-kind payment method detail.
V_QUERY_GIFTINKINDSALE Provides the ability to query gift-in-kind sales.
V_QUERY_GIFTINKINDSALEADJUSTMENT Provides the ability to query gift-in-kind sale adjustments.
V_QUERY_GIFTSTATUS Provides information about the status of ongoing recurring gifts and pledges.
V_QUERY_GIVINGSUMMARYUPDATEBATCHCONTROLREPORT View used for output for Giving Summary Update Batch Control Report.
V_QUERY_GIVINGSUMMARYUPDATEBATCHEXCEPTIONREPORT View used for output for Giving Summary Update Batch Exception Report.
V_QUERY_GLACCOUNTBATCH_CONTROLREPORT_QUERY View used for output for account batch control report.
V_QUERY_GLACCOUNTBATCH_CONTROLREPORT_QUERY2 View used for output for account batch control report.
V_QUERY_GLACCOUNTBATCH_EXCEPTIONREPORT_QUERY View used for output for account batch exception report.
V_QUERY_GLACCOUNTBATCH_EXCEPTIONREPORT_QUERY2 View used for output for account batch exception report.
V_QUERY_GLACCOUNTCODEATTACHMENT This query view spec definition provides the ability to query for account code attachments.
V_QUERY_GLACCOUNTCODEMEDIALINK This query view spec definition provides the ability to query for account code media links.
V_QUERY_GLACCOUNTCODENOTE This query view spec definition provides the ability to query for account code notes.
V_QUERY_GLPOST View to support GL post
V_QUERY_GOALS Query view used for goals of the faf event.
V_QUERY_GRANTAWARD Provides the ability to query fields for grant awards on funding requests.
V_QUERY_GRANTAWARDFROMOPPORTUNITY Provides the ability to query fields for grant awards on opportunities.
V_QUERY_GRANTDEADLINE Provided the ability to query grant deadline fields.
V_QUERY_GRANTFUNDINGTYPE Provides the ability to query grant funding type fields.
V_QUERY_GRANTOR This provides the ability to query grantor fields.
V_QUERY_GRANTS Provides the ability to query grant program fields.
V_QUERY_GROUPMEMBERDATERANGE Provides the ability to query group member date ranges.
V_QUERY_GROUPMEMBERROLE Provides the ability to query constituent group member role fields.
V_QUERY_GROUPSALESCONTRACTOUTPUT Provides the ability to query reservation fields that are used in contracts.
V_QUERY_GROUPSALESDEFAULT Provides the ability to query group sales default information.
V_QUERY_GROUPTYPE_REQUIREDRESOURCE Provides the ability query group type required supply/equipment resource information.
V_QUERY_GROUPTYPE_REQUIREDSTAFFRESOURCE Provides the ability to query group type required staffing resource information.
V_QUERY_HOUSEHOLD Provides the ability to query household fields.
V_QUERY_HOUSEHOLD_MODELSCORESANDRATINGS_DETAIL
V_QUERY_HOUSEHOLDCONSTITUENT Rolls up household members into a household view.
V_QUERY_HOUSEHOLDGOALS Query view used for household goals.
V_QUERY_HOUSEHOLDMEMBER Provides the ability to query household member fields.
V_QUERY_HOUSEHOLDMEMBERSHIP Provides the ability to query households a constituent belongs to.
V_QUERY_HOUSEHOLDMODELINGANDPROPENSITY Household Modeling and Propensity.
V_QUERY_HOUSEHOLDREVENUE Household revenue
V_QUERY_HOUSEHOLDREVENUERECOGNITION Provides the ability to query household revenue recognition credits.
V_QUERY_HOUSEHOLDWEALTH Household wealth
V_QUERY_INCENTIVES Query view used for incentives options of the faf event.
V_QUERY_INCENTIVESBENEFITS Query view used for incentives options benefits of the faf event.
V_QUERY_INDIVIDUALGOALS Query view used for individual goals.
V_QUERY_INDIVIDUALLASTYEAR Query view used for individual participant of last year.
V_QUERY_INSTALLMENTPLANINSTALLMENTS
V_QUERY_INSTALLMENTPLANINSTALLMENTSPLITS
V_QUERY_INSTALLMENTPLANTOPAYMENT
V_QUERY_INSTALLMENTWRITEOFF Provides the ability to query write-offs.
V_QUERY_INTERACTION Interactions.
V_QUERY_INTERACTIONADDITIONALFUNDRAISER Provides the ability to query a step's additional fundraisers.
V_QUERY_INTERACTIONALL Provides the ability to query all interactions including plan steps and constituent interactions.
V_QUERY_INTERACTIONATTACHMENT This provides to ability to query for interaction attachments.
V_QUERY_INTERACTIONBATCHCONTROLREPORT View used for output for Interaction Batch Control Report.
V_QUERY_INTERACTIONBATCHEXCEPTIONREPORT View used for output for Interaction Batch Exception Report.
V_QUERY_INTERACTIONMEDIALINK This provides to ability to query for interaction media links.
V_QUERY_INTERACTIONNOTE Interaction Notes.
V_QUERY_INTERACTIONPARTICIPANT Provides the ability to query interaction participants.
V_QUERY_INTERACTIONRESPONSE Provides the ability to query constituent interaction response fields.
V_QUERY_INTERACTIONSITE Provides the ability to query interaction sites.
V_QUERY_INTERESTS Query view used for interests.
V_QUERY_INVITATIONHISTORY This provides the ability to query for invitation runs.
V_QUERY_INVITEE This provides the ability to query for event invitees.
V_QUERY_INVITEEHISTORY This provides the ability to query for invitee history.
V_QUERY_INVITEEPROCESS_EMAILOUTPUT View used for constituent email output with the invitation process.
V_QUERY_INVITEEPROCESS_SEASONALADDRESSOUTPUT View used for constituent seasonal address output with the invitation process.
V_QUERY_INVITEEPROCESS_STANDARDADDRESSOUTPUT View used for constituent standard address output with the invitation process.
V_QUERY_INVOICE Query for invoices.
V_QUERY_ITINERARY Provides the ability query itinerary information.
V_QUERY_ITINERARYATTENDEE Provides the ability query itinerary attendee information.
V_QUERY_ITINERARYITEM Provides the ability query itinerary item information.
V_QUERY_ITINERARYITEMRESOURCE Provides the ability query itinerary item resource information.
V_QUERY_ITINERARYITEMSTAFFRESOURCE Provides the ability query itinerary item staff resource information.
V_QUERY_ITINERARYRESOURCE Provides the ability to query itinerary resource information.
V_QUERY_ITINERARYSTAFFRESOURCE Provides the ability to query itinerary staff resource information.
V_QUERY_JOB This provides the ability to query all job fields.
V_QUERY_JOBADMINISTRATIVE This provides the ability to query all job administrative trait fields.
V_QUERY_JOBATTACHMENT This provides to ability to query for job attachments.
V_QUERY_JOBCERTIFICATION This provides the ability to query all job certifications fields.
V_QUERY_JOBCOURSE This provides the ability to query all job course fields.
V_QUERY_JOBINTEREST This provides the ability to query all job interests fields.
V_QUERY_JOBLICENSE This provides the ability to query all job license fields.
V_QUERY_JOBMEDIALINK This provides to ability to query for job media links.
V_QUERY_JOBMEDICAL This provides the ability to query all job medical fields.
V_QUERY_JOBNOTE This provides to ability to query for job notes.
V_QUERY_JOBOCCURRENCE This provides the ability to query all job occurrence fields.
V_QUERY_JOBSKILL This provides the ability to query all job skill fields.
V_QUERY_JOBSPECIALNEED This provides the ability to query all job specialneed fields.
V_QUERY_JOBTRAIT_ADMINISTRATIVE This provides the ability to query all administrative job traits.
V_QUERY_JOBTRAIT_CERTIFICATION This provides the ability to query all certification job traits.
V_QUERY_JOBTRAIT_COURSE This provides the ability to query all course job traits.
V_QUERY_JOBTRAIT_INTEREST This provides the ability to query all interest job traits.
V_QUERY_JOBTRAIT_LICENSE This provides the ability to query all license job traits.
V_QUERY_JOBTRAIT_MEDICAL This provides the ability to query all medical job traits.
V_QUERY_JOBTRAIT_SKILL This provides the ability to query all skill job traits.
V_QUERY_JOBTRAIT_SPECIALNEED This provides the ability to query all special need job traits.
V_QUERY_JOBTRAITS This provides the ability to query all job traits in a consolidated view.
V_QUERY_KPI Provides support for querying on KPI metadata from the application catalog.
V_QUERY_KPIINSTANCE Provides the ability to query KPIs.
V_QUERY_KPIPARAMETERS Provides support for querying on the parameters for KPIs from the application catalog.
V_QUERY_KPIVALUE Provides the ability to query the values for a given KPI.
V_QUERY_LEDGERACCOUNT This provides the ability to query for ledger accounts.
V_QUERY_LEDGERACCOUNTATTACHMENT This query view spec definition provides the ability to query for ledger account attachments.
V_QUERY_LEDGERACCOUNTMEDIALINK This query view spec definition provides the ability to query for ledger account media links.
V_QUERY_LEDGERACCOUNTNOTE This query view spec definition provides the ability to query for ledger account notes.
V_QUERY_LETTERCODE Provides the ability to query revenue letters.
V_QUERY_LETTERCODESITE Query view used for revenue letter site information.
V_QUERY_LETTERTEMPLATE Provides the ability to query letter templates from the library.
V_QUERY_MARKETINGSURVEY Query responses to marketing survey questions.
V_QUERY_MATCHFINDERONLINECONTROLREPORT View used for output by the Update Multiple Constituents from MatchFinder Online Batch Control Report.
V_QUERY_MATCHFINDERONLINEEXCEPTIONREPORT View used for output by the Update Multiple Constituents from MatchFinder Online Batch Exception Report
V_QUERY_MATCHINGGIFTCONDITION Provides the ability to query a constituent's matching gift conditions.
V_QUERY_MATCHINGGIFTCONDITIONRELATIONSHIP Provides the ability to query a matching gift condition's relationships.
V_QUERY_MATCHINGGIFTPLEDGE Provides the ability to query on a revenue record's matching gifts.
V_QUERY_MATCHINGGIFTTOPAYMENT Provides a connection between matching gifts and their payments.
V_QUERY_MEMBER This provides the ability to query all member fields.
V_QUERY_MEMBERATTACHMENT This query view spec definition provides the ability to query for member attachments.
V_QUERY_MEMBERMEDIALINK This query view spec definition provides the ability to query for member media links.
V_QUERY_MEMBERNOTE This query view spec definition provides the ability to query for member notes.
V_QUERY_MEMBERSHIP This provides the ability to query membership fields.
V_QUERY_MEMBERSHIP_TEMPLATE This is a template for the system generated membership program queries.
V_QUERY_MEMBERSHIPADDON
V_QUERY_MEMBERSHIPBATCHCONTROLREPORT View used for output for Membership Batch Control Report
V_QUERY_MEMBERSHIPBATCHEXCEPTIONREPORT View used for output for the Membership Batch Exception Report.
V_QUERY_MEMBERSHIPCARD This provides the ability to query membership card fields.
V_QUERY_MEMBERSHIPCARD_PRINTOUTPUT Provides the ability to query fields used to print membership cards
V_QUERY_MEMBERSHIPLEVEL Query view used for membership level information.
V_QUERY_MEMBERSHIPLEVELBENEFIT Provides the ability to query membership level benefits.
V_QUERY_MEMBERSHIPLEVELCAMPAIGN Provides the ability to query membership level campaigns.
V_QUERY_MEMBERSHIPLEVELTERMS Query view for membership level terms information.
V_QUERY_MEMBERSHIPLEVELTYPES Query view used for membership level types information.
V_QUERY_MEMBERSHIPMARKETING Membership query for marketing integration.
V_QUERY_MEMBERSHIPPROGRAM Query view used for membership program information.
V_QUERY_MEMBERSHIPPROGRAMADDON
V_QUERY_MEMBERSHIPPROGRAMCAMPAIGN Provides the ability to query membership program campaigns.
V_QUERY_MEMBERSHIPPROGRAMENDDATE Query view used for membership program end date information.
V_QUERY_MEMBERSHIPPROMO
V_QUERY_MEMBERSHIPPROMOCODE
V_QUERY_MEMBERSHIPRENEWAL This provides the ability to query for membership renewal notices
V_QUERY_MEMBERSHIPTRANSACTION This provides the ability to query membership transaction fields.
V_QUERY_MEMORIALANDTRIBUTE Query view used for memorial and tribute of registrant.
V_QUERY_MERCHANDISE_VENDOR Query merchandise vendors.
V_QUERY_MERCHANDISEDEPARTMENT Query view used for merchandise department information.
V_QUERY_MERCHANDISEDEPARTMENTCATEGORY Query view used for merchandise department category information.
V_QUERY_MERCHANDISEDEPARTMENTTAX Returns all the taxes for a merchandise department.
V_QUERY_MERCHANDISEPRODUCT Query view used for merchandise information.
V_QUERY_MERCHANDISEPRODUCTATTACHMENT Provides to ability to query for merchandise item attachments.
V_QUERY_MERCHANDISEPRODUCTINSTANCE Query view used for merchandise item instance information.
V_QUERY_MERCHANDISEPRODUCTINSTANCEHISTORY
V_QUERY_MERCHANDISEPRODUCTINSTANCELOOKUPCODE
V_QUERY_MERCHANDISEPRODUCTINSTANCEOPTION Query view used for merchandise inventory item detail option information.
V_QUERY_MERCHANDISEPRODUCTMEDIALINK Provides to ability to query for merchandise item attachments.
V_QUERY_MERCHANDISEPRODUCTNOTE Provides to ability to query for merchandise item attachments.
V_QUERY_MERCHANDISEPRODUCTOPTION Query view used for merchandise detail type information.
V_QUERY_MERCHANDISEPRODUCTOPTIONVALUE Query view used for merchandise detail option information.
V_QUERY_MERCHANDISEPRODUCTSALESMETHOD Query view used for merchandise item sales method information.
V_QUERY_MISCELLANEOUSPAYMENT This provides the ability to query for miscellaneous payments.
V_QUERY_MKTACKNOWLEDGEMENTEXPORT Includes acknowledgement fields for use in an export definition.
V_QUERY_MKTACKNOWLEDGEMENTMAILINGEXPORTROOT Export definitions used with marketing acknowledgement exports are based on this query view.
V_QUERY_MKTASKLADDER Provides the ability to query ask ladders.
V_QUERY_MKTCREATIVE All creative fields
V_QUERY_MKTCREATIVEATTACHMENT All attachment fields
V_QUERY_MKTDOCUMENT All marketing document fields
V_QUERY_MKTEXPENSE All marketing expense fields
V_QUERY_MKTEXPORTDEFINITION Provides the ability to query export definitions.
V_QUERY_MKTLETTERCODE Provides the ability to query letters.
V_QUERY_MKTLIST Provides the ability to query acquisition lists.
V_QUERY_MKTLISTSEGMENT Provides the ability to query a list's segments.
V_QUERY_MKTLISTSELECTION Provides the ability to query a list's selections.
V_QUERY_MKTMARKETINGPLAN All marketing plan fields.
V_QUERY_MKTMARKETINGPLANAPPEAL All marketing plan appeal fields.
V_QUERY_MKTMARKETINGPLANBRIEF All marketing plan marketing effort segment summary fields.
V_QUERY_MKTMARKETINGPLANEFFORT All marketing plan marketing effort fields.
V_QUERY_MKTMARKETINGPLANITEM All marketing plan item fields.
V_QUERY_MKTMARKETINGPLANITEMATTACHMENT All marketing plan item attachment fields.
V_QUERY_MKTMARKETINGPLANITEMEXPENSE All marketing plan expense fields.
V_QUERY_MKTMARKETINGPLANITEMSPEC All marketing plan specification fields.
V_QUERY_MKTMARKETINGPLANITEMTASK All marketing plan task fields.
V_QUERY_MKTMARKETINGPLANPACKAGE All marketing plan effort package fields.
V_QUERY_MKTMARKETINGPLANTEMPLATE All marketing plan template fields.
V_QUERY_MKTMARKETINGPLANTEMPLATEITEM All marketing plan template item fields.
V_QUERY_MKTMATERIAL All marketing material fields
V_QUERY_MKTMEMBERSHIPMAILINGEXPORTROOT Export definitions used with membership effort exports are based on this query view.
V_QUERY_MKTPACKAGE Provides the ability to query packages.
V_QUERY_MKTPACKAGECREATIVE Provides the ability to query a package's creatives.
V_QUERY_MKTPACKAGEDOCUMENT Provides the ability to query a package's documents.
V_QUERY_MKTPACKAGEEXPENSE Provides the ability to query a package's expenses.
V_QUERY_MKTPACKAGEMATERIAL Provides the ability to query a package's materials.
V_QUERY_MKTSEGMENT Provides the ability to query segments.
V_QUERY_MKTSEGMENTATION Provides the ability to query marketing efforts.
V_QUERY_MKTSEGMENTATIONAPPEAL Provides the ability to query a marketing effort's appeals.
V_QUERY_MKTSEGMENTATIONBUSINESSUNIT Query view used for appeal business unit information.
V_QUERY_MKTSEGMENTATIONEXCLUSIONPREVIOUSMAILING Provides the ability to query a marketing effort's previous marketing effort exclusions.
V_QUERY_MKTSEGMENTATIONEXCLUSIONSELECTION Provides the ability to query a marketing effort's exclusion selections.
V_QUERY_MKTSEGMENTATIONEXPORT Includes marketing effort fields for use in an export definition.
V_QUERY_MKTSEGMENTATIONEXPORTROOT Export definitions used with direct marketing effort exports are based on this query view.
V_QUERY_MKTSEGMENTATIONINCLUSIONSELECTION Provides the ability to query the selections in a marketing effort's universe.
V_QUERY_MKTSEGMENTATIONPACKAGE Provides the ability to query a marketing effort's packages.
V_QUERY_MKTSEGMENTATIONSEED Provides the ability to query a marketing effort's seeds.
V_QUERY_MKTSEGMENTATIONSEGMENT Provides the ability to query a marketing effort's segments.
V_QUERY_MKTSEGMENTATIONSEGMENTBUSINESSUNIT Query view used for appeal business unit information.
V_QUERY_MKTSEGMENTATIONSEGMENTPACKAGE Provides the ability to query marketing effort segment packages.
V_QUERY_MKTSEGMENTATIONSEGMENTUNIFIED Includes marketing effort fields for use with export.
V_QUERY_MKTSEGMENTATIONTESTSEGMENT Provides the ability to query a marketing effort segment's test segments.
V_QUERY_MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT Query view used for appeal business unit information.
V_QUERY_MKTSEGMENTATIONTESTSEGMENTPACKAGE Provides the ability to query marketing effort test segment packages.
V_QUERY_MKTSEGMENTGROUP Provides the ability to query a segment's groups.
V_QUERY_MKTSEGMENTPASSIVE Provides the ability to query media outlets, time slots and marketing locations.
V_QUERY_MKTSEGMENTSELECTION Provides the ability to query a segment's selections.
V_QUERY_MKTSEGMENTWHITEMAIL Provides the ability to query white mail segments.
V_QUERY_MKTSPONSORSHIPMAILINGEXPORTROOT Export definitions used with sponsorship effort exports are based on this query view.
V_QUERY_MKTVENDOR All vendor fields
V_QUERY_MODELILNGANDPROPENSITYUPDATEBATCHCONTROLREPORT View used for output for Modeling and Propensity Update Batch Control Report.
V_QUERY_MODELILNGANDPROPENSITYUPDATEBATCHEXCEPTIONREPORT View used for output for Modeling and Propensity Update Batch Exception Report.
V_QUERY_MODELINGANDPROPENSITY_SIMPLE Select all Modeling and Propensity data.
V_QUERY_MODELINGANDPROPENSITYBATCHCONTROLREPORT View used for output for Modeling and Propensity Batch Control Report.
V_QUERY_MODELINGANDPROPENSITYBATCHEXCEPTIONREPORT View used for output for Modeling and Propensity Batch Exception Report.
V_QUERY_MODELSCORESANDRATINGS_DETAIL
V_QUERY_MOSTRECENTREVENUERECEIPT
V_QUERY_NAMINGOPPORTUNITY Provides the ability to query naming opportunities.
V_QUERY_NAMINGOPPORTUNITYATTACHMENT This provides to ability to query for naming opportunity attachments.
V_QUERY_NAMINGOPPORTUNITYFACILITY Provides the ability to query naming opportunity facilities.
V_QUERY_NAMINGOPPORTUNITYMEDIALINK This provides to ability to query for naming opportunity media links.
V_QUERY_NAMINGOPPORTUNITYMGOPPORTUNITY Provides the ability to query naming opportunity major giving opportunities.
V_QUERY_NAMINGOPPORTUNITYNOTE Provides the ability to query for naming opportunity notes.
V_QUERY_NAMINGOPPORTUNITYRECOGNITION Provides the ability to query naming opportunity recognitions.
V_QUERY_NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATION Provides the ability to query naming opportunity recognition installed locations.
V_QUERY_NETCOMMUNITYCLIENTUSER Provides the ability to query community member information.
V_QUERY_NETCOMMUNITYEMAILINFO Provides the ability to query community member email information.
V_QUERY_NETCOMMUNITYEMAILJOBRECIPIENT Provides the ability to query emails received by community members.
V_QUERY_NETCOMMUNITYNEWSLETTERSUBSCRIPTION Provides the ability to query community member newsletter subscriptions.
V_QUERY_NETCOMMUNITYTEAMFUNDRAISEREMAIL Provides the ability to query community member newsletter subscriptions.
V_QUERY_NETCOMMUNITYWEBTRAFFIC Provides the ability to query community members website traffic.
V_QUERY_NEWSLETTER Query view used for newsletters of constituent.
V_QUERY_OLAPDATASOURCE_ETLHISTORY The log of the ETL History for all Data Marts
V_QUERY_OPPORTUNITY Opportunities
V_QUERY_OPPORTUNITYCAMPAIGN Provides the ability to query a opportunity's campaigns.
V_QUERY_OPPORTUNITYDESIGNATION Designations for an opportunity.
V_QUERY_OPPORTUNITYDESIGNATIONCAMPAIGN Provides the ability to query opportunity designation campaigns.
V_QUERY_OPPORTUNITYFUNDINGTYPE Provides the ability to query opportunity funding type fields.
V_QUERY_OPPORTUNITYSOLICITOR
V_QUERY_ORGANIZATION Provides the ability to query organization fields.
V_QUERY_ORGANIZATIONHIERARCHYPOSITION Organization hierarchy position information.
V_QUERY_ORIGINALREVENUERECEIPT
V_QUERY_OTHERASSET Select all WealthPoint Other Asset data.
V_QUERY_OTHERASSETS Prospect Wealth Other Assets
V_QUERY_OUTPUTBUSINESSPROCESSES Used to query business processes that return generate output.
V_QUERY_OUTSIDEEDUCATION Provides support for querying outside education.
V_QUERY_PAGE Provides support for querying on Page metadata from the application catalog.
V_QUERY_PAGEACTIONGROUPS Provides support for querying on page action groups.
V_QUERY_PAGEACTIONS Provides support for querying on page actions.
V_QUERY_PAGECONTEXTLINKS
V_QUERY_PAGESECTIONS Provides support for querying on page sections.
V_QUERY_PAGETABS Provides support for querying on page tabs.
V_QUERY_PARTICIPANTGOALS Query view used for participant goals.
V_QUERY_PAYABLES_TRANSACTION Query for payables transactions.
V_QUERY_PAYMENT This provides the ability to query for payments.
V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHCONTROLREPORT View used for output for Account Segment Mapping Batch Control Report
V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHCONTROLREPORT2 View used for output for Account Segment Mapping Batch Control Report 2.
V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHEXCEPTIONREPORT View used for output for Account Segment Mapping Batch Exception Report.
V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHEXCEPTIONREPORT2 View used for output for Account Segment Mapping Batch Exception Report by Account System.
V_QUERY_PEOPLEFINDERBATCHCONTROLREPORT View used for output for the PeopleFinder batch control report.
V_QUERY_PEOPLEFINDERBATCHEXCEPTIONREPORT View used for output for PeopleFinder batch exception report.
V_QUERY_PEOPLELINKCONTACT PeopleLink Contact
V_QUERY_PEOPLELINKORGANIZATION PeopleLink Organization
V_QUERY_PHONEFINDERBATCHCONTROLREPORT View used for output for the PhoneFinder batch control report
V_QUERY_PHONEFINDERBATCHEXCEPTIONREPORT View used for output for PhoneFinder batch exception report
V_QUERY_PLANNEDGIFT Enables query for planned gift records.
V_QUERY_PLANNEDGIFTACKNOWLEDGEMENT Provides the ability to query planned gift acknowledgements.
V_QUERY_PLANNEDGIFTACKNOWLEDGEMENTEMAILOUTPUT View used for email output for the planned gift acknowledgement process.
V_QUERY_PLANNEDGIFTACKNOWLEDGEMENTPROCESS View used for standard output for the planned gift acknowledgement process.
V_QUERY_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_SEASONALADDRESSOUTPUT PView used for seasonal address output for the acknowledgement process.
V_QUERY_PLANNEDGIFTADDITION Enables query for planned gift addition records.
V_QUERY_PLANNEDGIFTADDITIONASSET Enables query on planned gift addition asset records.
V_QUERY_PLANNEDGIFTADDITIONDESIGNATION Enables query on planned gift addition designation records.
V_QUERY_PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN Enables query on planned gift addition designation campaign records.
V_QUERY_PLANNEDGIFTADDITIONREVENUE Provides the ability to query for planned gift addition revenue.
V_QUERY_PLANNEDGIFTASSET Enables query on planned gift asset records.
V_QUERY_PLANNEDGIFTATTACHMENT This provides to ability to query for planned gift attachments.
V_QUERY_PLANNEDGIFTBENEFICIARY Enables query on planned gift beneficiary records.
V_QUERY_PLANNEDGIFTDESIGNATION Enables query on planned gift designation records.
V_QUERY_PLANNEDGIFTDESIGNATIONCAMPAIGN Enables query on planned gift designation campaign records.
V_QUERY_PLANNEDGIFTFUNDINGTYPE Provides the ability to query planned gift funding type fields.
V_QUERY_PLANNEDGIFTLETTER Provides the ability to query letters for a planned gift.
V_QUERY_PLANNEDGIFTLETTERCODE Provides the ability to query planned gift letters.
V_QUERY_PLANNEDGIFTLETTERCODESITE Query view used for planned gift letter site information.
V_QUERY_PLANNEDGIFTMEDIALINK This provides to ability to query for planned gift media links.
V_QUERY_PLANNEDGIFTNOTE Planned Gift Notes.
V_QUERY_PLANNEDGIFTRELATIONSHIP Enables query on planned gift relationship records.
V_QUERY_PLANNEDGIFTREVENUE Provides the ability to query for planned gift revenue.
V_QUERY_PLANNEDGIFTSITE Query view used for planned gift site information.
V_QUERY_PLANNEDGIFTTOPAYMENT Provides a connection between planned gifts and their payments.
V_QUERY_PLANPARTICIPANT Provides the ability to query plan participant fields.
V_QUERY_PLANSOLICITORS
V_QUERY_PLEDGEINSTALLMENTS Provides the ability to query installment information for pledges.
V_QUERY_PLEDGEINSTALLMENTSPLITS Provides ability to query on installment split information for pledges.
V_QUERY_PLEDGEREMINDER Provides the ability to query pledge reminders.
V_QUERY_PLEDGEREMINDERPROCESS View used for standard output for the pledge reminder process.
V_QUERY_PLEDGEREMINDERPROCESS_SEASONALADDRESSOUTPUT View used for seasonal address output for the pledge reminder process.
V_QUERY_PLEDGEREMINDERPROCESS_SPONSORSHIP View used for sponsorship output for the pledge reminder process.
V_QUERY_PLEDGEREMINDERPROCESSDETAILS View used for standard output for the pledge reminder process details when grouping by revenue is chosen.
V_QUERY_PLEDGEREMINDERPROCESSDETAILS_SPONSORSHIP View used for sponsorship output for the pledge reminder process details when grouping by revenue is chosen.
V_QUERY_PLEDGEREMINDERPROCESSQUERY Provides the ability to query pledge reminder processes.
V_QUERY_PLEDGEREMINDERPROCESSSEASONALADDRESSDETAILS View used for standard output for the pledge reminder process details when grouping by revenue is chosen.
V_QUERY_PLEDGEREMINDERPROCESSSEASONALADDRESSSUMMARY View used for standard output for the pledge reminder seasonal address summary when grouping by revenue is chosen.
V_QUERY_PLEDGEREMINDERPROCESSSUMMARY View used for standard output for the pledge reminder process summary when grouping by revenue is chosen.
V_QUERY_PLEDGEREMINDERPROCESSSUMMARY_SPONSORSHIP View used for sponsorship output for the pledge reminder process summary when grouping by revenue is chosen.
V_QUERY_PLEDGETOPAYMENT Provides a connection between pledges and their payments.
V_QUERY_POSTALFIELDS_CA Includes CA postal mailing fields for use in an export definition.
V_QUERY_POSTALFIELDS_UK Includes UK postal mailing fields for use in an export definition.
V_QUERY_POSTALFIELDS_USA Includes US postal mailing fields for use in an export definition.
V_QUERY_POSTTOGLPROCESSSTANDARD View used for standard output for the post to GL process.
V_QUERY_POSTTOGLPROCESSSTANDARD_2 View used for Financial Edge 7 output for the post to GL process.
V_QUERY_POSTTOGLPROCESSSTANDARD_3 View used for Financial Edge 7 output with project for the post to GL process.
V_QUERY_POSTTOGLPROCESSSTANDARD_4 View used for segmented account output for the post to GL process.
V_QUERY_POSTTOGLPROCESSSTANDARD_5 View used for Peachtree output for the post to GL process
V_QUERY_POSTTOGLPROCESSSTANDARD_6 View used for Peachtree output for the post to GL process
V_QUERY_POSTTOGLPROCESSSTANDARD_7
V_QUERY_PREFERENCECONFLICT This provides the ability to query for preferences for event conflicts.
V_QUERY_PREFERENCEGROUPCONFLICT This provides the ability to query for preference groups for event conflicts.
V_QUERY_PREVIOUSREVENUERECEIPT
V_QUERY_PRICE Provides the ability to query prices.
V_QUERY_PRICELIST Provides the ability to query price lists.
V_QUERY_PRINTERLIST Provides the ability to query printer lists.
V_QUERY_PRINTERLISTITEM Provides the ability to query printer list items.
V_QUERY_PROGRAM Query view used for program information.
V_QUERY_PROGRAMDISCOUNT Query view for program discounts.
V_QUERY_PROGRAMDOCUMENT Query view for program documents.
V_QUERY_PROGRAMEVENT Query view used for scheduled event information.
V_QUERY_PROGRAMEVENTLOCATION Query view for program event locations.
V_QUERY_PROGRAMFEE Query view for program fees.
V_QUERY_PROGRAMGROUP Provides the ability to query program groups of combinations.
V_QUERY_PROGRAMGROUPGROUP Provides the ability to query programs of the program groups of the combinations.
V_QUERY_PROGRAMGROUPPRICE Provides the ability to query prices of the program groups of the combinations.
V_QUERY_PROGRAMGROUPPROGRAM Provides the ability to query programs of the program groups of the combinations.
V_QUERY_PROGRAMLOCATION Query view for program locations.
V_QUERY_PROGRAMPREFERENCE This provides the ability to query for program preferences.
V_QUERY_PROGRAMPREFERENCEGROUP This provides the ability to query for program preference groups.
V_QUERY_PROGRAMPRICE Query view for program prices.
V_QUERY_PROGRAMREGISTRATIONINFORMATION
V_QUERY_PROGRAMRESOURCE Query view for program resource
V_QUERY_PROGRAMSALESMETHOD Query view for program sales methods.
V_QUERY_PROGRAMSTAFFRESOURCE Query view for program staff resource
V_QUERY_PROGRAMTAX Query view for program taxes.
V_QUERY_PROJECT This provides the ability to query for projects.
V_QUERY_PROJECTATTACHMENT This query view spec definition provides the ability to query for project attachments.
V_QUERY_PROJECTMEDIALINK This query view spec definition provides the ability to query for project media links.
V_QUERY_PROJECTNOTE This query view spec definition provides the ability to query for project notes.
V_QUERY_PROMOTIONALCODE Provides the ability to query discount promotion codes.
V_QUERY_PROSPECT Prospect
V_QUERY_PROSPECTASSIGNMENTREQUEST Query view prospect assignment requests
V_QUERY_PROSPECTFUNDINGINTEREST Provides the ability to query prospect funding interest fields.
V_QUERY_PROSPECTFUNDINGINTERESTSITE Query view used for prospect funding interest site information.
V_QUERY_PROSPECTMANAGERHISTORY Provides the ability to query on prospect manager history fields.
V_QUERY_PROSPECTPLAN Provides the ability to query all prospect plan fields.
V_QUERY_PROSPECTPLANATTACHMENT This provides to ability to query for prospect plan attachments.
V_QUERY_PROSPECTPLANMANAGERHISTORY Provides the ability to query on prospect plan manager history fields.
V_QUERY_PROSPECTPLANMEDIALINK This provides to ability to query for prospect plan media links.
V_QUERY_PROSPECTPLANNOTE This provides to ability to query for prospect plan notes.
V_QUERY_PROSPECTPLANREQUEST Queries prospect plan requests
V_QUERY_PROSPECTPLANSITE Provides the ability to query prospect plan sites.
V_QUERY_PROSPECTRESEARCHCONSTITUENT Provides the ability to query constituents who are allowed to receive wealth updates for prospect research.
V_QUERY_PROSPECTRESEARCHREQUEST Provides the ability to query prospect research request data.
V_QUERY_PROSPECTRESEARCHREQUESTCONSTITUENT Provides the ability to query prospect research request constituent data.
V_QUERY_PROSPECTRESEARCHREQUESTCSOURCE
V_QUERY_PROSPECTRESEARCHREQUESTSITE Provides the ability to query site information on prospect research request data.
V_QUERY_PROSPECTTEAM Handles queries for prospect team assignments
V_QUERY_QUERYVIEW Provides support for querying on Query View metadata from the application catalog.
V_QUERY_QUERYVIEWOUTPUT Provides support for querying on the output for query views in the application catalog.
V_QUERY_RATESCALE Provides the ability to query rate scale information.
V_QUERY_RATESCALEAPPLICATION Provides the ability to query rate scale application information.
V_QUERY_RATESCALEFEE Provides the ability query rate scale fee information.
V_QUERY_RATESCALEPRICE Provides the ability query rate scale price information.
V_QUERY_RATESCALEPROGRAM Provides the ability query rate scale program information.
V_QUERY_RATESCALERESOURCE Provides the ability query rate scale supplies/equipment resource information.
V_QUERY_RATESCALESTAFFRESOURCE Provides the ability to query rate scale staffing resource information.
V_QUERY_RATINGSBATCHCONTROLREPORT View used for output for Ratings Batch Control Report.
V_QUERY_RATINGSBATCHEXCEPTIONREPORT View used for output for Ratings Batch Exception Report.
V_QUERY_RE7_ADDRESS
V_QUERY_RE7_ADDRESSATTRIBUTE
V_QUERY_RE7_APPEAL
V_QUERY_RE7_APPEALATTRIBUTE
V_QUERY_RE7_APPEALEXPENSES
V_QUERY_RE7_ASSIGNEDTOSOLICIT
V_QUERY_RE7_ATTRIBUTECONSTITUENT
V_QUERY_RE7_BBNCCLIENTUSER
V_QUERY_RE7_BBNCEMAILBOUNCES
V_QUERY_RE7_BBNCEMAILINFORMATION
V_QUERY_RE7_BBNCEMAILRECEIVED
V_QUERY_RE7_BBNCNEWSLETTERSUBSCRIPTION
V_QUERY_RE7_BBNCPERSONALPAGES
V_QUERY_RE7_BBNCTEAMFUNDRAISING
V_QUERY_RE7_BBNCWEBTRAFFIC
V_QUERY_RE7_BBNCWEBTRAFFICSUMMARY
V_QUERY_RE7_CAMPAIGN
V_QUERY_RE7_CAMPAIGNATTRIBUTE
V_QUERY_RE7_CONSTITUENT
V_QUERY_RE7_CONSTITUENTACTION
V_QUERY_RE7_CONSTITUENTACTIONATTRIBUTE
V_QUERY_RE7_CONSTITUENTACTIONSOLICITOR
V_QUERY_RE7_CONSTITUENTACTIONSUMMARY
V_QUERY_RE7_CONSTITUENTAPPEAL
V_QUERY_RE7_CONSTITUENTATTRIBUTES
V_QUERY_RE7_CONSTITUENTCODE
V_QUERY_RE7_CONSTITUENTEDUCATION
V_QUERY_RE7_CONSTITUENTEDUCATIONATTRIBUTE
V_QUERY_RE7_CONSTITUENTEDUCATIONMAJOR
V_QUERY_RE7_CONSTITUENTEDUCATIONMINOR
V_QUERY_RE7_CONSTITUENTEVENTSUMMARY
V_QUERY_RE7_CONSTITUENTFUNDRELATIONSHIP
V_QUERY_RE7_CONSTITUENTMEMBERSHIP
V_QUERY_RE7_CONSTITUENTMEMBERSHIPSUMMARY
V_QUERY_RE7_CONSTITUENTPROSPECT
V_QUERY_RE7_CONSTITUENTRATING
V_QUERY_RE7_CONSTITUENTRELATIONSHIP
V_QUERY_RE7_CONSTITUENTRELATIONSHIP_COMBINED
V_QUERY_RE7_CONSTITUENTRELATIONSHIP_INDIVIDUAL
V_QUERY_RE7_CONSTITUENTRELATIONSHIP_ORGANIZATION
V_QUERY_RE7_CONSTITUENTSALUTATION
V_QUERY_RE7_CONSTITUENTSOFTCREDIT
V_QUERY_RE7_CONSTITUENTSOLICITCODE
V_QUERY_RE7_CONSTITUENTSPOUSE
V_QUERY_RE7_DATE
V_QUERY_RE7_EVENTATTRIBUTES
V_QUERY_RE7_EVENTEXPENSES
V_QUERY_RE7_EVENTPARTICIPANTFEE
V_QUERY_RE7_EVENTREGISTRANT
V_QUERY_RE7_EVENTREGISTRANTATTRIBUTES
V_QUERY_RE7_EVENTREGISTRANTGIFT
V_QUERY_RE7_FUND
V_QUERY_RE7_FUNDATTRIBUTE
V_QUERY_RE7_GIFT
V_QUERY_RE7_GIFTATTRIBUTE
V_QUERY_RE7_GIFTSOFTCREDIT
V_QUERY_RE7_INSTALLMENT
V_QUERY_RE7_INSTALLMENTPAYMENT
V_QUERY_RE7_LIFETIMEGIVINGSUMMARY
V_QUERY_RE7_MEMBERSHIPATTRIBUTES
V_QUERY_RE7_MEMBERSHIPBENEFIT
V_QUERY_RE7_MEMBERSHIPRENEWAL
V_QUERY_RE7_MEMBERSHIPTRANSACTIONREVENUE
V_QUERY_RE7_PACKAGE
V_QUERY_RE7_PACKAGEATTRIBUTE
V_QUERY_RE7_PHONE
V_QUERY_RE7_PLEDGESUMMARY
V_QUERY_RE7_PROPOSAL
V_QUERY_RE7_PROPOSALATTRIBUTES
V_QUERY_RE7_PROPOSALSOLICITOR
V_QUERY_RE7_RESTRICTEDGIVINGSUMMARY
V_QUERY_RE7_REVENUEINSTALLMENT
V_QUERY_RE7_REVENUEPROPOSAL
V_QUERY_RE7_REVENUESOLICITOR
V_QUERY_RE7_REVENUETRIBUTE
V_QUERY_RE7_REVENUETRIBUTEACKNOWLEDGEMENT
V_QUERY_RE7_SOLICITORASSIGNMENT
V_QUERY_RE7_SOLICITORGOAL
V_QUERY_RE7_TEAM
V_QUERY_RE7_TRIBUTE
V_QUERY_RE7_TRIBUTEACKNOWLEDGEMENT
V_QUERY_RE7_UNRESTRICTEDGIVINGSUMMARY
V_QUERY_RE7_VOLUNTEER
V_QUERY_RE7_VOLUNTEERASSIGNMENT
V_QUERY_RE7_VOLUNTEERJOB
V_QUERY_RE7_VOLUNTEERTIMESHEET
V_QUERY_RE7_VOLUNTEERTYPE
V_QUERY_RE7GIVINGSUMMARY Provides the ability to query RE7 Integration Giving Summary.
V_QUERY_RE7INTEGRATIONCONSTITUENTMAP
V_QUERY_RE7INTEGRATIONGIVINGSUMMARYBATCHCONTROLREPORT View used for output for RE7 Integration Giving Summary Batch Control Report.
V_QUERY_RE7INTEGRATIONGIVINGSUMMARYBATCHEXCEPTIONREPORT View used for output for RE7 Integration Giving Summary Batch Exception Report.
V_QUERY_RECEIPTEMAILOUTPUT View used for email output for the receipt process.
V_QUERY_RECEIPTING_EMAILGIFTDETAILOUTPUT View used for consolidated gift detail email output for the receipt process.
V_QUERY_RECEIPTING_EMAILGIFTSUMMARYOUTPUT View used for consolidated email gift summary output for the receipting process.
V_QUERY_RECEIPTING_GIFTDETAILOUTPUT View used for consolidated gift detail output for the receipting process.
V_QUERY_RECEIPTING_GIFTSUMMARYOUTPUT View used for consolidated gift summary output for the receipting process.
V_QUERY_RECEIPTING_SEASONALADDRESSPAYMENT View used for seasonal address output for the receipting process.
V_QUERY_RECEIPTING_STANDARDPAYMENT View used for standard output for the receipting process.
V_QUERY_RECEIPTSTACK Provides ability to query receipt stacks
V_QUERY_RECEIVABLECREDIT Queries the receivable credit objects in the system.
V_QUERY_RECEIVABLECREDITLINEITEM Returns information about receivable credit line items.
V_QUERY_RECEIVABLEPAYMENT Returns information about a given receivable payment.
V_QUERY_RECOGNITION_TEMPLATE This is a template for the system generated recognition program queries.
V_QUERY_RECOGNITIONLEVEL Provides the ability to query recognition levels.
V_QUERY_RECOGNITIONLEVELAMOUNT Provides the ability to query recognition level amount.
V_QUERY_RECOGNITIONLEVELBENEFIT Provides the ability to query recognition level benefit.
V_QUERY_RECOGNITIONPROGRAM Provides the ability to query recognition programs.
V_QUERY_RECOGNITIONPROGRAMDESIGNATION Provides the ability to query recognition program designation.
V_QUERY_RECONCILIATION Provides the ability to query reconciliations.
V_QUERY_RECORD Provides the ability to query all record fields.
V_QUERY_RECORDOPERATION Provides support for querying on Record Operation metadata from the application catalog.
V_QUERY_RECORDOPERATIONEXPECTEDCONSTRAINTEXCEPTIONS Provides support for querying on the expected constraint exceptions for record operations from the application catalog.
V_QUERY_RECORDOPERATIONEXPECTEDCUSTOMEXCEPTIONS Provides support for querying on the expected custom exceptions for record operations from the application catalog.
V_QUERY_RECORDOPERATIONPARAMETERS
V_QUERY_RECORDRELATIONSHIPS This provides the ability to query for record relationship information.
V_QUERY_RECURRINGGIFTAMENDMENT
V_QUERY_RECURRINGGIFTDEVELOPMENTFUNCTIONHISTORY Query to retrieve revenue function history for recurring gifts.
V_QUERY_RECURRINGGIFTSTATUS
V_QUERY_RECURRINGGIFTTOPAYMENT Provides a connection between recurring gifts and their payments.
V_QUERY_RECURRINGGIFTWRITEOFF Provides the ability to query pledge write-offs.
V_QUERY_REFUND
V_QUERY_REFUNDEDEVENTREGISTRATIONS
V_QUERY_REFUNDEDITEMS
V_QUERY_REFUNDEDMEMBERSHIP
V_QUERY_REFUNDPAYMENT
V_QUERY_REFUNDS
V_QUERY_REGISTRANT This provides the ability to query for event registrants.
V_QUERY_REGISTRANT_FUNDRAISINGGROUP Query view used for fundraising groups information
V_QUERY_REGISTRANT_FUNDRAISINGTOTAL Query view used for fundraising totals of registrant.
V_QUERY_REGISTRANT_TEAMTOTALS Query view used for team totals of registrant.
V_QUERY_REGISTRANTBENEFIT Provides the ability to query benefits associated with a registrant.
V_QUERY_REGISTRANTDONATION Provides support for querying on Registrant Donation information.
V_QUERY_REGISTRANTEXTENSION Provides support for querying on Registrant Extension information.
V_QUERY_REGISTRANTLODGING Provides the ability to query lodging associated with a registrant.
V_QUERY_REGISTRANTMAPPEDREGISTRATION Provides the ability to query the registrations mapped to a registrant.
V_QUERY_REGISTRANTPAYMENT This provides the ability to query for payments applied to event registrants.
V_QUERY_REGISTRANTPREFERENCE This provides the ability to query for registrant preferences.
V_QUERY_REGISTRANTREGISTRATION This provides the ability to query for registrant registrations.
V_QUERY_REGISTRANTREGISTRATIONINFORMATION
V_QUERY_REGISTRANTREGISTRATIONMAPPEDPREFERENCE Provides the ability to query the preferences mapped to a registrant's mapped registration.
V_QUERY_REGISTRANTREGISTRATIONMAPPEDREGISTRANT Provides the ability to query the registrants mapped to a registration.
V_QUERY_REGISTRANTRESTRICTIONOPTION Registrant Restriction Option Query
V_QUERY_REGISTRANTROLE Provides support for querying on Registrant Role information.
V_QUERY_REGISTRANTTRAVEL Provides the ability to query travel associated with a registrant.
V_QUERY_REGISTRATIONINFORMATION
V_QUERY_REGISTRATIONINFORMATIONOPTION
V_QUERY_REGISTRATIONINFORMATIONPRICETYPE
V_QUERY_REGISTRATIONPACKAGE Query view used for registration package information.
V_QUERY_REGISTRATIONPACKAGEPRICE Query view used for registration package registration option information.
V_QUERY_REGISTRATIONRESTRICTIONS Query view used for restrictions of the registration type.
V_QUERY_REGISTRATIONWAIVER Provides support for querying on Registration Waiver information.
V_QUERY_RELATIONSHIPJOBINFO Job information for a constituent.
V_QUERY_RELATIONSHIPMANAGER This provides the ability to query for constituent relationship managers.
V_QUERY_RELATIONSHIPS This provides the ability to query for constituent relationship information.
V_QUERY_REMINDERSEXPORTROOT Export definitions used with reminders are based on this query view.
V_QUERY_REPORT Provides support for querying on Report metadata from the application catalog.
V_QUERY_REPORTDATARETRIEVALOBJECTS Provides support for querying on report data retrieval objects.
V_QUERY_REPORTPARAMETERS Provides support for querying on the parameters for reports from the application catalog.
V_QUERY_REPORTSELECTIONFILTERS Provides support for querying on report selection filters.
V_QUERY_RERECEIPTHISTORY Provides ability to query the re-receipt history
V_QUERY_RESEARCHGROUP Provides the ability to query research groups.
V_QUERY_RESEARCHGROUPADDMEMBERS
V_QUERY_RESEARCHGROUPADDMEMBERS_ANYADDRESS
V_QUERY_RESEARCHGROUPADDMEMBERS_ANYBUSINESS
V_QUERY_RESEARCHGROUPADDMEMBERS_ANYEDUCATION
V_QUERY_RESEARCHGROUPADDMEMBERS_ANYPRIMARY
V_QUERY_RESEARCHGROUPADDMEMBERS_BUSINESSOWNERSHIP
V_QUERY_RESEARCHGROUPADDMEMBERS_CONSTITUENCY
V_QUERY_RESEARCHGROUPADDMEMBERS_PHILANTHROPICGIFT
V_QUERY_RESEARCHGROUPADDMEMBERS_POLITICALDONATION
V_QUERY_RESEARCHGROUPADDMEMBERS_PRIMARYADDRESS
V_QUERY_RESEARCHGROUPADDMEMBERS_PRIMARYBUSINESS
V_QUERY_RESEARCHGROUPADDMEMBERS_REALESTATE
V_QUERY_RESEARCHGROUPADDMEMBERSRATINGS
V_QUERY_RESEARCHGROUPMEMBER This provides the ability to query research group members.
V_QUERY_RESEARCHGROUPSITE Provides the ability to query site information on research group data.
V_QUERY_RESERVATION Provides the ability to query reservation information.
V_QUERY_RESERVATIONATTACHMENT Provides the ability query reservation attachment information.
V_QUERY_RESERVATIONMEDIALINK Provides the ability query reservation media link information.
V_QUERY_RESERVATIONNOTE Provides the ability query reservation note information.
V_QUERY_RESERVATIONRATESCALE Provides the ability to query reservation rate scale information.
V_QUERY_RESERVATIONRATESCALEAPPLICATION Provides the ability to query reservation rate scale application information.
V_QUERY_RESERVATIONRATESCALEFEE Provides the ability query reservation rate scale fee information.
V_QUERY_RESERVATIONRATESCALEPRICE Provides the ability query reservation rate scale price information.
V_QUERY_RESERVATIONRATESCALEPROGRAM Provides the ability query reservation rate scale program information.
V_QUERY_RESERVATIONRATESCALERESOURCE Provides the ability query reservation rate scale supplies/equipment resource information.
V_QUERY_RESERVATIONRATESCALESTAFFRESOURCE Provides the ability to query reservation rate scale staffing resource information.
V_QUERY_RESERVATIONSTATUSHISTORY Provides the ability query reservation status history information.
V_QUERY_RESOURCE Provides the ability to query supplies and equipment resources.
V_QUERY_RESOURCETAX Provides the ability to query supply/equipment resource taxes.
V_QUERY_RESPONSE Provides the ability to query response fields.
V_QUERY_REVENUE Revenue
V_QUERY_REVENUE_GIFTAID Provides the ability to query revenue gift aid.
V_QUERY_REVENUE_GIFTAID_CALCULATED
V_QUERY_REVENUE_INSTALLMENTPLANBALANCE
V_QUERY_REVENUE_PLEDGEBALANCE Revenue Pledge Balance view used in reporting
V_QUERY_REVENUEADJUSTMENT Revenue Adjustment
V_QUERY_REVENUEATTACHMENT This provides to ability to query for revenue attachments.
V_QUERY_REVENUEBATCHCONTROLREPORT View used for output for Revenue Batch Control Report.
V_QUERY_REVENUEBATCHEXCEPTIONREPORT View used for output for Revenue Batch Exception Report
V_QUERY_REVENUEBBNC
V_QUERY_REVENUEBENEFIT Revenue benefit information
V_QUERY_REVENUECOMMITMENTREVALUATION Provides the ability to query for revenue commitment revaluation records.
V_QUERY_REVENUEGLDISTRIBUTION Provides the ability to query on a revenue's GL distribution.
V_QUERY_REVENUELETTER Provides the ability to query revenue letters for a revenue record.
V_QUERY_REVENUELIFECYCLE Provides a means of querying on donor lifecycle data.
V_QUERY_REVENUELIFECYCLEHISTORY Provides a means of querying on donor lifecycle history data.
V_QUERY_REVENUELOCKBOX Returns information relating to the lockbox revenue.
V_QUERY_REVENUEMARKETING Revenue Appeal query for marketing integration.
V_QUERY_REVENUEMEDIALINK This provides to ability to query for revenue media links.
V_QUERY_REVENUENOTE This provides to ability to query for revenue notes.
V_QUERY_REVENUEOPPORTUNITY Provides the ability to query opportunities associated with revenue.
V_QUERY_REVENUEOPTIONS Query view used for the revenue options of the faf event.
V_QUERY_REVENUERECEIPT Provides the ability to query revenue receipts.
V_QUERY_REVENUERECOGNITION Provides the ability to query revenue recognition credits.
V_QUERY_REVENUEREGISTRANT This provides the ability to query for payments applied to event registrants.
V_QUERY_REVENUESEGMENT Provides the ability to query marketing information (such as mailings, segments, and source code parts) related to revenue from the 'Revenue Marketing' source view.
V_QUERY_REVENUESOLICITOR Revenue solicitor information
V_QUERY_REVENUESOLICITORPOSITION Revenue Solicitor position information.
V_QUERY_REVENUESPLIT Revenue application information
V_QUERY_REVENUESPLIT_GIFTAID Provides the ability to query revenue split gift aid.
V_QUERY_REVENUESPLIT_GIFTAID_CALCULATED
V_QUERY_REVENUESPLIT_GIFTFEE Revenue split gift fee query
V_QUERY_REVENUESPLITBUSINESSUNIT Query view used for appeal business unit information.
V_QUERY_REVENUESPLITCAMPAIGN Provides the ability to query revenue split campaigns.
V_QUERY_REVENUESPLITINFO Provides the ability to query for details of a revenue split.
V_QUERY_REVENUESPLITOTHER Provides the ability to query for other details of a revenue split.
V_QUERY_REVENUETRIBUTE Provides the ability to query on revenue tributes.
V_QUERY_REVENUETRIBUTELETTER Provides the ability to query revenue tribute letters for a revenue record.
V_QUERY_SALESMETHOD Provides the ability to query sales methods.
V_QUERY_SALESMETHODDELIVERYMETHOD Sales Method Delivery Methods
V_QUERY_SALESMETHODDISCOUNT Provides the ability to query sales method discounts.
V_QUERY_SALESMETHODEXCLUDEDPRICETYPE Provides the ability to query prohibited price types for a sales method.
V_QUERY_SALESMETHODFEE Provides the ability to query sales method fees.
V_QUERY_SALESMETHODPAYMENTMETHOD Sales Method Payment Types
V_QUERY_SALESORDER Provides the ability to query sales orders.
V_QUERY_SALESORDERALERTEMAILSUBSCRIPTION
V_QUERY_SALESORDERATTACHMENT Provides to ability to query for sales order attachments.
V_QUERY_SALESORDERITEM Provides the ability to query sales order items.
V_QUERY_SALESORDERITEM_RESOURCE Provides the ability to query sales order supplies/equipment resources.
V_QUERY_SALESORDERITEM_STAFFRESOURCE Provides the ability to query sales order staffing resources.
V_QUERY_SALESORDERITEMDISCOUNT Provides the ability to query sales order discounts.
V_QUERY_SALESORDERITEMDONATION Provides the ability to query sales order donations.
V_QUERY_SALESORDERITEMEVENTREGISTRATION Provides the ability to query sales order event registrations.
V_QUERY_SALESORDERITEMFACILITY Provides the ability to query sales order facilities.
V_QUERY_SALESORDERITEMFEE Provides the ability to query sales order fees.
V_QUERY_SALESORDERITEMMEMBERSHIP Provides the ability to query sales order memberships.
V_QUERY_SALESORDERITEMMEMBERSHIPADDON
V_QUERY_SALESORDERITEMMEMBERSHIPITEMPROMOTION Provides the ability to query sales order membership item promotions.
V_QUERY_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM Provides the ability to query sales order membership item promotion applied items.
V_QUERY_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET Provides the ability to query sales order membership item promotion applied item tickets.
V_QUERY_SALESORDERITEMMERCHANDISE Provides the ability to query sales order merchandise.
V_QUERY_SALESORDERITEMORDERDISCOUNTDETAIL Provides the ability to query order level discount distribution details.
V_QUERY_SALESORDERITEMTAX Provides the ability to query sales order taxes.
V_QUERY_SALESORDERITEMTICKET Provides the ability to query sales order tickets.
V_QUERY_SALESORDERITEMTICKETREGISTRANT Provides the ability to query sales order registrants.
V_QUERY_SALESORDERMEDIALINK This provides to ability to query for sales order media links.
V_QUERY_SALESORDERNOTE This provides to ability to query for sales order notes.
V_QUERY_SALESORDERPAYMENT Provides the ability to query sales order payments.
V_QUERY_SEARCHLIST Provides support for querying on Search List metadata from the application catalog.
V_QUERY_SEARCHLISTFIELDS Provides support for querying on the fields for search lists from the application catalog.
V_QUERY_SEARCHLISTOUTPUT Provides support for querying on the output for search lists from the application catalog.
V_QUERY_SECONDARYFUNDRAISER Prospect plans.
V_QUERY_SECONDARYPLANFORFUNDRAISER Allows a fundraiser query to display plans on which the fundraiser is a secondary solicitor.
V_QUERY_SELECTIONBASEDAPPEALMAILING Provides the ability to query selection-based appeal mailings.
V_QUERY_SEPAMANDATE
V_QUERY_SIMPLEDATALIST Provides support for querying on Simple Data List metadata from the application catalog.
V_QUERY_SIMPLEDATALISTPARAMETERS Provides support for querying on the parameters for simple data lists in the application catalog.
V_QUERY_SITE Query view used for site information.
V_QUERY_SMARTFIELD Provides support for querying on smart field metadata from the application catalog.
V_QUERY_SMARTFIELDPARAMETERS Provides support for querying on the parameters for smart fields in the application catalog.
V_QUERY_SMARTQUERY Provides support for querying on smart query metadata from the application catalog.
V_QUERY_SMARTQUERYINSTANCE Provides the ability to query smart query instances.
V_QUERY_SMARTQUERYOUTPUT Provides support for querying on the output for smart queries in the application catalog.
V_QUERY_SMARTQUERYPARAMETERS Provides support for querying on the parameters for smart queries from the application catalog.
V_QUERY_SOCIALMEDIAACCOUNTWP
V_QUERY_SOCIALNETWORKS Query view used for the social networks of the FAF event.
V_QUERY_SOCIALNETWORKSTATUSUPDATELOG Provides support for querying on Social Networking Status Log information.
V_QUERY_SOLICITCODECHANNELOPTOUT
V_QUERY_SPONSOR This provides the ability to query all sponsor fields.
V_QUERY_SPONSORSHIP This provides the ability to query all sponsorship fields.
V_QUERY_SPONSORSHIPBATCHCONTROLREPORT View used for output for Revenue Batch Control Report.
V_QUERY_SPONSORSHIPBATCHEXCEPTIONREPORT View used for output for Sponsorship Batch Exception Report
V_QUERY_SPONSORSHIPGREATESTNEEDCHILD Returns the subset of fields on a child used for determining greatest need.
V_QUERY_SPONSORSHIPGREATESTNEEDPROJECT Returns the subset of fields on a project used for determining greatest need.
V_QUERY_SPONSORSHIPLOCATION This provides the ability to query all sponsorship location fields.
V_QUERY_SPONSORSHIPLOCATIONPARENT Returns the parent locations for a sponsorship location.
V_QUERY_SPONSORSHIPMARKETING This provides the ability to query all sponsorship marketing fields.
V_QUERY_SPONSORSHIPOPPORTUNITY This provides the ability to query all sponsorship opportunity fields.
V_QUERY_SPONSORSHIPOPPORTUNITYATTACHMENT This provides the ability to query for sponsorship opportunity attachments.
V_QUERY_SPONSORSHIPOPPORTUNITYCHILD This provides the ability to query all sponsorship opportunity child fields.
V_QUERY_SPONSORSHIPOPPORTUNITYCHILDREASON This provides the ability to query sponsorship opportunity child reasons.
V_QUERY_SPONSORSHIPOPPORTUNITYCMS This provides the ability to query all sponsorship fields. The queries will appear in sponsorship search part of the CMS.
V_QUERY_SPONSORSHIPOPPORTUNITYGREATESTNEED Returns all valid sponsorship opportunity/program combinations and the opportunity's greatest need for the program.
V_QUERY_SPONSORSHIPOPPORTUNITYGREATESTNEEDCMS
V_QUERY_SPONSORSHIPOPPORTUNITYGROUP This provides the ability to query all sponsorship opportunity group fields.
V_QUERY_SPONSORSHIPOPPORTUNITYMEDIALINK This provides the ability to query for sponsorship opportunity media links.
V_QUERY_SPONSORSHIPOPPORTUNITYNOTE This provides to ability to query for sponsorship opportunity notes.
V_QUERY_SPONSORSHIPOPPORTUNITYPROJECT This provides the ability to query all sponsorship opportunity project fields.
V_QUERY_SPONSORSHIPOPPORTUNITYPROJECTREASON This provides the ability to query sponsorship opportunity project reasons.
V_QUERY_SPONSORSHIPOPTIONBENEFITS Query view used for sponsorship options benefits of the faf event.
V_QUERY_SPONSORSHIPOPTIONS Query view used for goals of the faf event.
V_QUERY_SPONSORSHIPPROGRAM This provides the ability to query all sponsorship program fields.
V_QUERY_SPONSORSHIPRECURRINGADDITIONALGIFT This provides the ability to query linked sponsorship recurring additional gift.
V_QUERY_SPONSORSHIPTRANSACTION Returns all sponsorship transactions.
V_QUERY_STAFFCONSTITUENCY This provides the ability to query staff constituency information.
V_QUERY_STAFFINGRESOURCE Provides the ability to query staffing resources.
V_QUERY_STAFFINGRESOURCETAX Provides the ability to query staffing resource taxes.
V_QUERY_STANDINGORDERACCOUNT This provides the ability to query constituent financial account information for standing orders.
V_QUERY_STEP Query view for prospect plan steps.
V_QUERY_STEWARDSHIP_PLAN_STEP_UPDATEEXCEPTIONREPORT View used for output for the Stewardship Plan Step Update batch exception report.
V_QUERY_STEWARDSHIPATTACHMENTS Stewardship attachments.
V_QUERY_STEWARDSHIPMEDIALINKS Stewardship media links.
V_QUERY_STEWARDSHIPNOTES Stewardship notes.
V_QUERY_STEWARDSHIPPLAN Provides the ability to query stewardship plans.
V_QUERY_STEWARDSHIPPLANMANAGERHISTORY Provides the ability to query on steward plan manager history fields.
V_QUERY_STEWARDSHIPPLANSITE Provides the ability to query stewardship plan sites.
V_QUERY_STEWARDSHIPPLANSTEPPARTICIPANT Stewardship plan step participants.
V_QUERY_STEWARDSHIPPLANSTEPS Provides the ability to query stewardship plan steps.
V_QUERY_STEWARDSHIPPLANSTEWARDS Stewardship plan stewards.
V_QUERY_STEWARDSHIPSTEPASSOCIATEDPLANS Stewardship plan stewards.
V_QUERY_STOCKSALE Provides the ability to query stock sales.
V_QUERY_STOCKSALEADJUSTMENT Provides the ability to query stock sale adjustments.
V_QUERY_STORY Provides support for querying on Story information.
V_QUERY_STUDENT Provides support for querying on Student information.
V_QUERY_STUDENT_ENROLLMENT Provides support for querying on student enrollment information.
V_QUERY_STUDENT_MARKINGCOLUMN_GRADES Provides support for querying on Marking Column Grades.
V_QUERY_STUDENT_PROGRESSION Provides support for querying on Student Progression information.
V_QUERY_STUDENT_PROGRESSION_ADVISOR Provides support for querying on student progression advisor information.
V_QUERY_STUDENTCLASSMEETING Provides support for querying on the class records associated to a Student.
V_QUERY_STUDENTCLASSMEETINGGROUP Provides support for querying on the class records associated to a Student.
V_QUERY_STUDENTCOURSEREQUEST Provides support for querying student course requests.
V_QUERY_STUDENTPROGRESSION_CURRENTSTUDENTPROGRESSIONS Provides support for querying on current student progression information.
V_QUERY_STUDENTRELATIONSHIPS This provides the ability to query for student relationship information.
V_QUERY_SUBEVENT Query view that pulls each event's sub-events.
V_QUERY_SURVEY Provides the ability to query surveys.
V_QUERY_SURVEYATTACHMENT This query view spec definition provides the ability to query for survey attachments.
V_QUERY_SURVEYMEDIALINK This query view spec definition provides the ability to query for survey media links.
V_QUERY_SURVEYNOTE This query view spec definition provides the ability to query for survey notes.
V_QUERY_SURVEYRESPONSE Provides the ability to query survey responses.
V_QUERY_SYSTEMPROLEPERM_BATCHTYPE Provides the ability to query batch type permissions for a given role.
V_QUERY_SYSTEMPROLEPERM_CODETABLE List of code table permissions assigned to a system role.
V_QUERY_SYSTEMPROLEPERM_KPI Provides the ability to query KPI permissions for a given role.
V_QUERY_SYSTEMROLE List of all System Roles.
V_QUERY_SYSTEMROLEADGROUP List of Active Directory/NT groups setup to synchronize to a System role.
V_QUERY_SYSTEMROLEADGROUPCONSTITUENTSECURITYGROUP List of all constituent security groups assigned to an active directory group on a system role.
V_QUERY_SYSTEMROLEADGROUPSITE List of all sites assigned to an active directory group.
V_QUERY_SYSTEMROLEAPPUSER Joins System Role to Application Users.
V_QUERY_SYSTEMROLEAPPUSERCONSTITUENTSECURITYGROUP List of all constituent security groups assigned to an application user in a system role.
V_QUERY_SYSTEMROLEAPPUSERSITE List of all sites assigned to an application user in a system role.
V_QUERY_SYSTEMROLEFEATUREGROUPPERMS
V_QUERY_SYSTEMROLEFEATUREPERMS List of feature permissions that have been assigned to a role.
V_QUERY_SYSTEMROLEPERM_QUERYVIEW Query view permissions assigned to a role.
V_QUERY_SYSTEMROLETASK List of tasks assigned to a system role.
V_QUERY_TABLESTATISTICS Used to query table statistics for the system.
V_QUERY_TASK Provides support for querying on task metadata from the application catalog.
V_QUERY_TAX Provides the ability to query taxes.
V_QUERY_TAXDECLARATION Provides the ability to query tax declarations.
V_QUERY_TAXITEM Provides the ability to query tax items.
V_QUERY_TAXPROGRAM Query view for taxes on programs.
V_QUERY_TEAMEXTENSION Provides support for querying on Team Extension information.
V_QUERY_TEAMFUNDRAISER Provides the ability to query for team fundraisers.
V_QUERY_TEAMFUNDRAISERFROMAPPEAL Provides the ability to query for team fundraisers in the context of an appeal.
V_QUERY_TEAMFUNDRAISERFROMCONSTITUENT Provides the ability to query for team fundraisers in the context of a constituent.
V_QUERY_TEAMFUNDRAISINGTEAM Provides the ability to query for team fundraising team.
V_QUERY_TEAMFUNDRAISINGTEAMCAPTAIN Provides the ability to query for captains of team fundraising teams.
V_QUERY_TEAMFUNDRAISINGTEAMCAPTAINFROMCONSTITUENT Provides the ability to query for captains of team fundraising teams from the context of a constituent.
V_QUERY_TEAMFUNDRAISINGTEAMMEMBER Provides the ability to query for members of team fundraising teams.
V_QUERY_TEAMFUNDRAISINGTEAMMEMBERFROMTEAMFUNDRAISER Provides the ability to query for team fundraising team membership information from a team fundraiser.
V_QUERY_TEAMGOALS Query view used for household goals.
V_QUERY_THIRDPARTYAUTH_APPLICATIONUSERS
V_QUERY_TICKET Provides the ability to query tickets.
V_QUERY_TICKETPRINTINFO TicketPrintInfo
V_QUERY_TIMESHEET This provides the ability to query timesheet fields.
V_QUERY_TIMESHEETBATCHCONTROLREPORT View used for output of the timesheet batch control report.
V_QUERY_TIMESHEETBATCHEXCEPTIONREPORT View used for output for Timesheet Batch Exception Report.
V_QUERY_TRACK Provides the ability to query track information.
V_QUERY_TRACKITEM Provides the ability query track item information.
V_QUERY_TRACKITEMRESOURCE Provides the ability query track item resource information.
V_QUERY_TRACKITEMSTAFFRESOURCE Provides the ability query track item staff resource information.
V_QUERY_TRACKRESOURCE Provides the ability query track resource information.
V_QUERY_TRACKSTAFFRESOURCE Provides the ability query track staff resource information.
V_QUERY_TRANSACTION Provides the ability to query transactions.
V_QUERY_TRIBUTE Provides the ability to query on tributes.
V_QUERY_TRIBUTEACKNOWLEDGEE Provides the ability to query on tribute acknowledgees.
V_QUERY_TRIBUTEACKNOWLEDGEMENT Provides the ability to query tribute acknowledgements.
V_QUERY_TRIBUTEACKNOWLEDGEMENTPROCESS_EMAILOUTPUT View used for email output for the tribute acknowledgement process.
V_QUERY_TRIBUTEACKNOWLEDGEMENTPROCESS_STANDARDOUTPUT View used for standard output for the tribute acknowledgement process.
V_QUERY_TRIBUTELETTERCODE Provides the ability to query tribute letters.
V_QUERY_TRIBUTELETTERCODESITE Query view used for tribute letter site information.
V_QUERY_TRIBUTENOTIFICATION Query view used for notification of memorial and tribute in registrant.
V_QUERY_TRIBUTESITE Query view used for tribute site information.
V_QUERY_UNREALIZEDGAINLOSSGLDISTRIBUTION Provides the ability to query on a revenue's unrealized gain/loss GL distributions.
V_QUERY_USERDEFINEDELEMENTATTACHMENT This query view spec definition provides the ability to query for user-defined element attachments.
V_QUERY_USERDEFINEDELEMENTMEDIALINK This query view spec definition provides the ability to query for user-defined element media links.
V_QUERY_USERDEFINEDELEMENTNOTE This query view spec definition provides the ability to query for user-defined element notes.
V_QUERY_VENDOR Query for vendors.
V_QUERY_VENDOR1099ADJUSTMENT Query for vendor 1099 adjustments.
V_QUERY_VENDOR1099DISTRIBUTION Query for vendor 1099 distributions.
V_QUERY_VIDEO Provides support for querying on Video information.
V_QUERY_VOLUNTEER This provides the ability to query all volunteer fields.
V_QUERY_VOLUNTEERADMINISTRATIVE This provides the ability to query all volunteer administrative trait fields.
V_QUERY_VOLUNTEERASSIGNMENTS This provides the ability to query all volunteer assignments.
V_QUERY_VOLUNTEERATTACHMENT This provides to ability to query for volunteer attachments.
V_QUERY_VOLUNTEERAVAILABILITY This provides the ability to query all volunteer availability fields.
V_QUERY_VOLUNTEERAWARDASSIGNMENT Selects volunteer award assignments
V_QUERY_VOLUNTEERCERTIFICATION This provides the ability to query all volunteer certifications fields.
V_QUERY_VOLUNTEERCOURSE This provides the ability to query all volunteer course fields.
V_QUERY_VOLUNTEERINTEREST This provides the ability to query all volunteer interests fields.
V_QUERY_VOLUNTEERLICENSE This provides the ability to query all volunteer license fields.
V_QUERY_VOLUNTEERMEDIALINK This provides to ability to query for volunteer media links.
V_QUERY_VOLUNTEERMEDICAL This provides the ability to query all volunteer medical fields.
V_QUERY_VOLUNTEERNOTE This provides to ability to query for volunteer notes.
V_QUERY_VOLUNTEERSCREENPLAN This provides the ability to query all volunteer screening plans.
V_QUERY_VOLUNTEERSCREENPLANSTEP This provides the ability to query all volunteer screening plan steps.
V_QUERY_VOLUNTEERSKILL This provides the ability to query all volunteer skill fields.
V_QUERY_VOLUNTEERSPECIALNEED This provides the ability to query all volunteer specialneed fields.
V_QUERY_VOLUNTEERTRAITS This provides the ability to query all volunteer traits in a consolidated view.
V_QUERY_VOLUNTEERVOLUNTEERLOCATION This provides the ability to query all volunteer location fields.
V_QUERY_VOLUNTEERVOLUNTEERTYPE This provides the ability to query all volunteer types.
V_QUERY_WEALTH Wealth
V_QUERY_WEALTHCAPACITY Provides the ability to query wealth capacity.
V_QUERY_WORKFLOWINBOX Provides support for querying on workflow inbox information.
V_QUERY_WORKSTATION Provides the ability to query workstations.
V_QUERY_WORKSTATIONCASHDRAWEROPEN Query view used for no sale/open cash drawer information.
V_QUERY_WORKSTATIONPRINTER Provides the ability to query sales workstation printers.
V_QUERY_WPAFFLUENCEINDICATOR Select all WealthPoint Affluence Indicator data.
V_QUERY_WPBIOGRAPHICAL Select all WealthPoint Biographical data.
V_QUERY_WPBIOGRAPHICALDEMOGRAPHIC
V_QUERY_WPBIOGRAPHICALHHMEMBER
V_QUERY_WPBUSINESSOWNERSHIP Select all WealthPoint Business Ownership data.
V_QUERY_WPBUSINESSOWNERSHIPBIOS Select all WealthPoint Business Ownership Bios data.
V_QUERY_WPBUSINESSOWNERSHIPOWNERSHIP Select all WealthPoint Business Ownership Ownership data.
V_QUERY_WPCAMPAIGNCONTRIBUTION Prospect Wealth Political Donation
V_QUERY_WPDUNANDBRADSTREET Prospect Wealth Business
V_QUERY_WPFOUNDATIONASSETS Prospect Wealth Private Foundations
V_QUERY_WPGIFT Prospect Wealth Philanthropic Gift
V_QUERY_WPINCOMECOMPENSATION Select all WealthPoint Income/Compensation data.
V_QUERY_WPLEXISNEXIS WPLexisNexis
V_QUERY_WPMARKETGUIDE Prospect Wealth Income/Compensation
V_QUERY_WPMILLIONAIREPENSION Prospect Wealth Millionaire/Pension
V_QUERY_WPNONPROFITAFFILIATION Select all WealthPoint Nonprofit Affiliation data.
V_QUERY_WPNONPROFITOFFICER Prospect Wealth Non-Profit Officer/Director
V_QUERY_WPPHILANTHROPICGIFT Selects all WealthPoint Philanthropic Gift data.
V_QUERY_WPPOLITICALDONATION Select all WealthPoint Political Donation data.
V_QUERY_WPPRIVATEFOUNDATION Selects all WealthPoint Private Foundation data.
V_QUERY_WPREALESTATE Select all WealthPoint Real Estate data.
V_QUERY_WPRELATIONSHIP_BO Select all WealthPoint Business relationship data.
V_QUERY_WPRELATIONSHIP_BO_IND Select all WealthPoint Business relationship individual data.
V_QUERY_WPRELATIONSHIP_NPA Select all WealthPoint Nonprofit Affiliation relationship data.
V_QUERY_WPRELATIONSHIP_NPA_IND Select all WealthPoint Nonprofit Affiliation relationship individual data.
V_QUERY_WPRELATIONSHIP_PF Select all WealthPoint Private Foundation relationship data.
V_QUERY_WPRELATIONSHIP_PF_IND Select all WealthPoint Private Foundation relationship individual data.
V_QUERY_WPSEARCHHISTORY Provides the ability to query WealthPoint Search History.
V_QUERY_WPSECURITIES Select all WealthPoint Securities data.
V_QUERY_WPSECURITIESTRANSACTION Select all WealthPoint Securities Transactions data.
V_QUERY_WPSOCIAL
V_QUERY_WPSOCIALIMAGE
V_QUERY_WPSOCIALPROFILE
V_QUERY_WPWHOSWHO Prospect Wealth Biographical
V_QUERY_WRITEOFFADJUSTMENT Provides the ability to query write-off adjustment data.
V_QUERY_WRITEOFFGLDISTRIBUTION Provides the ability to query write-off GL distribution information.
V_QUEUEPROCESS_UNIQUE_NAME Used to enforce unique values on the QUEUEPROCESS.NAME field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the QUEUEPROCESS table.
V_RECORDOPERATIONCATALOG_UNIQUE_PROCEDURENAME
V_RECORDTYPE_UNIQUE_BASETABLENAME
V_RECURRINGGIFTINSTALLMENT
V_REVENUE_WITHNULLCONSTITUENTSECURITY
V_REVENUE_WITHNULLSITESECURITY
V_SCHEMA_INDEXCOLUMNS
V_SCHEMA_INDEXINCLUDECOLUMNS
V_SCHEMA_TABLEINDEXES
V_SCHOLARSHIPTERM
V_SEARCH_APPUSER Used to search for Application Users
V_SEARCH_BANK This search is for finding bank constituent organizations.
V_SEARCH_BANK_2
V_SEARCH_BANKACCOUNT This search list searches for a bank account.
V_SEARCH_BANKACCOUNTADJUSTMENTCATEGORY Search for a bank account adjustment category.
V_SEARCH_BANKACCOUNTDEPOSIT This searches for a deposit.
V_SEARCH_BENEFIT Search screen for finding benefit records.
V_SEARCH_CALENDARCATALOG Search for a Calendar.
V_SEARCH_CAMPAIGN Search screen for finding a campaign.
V_SEARCH_COMMUNICATIONLETTER Search for communication letters.
V_SEARCH_CREDIT_REFUND Search for refunds by patron, date, or program.
V_SEARCH_CURRENCY Used to search for currencies.
V_SEARCH_DESIGNATION Search screen for finding a node of the giving hierarchy.
V_SEARCH_DESIGNATIONHIERARCHY Search screen for finding hierarchies.
V_SEARCH_DESIGNATIONLEVEL Search screen for finding Fundraising Purpose records.
V_SEARCH_DIRECTMARKETINGEFFORTBATCHLIST Search for lists.
V_SEARCH_DIRECTMARKETINGEFFORTBATCHPACKAGE Search screen for finding package records.
V_SEARCH_DIRECTMARKETINGEFFORTBATCHSEGMENT Search for direct marketing segments.
V_SEARCH_DIRECTMARKETINGEFFORTBATCHTESTSEGMENT Search for direct marketing test segments.
V_SEARCH_EVENTLOCATION Search screen for event location records.
V_SEARCH_EVENTLODGINGLOCATION This provides the ability to search for event lodging locations.
V_SEARCH_FINANCIALINSTITUTION This search is used for finding constituent financial institutions.
V_SEARCH_FUNDINGPLAN Search screen for funding plan records.
V_SEARCH_GRANT Search screen for grant program records.
V_SEARCH_INVITATION Search screen for invitation process parameter sets.
V_SEARCH_INVITEE Provides the ability to search for invitees.
V_SEARCH_JOB This search is for finding jobs.
V_SEARCH_JOBOCCURRENCE This search is for finding job occurrences.
V_SEARCH_KPICATALOG Search for a KPI type
V_SEARCH_KPIINSTANCE Searches for a KPI instance.
V_SEARCH_LEDGERACCOUNT Search for accounts.
V_SEARCH_LOCALE Used to search for locales.
V_SEARCH_MGRELATIONREVENUE Search screen for finding a matching gift relation revenue for an organization.
V_SEARCH_MISCELLANEOUSPAYMENT Search for a miscellaneous payment.
V_SEARCH_MKTACKNOWLEDGEMENTMAILINGTEMPLATE Search for marketing acknowledgement templates.
V_SEARCH_MKTLETTERCODE Search screen for finding letter records.
V_SEARCH_MKTLIST Search for lists.
V_SEARCH_MKTMEMBERSHIPMAILINGTEMPLATE Search for membership renewal effort templates.
V_SEARCH_MKTVENDOR This provides the ability to search for vendors by name or by contact, listing all contacts in the results.
V_SEARCH_NAMINGOPPORTUNITYFACILITY Search screen for naming opportunity facility records.
V_SEARCH_NONBANK This search is for finding constituent organizations that are not banks.
V_SEARCH_OPPORTUNITY Search for Opportunity
V_SEARCH_OUTSTANDING_PLEDGE
V_SEARCH_PACKAGE Search screen for finding package records.
V_SEARCH_PATRON Provides a quick ability to search constituents by name, address, phone, or membership.
V_SEARCH_PAYABLEVENDOR Search for individual and organization records.
V_SEARCH_PAYMENT Search for a payment.
V_SEARCH_RE7APPEAL
V_SEARCH_RE7BBNCPAGE
V_SEARCH_RE7BBNCWEBTRAFFICPAGE
V_SEARCH_RE7CAMPAIGN
V_SEARCH_RE7CONSTITUENT
V_SEARCH_RE7CONSTITUENTRATING
V_SEARCH_RE7EVENT
V_SEARCH_RE7FUND
V_SEARCH_RE7MEMBERSHIPRENEWAL
V_SEARCH_RE7PACKAGE
V_SEARCH_RE7REVENUE
V_SEARCH_RE7TRIBUTEDESCRIPTION
V_SEARCH_RESEARCHGROUP This search is used for finding research groups.
V_SEARCH_REVENUE Search for Revenue
V_SEARCH_SALESORDER Search for orders by patron, date, order number, or program.
V_SEARCH_SEGMENT Search for segments.
V_SEARCH_SEGMENTATION Search for marketing efforts.
V_SEARCH_SEGMENTMEDIAOUTLET Search for a media outlet.
V_SEARCH_SEGMENTPASSIVE Search for media outlets, time slots and marketing locations.
V_SEARCH_SITE Search screen for finding a site.
V_SEARCH_TEAMFUNDRAISINGTEAM Search screen for finding team fundraising team records.
V_SEARCH_TRANSACTION Search for transactions in revenue update batch
V_SEARCH_TRIBUTE Search for tributes.
V_SEARCH_UNLINKEDCREDITPAYMENT Search for refund payments that have been reconciled but are not linked to a bank account deposit.
V_SEARCH_VOLUNTEER This search is for finding constituents who are members of the volunteer.
V_SEARCHLIST_ACKNOWLEDGEMENT Search screen for finding acknowledgement processes.
V_SEARCHLIST_APPEAL Search screen for finding appeal records associated with constituents.
V_SEARCHLIST_BOARDMEMBER This search is for finding constituents who are members of the board member constituency.
V_SEARCHLIST_CONSTITUENT This provides the ability to search for advocate
V_SEARCHLIST_CONSTITUENTBYLOOKUPID This provides the ability to search for constituents.
V_SEARCHLIST_CONSTITUENTBYNAMEORLOOKUPID
V_SEARCHLIST_CONSTITUENTFUNDRAISER Search for Fundraisers.
V_SEARCHLIST_CONSTITUENTMATCHINGGIFTORG This search is used for finding organizations which match gifts.
V_SEARCHLIST_CONSTITUENTMERGEDCONSTITUENTS Trace a merged constituent to the constituent with which it was merged.
V_SEARCHLIST_CONSTITUENTNONFUNDRAISER Search for constituents who are not fundraisers.
V_SEARCHLIST_CONSTITUENTNONPROSPECT Search for constituents who are not prospects.
V_SEARCHLIST_CONSTITUENTNONVOLUNTEER This search is for finding constituents who are not members of the volunteer.
V_SEARCHLIST_CONSTITUENTPROSPECT Search for stewarded donors.
V_SEARCHLIST_CONSTITUENTSOLICITOR Search for Solicitors.
V_SEARCHLIST_CONSTITUENTSPONSOR Search for sponsors
V_SEARCHLIST_CONSTITUENTVOLUNTEEREXCLUDEJOB This search is for finding constituents who are volunteers but not assigned to a job on a date.
V_SEARCHLIST_CONSTITUENTWITHCOMMITMENTDETAILS Provides the ability to search for constituents while displaying any outstanding commitments for that constituent.
V_SEARCHLIST_DONORCHALLENGE Search for and view donor challenges
V_SEARCHLIST_EDUCATIONALINSTITUTION This provides the ability to search for an educational institution.
V_SEARCHLIST_EVENT Search screen for event records.
V_SEARCHLIST_EVENT2 Search screen for event records.
V_SEARCHLIST_FACULTY Search for a faculty member.
V_SEARCHLIST_FACULTYADVISOR Search for a faculty advisor.
V_SEARCHLIST_FAFEVENT Used for FAFEvent Search
V_SEARCHLIST_FEE Search for a system fee.
V_SEARCHLIST_IDSET Search form for Selections.
V_SEARCHLIST_INDIVIDUAL
V_SEARCHLIST_INTERACTION This provides the ability to search for interactions.
V_SEARCHLIST_LETTERTEMPLATE This provides the ability to search for letter templates.
V_SEARCHLIST_MERCHANDISEPRODUCTINSTANCE Search for an inventory item.
V_SEARCHLIST_NAMINGOPPORTUNITY Search screen for finding naming opportunity records.
V_SEARCHLIST_NAMINGOPPORTUNITYRECOGNITION Searches for a naming opportunity recognition record.
V_SEARCHLIST_ORGANIZATION This search is used for finding organizations.
V_SEARCHLIST_ORGANIZATIONRECORD This provides the ability to search for organization records.
V_SEARCHLIST_PLEDGEREMINDER Search screen for finding pledge reminder processes.
V_SEARCHLIST_PROGRAM Simple way to select a program
V_SEARCHLIST_PROGRAMACTIVE Simple way to select an active program
V_SEARCHLIST_PROGRAMEVENT Provides the ability to search for program events.
V_SEARCHLIST_PROSPECTSEARCHADDINDIVIDUAL
V_SEARCHLIST_PROSPECTSEARCHPOPUPINDIVIDUAL
V_SEARCHLIST_PROSPECTSEARCHPOPUPORGANIZATION
V_SEARCHLIST_RECOGNITIONPROGRAM
V_SEARCHLIST_RECORD This provides the ability to search for records.
V_SEARCHLIST_RESOURCE Allows a user to search for a resource.
V_SEARCHLIST_REVENUECONSTITUENT This is used to search constituents on revenue forms.
V_SEARCHLIST_STAFF This search is for finding constituents who are capable of managing events.
V_SEARCHLIST_STUDENT Search for a Student.
V_SEARCHLIST_TAX Search system taxes.
V_SEARCHLIST_TRACK Searches for tracks specified by name.
V_SEARCHLIST_TRIBUTEEACKNOWLEDGEE A search list of tributee/acknowledgee
V_SEARCHLIST_VENDORCONTACT This provides the ability to search for individuals to serve as vendor contacts.
V_SEARCHLISTCATALOG_UNIQUE_PROCEDURENAME
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ADHOCQUERYFOLDER
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ADHOCQUERYINSTANCE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ADHOCQUERYINSTANCEEDIT
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ATTRIBUTECATEGORY
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATECUSTOMIZE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLEENTRY
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_DASHBOARD
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_DASHBOARD_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_DASHBOARD_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_DATALIST
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_DATALIST_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_DATALIST_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_KPI
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_KPI_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_KPI_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_MAPENTITY
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_MAPENTITY_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_MAPENTITY_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_REPORT
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_REPORT_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_REPORT_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SEARCHLIST
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SEARCHLIST_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SEARCHLIST_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SELECTION
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERYINSTANCE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE_BYROLE
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK_BYFEATUREGROUP
V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK_BYROLE
V_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGE Returns a list of academic catalog colleges for a given degree.
V_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGEIDQUERY Returns a list of academic catalog college IDs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGCOLLEGEQUERY Returns a list of academic catalog colleges for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDEGREE Returns a list of academic catalog degrees for a given program.
V_SIMPLEDATALIST_ACADEMICCATALOGDEGREEIDQUERY Returns a list of academic catalog degree IDs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDEGREEQUERY Returns a list of academic catalog degrees for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDEGREETYPE Returns a list of academic catalog degree types for a given department.
V_SIMPLEDATALIST_ACADEMICCATALOGDEGREETYPEIDQUERY Returns a list of academic catalog degree type IDs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT Returns a list of academic catalog departments for a given college.
V_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENTIDQUERY Returns a list of academic catalog department IDs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENTQUERY Returns a list of academic catalog departments for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDIVISIONIDQUERY Returns a list of academic catalog division IDs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGDIVISIONQUERY Returns a list of academic catalog divisions for query.
V_SIMPLEDATALIST_ACADEMICCATALOGPROGRAM Returns a list of academic catalog programs for a given educational institution.
V_SIMPLEDATALIST_ACADEMICCATALOGPROGRAMQUERY Returns a list of academic catalog programs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGSUBDEPARTMENTIDQUERY Returns a list of academic catalog sub department IDs for query.
V_SIMPLEDATALIST_ACADEMICCATALOGSUBDEPARTMENTQUERY Returns a list of academic catalog sub departments for query.
V_SIMPLEDATALIST_ACCOUNTSTRUCTURE List of all accounting elements
V_SIMPLEDATALIST_ACTIONCATEGORYCODE
V_SIMPLEDATALIST_ACTIONLOCATIONCODE
V_SIMPLEDATALIST_ACTIONPRIORITYCODE
V_SIMPLEDATALIST_ACTIONSTATUSCODE
V_SIMPLEDATALIST_ACTIONTYPECODE
V_SIMPLEDATALIST_ADDRESSCURRENT Returns a list of all current addresses for a constituent.
V_SIMPLEDATALIST_ADDRESSPROCESSINGOPTIONS A list of saved address processing option sets.
V_SIMPLEDATALIST_ADDRESSTYPE
V_SIMPLEDATALIST_ADJUSTMENTCATEGORY This provides a simple list of adjustment categories.
V_SIMPLEDATALIST_ADJUSTMENTCATEGORY2 This provides a simple list of adjustment categories.
V_SIMPLEDATALIST_ADJUSTMENTREASONCODES Returns a list of adjustment reason codes and descriptions.
V_SIMPLEDATALIST_APPEALCATEGORYCODE
V_SIMPLEDATALIST_APPLICATIONLIST A list of all applications
V_SIMPLEDATALIST_APPUSERTRANSACTIONCURRENCY Generates the list of transaction currencies available to a user through their currency set.
V_SIMPLEDATALIST_ASKLADDERLIST Returns a simple list of all ask ladders.
V_SIMPLEDATALIST_ATTRIBUTETYPECODE
V_SIMPLEDATALIST_AUCTIONITEMCATEGORY List of auction item categories.
V_SIMPLEDATALIST_AUCTIONITEMSUBCATEGORY Retrieves a list of auction item subcategories for a category in Query.
V_SIMPLEDATALIST_BANKACCOUNT This simple list returns a list of open bank accounts.
V_SIMPLEDATALIST_BANKACCOUNT_BANK This simple list returns a list of all banks.
V_SIMPLEDATALIST_BANKINGSYSTEMUNIVERSALNAME
V_SIMPLEDATALIST_BASECURRENCY Generates the list of currencies that should be available when assigning a record a new base currency.
V_SIMPLEDATALIST_BENEFITCODE
V_SIMPLEDATALIST_BUSINESSPROCESSVIEW A simple data list of available output views for a given business process.
V_SIMPLEDATALIST_CAMPAIGNCATEGORYCODE
V_SIMPLEDATALIST_CHANGEAGENTLIST Return the list of action centers
V_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERBYID Returns a list of charity claim reference numbers with the VALUE column set to the row ID.
V_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERQUERY Returns a list of charity claim reference numbers with the VALUE column set to the row ID.
V_SIMPLEDATALIST_CLASSOFDEGREECODE
V_SIMPLEDATALIST_CONSTIT_SECURITY_ATTRIBUTES This simple datalist returns all constituent security attributes in the system.
V_SIMPLEDATALIST_CONSTIT_SECURITY_ATTRIBUTES_FORUSER This simple datalist returns all constituent security attributes in the system that the given user has access to.
V_SIMPLEDATALIST_CONSTITUENCY This simple list returns all of the system and user defined constituencies.
V_SIMPLEDATALIST_CONSTITUENCYCODECODE
V_SIMPLEDATALIST_CONSTITUENCYCODEDESCRIPTION
V_SIMPLEDATALIST_CONSTITUENTCOUNTRY
V_SIMPLEDATALIST_CONSTITUENTDATAREVIEWROLLBACKREASONS Returns a list of constituent data review rollback reasons and descriptions.
V_SIMPLEDATALIST_CONSTITUENTINACTIVITYREASONCODES Returns a list of constituent inactivity reason codes and descriptions.
V_SIMPLEDATALIST_CONSTITUENTRATINGSOURCECODE
V_SIMPLEDATALIST_CONSTITUENTSOLICITCODE
V_SIMPLEDATALIST_CONSTITUENTSTATE
V_SIMPLEDATALIST_CONSTITUENTSTATEABBREVIATION
V_SIMPLEDATALIST_CONTACTTYPECODE
V_SIMPLEDATALIST_CORRESPONDENCECODE Returns a list of correspondence codes.
V_SIMPLEDATALIST_COUNTRY Returns a list of all countries. Optionally can exclude inactive and/or return abbreviations.
V_SIMPLEDATALIST_COUNTRY_ABBREVIATION Returns abbreviations for all countries.
V_SIMPLEDATALIST_COUNTYCODE
V_SIMPLEDATALIST_COURSE Course List
V_SIMPLEDATALIST_CURRENCIES Returns a list of transaction currencies for an enhanced revenue batch row with given parameters.
V_SIMPLEDATALIST_CURRENCIESBYPROVIDER Returns a list of currencies supported by a particular third party provider, and their descriptions.
V_SIMPLEDATALIST_CURRENCYSET Returns a list of currency set with names.
V_SIMPLEDATALIST_CURRENCYSETTRANSACTIONCURRENCY Generates the list of transaction currencies available by currency set.
V_SIMPLEDATALIST_CURRENCYSETWITHBASECURRENCY Generates the list of currencies that should be available when assigning a record a new base currency.
V_SIMPLEDATALIST_DEGREECODE
V_SIMPLEDATALIST_DESIGNATIONLEVELTYPE Returns a list of types for a fundraising purpose.
V_SIMPLEDATALIST_DISTINCTMEMBERSHIPLEVELNAME Returns a distinct list of membership level names.
V_SIMPLEDATALIST_EDUCATIONALHISTORYSTATUS_DESCRIPTION Educational history status description list
V_SIMPLEDATALIST_EDUCATIONALINSTITUTION Returns a list of educational institutions.
V_SIMPLEDATALIST_EDUCATIONALINSTITUTIONQUERY Returns a list of educational institutions for query.
V_SIMPLEDATALIST_EDUCATIONALINVOLVEMENTNAME Returns all Educational Involvement Name records.
V_SIMPLEDATALIST_EDUCATIONSTATUSCODE
V_SIMPLEDATALIST_EMAILADDRESSCURRENT
V_SIMPLEDATALIST_ETHNICITYCODE
V_SIMPLEDATALIST_EVENTEXPENSETYPECODE
V_SIMPLEDATALIST_EVENTGROUPCODE
V_SIMPLEDATALIST_EVENTREGISTRATIONTYPES A simple data list of event registration types.
V_SIMPLEDATALIST_EVENTTYPECODE
V_SIMPLEDATALIST_EXPENSETYPECODE
V_SIMPLEDATALIST_FINANCIALINSTITUTIONBANKNAMES This simple datalist returns all distinct constituent financial institution bank names.
V_SIMPLEDATALIST_FINANCIALINSTITUTIONBRANCHNAMES This simple datalist returns all distinct constituent financial institution branch names.
V_SIMPLEDATALIST_FINANCIALINSTITUTIONNAMES This simple datalist returns all distinct constituent financial institution names.
V_SIMPLEDATALIST_FUNCTIONALAREA Returns an unfiltered list of all functional areas in the system.
V_SIMPLEDATALIST_FUNDCATEGORYCODE
V_SIMPLEDATALIST_FUNDTYPECODE
V_SIMPLEDATALIST_FUTUREAWARDCODE
V_SIMPLEDATALIST_GIFTCODE
V_SIMPLEDATALIST_GIFTFEEOVERRIDEREASONCODES Returns a list of gift fee override reason codes and descriptions.
V_SIMPLEDATALIST_GLREVENUECATEGORY Returns a list of revenue categories from the GL Revenue Category Mapping table.
V_SIMPLEDATALIST_GROUPTYPE This simple list returns a list of the built-in and custom group types
V_SIMPLEDATALIST_INCOMECODE
V_SIMPLEDATALIST_INDUSTRYCODE
V_SIMPLEDATALIST_INSTALLEDPRODUCTAVAILABLELIST A list of installed products available in the system.
V_SIMPLEDATALIST_INSTALLMENTFREQUENCYCODE
V_SIMPLEDATALIST_INTERACTIONCATEGORY This simple datalist returns active interaction categories.
V_SIMPLEDATALIST_INTERACTIONSUBCATEGORY This simple datalist returns all the active sub categories for a given interaction category.
V_SIMPLEDATALIST_JOBBYVOLUNTEERTYPE Returns a list of all the jobs for a given volunteer type.
V_SIMPLEDATALIST_LETTERCODE Returns a list of revenue letters.
V_SIMPLEDATALIST_LETTERCODE_ALL Returns a list of all revenue letters.
V_SIMPLEDATALIST_LETTERCODE_ALL_REVENUELETTER Returns a list of all revenue letters.
V_SIMPLEDATALIST_LETTERCODE_ASSIGNLETTERCODEPROCESS Returns a list of revenue letters along with revenue letters linked to an assign letter code process.
V_SIMPLEDATALIST_LETTERTEMPLATE_ALLTAGGEDQUERYVIEWS Returns a list of all query views that have been tagged by a datalist.
V_SIMPLEDATALIST_LOCALE Returns a list of Windows locales.
V_SIMPLEDATALIST_LOCALEWINDOWSLOCALEID Returns a list of Windows locale IDs.
V_SIMPLEDATALIST_LOCATIONCODE
V_SIMPLEDATALIST_MAJORCODE
V_SIMPLEDATALIST_MARITALSTATUSCODE
V_SIMPLEDATALIST_MATCHCODE2 Returns all match codes.
V_SIMPLEDATALIST_MEMBERSHIPCANCELLATIONCODE
V_SIMPLEDATALIST_MEMBERSHIPCARDFORMATSINUSE Returns a list of membership card formats that are being used by membership programs or the print membership cards process.
V_SIMPLEDATALIST_MEMBERSHIPCATEGORYCODE
V_SIMPLEDATALIST_MEMBERSHIPPROGRAM Returns all membership programs.
V_SIMPLEDATALIST_MEMBERSHIPPROGRAMCODE
V_SIMPLEDATALIST_MEMBERSHIPPROGRAMLEVEL This simple datalist returns all levels for a given membership program.
V_SIMPLEDATALIST_MEMBERSHIPREASONCODE
V_SIMPLEDATALIST_MEMBERSHIPSUBCATEGORYCODE
V_SIMPLEDATALIST_MINORCODE
V_SIMPLEDATALIST_MKTCOMMUNICATIONTEMPLATEKPI
V_SIMPLEDATALIST_MKTEXPORTDEFINITION Returns a list of all export definitions.
V_SIMPLEDATALIST_MKTLETTERCODE Returns a list of letters.
V_SIMPLEDATALIST_MKTLETTERCODEEXPORTDEFINITION Returns a list of all export definitions used by letters.
V_SIMPLEDATALIST_MKTRECORDSSOURCE Returns a list of available record sources for a segment.
V_SIMPLEDATALIST_NAMEFORMATPARAMETER A list of saved name format parameter sets.
V_SIMPLEDATALIST_NAMEFORMATS This datalist returns all available individual name formats in the system.
V_SIMPLEDATALIST_OLAPDATASOURCE List of all OLAP data sources registered in the system
V_SIMPLEDATALIST_PACKAGECATEGORYCODE
V_SIMPLEDATALIST_PARTICIPANTGIFTTYPECODE
V_SIMPLEDATALIST_PARTICIPANTINVITATIONCODE
V_SIMPLEDATALIST_PARTICIPANTREGISTRATIONCODE
V_SIMPLEDATALIST_PARTICIPANTRESPONSECODE
V_SIMPLEDATALIST_PARTICIPANTSTATUSCODE
V_SIMPLEDATALIST_PARTICIPATIONCODE
V_SIMPLEDATALIST_PAYMENTTYPECODE
V_SIMPLEDATALIST_PDACCOUNTCODEVALUES Returns a list of account code values.
V_SIMPLEDATALIST_PDACCOUNTSYSTEMBASECURRENCYEXCHANGERATES Returns a list of exchange rates for converted from the given currency to the base currency of the given account system.
V_SIMPLEDATALIST_PDACCOUNTSYSTEMVALUES Returns a list of accounting systems for a given user for reports.
V_SIMPLEDATALIST_PHONECURRENT
V_SIMPLEDATALIST_PHONETYPECODE
V_SIMPLEDATALIST_PROFESSIONCODE
V_SIMPLEDATALIST_PROPOSALINSTRUMENTCODE
V_SIMPLEDATALIST_PROPOSALREASONCODE
V_SIMPLEDATALIST_PROPOSALREVENUETYPECODE
V_SIMPLEDATALIST_PROPOSALSTATUSCODE
V_SIMPLEDATALIST_PROSPECTCLASSIFICATIONCODE
V_SIMPLEDATALIST_PROSPECTRESEARCHTEMPLATE Returns a list of Prospect Research Report Templates.
V_SIMPLEDATALIST_PROSPECTSTATUSCODE
V_SIMPLEDATALIST_PURPOSECODE
V_SIMPLEDATALIST_QUERYVIEW_RECORDTYPES Returns the set of record types for which query views exist.
V_SIMPLEDATALIST_RATINGCODE
V_SIMPLEDATALIST_RATINGDESCRIPTIONCODE
V_SIMPLEDATALIST_RE7EVENTCATEGORYCODE
V_SIMPLEDATALIST_RE7LETTERCODE
V_SIMPLEDATALIST_RE7PLEDGESUBTYPE
V_SIMPLEDATALIST_RE7SALUTATIONTYPECODE
V_SIMPLEDATALIST_RECEIPTOUTPUTQUERYVIEW Returns a list of receipt output business process views.
V_SIMPLEDATALIST_RECIPROCALCODE
V_SIMPLEDATALIST_RECORDTYPE Returns the set of record types defined in the system
V_SIMPLEDATALIST_RECORDTYPEBUSINESSPROCESS
V_SIMPLEDATALIST_RECORDTYPEWITHDATALIST Returns a list of record types which have corresponding data lists.
V_SIMPLEDATALIST_RECORDTYPEWITHKPI
V_SIMPLEDATALIST_RECORDTYPEWITHMARKETINGFILTER Returns the set of record types defined in the system.
V_SIMPLEDATALIST_RECORDTYPEWITHSEARCHLIST Returns a list of record types which have corresponding search lists.
V_SIMPLEDATALIST_RECORDTYPEWITHSMARTFIELD
V_SIMPLEDATALIST_RECURRINGGIFTINSTALLMENTSKIPREASONCODES
V_SIMPLEDATALIST_REGIONCODE
V_SIMPLEDATALIST_RELATIONSHIPCODE
V_SIMPLEDATALIST_RELIGIONCODE
V_SIMPLEDATALIST_RERECEIPTREASONCODE Returns a list of re-receipt reason codes and descriptions.
V_SIMPLEDATALIST_RESEARCHGROUPS Returns a list of all research groups.
V_SIMPLEDATALIST_RESPONSECATEGORY This simple datalist returns active response categories.
V_SIMPLEDATALIST_RESPONSECODE
V_SIMPLEDATALIST_REVENUELIFECYCLES Lists all of the available lifecycle types based on lifecycle group id.
V_SIMPLEDATALIST_REVENUELOCKBOX Returns the list of lockboxes.
V_SIMPLEDATALIST_REVENUETRIBUTE Returns a list of revenue tributes.
V_SIMPLEDATALIST_REVENUETYPECODE
V_SIMPLEDATALIST_SCHOLARSHIPTERM Returns a list of scholarship terms.
V_SIMPLEDATALIST_SCHOOLCODE
V_SIMPLEDATALIST_SCHOOLDEPARTMENTCODE
V_SIMPLEDATALIST_SCHOOLFACULTYCODE
V_SIMPLEDATALIST_SCHOOLTYPECODE
V_SIMPLEDATALIST_SCREENPLAN A simple data list available screening plans.
V_SIMPLEDATALIST_SEPAMANDATEFORBATCHREVENUECONSTITUENTACCOUNT
V_SIMPLEDATALIST_SIMPLEACKLETTERS Returns a list of available simple acknowledgement letters
V_SIMPLEDATALIST_SITES List of all sites in the system.
V_SIMPLEDATALIST_SITESFORSPECIFICUSER List of all sites in the system that specified user can interact with (based on Role assignments).
V_SIMPLEDATALIST_SITESFORUSER List of all sites in the system that a given user could interact with in the context of a specific feature, based on Role assignments.
V_SIMPLEDATALIST_SMARTFIELDVALUEGROUPITEMS Returns a list of smart field value group items.
V_SIMPLEDATALIST_SOCIALMEDIASERVICE
V_SIMPLEDATALIST_SOLICITORASSIGNMENTTYPECODE
V_SIMPLEDATALIST_SOLICITORGOALCATEGORYCODE
V_SIMPLEDATALIST_STATE Returns all states for the given country (or all countries if no country supplied).
V_SIMPLEDATALIST_STATE_ABBREVIATION Returns abbreviations for all states for the given country (or all countries if no country supplied).
V_SIMPLEDATALIST_STEWARDSHIPPACKAGE Returns all stewardship records.
V_SIMPLEDATALIST_SUBJECTOFSTUDYCODE
V_SIMPLEDATALIST_SUFFIXCODE
V_SIMPLEDATALIST_SUGGESTEDMEMBERSHIPLEVEL Lists all Suggested Membership Level ranges.
V_SIMPLEDATALIST_SUGGESTEDMEMBERSHIPLEVELSCORE Lists all Suggested Membership Level scores.
V_SIMPLEDATALIST_TAGGEDQUERY A simple data list of available query views tagged with the values passed in.
V_SIMPLEDATALIST_TARGETGIFTRANGE Lists all Target Gift Range scores.
V_SIMPLEDATALIST_TASKCODE
V_SIMPLEDATALIST_TASKGROUP Returns an unfiltered list of the distinct Task group names.
V_SIMPLEDATALIST_TIMEZONEENTRY Returns a list of all active time zone entries.
V_SIMPLEDATALIST_TITLECODE
V_SIMPLEDATALIST_TRIBUTE Returns a list of tributes.
V_SIMPLEDATALIST_TRIBUTELETTERCODE Returns a list of tribute letters.
V_SIMPLEDATALIST_TRIBUTETYPECODE
V_SIMPLEDATALIST_USER
V_SIMPLEDATALIST_VATTAXRATE Returns a list of value added tax rates.
V_SIMPLEDATALIST_VATTAXRATE_DESCRIPTION Returns a list of value added tax rate descriptions.
V_SIMPLEDATALIST_VEHICLETYPECODE
V_SIMPLEDATALIST_VOLUNTEERJOBCATEGORYCODE
V_SIMPLEDATALIST_VOLUNTEERSKILLLEVEL A simple data list available skill levels.
V_SIMPLEDATALIST_VOLUNTEERSTATUSCODE
V_SIMPLEDATALIST_VOLUNTEERTYPE A simple data list available volunteer types.
V_SIMPLEDATALIST_VOLUNTEERTYPECODE
V_SIMPLEDATALIST_VSECATEGORY List of VSE categories
V_SIMPLEDATALIST_VSESUBCATEGORY List of VSE subcategories.
V_SIMPLEDATALIST_WEALTHCAPACITYFORMULA Returns a list of Wealth Capacity Formulas.
V_SIMPLEDATALIST_WEALTHESTIMATORRATING Lists all Wealth Estimator Rating ranges.
V_SIMPLEDATALIST_WRITEOFFREASONCODES Returns a list of write-off reason codes and descriptions.
V_SIMPLEDATALISTCATALOG_UNIQUE_PROCEDURENAME
V_SITEID_MAPFROM_DESIGNATIONID
V_SITEPAGES_ALL
V_SITEPAGESLIST_ALL
V_SITEPAGESTAB_ALL
V_STUDENT_UNIQUE_STUDENTID Used to enforce unique values on the STUDENT.STUDENTID field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the STUDENT table.
V_STUDENTSKILL_NAME_UNIQUE_IGNORE_PUNCTUATION Used to maintain uniqueness of skill names regardless of punctuation.
V_TEAMFUNDRAISINGTEAM_UNIQUE_TEAMFUNDRAISINGTEAMGROUPID_APPEALID
V_USAGEREPORT_CUSTOMCATALOGCOMPONENTS Provides information about custom catalog components
V_USAGEREPORT_USERSWITHEDITRIGHTS Provides information about users that have some form of record editing rights.
V_WPRELATIONSHIP_BO_UNIQUE_DUNS Used to enforce unique values on the WPRELATIONSHIP_BO.DUNS field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the WPRELATIONSHIP_BO table.
V_WPRELATIONSHIP_NPA_UNIQUE_EIN Used to enforce unique values on the WPRELATIONSHIP_NPA.EIN field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the WPRELATIONSHIP_NPA table.
V_WPRELATIONSHIP_PF_UNIQUE_EIN Used to enforce unique values on the WPRELATIONSHIP_PF.EIN field (which is defined as being unique but not required). This view will contain all non-empty values for this field from the WPRELATIONSHIP_PF table.
vwBackOfficeLinkedUsers
vwCategorizedFields
vwContentTypes
vwCustomFormEntries
vwEmailJobClickthroughs
vwEmailJobDonationStats
vwEmailJobEventStats
vwEmailJobMembershipStats
vwEmailJobProfileUpdateStats
vwEmailJobSignupStats
vwEmailJobStats
vwEmailJobVolunteerStats
vwEmailListQueryPeople
vwEmailTemplateDataSources
vwFundraiserParticipants
vwFundRaiserSolicitorSummaries
vwFundraiserSummaries
vwFundRaiserTeamSummaries
vwPageContent
vwSiteContent
vwSiteContentFolders
vwSitePages
vwSitePagesList
vwSitePagesTab
WRITEOFF
WRITEOFFGLDISTRIBUTION
WRITEOFFSPLIT