{$page}
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
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| EmployeeGroup.AddressID | int | Group's Address | Address.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. | PhoneNumber.ID | ||||
| EmployeeGroup.MainPhoneNumberID | int | PhoneNumber.ID | |||||
| EmployeeGroup.ManagerID | int | Employee.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 | PricingPlan.ID | |||||
| EmployeeGroup.PrimaryNumber | varchar(75) | ||||||
| EmployeeGroup.PrintAsName | nvarchar(75) | Used for reporting. If PrintAsName is blank or NULL, use GroupName. | |||||
| EmployeeGroup.PriNumberTypeID | int | Element.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) | PricingElement.ID Where ClassTypeID 12501 | ||||
| EmployeeGroup.QPHomeListStoreID | int | Not Used. | |||||
| EmployeeGroup.QPServiceListID | int | Links to the QuickProducts menu that is used on Service Tickets | PricingElement.ID Where ClassTypeID 12501 | ||||
| EmployeeGroup.QPServiceListStoreID | int | Not Used. | |||||
| EmployeeGroup.QPTransListID | int | Links to the QuickProducts menu that is used for Orders and Estimates | PricingElement.ID Where ClassTypeID 12501 | ||||
| EmployeeGroup.QPTransListStoreID | int | Not Used. | |||||
| EmployeeGroup.SecNumberTypeID | int | Element.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. | TaxClass.ID | ||||
| EmployeeGroup.ThirdNumber | varchar(75) | ||||||
| EmployeeGroup.ThirdNumberTypeID | int | Element.ID WHERE ClassTypeID 4101 | |||||
| EmployeeGroup.ThirdNumberTypeText | varchar(50) |
Related Tables
See Also