{$page}

Updated: 2009-00-24

Version: Control 4.4

Table Purpose, Usage, and Notes

This table stores contact information for Employees.

Information on Table Data

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
EmployeeContact.ClassTypeID int Identifier for the Type of Object
EmployeeContact.EmailAddress nvarchar(50)
EmployeeContact.EmployeeID int ID of the Employee Employee.ID
EmployeeContact.FirstName nvarchar(25)
EmployeeContact.ID int Primary Key for the Table
EmployeeContact.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
EmployeeContact.IsSystem bit Used to Mark Required Records
EmployeeContact.LastName nvarchar(25)
EmployeeContact.MainFaxNumberID int
EmployeeContact.MainPhoneNumberID int
EmployeeContact.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
EmployeeContact.ModifiedByUser nvarchar(25) Windows User who last modified this record
EmployeeContact.ModifiedDate datetime DateTime this Record was last modified
EmployeeContact.Notes text
EmployeeContact.Position nvarchar(25)
EmployeeContact.PrimaryNumber varchar(75)
EmployeeContact.PriNumberTypeID int Element.ID WHERE ClassTypeID 4101
EmployeeContact.PriNumberTypeText varchar(50)
EmployeeContact.SecNumberTypeID int Element.ID WHERE ClassTypeID 4101
EmployeeContact.SecNumberTypeText varchar(50)
EmployeeContact.SecondaryNumber varchar(75)
EmployeeContact.SeqID int
EmployeeContact.StoreID int Not Used.
EmployeeContact.ThirdNumber varchar(75)
EmployeeContact.ThirdNumberTypeID int Element.ID WHERE ClassTypeID 4101
EmployeeContact.ThirdNumberTypeText varchar(50)
EmployeeContact.Title nvarchar(10)

Related Tables

Employee

See Also