DARTS : UMS05 (UM) NSFA GL Summary

Report Purpose

This report provides data for base budget, current budget, project to date, encumbrance, and program balance for the University of Maine, College of Natural Sciences, Forestry, and Agriculture (NSFA).

Report Location

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

Report Name

• UMS_NSFA_GL_SUMMARY        (For Account 10000 -89999)
  
• UMS_NSFA_SALARY_VAR          (For Account 50000 -54799)
  

Report Type

Query

Prompts Required

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

• Fiscal Year
• Accounting Period
• DEPT_CR_3
• Program Code
• Project ID
• Fund Code
• Account FROM 
• Account TO
• Deptid

Data Fields Generated

UMS_NSFA_GL_SUMMARY :

UMS_NSFA_SALARY_VAR:

Tables Used

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

Criteria Used

For UMS_NSFA_GL_SUMMARY:

• ACCOUNT between 10000 and 89999
• BUSINESS_UNIT= UMS05
• DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2018-07-01,5NSFA)
  
• BASE_BUDGET <> 0 OR UM_CURR_BUDGET  <> 0 OR UM_ACTUALS_CURR <> 0 OR YTD_ACTUAL<>0 OR PTD_ACTUAL<>0 OR UM_TOT_ENCUMBRANCE <>0 OR Budget Balance <> 0

For UMS_NSFA_SALARY_VAR:

• ACCOUNT between 50000 and 54799

• FUND_CODE NOT in list ('20','24','04','13')

• PROGRAM_CODE (not between 57530 AND 57647) OR not 58036 OR not 54958 (Cooperative Forestry Unit, not under NSFA)
• BUSINESS_UNIT= UMS05
• DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2018-07-01,5NSFA)
  
• BASE_BUDGET <> 0 OR UM_CURR_BUDGET  <> 0 OR UM_ACTUALS_CURR <> 0 OR YTD_ACTUAL<>0 OR PTD_ACTUAL<>0 OR UM_TOT_ENCUMBRANCE <>0 OR Budget Balance <> 0