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.