Versions Compared

Key

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

...

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. 

...

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

Financial data 

The following financial data is excluded:

...

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 divided by Research Sq Feet
Expenditures per Research Square Foot AdjustedCorresponding expenditures amount (Direct, F&A or Total) devided divided by Research Sq Feet Adjusted
F&A Expenditures

Expenditures allocated to accounts 51990 and 51995 (excluding Carry forward funds)

GEMS Hire DateEmployee GEMS Appointment Hire Date
Included As Research Sq Feet Adj? Y/NY/N flag to indicare indicate 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 %
Occupancy Begin DaySpace 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 DaySpace Occupancy End Day as reported in IFIS
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 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 Occupied Research Square Feet > $500 

Green:   Expenditures Per Occupied Reasearch Research Square Feet bteween between $200 and $500

Yellow:  Expenditures Per Occupied Reasearch Occupied Research Square Feet  between $100 and $199 

Pink:      Expenditures Per Occupied Reasearch Occupied Research Square Feet less than $100 and Employee Hire Date < 30 Months 

Red:       Expenditures Per Occupied Reasearch Occupied Research Square Feet less than $100 

...