Updated: 2009-09-22
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store Employee Information. Payroll setup information is also included in these records, though they are only applicable when Payroll or Advanced Job Costing is enabled.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 3500 - Employee
- Valid values for MaritalStatus:
- 0 Unknown
- 1 Single
- 2 Married
- Valid values for EmployeeStatus:
- 0 Regular
- 1 Contract
- 2 On Leave
- 3 Prior
- Valid values for PayFrequency:
- 0 Special
- 1 Weekly
- 2 BiWeekly
- 3 SemiMonthly
- 4 Monthly
- 5 Quarterly
- 6 Annually
- Valid values for PayrollType:
- 0 Hourly
- 1 Salary
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
Employee.AddressID | int | sql_structure_-_address_table.ID | |||||
Employee.AdvanceAccrualAccountID | int | sql_structure_-_glaccount_table.ID sql_structure_-_gl_table.GLAccountID |
|||||
Employee.AdvanceCurrentBalance | float | ||||||
Employee.AdvanceEstRepaymentDate | datetime | ||||||
Employee.AdvanceLastDate | datetime | ||||||
Employee.AdvanceLastRepaymentDate | datetime | ||||||
Employee.AdvanceRepaymentAmount | float | ||||||
Employee.AllowAdvances | bit | ||||||
Employee.AnnualSalary | float | ||||||
Employee.Birthdate | datetime | ||||||
Employee.ClassTypeID | int | Identifier for the Type of Object | |||||
Employee.CommissionPlanID | int | SQL Structure - CommissionPlan Table.ID | |||||
Employee.DefaultHomeScreen | int | Not Used. | |||||
Employee.DefaultWageExpenseAccountID | int | sql_structure_-_glaccount_table.ID sql_structure_-_gl_table.GLAccountID |
|||||
Employee.DefaultWorkersCompID | int | ||||||
Employee.Department | nvarchar(50) | ||||||
Employee.DiscountLevel | float | Not Used. | |||||
Employee.DoubleTimeRate | float | ||||||
Employee.EmailAddress | nvarchar(50) | ||||||
Employee.EmployeeStatus | int | Enumerated Type | |||||
Employee.EnableHolidayPTO | bit | sql_structure_-_payrollpto_table.ID | |||||
Employee.EnableSickPTO | bit | ||||||
Employee.EnableVacationPTO | bit | ||||||
Employee.FirstName | nvarchar(25) | ||||||
Employee.GroupID | int | sql_structure_-_employeegroup_table.ID | |||||
Employee.HireDate | datetime | ||||||
Employee.HolidayPTOID | int | sql_structure_-_payrollpto_table.ID | |||||
Employee.HoursWorkedPerYear | float | ||||||
Employee.HoursWorkedPerYearOV | bit | ||||||
Employee.ID | int | Primary Key for the Table | sql_structure_-_username_table.ParentID sql_structure_-_journal_table.EmployeeID |
||||
Employee.IDNumber | varchar(100) | License Number | |||||
Employee.IncludeInPayroll | bit | ||||||
Employee.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
Employee.IsInstructor | bit | ||||||
Employee.IsSalesperson | bit | Can this employee be assigned as a Salesperson on Orders, Estimates, etc… | |||||
Employee.IsSystem | bit | Used to Mark Required Records | |||||
Employee.IsWorkerResource | bit | Not Used. | |||||
Employee.LastName | nvarchar(25) | ||||||
Employee.LastRaiseDate | datetime | ||||||
Employee.MailAddressID | int | sql_structure_-_address_table.ID | |||||
Employee.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 | ||||
Employee.MainPhoneNumberID | int | sql_structure_-_phonenumber_table.ID | |||||
Employee.MaritalStatus | int | Enumerated Type | |||||
Employee.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
Employee.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
Employee.ModifiedDate | datetime | DateTime this Record was last modified | |||||
Employee.Notes | text | Notes that will be visible in Employee Setup under the Employee Information tab. | |||||
Employee.OverTimeRate | float | ||||||
Employee.PayFrequency | int | Enumerated Type | |||||
Employee.PayRollType | int | Enumerated Type | |||||
Employee.PerImageID | int | Employee's Photo | sql_structure_-_graphic_table.ID | ||||
Employee.Position | nvarchar(25) | ||||||
Employee.PricingLevel | float | ||||||
Employee.PricingLevelID | int | sql_structure_-_pricinglevel_table.ID | |||||
Employee.PrimaryNumber | varchar(75) | ||||||
Employee.PriNumberTypeID | int | sql_structure_-_element_table.ID WHERE ClassTypeID 4101 | |||||
Employee.PriNumberTypeText | varchar(50) | ||||||
Employee.QPHomeListID | int | ||||||
Employee.QPHomeListStoreID | int | Not Used. | |||||
Employee.QPServiceListID | int | ||||||
Employee.QPServiceListStoreID | int | Not Used. | |||||
Employee.QPTransListID | int | ||||||
Employee.QPTransListStoreID | int | Not Used. | |||||
Employee.ReportsToID | int | sql_structure_-_employee_table.ID | |||||
Employee.ReportTemplateID | int | ||||||
Employee.ReportTemplateStoreID | int | Not Used. | |||||
Employee.SecNumberTypeID | int | sql_structure_-_element_table.ID WHERE ClassTypeID 4101 | |||||
Employee.SecNumberTypeText | varchar(50) | ||||||
Employee.SecondaryNumber | varchar(75) | ||||||
Employee.SeqID | int | ||||||
Employee.ShiftDiffRate | float | ||||||
Employee.ShowOnActivityManager | bit | ||||||
Employee.ShowOnLineItems | bit | ||||||
Employee.ShowOnTimeClock | bit | ||||||
Employee.SickPTOID | int | ||||||
Employee.SignatureID | int | An image capture of the Employee's signature. | sql_structure_-_graphic_table.ID | ||||
Employee.StatusClassTypeID | int | ||||||
Employee.StatusID | int | Calendar StatusID | sql_structure_-_calendarstatus_table.ID | ||||
Employee.StatusText | varchar(50) | ||||||
Employee.StoreID | int | Not Used. | |||||
Employee.StraightTimeRate | float | ||||||
Employee.TaxNumber | nvarchar(25) | Masked Social Security Number | |||||
Employee.TerminationDate | datetime | ||||||
Employee.ThirdNumber | varchar(75) | ||||||
Employee.ThirdNumberTypeID | int | sql_structure_-_element_table.ID WHERE ClassTypeID 4101 | |||||
Employee.ThirdNumberTypeText | varchar(50) | ||||||
Employee.TimeCardsReqd | bit | ||||||
Employee.Title | nvarchar(10) | ||||||
Employee.TrackPTO | bit | ||||||
Employee.UserID | int | sql_structure_-_username_table.ID | |||||
Employee.VacationPTOID | int | ||||||
Employee.W2FirstName | varchar(35) | First name as it should appear on the W-2 Report. | |||||
Employee.W2LastName | varchar(35) | Last name as it should appear on the W-2 Report. | |||||
Employee.W2MiddleName | varchar(35) | Middle name (or Initial) as it should appear on the W-2 Report. |
Related Tables
sql_structure_-_employeegroup_table
You could leave a comment if you were logged in.