Report Description
Research Space Utilization Report displays the state of space utilization as available in the IFIS system and expenditures analysis for the selected department(s). The report contains three different views (presented as the report tabs): Space, Building and Summary views. Space view provides the view of the space utilization and expenditures (Direct, F&A and Total) for every employee associated with the selected department. Building view displays the Research Space Utilization Indicators as a Percentage of the Total Occupied Research Sq. Ft on Floor as well summary data of space functions, research expenditures for every space type associated with the given building and floor level. Summary view summarizes the space utilization and expenditures data for the selected department (employee level)
Source Systems
Space data: IFIS (Integrated Facilities Information System)
Financial data: FAST (Financial Accounting SysTem)
Filters
Space data
The following space data is excluded:
- IFIS room HEFIC Names ANIMAL QTRS and ANIMAL QTRS SVC
- All space flagged in IFIS as "Commom Room"
Financial data
The following financial data is excluded:
- Transfers (account 68900)
- Carry forward funds (adjusted accounting period 0)
Population
Data Elements Definitions
| Element Name | Definition |
|---|---|
| Currently Occupied | Space occupancy flag (Yes/No) as reported in IFIS |
| Direct Research Expenditures |
|
| Expenditures per Square Foot - Research Lab | Corresponding expenditures amount (Direct, F&A or Total) devided by Research Sq Feet |
| Expenditures per Research Square Foot Adjusted | Corresponding expenditures amount (Direct, F&A or Total) devided by Research Sq Feet Adjusted |
| F&A Expenditures | Expenditures allocated to accounts 51990 and 51995 (excluding Carry forward funds) |
| Included As Research Sq Feet Adj? Y/N | Y/N flag to indicare if the Space is considered the research space (see Research Square Feet Adjusted metric definition) |
| Net Square Feet | Space Net Square Feet as reported in IFIS |
| Net Square Feet Adjusted by Function % | Net Square Feet * Space Function % |
| Primary Department | Employee's Primary Global Department Name |
| Project ID | FAST Project ID |
| Research Square Feet | Space Net Square Feet for all space types flagged as "Research Lab" |
| Research Square Feet Adjusted | Space Net Square Feet associated with following space functions only:
|
| Room Function | Space function as defined in IFIS |
| Room Function % | Space percentage allocation to the given function(s) as reported in IFIS One room may be allocated to multiple function |
| Room Location | Space location as reported in IFIS |
| Room Type | Space type as defined in IFIS |
| Total Expenditures (Direct and F&A) | Total of Direct and Indirect research expenditures |
Research Space Utilization Indicators Explained
Color coding is applied as displayed in the table above:
Dark Green: Expenditures Per Occupied Reasearch Square Feet > $500
Green: Expenditures Per Occupied Reasearch Square Feet bteween $200 and $500
Yellow: Expenditures Per Occupied Reasearch Square Feet between $100 and $199
Pink: Expenditures Per Occupied Reasearch Square Feet less than $100 and Employee Hire Date < 30 Months
Red: Expenditures Per Occupied Reasearch Square Feet less than $100
Data Last Refreshed: Date and time when data was last refreshed. Research expenditures by space data is set to be refreshed every weekday at early morning hours.