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.