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
You could leave a comment if you were logged in.