Query- Faculty Contract Dept Review Query
Summary
In this article, you will learn the steps to run the faculty contract department review query.
Body
Overview
You can run the Faculty Contract Dept Review query (180_MFE_CONTRACT_DEPT_REVIEW) from the System Manager Reporting Page to view faculty contract information in the OneUSG Connect system. This query should be run to locate incorrect information prior to the faculty contract delivery process in June 2019.
In this article, you will learn the steps to run the faculty contract department review query.
 |
First, log into OneUSG Connect
From the Manager Self Service page, click the System Manager Reporting tile.
|
|
 |
In the Queries section on the left side of the screen, click the Manage Faculty Events menu link.
|
|
 |
Click the Faculty Contract Dept Review query link.
|
|
 |
|
The 180_MFE_CONTRACT_DEPT_REVIEW query search page is displayed.
You are required to enter information into the Year and Cycle fields. All other search fields (Department, Empl ID, Contract Type, and Status) are optional to limit your results.
Note: Leaving the % sign in a field will return all results in a field.
|
|
 |
Enter the appropriate information into the YEAR field.
Example shown here: " 2020. "
|
|
 |
Enter the appropriate information into the CYCLE field.
Example shown here: " 1 ".
|
|
 |
Click the View Results button.
|
|
 |
The requested results are displayed.
You can download the results in three formats (i.e., Excel SpreadSheet, CSV Text File, and XML File).
Example shown here: Excel SpreadSheet link.
|
|
 |
The Excel file of the results section is downloaded to your computer.
Click the Open button.
|
|
 |
The file opens in Protected View.
Click Enable Editing to be able to edit the document.
|
|
 |
|
You can filter and sort the data in each column to view the information you need.
On this page, columns show Contract Status, Contract Type Code, Contract Type Description, Employee ID, and Contract Name.
Note: There are four types of Contract Status (Notified, Approved, Generated, and Signed). Department Review means "Notified."
|
|
 |
|
Scroll to the right to view additional columns, including Department number, Position Number, and Job Code.
|
|
 |
|
Scroll to the right to view additional columns, including Paygroup, Employment Type F/P (full- or part-time), Employee Type R/T, FTE, and Tenure Status.
|
|
 |
|
Scroll to the right to view additional columns, including Job Title, Tenure Home, Rank Description, and Contract Issue Date.
|
|
 |
|
If necessary, scroll to the right to view additional columns, including Contract Begin Date, Contract End Date, Starting Salary, Starting Supplement Pay, Mid Year Salary, Mid Year Supplement Pay, and Total Compensation.
|
|
Details
Details
Article ID:
148600
Created
Sat 9/24/22 10:49 PM
Modified
Mon 4/13/26 3:43 PM