Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is …
Information on Table Data
- ClassTypeIDs Stores in Table:
- 1800 - Activity Time Span
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| ActivityTimeSpan.ClassTypeID | int | Identifier for the Type of Object | |||||
| ActivityTimeSpan.Description | text | ||||||
| ActivityTimeSpan.Duration | datetime | ||||||
| ActivityTimeSpan.DurationLen | int | ||||||
| ActivityTimeSpan.DurationType | int | ||||||
| ActivityTimeSpan.EndTime | datetime | ||||||
| ActivityTimeSpan.FixedStartTime | bit | ||||||
| ActivityTimeSpan.ID | int | Primary Key for the Table | |||||
| ActivityTimeSpan.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| ActivityTimeSpan.IsSystem | bit | Used to Mark Required Records | |||||
| ActivityTimeSpan.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| ActivityTimeSpan.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| ActivityTimeSpan.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| ActivityTimeSpan.SeqID | int | ||||||
| ActivityTimeSpan.ShortDesc | varchar(50) | ||||||
| ActivityTimeSpan.ShortDescPlural | varchar(50) | ||||||
| ActivityTimeSpan.SpanName | varchar(50) | ||||||
| ActivityTimeSpan.StartTime | datetime | ||||||
| ActivityTimeSpan.StoreID | int | Not Used. |
Related Tables
You could leave a comment if you were logged in.