Data source: Grant expenditure data are loaded into the UDW+ Data Warehouse from fame. Data in the Departmental Metrics dashboard match those on the Grants page of the Financial Indicators dashboard when the corresponding Departmental Metrics Department and fame financial Org are selected.
Please note the Tandon School of Engineering data for fiscal year 2015 and forward are accurate. Due to the conversion of the Tandon School of Engineering research expenditures into fame, prior years contain possible discrepancies.
Please note the following filters have been applied via the loading of the data in the specific analyses that use the UDM-Projects subject area (an explanation of each is provided in the chart below it):
- Fund Code in (24,25) and BU = WSQ01
- Fund Code in (26,27) and BU = PLT01
- Fund Code in (72, 73) and BU = ADH01
- Project id starts with F, G, N, R, or S
- Project id does not start with F9
- Exclude Anticipated Spend
- Exclude Student Aid/Loans
- Please note accounting period 998 - Final Audit Adjustments is not excluded; so when comparing to the Executive dashboard the results will be different.
***A description of the abbreviations used can be found via this link to the CDV Fund Dictionary.
Update frequency: Grants data are updated nightly. Total prior-year expenditure and year-to-date expenditure in the current fiscal year are reported.
Supporting detail: The Departmental Metrics dashboard provides aggregate measures supported by limited grant-level summary data. Detail is available in the Grants Management dashboard and Budget Detail report.
Assigning grants to departments: Grants are assigned to departments (and other reporting units) in three ways. The dashboard shows as a department's grants (i) on the Grants by Administering Department page those administered by the department; and on the Grants by Department Investigators page either (ii) grants by principal investigators in the department (Principal Investigators View), or (iii) grants by principal investigators or co-principal investigators in the department (PIs and CoPIs View). The investigator’s department is the department of his/her primary appointment in HRIS or PeopleSync. These alternative selections are also provided for proposals.
For example if the Arts and Sciences dean’s office retains fiscal responsibility for a grant for which a Chemistry faculty member is the principal investigator the Chemistry department receives credit for the grant expenditures on the Grants by Department Investigators page but not on the Grants by Administering Department page. If the principal investigator for that grant were in Physics and a co-principal investigator in Chemistry it would only be attributed to Chemistry in the PIs and CoPIs View.
If there are investigators in different departments each department receives full credit for the grant. If there is more than one investigator in a department (or other unit) the grant is not double-counted. Where there are multiple CoPIs within a department (or other unit) the grant expenditure is distributed equally among the CoPIs in the drill-to-detail report so that the amounts listed sum to the departmental total.
Identifying the principal investigator: The principal investigator is assigned to a project for a specific period. If there is more than one principal investigator assignment during a fiscal year the grant is attributed to the last principal investigator. Grants for which no principal investigator is assigned during a fiscal year are omitted from Grants by Department of Principal Investigator metrics for that year and listed in the detail report for Grants by Administering Department with missing data for the principal investigator name and department. (Technical note: If there is risk-account expenditure before the project period it is attributed to the first principal investigator. If there is expenditure in the grace period after the project period they are attributed to the last principal investigator.)
Grant activity is measured by total expenditure. Clicking on a bar segment displays a list of the grants included.
Expenditure is year-to-date actual expense classified by the Budget Control hierarchy, which counts student aid as an expense. Encumbered and pending amounts are not included. Expenditure on subcontracts for NYU grants and expenditure on projects for which NYU is a subcontractor are included.
Grant Expenditure per Faculty
Two ratios of grant expenditure per faculty are provided: per the number of tenure-track faculty in the department (or other reporting unit) and per the number of sponsored project active tenure-track faculty. In each case the denominator is the number of faculty whose primary HR appointment is in the reporting unit as reported on the Faculty page.
Expenditure by Sponsor Category
Grants are classified into two categories: Federal and Other. The classification is based on the original sponsor, so that a federal grant to another university on which NYU is a subcontractor is classified as federal. This classification is implemented using the CFDA number recorded by Sponsored Programs Administration. Clicking on a bar segment displays grant detail including the specific sponsor.
Expenditure by Purpose
Grants are classified as Organized Research or Other. Applied Research, Basic Research and Experimental Development are categorized into Organized Research. Other includes Clinical Trials and Research Training segregated from Research to provide consistency with federal reporting categories. Clicking on a bar segment displays a list of the grants included.
New and Continuing Grants
To track the initiation of new projects grants activity is categorized as New or Continuing according to the project start date recorded in fame. Clicking on a bar segment displays a list of the grants included.
Grants are categorized as multidisciplinary when the PI and a CoPI are in different departments. Grants in which a CoPI's department cannot be determined are also counted as multidisciplinary. Those include, for example, grants with a CoPI in the medical school.
Clicking on a bar segment in the graph displays a list of the grants it comprises, including the disciplines of the PI and CoPI.
Use Note: A project will generate more than one row in the detail table if there is more than one CoPI. In that case the Expense is shown on both rows, so the table is not totaled.
Direct and Indirect Expense
Indirect expense is identified as recorded in Account 76450, Overhead Applied.
Direct Expense by Type
Direct expense is categorized into Personnel Expense, OTPS-Equipment and OTPS-Other. Personnel Expense is identified by that Account Category. OTPS - Equipment includes all expense in the Account Subcategories Computer Hardware/Software, Furniture & Equipment, and Rental of Equipment. All other expense in the Account Categories OTPS and Uncontrollable OTPS are classified as OTPS - Other.
Personnel Expense Trend
Personnel expense is segregated by Account. For example, the Post Docs and Fellows category is expense in Account 51542 - Salaries-Instruc.Post Doc&Fell. All expense in Accounts for purposes other than salaries is shown in the Fringe Benefits and Other category. Drill to detail is not provided.
Personnel Expense by Staff Type
This graph shows the same data as Personnel Expense Trend in a different way. The trend graph shows how a single personnel expense type has changed over four fiscal years. This graph shows the distribution by type within a fiscal year.