Tribute Revenue Received Report

Summary

This report pulls all revenue associated with tributes received during the last week. It can be used to search for all gifts received for a specific tribute or to review tribute gifts received by a school, college, or unit during a fiscal year.

Body

Where is it?

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

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

​​​​​What does it do?

This Report

This report pulls all revenue associated with tributes received during the last week. It can be used to search for all gifts received for a specific tribute or to review tribute gifts received by a school, college, or unit during a fiscal year.

Keywords

Revenue Tribute

Why use this report?

Use this report if you need to review all tribute gifts received in the past week or track tribute giving by a specific tribute, school, college, or unit.

E.g. Identify all gifts given in honor or memory of someone last week or analyze tribute giving for a particular unit during the fiscal year.

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

Uploaded Image (Thumbnail)

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) —

Tribute Attribute Filters (Optional – Select ONE)

  • Enter S / C / U Rollup Name

    • Allows user to select a School / College / Unit rollup for Tribute Revenues

    • E.g., College of Literature, Science & the Arts; Intercollegiate Athletics

  • OR Enter VP Area Rollup Name

    • Allows user to select a Vice President Area rollup for Tributes

    • E.g., Executive Vice President of Medical Affairs; VP Student Affairs

  • OR Enter Campus Rollup Name

    • Allows user to select a campus rollup for Tributes

    • E.g., University of Michigan – Dearborn; University of Michigan – Flint

  • OR Enter Specific Site Name

    • Allows user to select a specific DART Site for Tributes

    • E.g., College of Literature, Science & the Arts; University of Michigan Cancer Center; VP Student Affairs

  • OR Enter MPathways DeptID

    • Allows user to select one or more Site IDs based on MPATHWAYS Department ID

    • E.g., 603400; 500000

  • OR Enter Designation LookupID

    • Allows user to enter a specific designation using a 6-digit shortcode

  • OR Enter Tribute Text (use % as a wildcard)

    • Allows user to search tribute text using wildcard characters

    • E.g., %John%Smith% returns “John Smith”, “John Smith, Jr.”, “Dr. John E. Smith”

    • Note: %John Smith% will not return “John E. Smith” due to exact spacing rules

Revenue Date Filters (Optional – Multiple Allowed)

Answer any or all of the following prompts to restrict results by revenue date.

  • Enter Revenue Date (Start)

    • Allows user to specify the beginning date for revenue selection

    • E.g., 7/1/2011

  • Enter Revenue Date (End)

    • Allows user to specify the ending date for revenue selection

    • E.g., 6/30/2012

  • Enter Revenue Date Fiscal Year(s)

    • Allows user to select one or more Fiscal Years to run the report

    • E.g., FY2019; FY2020; FY2021

Report Tabs

There are 3 report tabs:

Uploaded Image (Thumbnail)

  • Tribute Revenue Detail

    • Shows detailed, transaction-level tribute revenue records by donor

    • Includes tribute donor identification, tribute name, revenue date, amount, and transaction type

    • Contains designation information, purpose SCU rollup, mailing restrictions, and donor primary address details

    • Indicates donor active status

  • Tribute Summary

    • Shows aggregated tribute revenue results by tribute

    • Includes tribute database ID, tribute text, and total tribute revenue

    • Displays total number of unique tribute donors per tribute

  • Tribute Detail with Acknowledgees

    • Shows detailed tribute revenue records including both donors and acknowledgees

    • Includes tributee and acknowledgee identification, names, and aggregated UM degree information

    • Contains acknowledgee mailing restrictions, address details, and active status

    • Includes donor information, revenue date, revenue amount, transaction type, designation, purpose SCU rollup, and online donor tribute comments

Details

Details

Article ID: 14697
Created
Wed 1/14/26 2:35 PM
Modified
Mon 1/19/26 9:22 AM