DARTS : Budget Report - Salary

Report Purpose

This report provides a list of positions with salary and wages, fringes, account, fund, and other information by fiscal year and business unit. 

Includes all types of FUND_CODE.

Since this report replaces one containing subtotals, the query will be flagged for replacement when a new BI tool is available. In the meantime, please use the subtotal function in Excel. Additional instructions for creating pivot tables is here.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Human Resources - Production > NavBar (compass icon, top right) > Navigator > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

1. UMS_DTS_PM_BUDGET_RPT_SALARY       (It excludes the positions whose Base budget, Current budget, Base Fringe, and Current Fringe are $0 )
2. UMS_DTS_PM_BUDRPT_ANN_ABBR_SAL   (It has slightly different fields such as "ANNL_BENEF_BASE_RT_SUM" or "SALBASE_SUM" . It includes the positions whose Base budget, Current budget, Base Fringe, and Current Fringe are $0)
3. UMS_DTS_PM_BUDRPT_SALARY_VAR   (It has fewer fields and includes the positions whose Base budget, Current budget, Base Fringe, and Current Fringe are $0 )
   

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

• Fiscal Year
• Business Unit

Data Fields Generated

1.  UMS_DTS_PM_BUDGET_RPT_SALARY

2.  UMS_DTS_PM_BUDRPT_ANN_ABBR_SAL

3.  UMS_DTS_PM_BUDRPT_SALARY_VAR

Table Used

UM_F_POS_BUD_VW - view of Posi & Budger extract

Criteria Used

1. CURRENT <> 0 OR BASE <> 0 OR BB-Frng <> 0  OR CB-Frng <> 0