Table: Employee

This Table stores all the information related to the employee.

Name	Type	Description	Remarks
Active	bit	Flag indicating if the employee is active.
AllowOverbooks	bit	Flag indicating if overbooks are allowed when using this employee in the scheduler.
AllowToBeScheduled	bit	Flag to indicate whether the employee can be used in the scheduler.
Company	varchar(20)	Employee's company id.	Companyid is a foreign key to CompanyInfo table.
DeaNumber		This is the DEA number for the employee who can prescribe drugs.
EinNumber		Ein number.	This field is not used in enterprise version.
EMCSubmitterID		EMC Submitter ID.	This field is not used in enterprise version.
AddressID	int	Stores the employee Address. This is foreign key to Address table.
EmployeeNum	varchar(30)	The employee Number of the employee.
EmployeeType	int	Type of the Employee. 0=None, 1=Provider, 2=Staff, 3=Admin	This field is not used in enterprise version.
EMREmployeeNum	varchar(20)	The employee Number in EMR System if any.
ETimeHourSalary	int	ETime hour salary type of this employee.	1=hourly, 2=salary
ETimeOffice	varchar(8)	ETimeOffice location of this employee.	ETimeOffice is a foreign key to Office table.
ETimeType	int	CatElementLU User-defined classification for ETimeType.	ETimeType is a foreign key to CatElementLU of LookupType 55.
ExamRate	decimal(18,0)	Exam rate amount of this employee.
ExternalID1	varchar(50)	Any external Id associated with the employee.	External ID1 field is available in employee edit dialog in Admin module.
ExternalID2	varchar(50)	Any external Id associated with the employee.	External ID2 field is available in employee edit dialog in Admin module.
Fax		Fax number of the employee.
FirstName	varchar(30)	First name of the employee.
HipaaDate		Last HIPAA training date of the employee.	This field is not used in enterprise version.
HireDate	DateTime	Date Employee was hired.
HomeOffice	varchar(8)	Stores the employee Home Office location. This is foreign key to Office table.
ISCommissionEmp	bit	Flag indicating if the employee is on commission.
IsContractor	bit	Flag indicating if the employee is contractor.
IsElectronicNotifiable	bit	flag indicating if the employee is electronically notifiable.	This field is not used in enterprise version.
ISMedicareDr	bit	Flag indicating if the employee is Medicare Doctor.
IsNonPersonResource	bit	Flag indicating if the employee is non-person resource.
IsScheduleRequired	bit	Flag indicating if the employee schedule is required while scheduling patient appointment.	This field is used while scheduling the patient appointment with doctor.
ISVspDr	bit	Flag indicating if the employee is Vsp doctor.
IsWebSchedulable	bit	Flag indicating if the employee/provider is allowed to be scheduled over the web.
LastModifiedDate	DateTime	Last modified date of this employee record.
LastName	varchar(30)	Last name of the employee.
LicenceNumber		License Number of the employee/provider and is stored in encrypted format in the database.
MaximumOverbooks	int	Maximum overbooks allowed before triggering a warning or error.
MinutesExam	bit	Default duration for appointment slot.
NationalProviderId	varchar(50)	National provider identifier of the employee if the employee has the doctor role assigned.
NumberOfRotationWeeks	int	Number of weeks on the rotation since the rotation start date on that location.	If the employee is on rotation to other office location, number of weeks on the rotation since rotation start date on that location for that employee.
PayRate	decimal(18,0)	Pay rate amount of this employee.
Phone		Phone number of the employee.
ProfessionalCredential		Professional Credentials of the provider. e.g. OD, DD, MD, etc.
ProfessionalSignature		Professional signature of the employee/provider. e.g. John Doe, OD
RotationStartDate	DateTime	Employee's rotation start date.	If the employee is on rotation to other office location, rotation start date of that location for that employee.
Title	char(10)	Title of the employee.
TpaNumber		Tpa Number.	This field is not used in enterprise version.
UserID	int	Employee's Userid associated for login.	Userid is a foreign key to Users table.