Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 21200 - Macro Activity
    • 21250 - Macro Activity Template

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
RuleActivity.AutoRollOver bit
RuleActivity.AutoRun bit
RuleActivity.ClassTypeID int Identifier for the Type of Object
RuleActivity.Color int
RuleActivity.Created datetime
RuleActivity.CreatedByID int
RuleActivity.ID int Primary Key for the Table
RuleActivity.ImageID int
RuleActivity.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
RuleActivity.IsFromRecurring bit
RuleActivity.IsSystem bit Used to Mark Required Records
RuleActivity.IsTimeless bit
RuleActivity.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
RuleActivity.ModifiedByUser nvarchar(25) Windows User who last modified this record
RuleActivity.ModifiedDate datetime DateTime this Record was last modified
RuleActivity.OriginalScheduled datetime
RuleActivity.Priority int
RuleActivity.PriorityText nvarchar(15)
RuleActivity.PrivateEvent bit
RuleActivity.RecurringActivityID int
RuleActivity.RuleClassTypeID int
RuleActivity.RuleID int
RuleActivity.RuleStoreID int Not Used.
RuleActivity.RunWithoutPrompting bit
RuleActivity.ScheduledEnd datetime
RuleActivity.ScheduledStart datetime
RuleActivity.SeqID int
RuleActivity.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.