{$page} 



Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is a split table with the [[sql_structure_-_journal_table|Journal Table]] and is used to 


  - Store Master Time Card Info


  - Store Detail Time Card link info - for greater detail, view [[sql_structure_-_partusagecard_table|Part Usage Card Table]]


  - Status info is broken down in the TimeClockStatus table.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 20050 - Master Time Card
    * 20051 - Detail Time Card



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| SpeedNote.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| SpeedNote.Full || text ||   ||   ||
|| SpeedNote.HasParseFields || bit ||   ||   ||
|| SpeedNote.ID || int || Primary Key for the Table ||   ||
|| SpeedNote.IsActive || bit || Indicates if Enabled. 1Record is Active, 0Record is Not Active ||   ||
|| SpeedNote.IsSystem || bit || Used to Mark Required Records ||   ||
|| SpeedNote.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| SpeedNote.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| SpeedNote.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| SpeedNote.NoteTypeID || int ||   ||   ||
|| SpeedNote.SeqID || int ||   ||   ||
|| SpeedNote.StoreID || int || Not Used. ||   ||
|| SpeedNote.Title || nvarchar(50) ||   ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]