...
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 Name | Definition |
---|---|
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) devided divided by Research Sq Feet |
Expenditures per Research Square Foot Adjusted | Corresponding 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 Date | Employee GEMS Appointment Hire Date |
Included As Research Sq Feet Adj? Y/N | Y/N flag to indicare 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:
|
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 |
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
...