DARTS : UMS05 (UM) NSFA Base Budget

Report Purpose

This query provides base budget data by department, program and account type for 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_BASE_BUDGET
• UMS_NSFA_HR_DETAIL_BB   (using UM_HR_ACCTG_VW)
  

Report Type

Query

Prompts Available

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

UMS_NSFA_BASE_BUDGET:

• Fiscal Year for the journal entry
• JOURNAL_DATE From 
• JOURNAL_DATE To
• FUND_CODE
• DEPT_CR_3
• Program Code
• Project ID
• Account FROM 
• Account TO
• Deptid

UMS_NSFA_HR_DETAIL_BB:

• JOURNAL_DATE From 
• JOURNAL_DATE To
• FUND_CODE
  

Data Fields Generated

For UMS_NSFA_BASE_BUDGET:

For UMS_NSFA_HR_DETAIL_BB:

Tables Used

For UMS_NSFA_BASE_BUDGET:

• A. UM_GLQ_REPRTING - Ledger Data
• B. UM_GLQ_ACCTA - GL reporting account attribute
• C. UM_JRNL_APPR_VW - Journal, approval, cf descr

For UMS_NSFA_HR_DETAIL_BB:

• A. UM_GLQ_REPRTING - Ledger Data
• B. UM_GLQ_ACCTA - GL reporting account attribute
• C. UM_HR_ACCTG_VW - HR Acctg Line with cf descr

Criteria Used

For UMS_NSFA_BASE_BUDGET:

• A.DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2018-07-01,5NSFA)
• A.BUSINESS_UNIT= UMS05
• A. FUND_CODE <> '20'
• A. ACCOUNTING_PERIOD  between 1 and 12
• B.LEDGER_GROUP = 'BASEBUD'

For UMS_NSFA_HR_DETAIL_BB:

• A. ACCOUNT between 50000 and 59999
• A. ACCOUNTING_PERIOD  between 1 and 12
• A. FUND_CODE <> '20'
• A. DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2017-07-01,5NSFA)
• A.BUSINESS_UNIT= UMS05
• B. LEDGER_GROUP = 'BASEBUD'
• B. KK_AMOUNT_TYPE not in list ('2','3')