Table of Contents

maxLevel	2

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

...

Warning
Report will not work correctly if you choose different departments for the Global Department prompts. If you are running the report for a specific faculty member(s), you will need to select their primary department in subsequent Global Department prompts.

Space

Header

Insert excerpt

	Primary Department - Space
	Primary Department - Space
nopanel	true

Insert excerpt

	Employee Name - Space
	Employee Name - Space
nopanel	true

Expenditures Per Square Foot Analysis - Research Space Only

This block displays only Research designated square footage. The green section is based on room type of Research Labs, while the blue section is based on Research Room Function.

Insert excerpt

Currently Occupied

	Research Square Feet - Space

Currently Occupied

	Research Square Feet - Space
nopanel	true

Insert excerpt

Direct Research Expenditures

	Expenditures per Square Foot - Research Lab - Space
	Expenditures per Square Foot - Research Lab - Space
nopanel	true

Insert excerpt

	Research Square Feet Adjusted - Space

Direct

	Research

Expenditures

Square Feet Adjusted - Space
nopanel	true

Insert excerpt

	Expenditures per Research Square Foot Adjusted - Space
	Expenditures per Research Square Foot Adjusted - Space
nopanel	true

Insert excerpt

	Direct Research Expenditures - Space
	Direct Research Expenditures - Space
nopanel	true

Insert excerpt

	F&A Expenditures - Space
	F&A Expenditures - Space
nopanel	true

Included As Research Sq Feet Adj? Y/N

Insert excerpt

Included As Research Sq Feet Adj? Y/N - Space

Total Expenditures (Direct and F&A) - Space
	Total Expenditures (Direct and F&A) - Space
nopanel	true

Building Table

This block displays all square footage assigned to the faculty member.

Insert excerpt

Net Square Feet

	Building - Space

Net Square Feet

	Building - Space
nopanel	true

Insert excerpt

Net Square Feet Adjusted by Function %

	Room Location - Space

Net Square Feet Adjusted by Function %

	Room Location - Space
nopanel	true

Insert excerpt

Primary Department

	Room Type - Space

Primary Department

	Room Type - Space
nopanel	true

Insert excerpt

Project ID

	Net Square Feet - Space

Project ID

	Net Square Feet - Space
nopanel	true

Insert excerpt

Research Square Feet

	Currently Occupied - Space

Research Square Feet

	Currently Occupied - Space
nopanel	true

Insert excerpt

Research Square Feet Adjusted

	Room Function - Space

Research Square Feet Adjusted

	Room Function - Space
nopanel	true

Insert excerpt

	Room Function % - Space
	Room Function % - Space
nopanel	true

Insert excerpt

Room

	Net Square Feet Adjusted by Function % - Space

Room

	Net Square Feet Adjusted by Function % - Space
nopanel	true

Insert excerpt

Room Location

	Included As Research Sq Feet Adj? Y/N - Space

Room Location

	Included As Research Sq Feet Adj? Y/N - Space
nopanel	true

Project Table

This block displays all projects from FAST where the employee is the PI.

Insert excerpt

Room Type

	Project ID - Space

Room Type

	Project ID - Space
nopanel	true

Insert excerpt

	Total Expenditures (Direct and F&A) - Space
	Total Expenditures (Direct and F&A) - Space
nopanel	true

...

Footer

Insert excerpt

GEMS Hire Date

	Data Last Refreshed - Space

GEMS Hire Date

	Data Last Refreshed - Space
nopanel	true

Insert excerptPrimary Department - SpacePrimary Department - Spacenopaneltrue

Building

Header

Insert excerpt

Room Type

	Building - Space

Room Type

	Building - Space
nopanel	true

Insert excerpt

Total Expenditures (Direct and F&A)

	Floor - Space

Total Expenditures (Direct and F&A)

	Floor - Space
nopanel	true

Research Space Utilization Indicators

...

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

Space type as defined in IFIS$100

Room Table

Insert excerpt

	Room Location - Space
	Room Location - Space
nopanel	true

Insert excerpt

	Expenditures Per Occupied Research Sq Ft - Space
	Expenditures Per Occupied Research Sq Ft - Space
nopanel	true

Insert excerpt

	Occupied Research Sq Ft - Space
	Occupied Research Sq Ft - Space
nopanel	true

Expenditures Per Square Foot Analysis - Research Space Only

Insert excerpt

	Room Location - Space
	Room Location - Space
nopanel	true

Insert excerpt

	Net Square Feet - Space
	Net Square Feet - Space
nopanel	true

Insert excerpt

	Room Type - Space
	Room Type - Space
nopanel	true

Insert excerpt

	Employee Name - Space
	Employee Name - Space
nopanel	true

Insert excerpt

	GEMS Hire Date - Space
	GEMS Hire Date - Space
nopanel	true

Insert excerpt

	Primary Department - Space
	Primary Department - Space
nopanel	true

Insert excerpt

	Total Expenditures (Direct and F&A) - Space
	Total Expenditures (Direct and F&A) - Space
nopanel	true

Insert excerpt

	Total FYXX Research Square Feet - Space
	Total FYXX Research Square Feet - Space
nopanel	true

Insert excerpt

	Total FYXX Research Square Feet Adjusted - Space
	Total FYXX Research Square Feet Adjusted - Space
nopanel	true

Insert excerpt

	Expenditures per Square Foot - Research Lab - Space
	Expenditures per Square Foot - Research Lab - Space
nopanel	true

Insert excerpt

	Expenditures per Research Square Foot Adjusted - Space
	Expenditures per Research Square Foot Adjusted - Space
nopanel	true

Insert excerpt

	Occupancy Begin Day - Space
	Occupancy Begin Day - Space
nopanel	true

Insert excerpt

	Occupancy End Day - Space
	Occupancy End Day - Space
nopanel	true

Insert excerpt

	Room Function - Space
	Room Function - Space
nopanel	true

Insert excerpt

	Room Function % - Space
	Room Function % - Space
nopanel	true

Insert excerpt

	Net Square Feet Adjusted by Function % - Space
	Net Square Feet Adjusted by Function % - Space
nopanel	true

Insert excerpt

	Included As Research Sq Feet Adj? Y/N - Space
	Included As Research Sq Feet Adj? Y/N - Space
nopanel	true

Footer

Insert excerpt

	Data Last Refreshed - Space
	Data Last Refreshed - Space
nopanel	true

Summary

Header

Insert excerpt

	Primary Department - Space
	Primary Department - Space
nopanel	true

Details

Insert excerpt

	Fiscal Year - Space
	Fiscal Year - Space
nopanel	true

Insert excerpt

	Employee Name - Space
	Employee Name - Space
nopanel	true

Insert excerpt

	Net Square Feet - Space
	Net Square Feet - 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

	F&A Expenditures Per Sq Ft (Research Space Only) - Space
	F&A Expenditures Per Sq Ft (Research Space Only) - Space
nopanel	true

...

Insert excerpt

	Total Expenditures (Direct and F&A) Per Sq Ft (Research Space Only) - Space
	Total

of

Expenditures (Direct and

Indirect research expenditures

Research Space Utilization Indicators Explained

Image Removed

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.

Filters

F&A) Per Sq Ft (Research Space Only) - Space
nopanel	true

Insert excerpt

	Research Square Feet Adjusted - Space
	Research Square Feet Adjusted - 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

	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:

IFIS room HEFIC Names ANIMAL QTRS and ANIMAL QTRS SVC
All space flagged in IFIS as "Common Room"

Financial data

The following financial data is excluded:

Transfers (account 68900)
Carry forward funds (adjusted accounting period 0)

Population

...

USF Health employees only, appointed or paid
USFPG position 2550 (mid-level provider), source: CYBORG
GEMS data :
GROUP 1 (source GEMS)
...
indicating a paid faculty member.
Excluding Employment Class H
...
GROUP 2 (ROAD population, source GEMS)
GEMS department IDs:
'0-60%'
'0-61%'
'0-6601%'
'0-63%'
'0-64%'
'0-6201%'
Salary Admin plans ('22','06','08','98','99' )
Excluding Employment Classes I and J
Job codes
9001       Professor
9002       Assoc Professor
9003       Assistant Professor
9004       Instructor
9006       Graduate Research Professor
9007       Distinguished Professor
9053       Librarian
9054       Associate Librarian
9056       Instructor Librarian
9115       Coordinator
9120       Associate In
9121       Assistant In
9126       Program Director
9166       Research Associate
9178       Instructional Specialist
9180       Postdoctoral Scholar - Empl
9199       Faculty Administrator
Report level filter: All GEMS dept IDs starting with ‘0-6%’
Job codes, classes and admin plans are later translated into the following HR groups that can be excluded on the report level using prompts:

Instructor:
Job code: 9004
Excluding Employment Class H (Faculty Courtesy)
Excluding Admin plans 98 and 99 (non-compensated positions)
Mid_Level provider:
Job code:
9464       Physician's Assistant
9499       Advanced Registered Nurse Prac
2550 (CYBORG) mid-level provider
Excluding Employment Class H (Faculty Courtesy)
Excluding Admin plans 98 and 99 (non-compensated positions)
OPS:
Job codes:
9001       Professor
9002       Assoc Professor
9003       Assistant Professor
9006       Graduate Research Professor
9007       Distinguished Professor
Excluding Employment Class H (Faculty Courtesy)
Admin plan 06 (OPS-Faculty)
, I, and J
Excluding Admin Plans 98 and 99

Sources

Space data: IFIS (Integrated Facilities Information System)

Financial data: FAST (Financial Accounting SysTemSystem)

HR: GEMS, FADS (Faculty Primary Department only)

Versions Compared

Old Version 24

New Version Current

Key

Prompts

AIMS Faculty Prompts

Space

Header

Expenditures Per Square Foot Analysis - Research Space Only

Building Table

Project Table

Footer

Building

Header

Research Space Utilization Indicators

Summary

Room Table

Expenditures Per Square Foot Analysis - Research Space Only

Footer

Summary

Header

Details

Research Space Utilization Indicators Explained

Filters

Filters

Space Data

Financial data

Population

Sources

Page Comparison

Versions Compared

Old Version 24

New Version Current

Key

Prompts

AIMS Faculty Prompts

Space

Header

Expenditures Per Square Foot Analysis - Research Space Only

Building Table

Project Table

Footer

Building

Header

Research Space Utilization Indicators

Summary

Room Table

Expenditures Per Square Foot Analysis - Research Space Only

Footer

Summary

Header

Details

Research Space Utilization Indicators Explained

Filters

Filters

Space Data

Financial data

Population

Sources