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.