Report Purpose
This query can be run using Prompts for any or all institutions and any or all Semesters.
The query documents all instructors assigned to classes (up to 5 instructors may be assigned to a class).
These tables are left outer joined (using criteria to eliminate duplication where the same instructor is listed in multiple instructor levels)
to each of the 5 INSTRUCTOR_LEVELS (by the use of Query Unions) to compare assignments of INSTRUCTOR_ROLES.
Please note that INSTRUCTOR_LEVEL_01 is not always assigned as the Primary Instructor.
It uses census data so will not return employee demographics until after the HRPRD census has run.
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_INSTR_LOAD_HISTORY
Report Type
Query
Prompts ( all prompts are optional)
INSTITUTION
Between 2 STRMs (inclusive, or use the same STRM in each field for a single STRM)
Data Fields Generated
| STRM | SEMESTER_SORT | INSTITITION | INSTITUTION_DESCR | ACAD_ORG | ACAD_ORG_DESCR | CLASS_NBR | CLASS_DESCR | INSTRUCTION_MODE | ENRL_TOT | UNITS_ACAD_PROG | CLASS_CREDIT_FTE | INSTRUCTOR_LEVEL | INSTRUCTOR_ROLE | INSTRUCTOR_EMPLID | INSTRUCTOR_NAME | FULL_PART_PRIMARY | FULL_PART_FJAPP | REG_TEMP | EMP_STATUS | JOBCODE | JOBCODE_DESCR | POSITION_TITLE | SERVICE_CREDITS | PATFA_SERVICE_LIST | CALENDAR_YR | PATFA_SEMESTER | PATFA_CLASS_COUNT | PATFA_CLASS_CREDITS | PATFA_CLASS_CREDITS_FTE | UNION | DEPTID_HR | DEPARTMENT_HR | COLLID_HR | COLLEGE_HR | CENSUS_DT | LAST_CHECK_DT | DAYS_SINCE_PAY |
Tables Used
Expression Information
This query uses several expressions, please contact Tamara Saarinen for code and usage instruction.
CENSUS_DATE and UM_PATFA_DTL Semesters into STRM
Class Credits into FTE (Full Time Equivalent)
Part-Time Service Credits into Part-Time Service List Position
STRM into Semester Sort Order
Identify and parse The University of Maine School of Law at USM
Criteria and Coding
This Public Query should not be changed without a functional understanding of the use of Unions in PS Query.
The query uses 4 Unions to return each level of instructor (01,02,03,04,05) without instructor redundancy.
The query will not return data before Spring 2008.