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 |