New Labor Plan and FTE Analysis Interactive Report now available

    March 24, 2021

    Summary

    Details

    The new Labor Plan and FTE Analysis Interactive Report aids in Salary and FTE budget actuals monitoring down to the employee level. It integrates Workday and YBT data into common reports and allows easy comparison of labor activity across different budget types, including Corporation Budget, Q2 Forecast, and Current Year monitoring.  Please view a video demo of the Labor Plan and FTE Analysis Interactive Report to learn about this report. 

    The Finance Data Mart Interactive Reports are the first set of interactive reports to be delivered to the Business Operations and Finance communities using the same platform as the Account Holder Report by Person (AHR-PI) and Financial Activity and Balances (FAB) reports. Created using the Finance Data Mart Model, individuals with financial roles in Workday can access data loaded daily from Workday and the Yale Budget Tool (YBT). These reports are available via the Power BI Report Server. These reports are also available for downloading to the Power BI Desktop once a user has attended desktop Power BI training.

    Interactive Report Instructor-led training is offered to all Workday cost center financial analysts and will be a prerequisite to future Power BI Desktop training offerings. Please register for a session via TMS.  Future training sessions will be made available by waitlist registration after Thursday, April 1, 2021.   

    Note: 

    The new Labor Plan and FTE Analysis report is currently only available as an interactive report.

    Interactive Report Name

    Report Description

    Detailed Transactions Trend

    This monthly trend report provides quick access to transaction details of interest defaulted at the Ledger Account Summary w/ the ability to drill through to the transaction level.

    Fund Balances

    This report provides a sorted view of remaining balances, at the summary, charging and transaction levels, so accounts needing attention are highlighted in the report. 

    Awards and Grants

    This report will allow users to view financial status at the award level, then review activity at the grant level and down to the transaction level.

    Payroll Details

    This report lists employees within a cost center or paid by a cost center, including valuable percentages. The report can be used to assist those managing grants with a view of who is being charged to the grant and the associated dollars/percent.

    Budget Variance Analysis

    This report assists in the investigation of variances between budgets and financial activity w/ the ability to drill through to the transaction level.

    Budget Compare and Project

    This report provides comparisons to the prior year and projections for the current year. This includes variance analysis with Current Year Forecast (CYF). Drill through features allow an understanding of budgets and activity by different COA segments plus the ability to drill all the way through to transaction-level detail.

    FD29 Industry Clinical Trials

    This report aids in the review of Fund 29 activity and balances. The summary level is organized by Award Owning responsible organization while the subsequent tabs provide detail for the review of the Award Balance including revenue, expenses and outstanding receivables.

    Labor Plan and FTE Analysis

    This report aids in Salary and FTE budget to actuals monitoring down to the employee level.

     

    Support

    You can find the training materials and guides on the Workday Reporting Training site. Please refer to Finance Data Mart Release Notes for updates and awareness features

    For support, please contact the Finance Support Center (FSC) at 203-432-5394 or send an email to askfinance@yale.edu.