Employee Work Schedule 

Searching

The Basics

By default, the report gives fields you would use in most searches:

  • Effective Date
    Currently this report only allows reporting for one particular date. The date is defaulted to today's date but you can change the date to look at historical data. A future phase of the report will allow for reporting on a date range. 
  • Personnel Number
    To search for an employee PERNR, open the look-up help and search by Name, MSU Net ID, Student ID, or ZPID.
  • Organizational Unit
    To search for an entire Major Administrative Unit (MAU):
    • Use the search help for the Organizational Unit filter. 
    • In the pop-up, enter the MAU in the "MAU/College Code" or "MAU/College Description"
    • Click "Go"
    • A list of departments in that MAU displays (for Supervisors, this includes only those orgs that have their employees in them). 
    • Select all of the organizations (select the first record, scroll down to the last record, hold down the shift key and select the last record. That will select all records in-between).
    • Click "OK"
    • You will see all units are now listed in the Organizational Unit filter.
  • Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday
    To search for employees with a work schedule by specific day, you can enter the hours in the days of the week.

The more detailed you are with your search criteria, the narrower your set of results and the more quickly the results will be returned. Select the “Go” button when ready for results.

Adapt Filters

Additional search criteria are available. Use the “Adapt Filters” option to add more filter fields for the employees’ assignment (Employee Group/Subgroup, Personnel Area/Subarea, Employment Status, Start/End Date of work schedule, Week # and Work Schedule Rule). From the screen where you select additional filters, you can also save those filters to view for later use.

Preset Variants are available. To add them to your report:

  1. Select the menu in the upper left that displays “Standard ˅” or “Employee Information ˅“.
  2. From the box that opens, choose the "Manage" button.
  3. In the next box that opens, mark additional views as favorites by selecting the star icon, turning it from empty to filled.
  4. OPTIONALLY
    1. You may also set one of these to be the “Default” view when you open the application. 
    2. The “Apply Automatically” checkbox on the Default view will allow you to bypass the “Go” button to run the view, if you don’t need to change any filter settings.
  5. Then select OK.

Output

By default, the report gives basic fields you would use in most searches:

  • Personnel Number: Employee name and personnel number.
  • Organization Unit: Organizational Unit Name and number.
  • Start Date: Work Schedule Rule record start date.
  • End Date: Work Schedule Rule record end date.
  • Work Schedule Rule: Work Schedule Rule name and abbreviated code.
  • Week #: Week number for rotating work schedules.
  • Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday: Days of the week that display the hours for each day.

Making the Report Your Own

Selecting the Setting button (gear icon) above the list of results opens a screen where you can select which columns to display on screen, as well as how the information is sorted or grouped.

Using the Results

Exporting

To download the list of results directly to MS Excel, use the “Export Table” button at the right end of the header for the results table (or choose the dropdown arrow and “Export”). It will save the file to the location you have specified as the default for downloading files in your browser settings. The export feature only downloads those columns that are displayed on screen.

When complete, click Back, log out, or search for another application.