DARTS : Facilities Base Budget

Search Tags: facilities , base budget, bi tool, universal

Report Purpose

The report provides base budget information for facilities for all campuses by department.

Since this report replaces one containing subtotals, the query will be flagged for replacement when a new BI tool is available. In the meantime, please use the subtotal function in Excel. Additional instructions for creating pivot tables is here.

Report Location

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

Report Name

UMS_DTS_FAC_BASE_BUDGET 

Report Type

Query

Prompts Required

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

• Fiscal Year
• Accounting Period 

Data Fields Generated

Tables Used

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

Criteria Used

• FUND_CODE in list  ('00','03')
• UM_ACCT_GRP_D= 'Expense'
• SUBSTR(A.ACCOUNT,1,3) <> 719
• SUBSTR(A.ACCOUNT,1,3) <> 729
• ACCOUNT NOT between 66000 and 66102
  

• ACCOUNT <> 65900

• UM_DEPT_EXP2 = EX70

• DEPTID in ('1755500', '1756500', '1759500', '1776550', '1779550', '1786550', '1911104', '1912104', '1913104', '1914104', '2720200', '2720201', '2720204', '2720205', '2720207', '2720208', '2720301', '2720307', '3700000', '3700020', '3700110', '3700120', '3700140', '3700170', '4350000', '4350040', '4350050', '4350070', '4350200', '4400010', '4410010', '5700107', '5745100', '5750100', '5750101', '5750106', '5751100', '5751101', '5751102', '5751103', '5752102', '5753100', '5753101', '5753102', '5753103', '5753104', '5753105', '5753106', '5753107', '5935100', '6351001', '6351003', '6702000', '6707000', '6710000', '6750002', '6755000', '6755001', '6756000', '6758000', '6759000', '6760000', '6761000', '7701112',' 7701113', '7701114', '7701116', '8350100', '8350101', '8350106')

• DEPTID NOT in ('1605500', '5165100', '6607004', '1605550')