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 Summary. The Space view provides the 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 Floor each floor, as well as, summary data of space, it's functions, and research expenditures for every space type associated with the given building and floor level . for the selected department(s). The Summary view summarizes the shows the space utilization and expenditures data for the selected department(employee level)
Important Note: Because in the current year there is no whole years' worth of expenditures thus when the report is run for the current FY, the research expenditures are pulled from the previous FY.
Source Systems
Space data: IFIS (Integrated Facilities Information System)
Financial data: FAST (Financial Accounting SysTem)
HR: FADS (Faculty Primary Department only)
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
Note: AIMS population filter explained (to be removed if AIMS population filter is removed)
- USF Health employees only, appointed or paid
- USFPG position 2550 (mid-level provider), source: CYBORG
- GEMS data:
GROUP 1 (source GEMS)
...
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:
- Ranked faculty:
- Job codes:
- 9001 Professor
- 9002 Assoc Professor
- 9003 Assistant Professor
- 9006 Graduate Research Professor
- 9007 Distinguished Professor
- Excluding Employment Class H (Faculty Courtesy)
- Excluding Admin plans 98 and 99 (non-compensated positions)
- 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)
Data Elements Definitions
...
- Fund Group “Sponsored research”
- Excluding transfers (account 69800)
- Excluding budget accounts (81050, 81550, 82950, 83950)
- Excluding fund code 80000
...
Expenditures allocated to accounts 51990 and 51995 (excluding Carry forward funds)
...
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
Include Page |
---|
| AIMS Faculty Prompts - Space |
---|
| AIMS Faculty Prompts - Space |
---|
|
Grant Prompts
Insert excerpt |
---|
| Enter Global Department Name Prompt - Grant |
---|
| Enter Global Department Name Prompt - Grant |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Enter Fiscal Year Number Prompt - Grants |
---|
| Enter Fiscal Year Number Prompt - Grants |
---|
nopanel | true |
---|
|
Space Prompts
Insert excerpt |
---|
| Enter Primary HART Global Department Name Prompt - Space |
---|
| Enter Primary HART Global Department Name Prompt - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Enter values for Space Function Review Period Prompt - Space |
---|
| Enter values for Space Function Review Period Prompt - Space |
---|
nopanel | true |
---|
|
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
Insert excerpt |
---|
| Primary Department - Space |
---|
| Primary Department - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Employee Name - Space |
---|
| Employee Name - Space |
---|
nopanel | true |
---|
|
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 |
---|
| Research Square Feet - Space |
---|
| Research Square Feet - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Expenditures per Square Foot - Research Lab - Space |
---|
| Expenditures per Square Foot - Research Lab - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Research Square Feet Adjusted - Space |
---|
| Research 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 |
---|
|
Insert excerpt |
---|
| 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 |
---|
| Building - Space |
---|
| Building - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Room Location - Space |
---|
| Room Location - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Room Type - Space |
---|
| Room Type - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Net Square Feet - Space |
---|
| Net Square Feet - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Currently Occupied - Space |
---|
| Currently Occupied - 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 Net Square Feet associated with following space functions only:
- Clinical Trials / Pharmaceuticals
- Organized Research
- Other Sponsored Activity
- Sponsored Instruction
...
Space percentage allocation to the given function(s) as reported in IFIS
One room may be allocated to multiple functions
...
Project Table
This block displays all projects from FAST where the employee is the PI.
Insert excerpt |
---|
| Project ID - Space |
---|
| Project ID - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Total Expenditures (Direct and F&A) - Space |
---|
| Total Expenditures (Direct and F&A) - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Data Last Refreshed - Space |
---|
| Data Last Refreshed - Space |
---|
nopanel | true |
---|
|
Building
Insert excerpt |
---|
| Building - Space |
---|
| Building - Space |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| Floor - Space |
---|
| Floor - Space |
---|
nopanel | true |
---|
|
Research Space Utilization Indicators
![](https://usfjira.atlassian.net/wiki/download/attachments/11873518811/image2018-7-23%2015:38:57.png?version=1&modificationDate=1532360337153&cacheVersion=1&api=v2)
Color coding is applied as displayed in the table above:
Dark Green: Expenditures 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. $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 |
---|
|
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 |
---|
|
Insert excerpt |
---|
| Data Last Refreshed - Space |
---|
| Data Last Refreshed - Space |
---|
nopanel | true |
---|
|
Summary
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 Expenditures (Direct and 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 indicating a paid faculty member.
- Excluding Employment Class H, I, and J
- Excluding Admin Plans 98 and 99
Sources
Space data: IFIS (Integrated Facilities Information System)
Financial data: FAST (Financial Accounting System)
HR: GEMS, FADS (Faculty Primary Department only)