{$page}

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 Address.ID
Employee.AdvanceAccrualAccountID int GLAccount.ID
GL.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 CommissionPlan.ID
Employee.DefaultHomeScreen int Not Used.
Employee.DefaultWageExpenseAccountID int GLAccount.ID
GL.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 PayrollPTO.ID
Employee.EnableSickPTO bit
Employee.EnableVacationPTO bit
Employee.FirstName nvarchar(25)
Employee.GroupID int EmployeeGroup.ID
Employee.HireDate datetime
Employee.HolidayPTOID int PayrollPTO.ID
Employee.HoursWorkedPerYear float
Employee.HoursWorkedPerYearOV bit
Employee.ID int Primary Key for the Table UserName.ParentID
Journal.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 Address.ID
Employee.MainFaxNumberID int Note: This field is no longer exclusive to Fax Numbers and is used to store a secondary phone number. PhoneNumber.ID
Employee.MainPhoneNumberID int PhoneNumber.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 Graphic.ID
Employee.Position nvarchar(25)
Employee.PricingLevel float
Employee.PricingLevelID int PricingLevel.ID
Employee.PrimaryNumber varchar(75)
Employee.PriNumberTypeID int Element.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 Employee.ID
Employee.ReportTemplateID int
Employee.ReportTemplateStoreID int Not Used.
Employee.SecNumberTypeID int Element.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. Graphic.ID
Employee.StatusClassTypeID int
Employee.StatusID int Calendar StatusID CalendarStatus.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 Element.ID WHERE ClassTypeID 4101
Employee.ThirdNumberTypeText varchar(50)
Employee.TimeCardsReqd bit
Employee.Title nvarchar(10)
Employee.TrackPTO bit
Employee.UserID int UserName.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

EmployeeGroup

See Also

You could leave a comment if you were logged in.