DARTS : Facilities Operating Expense Budgets

Search Tags: facilities,budget 

Report Purpose

This query provides base budget, current budget, and actual YTD amounts by department and account for specific departments.

Report Location

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

Report Name

UMS_DTS_FAC_OP_EXPENSE_BUDGET

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)

Data Fields Generated

Tables Used

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

Criteria Used

• A.BUSINESS_UNIT <> UMS08
• A. ACCOUNT not in list ('81900', '81902', '81920', '81901', '81910', '71900', '71920', '71922', '72900', '71801', '71910', '71912', '71921', '71911', '66000', '66001', '66100', '66101', '66102', '65900')
• A.FUND_CODE in list ('00','03')
• SUBSTR(A.ACCOUNT,1,3) <> 829
• SUBSTR(A.DEPTID,2,6) not in list ('000004', '000005', '000007')
• A.DEPTID in list ('2720301', '2720305', '3700140', '3700150', '3700170', '3700180', 4400010', '4410010', '5865109', '6601006', '6609003', '6609005', '6609007', '6609009', '6610000', '6610002', '6610004', '6610006', '6610008', '6610010', '6610012', '7701310', '7701313') OR UM_DEPT_EXP2 - 2-Digit Department Expense Cd = EX70
• B. UM_ACCT_SUBCAT <> 5320