SB Employees Manage Data Requirements

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.