DARTS : UMS06 (USM) UO Accounts

Report Purpose

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

UMS_DTS_USM_UO_ACCT_MULT   (For certain accounts only: ACCOUNT between '60500' and '60582', and 60401'& '60601')

Report Type

Query

Prompts Required

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

UMS_DTS_USM_UO_ACCT:

• Fiscal Year
• Accounting Period (Leave blank to get all of the periods)
• Fund Code (Leave blank to get all of the fund codes)
• Account (Leave blank to get all of the accounts)

UMS_DTS_USM_UO_ACCT_MULT:

• Fiscal Year
• Accounting Period (Leave blank to get all of the periods)
• Fund Code (Leave blank to get all of the fund codes)

Data Fields Generated

Tables Used

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

Criteria Used

For UMS_DTS_USM_UO_ACCT:

• DEPTID in ('6807000', '6808000', '6809000', '6813010', '6813014', '6813015', '6813016', '6813030', '6815001', '6816000', '6817000', '6812000', '6807002', '6815014', '6817004', '6601008', '6609000', '6702000', '6703000', '6711000', '6153000', '6153003', '6153004', '6153011')

For UMS_DTS_USM_UO_ACCT_MULT:

• DEPTID in ('6807000', '6808000', '6809000', '6813010', '6813014', '6813015', '6813016', '6813030', '6815001', '6816000', '6817000', '6812000', '6807002', '6815014', '6817004', '6601008', '6609000', '6702000', '6703000', '6711000', '6153000', '6153003', '6153004', '6153011') AND between 60500 and 60582 OR in ('60401','60601')