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 and is used to
- Store Master Time Card Info
- Store Detail Time Card link info - for greater detail, view sql_structure_-_partusagecard_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
You could leave a comment if you were logged in.