{$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 
  * ClassTypeIDs Stores in Table:
    * 3501 - Employee Contact



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 ||  || [[sql_structure_-_element_table|Element]].ID WHERE ClassTypeID  4101 ||
|| EmployeeContact.PriNumberTypeText || varchar(50) ||  ||   ||
|| EmployeeContact.SecNumberTypeID || int ||  || [[sql_structure_-_element_table|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 ||  || [[sql_structure_-_element_table|Element]].ID WHERE ClassTypeID  4101 ||
|| EmployeeContact.ThirdNumberTypeText || varchar(50) ||  ||   ||
|| EmployeeContact.Title || nvarchar(10) ||  ||   ||
Related Tables



[[sql_structure_-_employee_table|Employee]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]