Interpreting UM NSF Survey Report Detail Data

Overview

This document covers how to interpret the detailed information used to construct the three main summary grids in the associated summary UM NSF Survey Report.

After generating the UM NSF Survey Report, the detailed data report can be opened by selecting the file name ending with 2.PDFon the Report/Log Viewer page.

Detail List of Race and Ethnicity

The data in this list is the source of the counts in the "Summary Grid of Race and Ethnicity."

The Joint Prog Appr (Approved) column displays Yes for dual-program students. Before including these students in the actual survey, contact the other department to determine which department should report the student.

Detail List of Race and Ethnicity Example

Example of the detailed list of race and ethnicity

Detail List of Sources and Mechanisms

The data in detail list is the source of the counts in the “Summary Grid of Sources and Mechanisms.” This detail list displays a column for each item type received by a student for a sum of $2,000.00 or more, including stipends. It does not include columns for item types whose sums are less than $2,000.00 or for students who are self-supported.

Note: To identify students counted as self-supported in the summary grid, or to review item types for less than $2,000.00, refer to the CSV file of the “Detail List of Sources and Mechanisms”.

In this detail list, NAME, EMPLID, and SEX are specific to the student. Some data specific to each item type is:

  • SPONSOR: A description identifying the sponsor or donor of funds of the project/grant.
  • SPONSOR TYPE: A description of the type of sponsor (e.g., Federal).
  • GSA TYPE: Identifies the type of Graduate Student Assistant (GSA) waivers as:
    • GSI (Graduate Student Instructor)
    • NonSpRA (Non-Sponsored Research Assistant)
    • SpRA (Sponsored Research Assistant)
  • ITEM AMT: The sum amount of the item type funds entered for the student that term.
  • ITEM TYPE: The item type number.
  • DESCR: The item type description.
  • EXT ORG: The name of the external organization (e.g., Ford Motor Company).
  • TYPE: The external organization type (e.g., BUSN).
  • COUNTRY: The country of the external organization’s address. GOVT USA displays for some foreign sources of support that have addresses in the U.S.A. (e.g., Embassy of Mexico).
  • ACCT CD (ShortCode): The value that represents the ChartField combination associated with the transaction.
  • CLASS FLD (Class Code): The ChartField value used to group related activities directed towards the accomplishment of a set of common identifiable objectives or purposes.
  • FUND CD (Fund Code): The ChartField value used to identify the source of funds and intended use of the funds.
  • PROJECT ID (Project/Grant Code): The ChartField value used to accumulate financial information on a set of activities over a limited time span.
  • EARNINGS GRIDCELL: The value that identifies where each student is counted on the “Summary Grid of Sources and Mechanisms” using letters for grid columns and numbers for grid rows, as displayed on the actual web survey data entry grid columns and rows.

Detail List of Sources and Mechanisms Example

Example of the detailed list of sources and mechanisms

Detail List of Post Doctorate and Research Staff

The data in this list may be used to validate the counts in the Post Doctorate and Research Staff summary reports.

Detail List of Post Doctorate and Research Staff Example

Example of the detailed list of doctorate and research staff