DARTS : Capital and Maintenance Projects Expense

Report Purpose

This query provides a list of capital and maintenance projects with budget, YTD, and project expense amounts.

Report Location

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

Report Name

• UMS_DTS_CAPI_MAIN_PROJ_EXPENSE
• UMS_DTS_CAPITAL_PROJECT

Report Type

Query

Prompts Required

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

• Fiscal Year
• Accounting Period 
• Business Unit (Leave it blank if you want to see data from all business unit)
• PROJECT_ID

Data Fields Generated

UMS_DTS_CAPI_MAIN_PROJ_EXPENSE:

UMS_DTS_CAPITAL_PROJECT:

Tables Used

• A. UM_GLQ_REPRTING - Ledger Data
• B. UM_GLQ_ACCTA - GL reporting account attribute

Criteria Used

UMS_DTS_CAPI_MAIN_PROJ_EXPENSE:

• A.STATISTICS_CODE= ' '
• A.UM_PROJ_GROUP <> BOND_ADMIN
• A.FUND_CODE in list ('18','28')
• B.UM_ACCT_GRP_D - Account Group Descr = Expense
• SUM(A.UM_ACTUALS_YTD) <> 0 or SUM(A.UM_CURR_BUDGET) <> 0 or SUM(A.UM_TOT_ENCUMBRANCE) <> 0  or  SUM(A.UM_PROJECT_TO_DT) <>0

UMS_DTS_CAPITAL_PROJECT:

• A.STATISTICS_CODE= ' '
• A.UM_PROJ_GROUP <> BOND_ADMIN
• A.FUND_CODE in list ('18','28') OR A.PROJECT_ID <> 8150000 OR A.PROGRAM_CODE =89119
• A.UM_PROJ_EFF_STATUS = 'A'
• BUDGETED_SOURCES <> 0 or ACTUAL_SOURCES <> 0 or BUDGETED_EXPENSE <> 0  or  PROJECT_EXPENSE <>0

Expression Used

/*-FUNDING*/

Case when A.UM_PROG_CAT1_D <> ' ' then A.UM_PROG_CAT1_D
when A.FUND_CODE = '18' then 'Unrestricted' 
else 'Restricted' End