Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • xxxxx -
    • xxxxx -

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
PayrollPTO.AccrualAccountClassTypeID int
PayrollPTO.AccrualAccountID int
PayrollPTO.AmountPerPayPeriod float
PayrollPTO.Balance float
PayrollPTO.ClassTypeID int Identifier for the Type of Object
PayrollPTO.EstimatedPayOffDate datetime
PayrollPTO.ExpenseAccountClassTypeID int
PayrollPTO.ExpenseAccountID int
PayrollPTO.HoursPerYear float
PayrollPTO.ID int Primary Key for the Table
PayrollPTO.IncludeOverTime bit
PayrollPTO.IsAccrued bit
PayrollPTO.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
PayrollPTO.IsEnabled bit
PayrollPTO.IsSystem bit Used to Mark Required Records
PayrollPTO.LastDecreaseDate datetime
PayrollPTO.LastIncreaseDate datetime
PayrollPTO.ModifiedByComputer varchar(25) HostName of computer that last modified this record
PayrollPTO.ModifiedByUser varchar(25) Windows User who last modified this record
PayrollPTO.ModifiedDate datetime DateTime this Record was last modified
PayrollPTO.PTOEarningType int
PayrollPTO.PTOType int
PayrollPTO.SeqID int
PayrollPTO.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.