DARTS : UMS06 (USM) UO Budget Worksheet

Report Purpose

This query provides a list of accounts with previous YTD, base budget, current budget, current YTD, and encumbrance 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_BUDGET 

UMS_DTS_USM_UO_BUDGET_LIBRARY  (For library account only)

Report Type

Query

Prompts Required

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

UMS_DTS_USM_UO_BUDGET:

• Current Fiscal Year
• Accounting Period for Current Fiscal Year
• Previous Fiscal Year

UMS_DTS_USM_UO_BUDGET_LIBRARY:

• Current Fiscal Year
• Accounting Period for Current Fiscal Year
• Previous Fiscal Year
• Fund Code

Data Fields Generated

Tables Used

• UM_GLQ_REPRTING - Ledger Data

Criteria Used

UMS_DTS_USM_UO_BUDGET :

• DEPTID in ('6807000', '6808000', '6809000', '6813010', '6813014', '6813015', '6813016', '6813030', '6815001', '6816000', '6817000', '6812000', '6817004', '6601008', '6609000', '6702000', '6703000', '6711000')
• ACCOUNT Between 30000 AND 89999
• FUND_CODE in ('00','03','50')

UMS_DTS_USM_UO_BUDGET_LIBRARY:

• DEPTID in ('6153000','6153003','6153004','6153011','6153016')
• ACCOUNT Between 30000 AND 89999