Constituent Report - Dual Degree Households

Where is it?

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

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

​​​​​What does it do?

This report is designed to pull all married couples where both spouses hold a U-M Degree given a specified campus and/or school/college for the primary constituent and their spouse.

Keywords: Constituent, Alumni, Degree, SCU, House

Why use this report?

Use this report if you need to find all U-M alumni who are married from specific Schools or Colleges

E.g. Find all U-M Alumni who are married where one spouse attended UM-Ann Arbor and the other attended UM-Dearborn

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

  • Enter value(s) for Primary Constituent Campus Education

    • Allows users to select the Campus from which the Primary Constituent received a U-M Degree 

    • E.g., Univ of Michigan-Ann-Arbor, Univ of Michigan-Dearborn
       

  • Enter value(s) for Primary Constituent SCU Education

    • Allows users to select one or more U-M Schools/Colleges from which the Primary Constituent received a U-M Degree 

    • E.g., College of Engineering, School of Information
       

  • Enter value(s) for Spouse Constituent Campus Education

    • Allows users to select the Campus from which the Spouse Constituent received a U-M Degree 

    • E.g., Univ of Michigan-Ann-Arbor, Univ of Michigan-Dearborn
       

  • Enter value(s) for Spouse Constituent SCU Education

    • Allows users to select one or more U-M Schools/Colleges from which the Spouse Constituent received a U-M Degree 

    • E.g., College of Engineering, School of Information

Report Tabs

There is 1 report tab:

  • Dual UM Households 

    • Displays all constituent information (primary & spouse) from dual degree households

    • Includes Group LookupIDs (LIDs), Constituent LIDs, Full Names, Degrees, Prospect Managers, Gift Officer Capacity Ratings, Total Recognition, Payments, Commitments, and Plans 

Print Article