DARTS : UMS06 (USM) UO Revenue/ Expense Summary

Report Purpose

This report provides a summary for base budget, current budget, YTD actual, encumbrance, and budget balance by department and fund code for the University of Southern Maine, Auxiliary Services (formerly University Outreach).

Report Location

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

Report Name

UMS_DTS_USM_UO_REV_EXP_SUM

UMS_DTS_USM_UO_REV_EXP_AUX    (For Auxiliary accounts only)

Report Type

Query

Prompts Required

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

UMS_DTS_USM_UO_REV_EXP_SUM:

• Fiscal Year
• Accounting Period
• Fund Code  (Leave blank to get all of the fund codes)
• Revenue or Expense (Enter either 'Revenue' or 'Expense')

UMS_DTS_USM_UO_REV_EXP_AUX:

• Fiscal Year
• Accounting Period
• Revenue or Expense (Enter either 'Revenue' or 'Expense')

Data Fields Generated

Tables Used

• UM_GLQ_REPRTING - Ledger Data
• UM_GLQ_ACCTA - GL reporting account attribute

Criteria Used

UMS_DTS_USM_UO_REV_EXP_SUM:

• DEPTID in tree - UMSYS,,UMS_DEPT_ORG,2017-07-01,6UNIV_OUTREACH
• ACCOUNT between 40000 AND 89999
  

UMS_DTS_USM_UO_REV_EXP_AUX:

• DEPTID in ('6808000','6809000','6817000','6702000','6601008','6703000','6711000','6609000','6817004') -for Auxiliary department only
• ACCOUNT between 40000 AND 89999
• FUND_CODE in ('00','03','50')