Understanding the Work History Collection - Supervisor File

Tab 1 - Summary of Direct Reports
Column Title Description of Information Action Required

WSU ID

Name

Email

Job Code

Job Title

Supervisor

 These columns contain the information for each of your direct reports included in the collection of prior work history process.  This is for informational purposes only; No action required.

Degree (could be multiple)

Degree Field (could be multiple)		 These columns contain the educational information provided by the employee during the self-reporting period.

This is for informational purposes only; No action required.
Total Calculated Relevant Prior Experience This is the number of years of relevant prior experience in total (does not include years in current position) the consultant assessed upon reviewing the self-reported work history data.

This is for informational purposes only; No action required. NOTE: Unless indicated otherwise by the leader by putting a number in the “Supervisor Final Determination of Prior Experience”, this is the number of years to be used for the analysis. As well, the current years in position should not be included as it will be captured in another variable within the analysis.
Total Self-Reported Relevant Prior Experience This is the number of years of relevant prior experience provided by the employee during the self-reporting period.

This is for informational purposes only; No action required.
Difference This is the difference in years of relevant prior experience between what the consultant assessed and the employee reported.

This was used to determine which employees needed leader review and is for information purposes only; no action is required.
Supervisor Final Determination of Prior Experience This is the years of experience that will be used during the pay analysis process.

Update this column with your decision once you have reviewed all the information submitted. Please use whole numbers only, rounding up to the next full year of experience. NOTE: If left blank, the “Total Calculated Relevant Prior Experience” is the number of years to be used for the analysis (minus the number of years required for current position).

Tab 2 - Detailed Job History

Selected Employee

(Select Name From Dropdown Below to Review Detailed Job History):		 This dropdown option contains all of the employees who directly report to the supervisor. Select which employee’s information you would like to review from the dropdown box.
Job Title
Brief Job Summary
Start Date
End Date

These columns contain the summary of information for each job provided by the employee during the self-reporting period.

 Review this information, as needed, to help you determine the number of years to be used in the analysis, captured under “Supervisor Final Determination of Prior Experience”.
Calculated Prior Experience This is the number of years of relevant prior experience the consultant assessed upon reviewing the self-reported data from the position the employee provided information about. This is for informational purposes only; No action required. It allows the supervisor insight to how much of the Total Calculated Relevant Prior Experience came from each employee reported position.
Determined Relevant (T/F) This is to indicate whether or not the job was determined to be relevant. This is for informational purposes only; No action required. It allows the supervisor insight to whether or not the reported position was determined to be relevant when compared to the job code (job description) for the employee.
Service Adjustment for Overlapping Periods This identifies if any of the start/end dates for self-reported positions overlap with other star/end dates in other self-reported positions. This is for informational purposes only; No action required. NOTE: Where there was overlapping dates and the position experience was determined to be relevant, only one of the overlapping calculated prior experience credit was given towards the Total Calculated Relevant Prior Experience.
Total Calculated Relevant Prior Experience (at the top of the page) This is the number of years of relevant prior experience in total (does not include years in current position) the consultant assessed upon reviewing the self-reported data. This is for informational purposes only; No action required. It allows the supervisor insight to the Total Calculated Relevant Prior Experience came from each employee reported position. This number is the same number under Tab 1, column title “Total Calculated Relevant Prior Experience”.

NOTE: The information in the spreadsheet is as of 11/16/2023. Any employees hired after that date will not be in the spreadsheet. If a current employee had a position change after that date, the spreadsheet will reflect the prior position information. For those employees, HR did a review of their work history at the time of the offer or job change so nothing is needed from you at this time.

 

What to do with this file:

  1. Review the spreadsheet. Utilize the information on the first tab and if needed the information the employee submitted within their survey (which can be found on the second tab in the spreadsheet) to make a final determination for the total years of experience that will be used in the pay analysis for that employee.
  2. How to make a determination:
    1. Review what the employee submitted as relevant experience compared to what was identified as the relevant years of experience.
    2. If more information is needed, you can:
      1. Review the information provided by the employee within the 2nd Tab on the spreadsheet.
      2. Review the employee’s job description in the job catalog to see what is identified as work history that is relevant to their current position. The job catalog job code for the employee is located within the 1st Tab on the spreadsheet. For assistance with accessing the job catalog, please refer to the Accessing the Job Catalog tutorial.
      3. Discuss any further questions directly with the employee.
    3. Information that should not be considered:
      1. Education that exceeds the job’s minimum requirement should not be used as an equivalent for work experience unless specifically stated in the job description.
      2. Additional factors beyond the column headers, such as years in current position, additional licenses/credentials, performance, etc. There are additional components that will be brought together for the analysis that may be captured in another way (ex: current position is a separate variable). The information we are gathering is specifically for the prior work experience component.
  3. By 12/13/2023 – provide your determination for the number for the total years of experience that is to be used in the pay analysis. Unless indicated otherwise by the leader by putting a number in the “Supervisor Final Determination of Prior Experience”, the “Total Calculated Relevant Prior Experience” is the number of years that will be used for the analysis (minus the number of years required for current position).

If this tutorial does not answer your questions, please email your questions to marketbasedcomp@wichita.edu

 

Back to Top

Who to Contact

MBC Transition Team
MarketBasedComp@wichita.edu
Human Resources Logo

Updated: 12/04/2023 NH