Versions Compared

Old Version 5

changes.mady.by.user Kateryna Monastyrska

Saved on

compared with

New Version 6

changes.mady.by.user Kateryna Monastyrska

Saved on

Key

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

...

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

Population

Note: AIMS population filter explained

  1. USF Health employees only, appointed or paid
  2. USFPG position 2550 (mid-level provider), source: CYBORG
  3. GEMS data:

GROUP 1 (source GEMS)

  • Job codes:
    • 9001       Professor                    
    • 9002       Assoc Professor              
    • 9003       Assistant Professor          
    • 9004       Instructor                   
    • 9006       Graduate Research Professor  
    • 9007       Distinguished Professor      
    • 9464       Physician's Assistant        
    • 9499       Advanced Registered Nurse Prac
    • Excluding Employment Class H (Faculty Courtesy)
    • Excluding Admin plans 98 and 99 (non-compensated positions)

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. Ranked faculty:
    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. Excluding Admin plans 98 and 99 (non-compensated positions)
  3. 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) 

 

Data Elements Definitions 

Element NameDefinition
  
Currently OccupiedSpace occupancy flag (Yes/No) as reported in IFIS
Direct Research Expenditures
  1. Fund Group “Sponsored research”
  2. Excluding transfers (account 69800)
  3. Excluding budget accounts (81050, 81550, 82950, 83950)
  4. Excluding fund code 80000
Expenditures per Square Foot - Research LabCorresponding expenditures amount (Direct, F&A or Total) devided by Research Sq Feet
Expenditures per Research Square Foot AdjustedCorresponding 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/NY/N flag to indicare if the Space is considered the research space (see Research Square Feet Adjusted metric definition)
Net Square FeetSpace 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 IDFAST Project ID
Research Square FeetSpace 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:

  1. Clinical Trials / Pharmaceuticals
  2. Organized Research
  3. Other Sponsored Activity
  4. Sponsored Instruction
Room FunctionSpace 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 functions

Room LocationSpace location as reported in IFIS
Room TypeSpace type as defined in IFIS
Total Expenditures (Direct and F&A)Total of Direct and Indirect research expenditures
  
  
  
  
  
  
  
  
  

...

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       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 

...