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

Related Tables

sql_structure_-_employee_table

You could leave a comment if you were logged in.