Search Tags: UMS05, UM, NSFA, HR, accounting, journal entry
DM-160Report Purpose
Provides HR accounting line journal entries for UMaine 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_HR_DETAIL
- UMS_NSFA_JRNL_ACT_ID (Search by Employee ID)
- UMS_NSFA_JRNL_ACT_AD419 (For specific Federal Report)
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- UMS_NSFA_HR_DETAIL:
- JOURNAL_DATE From
- JOURNAL_DATE To
- FUND_CODE
- DEPT_CR_3
- Program Code
- Project ID
- Account FROM
- Account TO
- UMS_NSFA_JRNL_ACT_ID:
- JOURNAL_DATE From
- JOURNAL_DATE To
- EMPLID
- UMS_NSFA_JRNL_ACT_AD419:
- JOURNAL_DATE From
- JOURNAL_DATE To
Data Fields Generated
1. UMS_NSFA_HR_DETAIL:
| Fiscal Year | Fund | Dept_Cr_2 | Dept_Cr_3 | Deptid | Deptid Descr | Program | Program Descr | Proj Id | Proj Category | Proj Descr | Proj Mgr Id | Proj Mgr | Proj Status | Proj Start Dt | Proj End Dt | Acct Grp | Acct Cat D | Acct Subcat D | Account | Account Descr | Class | Line Descr | Amount | Jrnl Date | Jrnl ID | Jrnl Ln Ref | Acct Period | Position Nbr | HR Dept | EMPLID | Earning Code |
|---|
2. UMS_NSFA_JRNL_ACT_ID:
| DEPT_CR_2 | Fiscal Year | DEPT_CR_3 | EMPLID | Position Nbr | Fund Code | Line Descr | Accounting Period | Journal Date | Journal Id | Journal Line | Acct Descr | Deptid | Account | Class | Program Code | Project Id | Monetary Amount SUM | Um Code | Ledger Group |
|---|
3. UMS_NSFA_JRNL_ACT_AD419:
| DEPT_CR_2 | DEPT_CR_3 | ID | Position Nbr | Fund Code | Line Descr | Acct Descr | Deptid | Account | Class | Program Code | Project Id | Monetary Amount SUM | Ledger Group | Proj Descr |
|---|
Tables Used
UMS_NSFA_HR_DETAIL:
- A. UM_GLQ_REPRTING - Ledger Data
- B. UM_HR_ACCTG_VW- HR Acctg Line with cf descr
- C. UM_GLQ_ACCTA - GL reporting account attribute
UMS_NSFA_JRNL_ACT_ID:
UMS_NSFA_JRNL_ACT_AD419:
Criteria Used
UMS_NSFA_HR_DETAIL:
- A. ACCOUNT between 50000 and 53999
- B. LEDGER_GROUP = 'ACTUALS'
- B. KK_AMOUNT_TYPE - Commitment Control Amount Type NOT in list ('2','3') -- 2= Encumbrance and 3= Pre-encumbrance
- A. ACCOUNTING_PERIOD between 1 and 12
- A.DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2018-07-01,5NSFA)
UMS_NSFA_JRNL_ACT_ID:
- B. KK_AMOUNT_TYPE - Commitment Control Amount Type NOT in list ('2','3')
- B. LEDGER_GROUP = 'ACTUALS'
UMS_NSFA_JRNL_ACT_AD419:
- A. SUBSTR(B.JRNL_LN_REF,1,7) in list ('0042274', '0040472', '0044131', '0014835', '0349434', '0361881', '0021933', '0040157', '0043711', '0041930', '0040525', '0045381', '0042813', '0018838', '0019874', '0023903', '0045528', '0046771', '0619750', '0010891', '0032070', '0011750')
- B. KK_AMOUNT_TYPE - Commitment Control Amount Type NOT in list ('2','3')
- B. LEDGER_GROUP = 'ACTUALS'
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a report?
Click on Running Reports with Query Viewer & Query Manager or How to Run an SQR for simple how-to guides for running reports. If you've followed the path to an SQR location and cannot see the report, your PeopleSoft settings may need adjustment. Please contact the Change Management /Systems Security Analyst at 581-5420.
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.