Versions Compared

Old Version 30

changes.mady.by.user trichar2

Saved on

compared with

New Version 31

changes.mady.by.user trichar2

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2

...

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
Employee Name - Space
Employee Name - Space
nopaneltrue

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

...

Insert excerpt
Total Expenditures (Direct and F&A) - Space
Total Expenditures (Direct and F&A) - Space
nopaneltrue

Building Table

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

Insert excerpt
Building - Space
Building - Space
nopaneltrue

...

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

Project Table

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

Insert excerpt
Project ID - Space
Project ID - Space
nopaneltrue

Insert excerpt
Total Expenditures (Direct and F&A) - Space
Total Expenditures (Direct and F&A) - Space
nopaneltrue

Insert excerpt
Data Last Refreshed - Space
Data Last Refreshed - Space
nopaneltrue

...

Header

Insert excerpt
Building - Space
Building - Space
nopaneltrue

Insert excerpt
Floor - Space
Floor - Space
nopaneltrue

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

Room Table

Insert excerpt
Room Location - Space
Room Location - Space
nopaneltrue

Expenditures Per Occupied Research Sq Ft

Occupied Research Sq Ft

Expenditures Per Square Foot Analysis - Research Space Only

Insert excerpt
Room Location - Space
Room Location - Space
nopaneltrue

...

Insert excerpt
Net Square Feet - Space
Net Square Feet - Space
nopaneltrue

Insert excerpt
Data Last Refreshed
Room Type - Space
Data Last Refreshed
Room Type - Space
nopaneltrue

Insert excerpt
Data Last Refreshed
Employee Name - Space
Data Last Refreshed
Employee Name - Space
nopaneltrue

Insert excerpt
Expenditures per Research Square Foot Adjusted
GEMS Hire Date - Space
Expenditures per Research Square Foot Adjusted
GEMS Hire Date - Space
nopaneltrue

 

Expenditures per Square Foot - Research Lab

Insert excerpt
Expenditures per Square Foot - Research Lab - Space
Primary Department - Space
Primary Department - Space
nopaneltrue

Insert excerpt
Total Expenditures (Direct and F&A) - Space
Total Expenditures (Direct and F&A) - Space
nopaneltrue

Insert excerpt
Included As
Total FYXX Research
Sq
Square Feet
Adj? Y/N
- Space
Included As
Total FYXX Research
Sq
Square Feet
Adj? Y/N
- Space
nopaneltrue

Insert excerpt
GEMS Hire Date
Total FYXX Research Square Feet Adjusted - Space
GEMS Hire Date
Total FYXX Research Square Feet Adjusted - Space
nopaneltrue

Insert excerpt
Net Square Feet
Expenditures per Square Foot - Research Lab - Space
Net Square Feet
Expenditures per Square Foot - Research Lab - Space
nopaneltrue

Insert excerpt
Net
Expenditures per Research Square
Feet
Foot Adjusted
by Function %
- Space
Net
Expenditures per Research Square
Feet
Foot Adjusted
by Function %
- Space
nopaneltrue

Insert excerpt
Occupancy Begin Day - Space
Occupancy Begin Day - Space
nopaneltrue

Insert excerpt
Occupancy End Day - Space
Occupancy End Day - Space
nopaneltrue

Insert excerpt
Primary Department
Room Function - Space
Primary Department
Room Function - Space
nopaneltrue

Insert excerpt
Room Function % - Space
Room Function % - Space
nopaneltrue

Insert excerpt
Room
Net Square Feet Adjusted by Function % - Space
Room
Net Square Feet Adjusted by Function % - Space
nopaneltrue

Insert excerpt
Room Type Included As Research Sq Feet Adj? Y/N - SpaceRoom Type
Included As Research Sq Feet Adj? Y/N - Space
nopaneltrue

Footer

Insert excerpt
Total Expenditures (Direct and F&A)
Data Last Refreshed - Space
Total Expenditures (Direct and F&A)
Data Last Refreshed - Space
nopaneltrue

 

 Summary 

Header

Insert excerpt
Total FYXX Research Square Feet
Primary Department - Space
Total FYXX Research Square Feet
Primary Department - Space
nopaneltrue

Details

Insert excerpt
Total FYXX Research Square Feet Adjusted
Fiscal Year - Space
Total FYXX Research Square Feet Adjusted
Fiscal Year - Space
nopaneltrue

 

...

Insert excerpt
Employee Name - Space
Employee Name - Space
nopaneltrue

Insert excerpt
Data Last Refreshed
Net Square Feet - Space
Data Last Refreshed
Net Square Feet - Space
nopaneltrue

Insert excerpt
Direct Expenditures Per Sq Ft (Research Space Only) - Space
Direct Expenditures Per Sq Ft (Research Space Only)
- Spacenopaneltrue Insert excerptDirect Dollars Per Rsrch Sq Foot Adjusted - SpaceDirect Dollars Per Rsrch Sq Foot Adjusted
- Space
nopaneltrue

Insert excerpt
F&A Expenditures Per Sq Ft (Research Space Only) - Space
F&A Expenditures Per Sq Ft (Research Space Only) - Space
nopaneltrue

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

Insert excerpt
Net Research Square Feet Adjusted - SpaceNet
Research Square Feet Adjusted - Space
nopaneltrue

Insert excerpt
Research Square Feet Direct Dollars Per Rsrch Sq Foot Adjusted - SpaceResearch Square Feet
Direct Dollars Per Rsrch Sq Foot Adjusted - Space
nopaneltrue

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

Insert excerpt
Total Dollars Per Rsch Sq Foot Adjusted - Space
Total Dollars Per Rsch Sq Foot Adjusted - Space
nopaneltrue

 

 


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

...

  1. USF Health employees only, appointed or paid
  2. USFPG position 2550 (mid-level provider), source: CYBORG
  3. 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:

 

  1. Instructor:
    1. Job code: 9004  
    2. Excluding Employment Class H (Faculty Courtesy)
    3. Excluding Admin plans 98 and 99 (non-compensated positions)
    4. Mid_Level provider:      
      1. Job code:
        1.  9464       Physician's Assistant
        2.  9499       Advanced Registered Nurse Prac
        3. 2550 (CYBORG) mid-level provider
  1. Excluding Employment Class H (Faculty Courtesy)
  2. Excluding Admin plans 98 and 99 (non-compensated positions)
  3. OPS:
    1. Job codes:
      1. 9001       Professor
      2. 9002       Assoc Professor 
      3. 9003       Assistant Professor
      4. 9006       Graduate Research Professor 
      5. 9007       Distinguished Professor
  1. Excluding Employment Class H (Faculty Courtesy)
  2. Admin plan 06 (OPS-Faculty)
  1. indicating a paid faculty member.
    1. Excluding Employment Class H, I, and J
    2. 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)