Donor Intent by SCU, Site, or Designation v 1.0

This report pulls information about Designations with either Donor Intent Attributes or Notes related to Donor Intent.

Where is it?

Link to Report: https://businessintelligence.dsc.umich.edu/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=Ae6jit8P6P5AvcmaGHx6QNg

BusinessObjects Folder Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Revenue Reports/

​​​​​What does it do?

This Report

This report pulls information about Designations with either Donor Intent Attributes or Notes related to Donor Intent.

Why use this report?

Use this report if you need to identify and review specific fund designations that carry donor-stipulated restrictions, attributes, or detailed purpose notes regarding how a gift must be utilized.

E.g. Retrieve a list of Lookup IDs for all scholarship designations in the Medical School that contain specific "Donor Intent" notes to ensure upcoming expenditures align with the donor's original wishes.

How to use this report?

Scheduling

Please refer to this article for more information on scheduling reports: https//teamdynamix.umich.edu/TDClient/83/Portal/KB/ArticleDet?ID=7265

Running the Report Directly

Click the highlighted icon to bring up the user prompts.

If the report is taking too long to run, schedule the report (see above).

Prompts

You then need to set the prompts. (Prompts act as questions that help you to customize the information in a report to suit your own needs!)

Below are the available prompts (with explanation) —

Purpose Organizational Filters (Optional)

Answer the following prompts to restrict your search based on specific campus or organizational hierarchies.

• Enter value(s) for Purpose Campus Rollup

  • Select this if you want to limit your search to a specific U of M Campus.

  • E.g., University of Michigan-Flint

• Enter value(s) for Purpose VP Area Rollup

  • Select this if you want to limit your search to a specific VP Area.

  • E.g., Office of Research

• Enter value(s) for Purpose SCU Rollup

  • Select this if you want to limit your search to a specific School, College, or Unit.

  • E.g., Ross School of Business

Financial and Designation Identifiers (Optional)

Answer the following prompts to narrow results to specific physical sites, department codes, or fund designations.

• Enter value(s) for Purpose Site Name

  • Select this if you want to limit your search to a specific Site.

  • E.g., Museum of Art

• Enter value(s) for Purpose MPathways DeptID

  • Select this if you want to limit your search to a specific MPathways Department ID.

  • E.g., 100000

• Enter value(s) for Designation LookupID

  • Select this if you want to limit your search to a specific Designation.

  • E.g., 123456

Report Tabs

There are 6 report tabs:

• Summary by Designation

  • Report summary organized by Designation

  • Provides a high-level view of production totals based on the specific funds or accounts where the gifts were allocated

• DI Attribute Summary

  • Lists Donor Intent Attributes and counts

• Donor Details by Site

  • Listed donors and amounts

  • Grouped by Purpose Site Name

• Scholarships Recipients by Site

  • Scholarship Recipients grouped by Purpose Site Name

• Stewardship Recipients by Site

  • Stewardship Recipients grouped by Purpose Site Name

• DI Attribute Details

  • Individual Donor Attributes and values