Employee

This table contains data regarding the employees of Xtreme Mountain Bikes.

Table B-3: Employee data

Field Name	Data Type	Field Size/Format	Description
Employee ID	Number	Long Integer	Unique identification number assigned to each employee.
Supervisor ID	Number	Long Integer	Unique identification number assigned to the employee's supervisor.
Last Name	Text	20	Last name of the employee.
First Name	Text	10	First name of the employee.
Position	Text	30	Employee's position.
Birth Date	Date/Time	Short Date (MM/DD/YYYY)	Employee's birth date.
Hire Date	Date/Time	Short Date (MM/DD/YYYY)	Employee's hire date.
Home Phone	Text	20	Phone number includes country code or area code.
Extension	Text	4	Internal telephone extension number.
Photo	OLE Object	(N/A)	Picture of employee.
Notes	Memo	64,000	General information about employee's background.
Reports To	Number	Long Integer	Employee's supervisor.
Salary	Currency	Currency	Employee's salary.
SSN	Text	12	Employee's social security number.
Emergency Contact First Name	Text	20	First name of the employee's emergency contact.
Emergency Contact Last Name	Text	20	Last name of the employee's emergency contact.
Emergency Contact Relationship	Text	20	Relationship between the employee and the emergency contact.
Emergency Contact Phone	Text	20	The emergency contact's phone number.