PI Expenses and Receipts per Square Foot

Date Published:

Published In:

8/22/2019

Facilities

Brief Description

Provides Information about PI Expenses and Receipts and related square footage.

Data Classification

Internal

Developer

Becky Torrisi

Primary Audience

Facilities Staff. This dashboard is for use by facilities staff to support their discussions with departments.

Data Sources

The core facilities-related data is taken from the Facilities Management system (FAMIS). The data is loaded into the SMPH data warehouse (AADW) and used to generate the Qlik data files (QVDs).

Data Load Schedule

daily

Definitions

Average Annual Receipts - The total of monies received in SMPH (A53xxxx) Funds 144 and 133 where the faculty member is the Principle Investigator, regardless of department, averaged over the last three years. Average Annual MTDC - The total expenses that are considered Modified Total Direct Costs from SMPH Funds 144 and 133 where the faculty member is the Principle Investigator, regardless of department, averaged over the last three years. Allocated SqFt (PI) - The total square footage of office or research space allocated to the Principle Investigator as recorded in FAMIS. This is pro-rated for rooms that are shared. Allocated SqFt (Dept. Shared) - The total square footage of office or research space allocated as shared space among all department PIs divided by the number of PIs in that department. Department (HR) - The major department associated with the faculty member's primary position in the Human Resources (HR) system. Median Receipts per Median Sq.Ft. - The median funding received in the department divided by the median sq. ft. allocated to PIs in that department. Median MTDC per Median Sq.Ft. - The median MTDC expenses in the department divided by the median sq. ft. allocated to PIs in that department.

Plans for Future Development

There are discussions in progress for how to make space utilization information available through Qlik to departments, centers, and institutes.

Additional Notes

While the app pulls data daily, the load from FAMIS into AADW is a heavy manual process which occurs every few weeks on average. Details on when the data was last loaded from FAMIS are visible in the app itself.

  • No labels