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]] and is used for ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 9201 - Recurring Activity
    * 9202 - Recurring Macro Activity??



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| RecurringActivity.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| RecurringActivity.Day || int ||  ||   ||
|| RecurringActivity.EndDate || smalldatetime ||  ||   ||
|| RecurringActivity.Endinterval || int ||  ||   ||
|| RecurringActivity.EndType || int ||  ||   ||
|| RecurringActivity.ID || int || Primary Key for the Table ||   ||
|| RecurringActivity.interval || int ||  ||   ||
|| RecurringActivity.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| RecurringActivity.IsSystem || bit || Used to Mark Required Records ||   ||
|| RecurringActivity.LastScheduled small || datetime ||  ||   ||
|| RecurringActivity.LookAheadCount || int ||  ||   ||
|| RecurringActivity.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| RecurringActivity.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| RecurringActivity.ModifiedDate || SmallDatetime || DateTime this Record was last modified ||   ||
|| RecurringActivity.Month || int ||  ||   ||
|| RecurringActivity.NextScheduled small || datetime ||  ||   ||
|| RecurringActivity.RecurrenceType || int ||  ||   ||
|| RecurringActivity.SeqID || int ||  ||   ||
|| RecurringActivity.StartDate small || datetime ||  ||   ||
|| RecurringActivity.StoreID || int || Not Used. ||   ||
|| RecurringActivity.TemplateClassTypeID || int ||  ||   ||
|| RecurringActivity.TemplateID || int ||  ||   ||
Related Tables