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