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 that is used …
Information on Table Data
- ClassTypeIDs Stores in Table:
- 21100 - Contact Activity
- 21150 - Contact Activity Template
- 21300 - Work Assignment
- 21350 - Work Assignment Template
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
ContactActivity.AllDayEvent | bit | ||||||
ContactActivity.AutoRollOver | bit | ||||||
ContactActivity.AutoRun | bit | ||||||
ContactActivity.Category | nvarchar(25) | ||||||
ContactActivity.ClassTypeID | int | Identifier for the Type of Object | |||||
ContactActivity.Color | int | ||||||
ContactActivity.ContactActivityType | int | ||||||
ContactActivity.ContactActivityTypeText | nvarchar(15) | ||||||
ContactActivity.ContactCallType | int | ||||||
ContactActivity.ContactCallTypeText | nvarchar(15) | ||||||
ContactActivity.Created | datetime | ||||||
ContactActivity.CreatedByID | int | ||||||
ContactActivity.ID | int | Primary Key for the Table | |||||
ContactActivity.ImageID | int | ||||||
ContactActivity.IsActive | bit | Not Used for This Table | |||||
ContactActivity.IsFromRecurring | bit | ||||||
ContactActivity.IsLocked | bit | ||||||
ContactActivity.IsSystem | bit | Used to Mark Required Records | |||||
ContactActivity.IsTimeless | bit | ||||||
ContactActivity.Location | nvarchar(50) | ||||||
ContactActivity.LocationClassTypeID | int | ||||||
ContactActivity.LocationID | int | ||||||
ContactActivity.LocationStoreID | int | Not Used. | |||||
ContactActivity.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
ContactActivity.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
ContactActivity.ModifiedDate | datetime | DateTime this Record was last modified | |||||
ContactActivity.OriginalScheduled | datetime | ||||||
ContactActivity.PartInstanceID | int | ||||||
ContactActivity.Priority | int | ||||||
ContactActivity.PriorityText | nvarchar(15) | ||||||
ContactActivity.PrivateEvent | bit | ||||||
ContactActivity.RecurringActivityID | int | ||||||
ContactActivity.Result char(50) | |||||||
ContactActivity.RunWithoutPrompting | bit | ||||||
ContactActivity.ScheduledEnd | datetime | ||||||
ContactActivity.ScheduledStart | datetime | ||||||
ContactActivity.SeqID | int | ||||||
ContactActivity.StoreID | int | Not Used. | |||||
ContactActivity.TransPartClassTypeID | int | ||||||
ContactActivity.TransPartID | int | ||||||
ContactActivity.TransPartStoreID | int | Not Used. | |||||
ContactActivity.ValidStatus | int |
Related Tables
You could leave a comment if you were logged in.