Employees Manage Data Requirements
Employees Data Overview
Employees are the individuals who have held or currently hold positions within the district.
Employees Data Elements
Element | Description | Example |
|---|---|---|
Code | Unique identifier for an employee, typically the employee number. Should be a displayed value. | 1 |
First Name/Preferred Name | The first or preferred name of an employee. | Michale |
Middle Name | The middle/second name or initial of an employee. | P |
Last Name | The last name/surname/family name of an employee. | Hall |
Start Date | The first date the employee is valid for holding a position assignment in the district—often a hire or rehire date. | 2014-07-05 |
End Date | The last date the employee is valid for holding a position assignment in the district—often a termination/separation date. | 2019-06-30 |
Employees are unique by code and start_date. Employees uploaded or imported with the same code and start_date combination as an existing employee will see their name fields updated as well as their end_date. The end_date may be NULL and is expected to be filled in upon employee termination. If an employee is rehired, the district may recycle the same code with a new start_date for that employee or make the end_date = NULL with the previous start_date.
Employees Data Validations
code, first_name, last_name, and start_date are not null.
code and start_date are unique.
start_date less than end_date OR end_date is NULL.