DARTS : UMS05 (UM) NSFA Journal Detail

Report Purpose

This query provides all actual transactions by dates for non-salary items for University of Maine, College of Natural Sciences, Forestry, and Agriculture (NSFA).

It is recommended to Schedule Queries since the output of the data gets very large.

Report Location

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

Report Name

• UMS_NSFA_COMB_DETAIL_ALL
• UMS_NSFA_BENEFITS_DETAIL         (For ACCOUNT 54113 - 54999 and 55100 - 55300 only)
  

Report Type

Query

Prompts Required/ available

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

• JOURNAL_DATE From 
• JOURNAL_DATE To
• Fund Code
• Program Code
• Project ID
• Account FROM 
• Account TO
• DEPT_CR_3
• DEPT_CR_2
• Deptid

Data Fields Generated

UMS_NSFA_COMB_DETAIL_ALL:

UMS_NSFA_BENEFITS_DETAIL:

Tables Used

• A. UM_GLQ_REPRTING - Ledger Data
• B. UM_JOURNAL_VW - Journal header - line details
• C. UM_GLQ_ACCTA - GL reporting account attribute

Criteria Used

For UMS_NSFA_COMB_DETAIL_ALL:

• A.DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2019-07-01,5NSFA)
• A.BUSINESS_UNIT= UMS05
• B.LEDGER_GROUP = 'ACTUALS'
  
• B. KK_AMOUNT_TYPE not in list ('2', '3') →2= Encumbrance and 3= Pre-encumbrance
• A. ACCOUNTING_PERIOD between 1 and 12
• A.ACCOUNT (NOT between 50000 and 54999) and (NOT between 90000 and 99999) and (NOT between 10000 and 39999)→ since UM_JRNL_APPR_VW doesn't have EMPLID and Position Number, the range of account is limited. Use UMS_NSFA_HR_DETAIL for account 50000-53999.
  
• A.PROJECT_ID > 0

For UMS_NSFA_BENEFITS_DETAIL:

• A.DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2019-07-01,5NSFA)
• A.BUSINESS_UNIT= UMS05
• B.LEDGER_GROUP = 'ACTUALS'
  
• B. KK_AMOUNT_TYPE not in list ('2', '3') →2= Encumbrance and 3= Pre-encumbrance
• A. ACCOUNTING_PERIOD between 1 and 12
•  (A. ACCOUNT between 54113 and 54999) OR (A. ACCOUNT between 55100 and 55300)