| Table of Contents | ||
|---|---|---|
|
...
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 report tabs): Space, Building and Summary. The Space view provides a view of the space utilization and expenditures (Direct, F&A and Total) for every employee associated with the selected department(s). The Building view displays the Research Space Utilization Indicators as a Percentage of the Total Occupied Research Sq. Ft on each floor, as well as, summary data of space, it's functions, and research expenditures for every space associated with the given building and floor level for the selected department(s). The Summary view shows the space utilization and expenditures data for the selected department(s) per employee.
| Note |
|---|
Research expenditures are pulled from the previous FY and paired with space allocation from the current FY so there is a full year's worth of expenditures for calculation. |
Prompts
AIMS Faculty Prompts
...
Insert excerpt Currently Occupied - Space Currently Occupied - Space nopanel true
Insert excerpt Data Last Refreshed - Space Data Last Refreshed - Space nopanel true
Insert excerpt Direct Research Expenditures - Space Direct Research Expenditures - Space nopanel true
...
Insert excerpt Total Expenditures (Direct and F&A) - Space Total Expenditures (Direct and F&A) - Space nopanel true
Building
Insert excerpt Data Last Refreshed - Space Data Last Refreshed - Space nopanel true
Insert excerpt Expenditures per Research Square Foot Adjusted - Space Expenditures per Research Square Foot Adjusted - Space nopanel true
...
Insert excerpt Total FYXX Research Square Feet Adjusted - Space Total FYXX Research Square Feet Adjusted - Space nopanel true
...
Research Space Utilization Indicators Explained
Color coding is applied as displayed in the table above:
Dark Green: Expenditures Per Occupied Research Square Feet > $500
Green: Expenditures Per Occupied Research Square Feet between $200 and $500
Yellow: Expenditures Per Occupied Research Square Feet between $100 and $199
Pink: Expenditures Per Occupied Research Square Feet less than $100 and Employee Hire Date < 30 Months
Red: Expenditures Per Occupied Research Square Feet less than $100
Summary
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) divided by Research Sq Feet
Expenditures per Research Square Foot Adjusted
Corresponding expenditures amount (Direct, F&A or Total) divided by Research Sq Feet Adjusted
F&A Expenditures
Expenditures allocated to accounts 51990 and 51995 (excluding Carry forward funds)
GEMS Hire Date
Employee GEMS Appointment Hire Date
Included As Research Sq Feet Adj? Y/N
Y/N flag to indicate 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 %
Occupancy Begin Day
Space Occupancy Begin Day as reported in IFIS; If the date is not specified the occupancy begin day is set to the first day of the FY (selected in the prompt)
Occupancy End Day
Space Occupancy End Day as reported in IFIS
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:
- Clinical Trials / Pharmaceuticals
- Organized Research
- Other Sponsored Activity
- Sponsored Instruction
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 functions
Room Location
Space location as reported in IFIS
Room Type
...
Insert excerpt Data Last Refreshed - Space Data Last Refreshed - Space nopanel true
Insert excerpt Direct Expenditures Per Sq Ft (Research Space Only) - Space Direct Expenditures Per Sq Ft (Research Space Only) - Space nopanel true
Insert excerpt Direct Dollars Per Rsrch Sq Foot Adjusted - Space Direct Dollars Per Rsrch Sq Foot Adjusted - Space nopanel true
Insert excerpt F&A Expenditures Per Sq Ft (Research Space Only) - Space F&A Expenditures Per Sq Ft (Research Space Only) - Space nopanel true
Insert excerpt F&A Expenditures Per Sq Ft (Research Space Only) - Space F&A Expenditures Per Sq Ft (Research Space Only) - Space nopanel true
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||
|---|---|---|---|---|
|
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 Research Square Feet > $500
Green: Expenditures Per Occupied Research Square Feet between $200 and $500
Yellow: Expenditures Per Occupied Research Square Feet between $100 and $199
Pink: Expenditures Per Occupied Research Square Feet less than $100 and Employee Hire Date < 30 Months
Red: Expenditures Per Occupied Research 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.
|
Insert excerpt Total Dollars Per Rsch Sq Foot Adjusted - Space Total Dollars Per Rsch Sq Foot Adjusted - Space nopanel true
Filters
Space data
The following space data is excluded:
...