Information — Navigating the Appointed Faculty Counts: All Divisions Dashboard

General Overview

Source

The data are sourced from HRIS by extracting the data out of the Data Warehouse, as data extracts tend to be faster than live connections.

Because extracts are a snapshot of the data, the extract needs to be refreshed to receive updates from the data warehouse. SAP tables are extracted every weekday at midnight. The dashboard is scheduled to be updated with Data Warehouse data on the last day of each month at 7:00pm. You can determine the last update by looking at the “Data Extracted on” date in the top-right of the dashboard. The date shown is the date that the Data Warehouse was last updated from SAP HANA (HRIS) at the time the dashboard was update. Because there is a lag between when the Data Warehouse is updated from HRIS, the last updated date may show a day or two before the final day of the month.

Data Specifications

The dashboard contains data for appointed faculty positions, following the specifications for reporting on University of Toronto appointed faculty data, finalized in September 2021. These specifications include the following:

• Appointed faculty members only
• PVP group (includes: President / Vice Presidents and Vice Provosts) – not included on any tabs with individual faculty member details
• Clinicians who also hold a faculty appointment are included, all other Clinicians are excluded
• Faculty members who have at least a 20% total FTE are included
• Faculty members on Unpaid Leave are included
• Excluded: Faculty members on Long Term Disability LTD
• Excluded: Non-budgetary cross appointments are not reflected in the data

Navigation and Important Considerations

Filtering

• The “Select a Measure” filter defaults to showing Headcount (rather than FTE). This is the preferred measure for viewing the data.
• All other filters default to “(All)”.
• The Clinicians filter identifies appointed faculty who are also Clinicians.
• Faculty with budgetary cross appointments are reflected in the Academic Unit where they hold their Main appointment on all tabs, except the “Faculty Count by Main Appointment Showing Budgetary Cross Appointments” tab. 
  • Most tabs have a filter for “Academic Unit” – this refers to the Main Appointment Unit for any faculty member.
  • “Faculty Count by Main Appointment Showing Budgetary Cross Appointments” tabs also has an “Appointment Unit” filter – this refers to any academic unit that a faculty member holds a budgetary appointment (Main or Cross).

Downloading Data

Users are able to download a crosstab view for all tabs on the dashboard, meaning you may download the view of the data you see on your screen, but not the underlying dataset. In order to download, click the download icon in the bottom right of your screen. Next click “Crosstab”. Select the option that includes the title of the data (I.e. do not choose the “Help” or “Extract” options). Next, select your preferred format (Excel or CSV) and finally click “Download”.

Note:  On Excel downloads, the first row of your data will appear in white font. So we suggest changing the font colour to black, before further analyzing the data.

Important Considerations

It is important to note that the “Appointed Faculty Counts – All Divisions” dashboard is the only dashboard in which you will be able to see the counts of any faculty member whose Main Appointment unit is outside of your Faculty but who also holds a budgetary cross-appointment within your faculty.

Overview of Tabs

Filter Descriptions