DARTS : Multiple Year Budget Report

Report Purpose

This report provides budgets for the last two years, and the current base budget by department, account, program and project ID.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

• UMS_DTS_MULTI_BUDGET
• UMS_DTS_2ACTUAL_CYBUD_FUTBUD
• UMS_DTS_DJ_BIG_BUDGET (does not have future budget)
  
• UMS_DTS_ACTUALS_5YRS

Report Type

Query

Prompts Required

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

For UMS_DTS_MULTI_BUDGET:

• Fiscal Year for 3 FYs 
• Accounting Period for the FY3 (The accounting period for FY3_BASE_BUDGET is fixed with 1 (July).)
• Business Unit
• FUND_CODE
• Department ID

For UMS_DTS_2ACTUAL_CYBUD_FUTBUD:

• Fiscal Year for four FYs (2 past years, 1 current year, 1 future year)
• Accounting Period for the current FY
• Business Unit
• Department ID

For UMS_DTS_DJ_BIG_BUDGET:

• Fiscal Year for three FYs
• Accounting Period for the second FY
• Business Unit 

Data Fields Generated

For UMS_DTS_MULTI_BUDGET:

For UMS_DTS_2ACTUAL_CYBUD_FUTBUD:

For UMS_DTS_DJ_BIG_BUDGET:

Tables Used

    UM_GLQ_REPRTING - Ledger Data

Criteria Used

For UMS_DTS_DJ_BIG_BUDGET:

ACCOUNT between 40000 AND 89999

For UMS_DTS_2ACTUAL_CYBUD_FUTBUD:

FUND_CODE in list ('00','03')

For UMS_DTS_DJ_BIG_BUDGET:

ACCOUNT between 40000 AND 89999