Employees

Description

The Employees table is the full list of all employees in the company and their basic demographic data. This is a core table.

Column Definitions

The following columns are supported in the file. Be sure to follow the data type and maximum length rules and use the exact same column name as listed.

*Field Name*	*Required*	*Data Type*	*Max*	*Description*
EmployeeID	Yes	String	15	Stores the unique identifier of a specific employee
Active	Yes	Bit		1 if employee is active; 0 otherwise
BirthDate	Yes	Datetime		The employee’s birthdate
Class	Yes	String	15	Assigned class of the employee
FirstName	Yes	String	15	Employee’s first name
Gender	Yes	String	6	Employee gender; options are Male, Female, and Unknown
LastName	Yes	String	21	Employee’s last name
MiddleName	Yes	String	15	Employee’s middle name
SocialSecurityNumber	Yes	String	15	Employee Social Security Number
EmployeeAddressID		String	15	The ID of the employee address in the EmployeeAddresses file
BenefitAdjustedDate		Datetime		A date field used to store a benefits related date
ActiveEmployeeDirectDeposit		Bit		1 if employee uses direct deposit; 0 otherwise
BenefitExpireDate		Datetime		Expiration date of the benefits
DateInactivated		Datetime		Employee Inactive Date; only used if employee is no longer active
Department		String	7	Unique identifier of employee’s department
DepartmentDescription		String	30	Description of employee’s department; should be the same for all unique department codes
Division		String	7	Unique identifier of employee’s division
EmploymentType		String	30	Employment Type (e.g. Full Time Regular)
EthnicOrigin		String	30	Employee's ethnic origin Accepted Values: White AmericanIndianOrAlaskan BlackOrAfricanAmerican Asian HispanicOrLatino Mixed NotApplicable PacificIslander
HireDate		Datetime		Employee Hire Date
HRStatus		Bit		1 if Human Resources; 0 otherwise
LastDateWorked		Datetime		Datetime the employee last worked
LocationID		String	15	Unique identifier of employee’s work location; should match an ID in CompanyLocations
MaritalStatus		String	10	The employee’s marital status
SupervisorEmployeeID		String	15	The Employee ID of the employee’s supervisor; should match the ID of another employee
OfficerIndicator		Bit		1 if an officer; 0 otherwise
Position		String	15	Unique identifier for employee’s position
PositionDescription		String	30	Description of employee’s position; should be the same for all unique positions
ReasonEmployeeInactive		String	31	Reason the employee is inactive
UserDefinedOne		String	100	User defined field.
UserDefinedTwo		String	100	User defined field.
WorkHoursPerYear		Int		Number of hours worked per week.