Employee List

The Employee List is an interface within the Personnel module of CBS. The goal of this page is to offer the ability to quickly traverse Associate records for CAHNRS employees. The data displayed is a composite view of many data sources that seeks to present the most widely viewed, sorted, and filtered employee attributes.

It may be helpful to review the following Rank Definition

We now create a basic explanation of each column displayed in the Employee List.

  • WSUID: This is the WSU Employee ID and is pulled from PersonnelCurrentEmployees table, which in turn is populated by the associate table from the data warehouse.
  • FirstName: This is the employees first name and is pulled from PersonnelCurrentEmployees , which in turn is populated by the associate table from the data warehouse.
  • MiddleName:This is the employees middle name and is pulled from PersonnelCurrentEmployees , which in turn is populated by the associate table from the data warehouse.
  • LastName:This is the employees last name and is pulled from PersonnelCurrentEmployees , which in turn is populated by the associate table from the data warehouse.
  • Area: This is the employees home area.
  • Home: This is the employees home department.
  • Appointing: This is a comma delimited list of the employees appointing units. If you see duplicates that indicates multiple active appointments from the same unit.
  • FTE: This is the employees total Full Time Effort.
  • Type: This is the employees job classification (e.g. Faculty, Exempt, etc...).
  • Titles: This is a comma delimited list of title codes the employee has. Duplicate title codes indicate multiple active appointments with the same title code.
  • CompYrs: This is an employees comparable years, the number of non-WSU service years that are considered relevant work experience for purposes of seniority. This field is editable by clicking on it.
  • 75%: This field indicates if an employee has a compressed appointment and is editable by clicking on the field.
  • CrossCollege: This field indicates that this employee is an a different area than CAHNRS.
  • Rank: This field contains the faculty rank of the individual, which is editable and accepts values from 0-5. Once a value is entered manually the system will stop automatically updating that employees rank. To undo this enter in a negative value such as -1 and the value will reset to the computed value based on title codes and remove the flags excluding them from automatic updating.
  • Ranked: A true false flag indicating if a person has a faculty rank.
  • RankedTitle: Indicates the title code that correlates to their rank.
  • PostDoc: A true false field indicating if the employee is a post doc.
  • PostDocTitle: Indicates the title code that flags the person as a post doc.
  • Reminder: Indicates the the user has told the system to send them a reminder about this employee.
  • Details: This column has two options, "Details" and "Notice". Details opens another browser tab containing the details page of the employee. The Notice link opens an interface for setting a reminder with a custom message and date for the reminder to be delivered, along with a link to the employees details page.

Data Source

The data generating this list is from curated tables in the CBSFinancialFrontend Database called PersonnelCurrentEmployees and PersonnelCurrentAppointments.