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.