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.