Employee Salary Projection Report

This article covers how to run and interpret the Employee Salary Projection report on the Budget Management dashboard.

What does this report show?

This report shows salary projections for specific employees. It is similar to the Salary Expenditure (SEP) report. It includes: Jobcode ID,  Position Number, Person Name, FTE, Person ID, each month of the fiscal year, and Total.

As of July 2018, this report replaces the Salary Expenditure Projection (SEP) report.

1. Log in to the CSUF Data Warehouse (OBIEE).

2. Click on Dashboards and select Budget Management.

Dashboard selector
  1. Click on the Dashboards menu in the CSUF Data Warehouse.
  2. Select Budget Management.

3. Click the Employee Salary Projection tab on the Budget Management dashboard.

Report selector

Report Overview

The Employee Salary Projection report is a fiscal year overview showing actual salary expenditures for past months and salary projections for future months.

When you access the report, your personal settings for the report (page) appear. If you have not set up your personal settings, the system defaults will automatically populate.

Employee Salary Projection Report

Report Filters

The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.

Available Filters

Available Column Headers

Just under the report filters are the available columns headers for the report results table.

Available Columns

Report Results Table

The second section of the report contains the report results table.

The columns in yellow contain projection data.

Report Results

Column Descriptions

Column Description
Person Name The name of the employee currently occupying the position.
FTE This column indicates the total Full-Time Equivalency (FTE) of the person in the position in the line item. Note that a position may have an FTE of 1.00 with two people occupying that position at .50 FTE each.
Person ID The Campus-Wide ID (CWID) associated with the person.
Monthly Totals For each month in the fiscal year, the actual salary amount paid for the position OR projected salary amount (if column is in yellow).
Total This total is calculated by adding up the actual salary amounts and the projected salary amounts for the fiscal year for the position.

Need More Help?

For technical assistance with the Data Warehouse, please contact the IT Help Desk at helpdesk@fullerton.edu or 657-278-7777.

For assistance with the Budget Management reports and data, please email Budget@fullerton.edu.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.