Labour Distribution & BI Dept. Staff Report

Labour Distribution Reports (Dollars, Hours & FTE's)

These reports include information from the MacVIP system.  Account owners will see salary, wage and benefit, hours worked and calculated FTE details by account and by month for each employee charged to that cost centre.  As of October 2010, these reports are available in three different formats.

  1. Oracle Labour Distribution – electronic ($ only) - all ledgers
    Account owners who have Oracle ID’s for the Financial System can run their own reports by clicking on Oracle and signing in. If you do not have an Oracle ID, and wish access to these reports click on Application.

    Note: Because the information included in the Labour Distribution reports is Confidential (salaries by account, by name, etc) users must have their access authorized by the Prime Signing Authority on the account.
  2. E-Report– Effective May 2011
    Labour Distribution & Salary Commitment Reports are available as an E-Report using FAS E-Reports Application and signing in with a MACID. Application
  3. SAS BI(Business Intelligence)

    a) SAS BI(Business Intelligence) – electronic
    ($ Only) - all ledgers
    In late 2009, the BI Project staff developed an excel version of the reports noted in #1 above and combined with the Labour Distribution & Salary Commitment Report.  Several departments have used this information to assist in budget preparation. If you would like access to these reports click Application

    b) SAS BI(Business Intelligence) – electronic
    (Hours & FTE's Only) - Ledgers 2, 3 & FHS Cost of Practice Accounts
    In 2010, A NEW REPORT SIMILAR TO THE ONE noted in #3a above is now available. This report is identical in format however instead of reporting $'s it will report hours, and a calculated full time equivalent (FTE). If you currently receive the $ report you will automatically get the "Hours & FTE's" report.
    4. Note: An Annual Hours and FTE report will be done for University wide year end. This is needed for various internal and external reporting. It will include all ledgers and accounts, and will only have actual hours worked to April 30th, no projections/commitments.


    Presentation to Users re FTE Reports Oct 14, 2010

BI Dept. Staff Report (excel format)

Access to this report is restricted to Directors and Managers who prepare budgets and do budget modeling. The Report provides information helpful in budgeting and forecasting staff salary costs. Access requests can be made using this Application.

Resources