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

You could leave a comment if you were logged in.