DARTS : UMS IT Student Employee Earnings

Report Purpose

• Query 2 was created for Educause Core Data Service reporting to determine the FTE of student IT workers across the US:IT organization and could be used for any purpose where identifying UMS IT student workers, their department, supervisor, total hours and income are needed. 
• Query 1 could be used for any purpose where identifying all UMS student workers, their department, supervisor, total hours and income are needed.
• Both queries return one row per student worker, per job, with total hours and income for that student and that job, in a given fiscal year, in each row.

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/Type

1. UMS_FY_STUDENT_EARNINGS (uses criteria that returns all students system wide)
   
2. UMS_FY_STUDENT_EARNINGS_UMS_IT (uses criteria that returns all IT students system wide)

Report Type

Queries

Prompts Required

1. Pay Dates
2. None

Data Fields Generated

Tables Used

1. PAY_CHECK_EARNS - Pay Check Earnings
2. PAY_CHECK- Pay Check
3. UM_F_EMPLOYE_VW - Employee Flat Table
   
4. POSITION_VIEW - Posn Descr - Employment Titles
5. UM_DISTRIB_TBL - Clone of DEPT_BUDGET

Notes

• Specific campus student IT related HR Department Codes are used to select IT student workers.  
• In addition, to select Network Maine student workers, specific IT related Location codes were required.  

This query, UMS_LOCATION_TBL_10_13_16 demonstrates that UM uses location code differently than all other institutions. (Is this part of this query/report—or does this belong in Data Governance?)