Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • PayItemType in Table:
    • 0 - StraightTime
    • 1 - OverTime
    • 2 - DoubleTime
    • 3 - ShiftDiffTime
    • 4 - Salary
    • 5 - Bonus
    • 6 - Commission
    • 7 - Advance
    • 8 - AdvanceRepayment
    • 9 - Benefit
    • 10 - StandardEmployeeDeduction
    • 11 - OptionalEmployeeDeduction
    • 12 - StandardEmployerDeduction
    • 13 - OptionalEmployerDeduction
    • 14 - WorkersCompensation
    • 15 - VacationTime
    • 16 - SickTime
    • 17 - HolidayTime

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
PayrollPaycheckPayItem.Amount float
PayrollPaycheckPayItem.AmountOV bit
PayrollPaycheckPayItem.CalcAmount float
PayrollPaycheckPayItem.ClassTypeID int Identifier for the Type of Object
PayrollPaycheckPayItem.EmployeeID int ID of the Employee Employee.ID
PayrollPaycheckPayItem.Hours float
PayrollPaycheckPayItem.ID int Primary Key for the Table
PayrollPaycheckPayItem.IsActive bit Not Used for This Table
PayrollPaycheckPayItem.IsMissed bit
PayrollPaycheckPayItem.IsSystem bit Used to Mark Required Records
PayrollPaycheckPayItem.ModifiedByComputer varchar(25) HostName of computer that last modified this record
PayrollPaycheckPayItem.ModifiedByUser varchar(25) Windows User who last modified this record
PayrollPaycheckPayItem.ModifiedDate datetime DateTime this Record was last modified
PayrollPaycheckPayItem.OVAmount float
PayrollPaycheckPayItem.PaycheckID int
PayrollPaycheckPayItem.PayItemClassTypeID int
PayrollPaycheckPayItem.PayItemID int
PayrollPaycheckPayItem.PayItemText varchar(100)
PayrollPaycheckPayItem.PayItemType int See Above for List
PayrollPaycheckPayItem.PayrollClassTypeID int
PayrollPaycheckPayItem.PayrollID int
PayrollPaycheckPayItem.SeqID int
PayrollPaycheckPayItem.ShowOnPaycheck bit
PayrollPaycheckPayItem.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.