Updated: 2009-09-25



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is the parent grouping for Employees and other Employee Groups. It can also serve as a **Division** grouping since Divisions are enabled within the EmployeeGroup.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 3400 - Employee Group
  * Special Fields
    * *NumberID - Links to Element.ID WHERE ClassTypeID  4101
    * *Number - The actual number. (Ex. 5555555555)
    * *NumberTypeText - The type of number. (Ex. Home, Office, Cell, etc...)



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| EmployeeGroup.AddressID || int || Group's Address || [[sql_structure_-_address_table]].ID ||
|| EmployeeGroup.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| EmployeeGroup.DefaultHomeScreen || int || Not Used. ||   ||
|| EmployeeGroup.DivisionName || varchar(25) || If IsDivision, this is the name of the division. Otherwise it is NULL. ||   ||
|| EmployeeGroup.EmailAddress || nvarchar(50) ||   ||   ||
|| EmployeeGroup.GroupCode || nvarchar(25) || Arbitrary group code for display only. ||   ||
|| EmployeeGroup.GroupName || nvarchar(25) || The name of the group as it appears in the tree. For reporting purposes try to use PrintAsName. ||   ||
|| EmployeeGroup.ID || int || Primary Key for the Table ||   ||
|| EmployeeGroup.IsActive || bit || Indicates if Enabled. 1Record is Active, 0Record is Not Active ||   ||
|| EmployeeGroup.IsDivision || bit ||   ||   ||
|| EmployeeGroup.IsSystem || bit || Used to Mark Required Records ||   ||
|| EmployeeGroup.MainFaxNumberID || int || Note: This field is no longer exclusive to Fax Numbers and is used to store a secondary phone number.  || [[sql_structure_-_phonenumber_table]].ID ||
|| EmployeeGroup.MainPhoneNumberID || int ||   || [[sql_structure_-_phonenumber_table]].ID ||
|| EmployeeGroup.ManagerID || int ||   || [[sql_structure_-_employee_table]].ID ||
|| EmployeeGroup.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| EmployeeGroup.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| EmployeeGroup.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| EmployeeGroup.Notes || text ||   ||   ||
|| EmployeeGroup.ParentID || int || ID of Category/Group Above ||   ||
|| EmployeeGroup.PricingPlanID || int ||   || [[sql_structure_-_pricingplan_table]].ID ||
|| EmployeeGroup.PrimaryNumber || varchar(75) ||   ||   ||
|| EmployeeGroup.PrintAsName || nvarchar(75) || Used for reporting. If PrintAsName is blank or NULL, use GroupName. ||   ||
|| EmployeeGroup.PriNumberTypeID || int || [[sql_structure_-_element_table]].ID WHERE ClassTypeID  4101 ||   ||
|| EmployeeGroup.PriNumberTypeText || varchar(50) ||   ||   ||
|| EmployeeGroup.QPHomeListID || int || Links to the QuickProducts menu that is used for the employee's home screen (dashboard instrument) || [[sql_structure_-_pricingelement_table]].ID Where ClassTypeID  12501 ||
|| EmployeeGroup.QPHomeListStoreID || int || Not Used. ||   ||
|| EmployeeGroup.QPServiceListID || int || Links to the QuickProducts menu that is used on Service Tickets || [[sql_structure_-_pricingelement_table]].ID Where ClassTypeID  12501 ||
|| EmployeeGroup.QPServiceListStoreID || int || Not Used. ||   ||
|| EmployeeGroup.QPTransListID || int || Links to the QuickProducts menu that is used for Orders and Estimates || [[sql_structure_-_pricingelement_table]].ID Where ClassTypeID  12501 ||
|| EmployeeGroup.QPTransListStoreID || int || Not Used. ||   ||
|| EmployeeGroup.SecNumberTypeID || int ||   || [[sql_structure_-_element_table]].ID WHERE ClassTypeID  4101 ||
|| EmployeeGroup.SecNumberTypeText || varchar(50) ||   ||   ||
|| EmployeeGroup.SecondaryNumber || varchar(75) ||   ||   ||
|| EmployeeGroup.SeqID || int ||   ||   ||
|| EmployeeGroup.StoreID || int || Not Used. ||   ||
|| EmployeeGroup.TaxClassID || int || Default tax class for employees in this group. || [[sql_structure_-_taxclass_table]].ID ||
|| EmployeeGroup.ThirdNumber || varchar(75) ||   ||   ||
|| EmployeeGroup.ThirdNumberTypeID || int ||   || [[sql_structure_-_element_table]].ID WHERE ClassTypeID  4101 ||
|| EmployeeGroup.ThirdNumberTypeText || varchar(50) ||   ||   ||
Related Tables 



[[sql_structure_-_employee_table]]



[[sql_structure_-_employeecontact_table]]