Data Return TypeAbbreviationDescriptionWhen to Use
AccountsAReturns only the accounts that match the selected query criteriaIf you'd like to see account level information in your results. For example, if you'd like to see the names and addresses for everyone who attended an event. We cannot see journal information, such as Received Amount or Fund if we select this Data Return Type.
Journal EntriesJEReturns only the journal entries that match the selected query criteriaIf you'd like to see specific information about the journal entries, such as Date, Received Amount, Fund, etc. We can still see account level information, such as name and address, in addition to the journal fields. We will return one result for every journal entry that matches the query criteria.
All Household AccountsHAReturns the accounts that meet the selected query criteria, plus any accounts that are connected to the returned account through a household relationshipIf you'd like to see all members of a household, even when only one member of the household meets the query criteria. This can be especially useful for planning an event or generating a mailing list. For example, if one account is a volunteer with the organization, but you want to recruit their family members to volunteer, as well, we could use the All Household Accounts Data Return Type to find the family member who is a volunteer (and therefore meets the query criteria) and then all of the other accounts in the household.
Head of Household AccountsHHAThis return type first looks at the accounts that match the query critera and then checks to see if the account is listed in a household relationship. If so, the query will return the head of household's name. If not, it returns the name of the person who matches the query criteria.When you're only interested in head of household names (an individual who is not in a household relationship is considered head of their own household). The most common example of this is building a mailing list. Because you don't want to send multiple copies of a mailing to a single household, we can limit the results to just the head of household accounts so that you only send one mailing to each household.
All Household Journal EntriesHJEThis return type looks at the accounts that meet the query criteria and then returns all journal entries on those accounts. Further, it will include all journal entries (whether or not they match the query criteria) for any accounts connected to the original accounts via a household relationship.This data return type is used when you'd like to look at all of the entries (both transaction and non-transaction entries) for accounts and their related accounts. This is typically used in conjunction with a Custom Account Query or a query with very specific criteria. 
Household Journal Entries Per CriteriaHJECLike the All Household Journal Entries return type listed above, this data return type will first look at all accounts that match the query criteria. It will only return those entries that match the criteria (versus returning all entries with All Household Journal Entries return type). It will, then, look at the accounts connected to the returned accounts via a household relationship and return entries on those related accounts that match the query criteria.This data return type is also frequently used in conjunction with a Custom Account Query or very specific query criteria, but can be specified further to look at the exact journal entries that match the criteria. For example, if you'd like to see the how much everyone in the household donated in a given year for your Top 10 Donors, you would use the HJEC data return type.
Related AccountsRAReturns only accounts that meet the specified query criteria and have the indicated Relationship Type. When you select Related Accounts from the Data Return Type drop down menu, you will see two additional drop down menus. The first will allow you to select the Relationship Type and the second will allow you to specify which half of the Relationship you'd like to see. You have the option to base your query results on one or both sides of the Relationship.We use this Data Return Type to identify relationships that meet the query criteria. For example, let's say you have a Solicitor/Contributor relationship set up to track which of your employees or board members solicited a donation. We can use this Data Return Type to list all of the Solicitors who have relationships with donors who gave $1000 or more last year.
Matching Gift AccountsMGAReturns accounts that meet the specified query criteria and have a matching gift relationship on the account. This data return type will only return the account that is assigned as the matching gift account. For example, if you have an Employer/Employee relationship between two accounts and the Employer is assigned as the account that matches gifts, the query will return the Employer's information. For more information about matching gift relationships, see How to track accounts that match donations.This Data Return Type is used in situations where we need to find Matching Gifts. For example, if you have an Employer and Employee relationship where the Employer matches the Employee's gift, you would query to find the Employee's giving and the query will return the Employer's information so you can contact the Employer for their matching gift.