Search Tags: UMS05, ONF, Employee list, HR, position management, NSFA
JIRA Reference:
DM-85
-
UM ONF Employee Listing w JA
Closed
Report Purpose
This report provides a list of employees for UMS05 (UMaine) College of Natural Sciences, Forestry, and Agriculture (NSFA) only.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Human Resources - Production > NavBar (compass icon, top right) > Navigator > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_NSFA_EMP_LIST
Report Type
Query
Prompts Required
No Prompts
Data Fields Generated
| BUSINESS_UNIT | DEPTID_HR | NAME | POSITION_DESC | JOBCODE_DESCR | POSITION_NBR | EMPLID | EMPL_STATUS | EMPL_RCD | FTE_TOTAL | EXPECTED_END_DT | SALBASE_SUM | NSFA_SALBASE_WO_STIPEND | LAST_INCREASE_DT | END_DT | DEPTID_GL | FUND_CODE | PROGRAM_CODE | PROJECT_ID | ACCOUNT | CLASS_FLD | ERNCD | DIST_PCT | ANN_RT_DIST_SUM | JOB_INDICATOR | ACCT_CD_HR |
|---|
Tables Used
Criteria Used
(From UM_F_EMPLOYE_VW )
- BUSINESS_UNIT - Business Unit = 'UMS05'
- EMPL_STATUS - Payroll Status in ('A','P')
- JOB_INDICATOR - Job Indicator in ('P','S')
- UM_COLLEGE - College = 'ONF' or DEPTID - Department = 'ONFDN'
- POSITION_NBR - Position Number in
('00011575','00022727','00013376','00022729','00022731','00019039','00022730','00022732','00012972','00020294',
'00019676','00012947','00010645','00013278','00013743','00013575', '00014388','00012098','00013219','00011332',
'00013953', '00014463','00020081','00013951','00013206','00019389','00013818','00011322','00019704','00013334',
'00013235','00022728', '00021057','00021525','00022726','00022725', '00014529','00010953','00010645','00014324',
'00022731') OR EMPLID - Empl ID= '0951451'
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 adjustments. Please see Security Questions (PS Query/Discoverer).
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.