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