{$page} 



Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 23000 - Macro



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| RuleMacro.AutoTriggerTargetClassTypeID || int ||  ||   ||
|| RuleMacro.AutoTriggerTargetID || int ||  ||   ||
|| RuleMacro.AutoTriggerType || int ||  ||   ||
|| RuleMacro.CanRunManually || bit ||  ||   ||
|| RuleMacro.CategoryType || int ||  ||   ||
|| RuleMacro.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| RuleMacro.CreatedByID || int ||  ||   ||
|| RuleMacro.Description || text ||  ||   ||
|| RuleMacro.FilterCondition || text ||  ||   ||
|| RuleMacro.FilterConditionType || int ||  ||   ||
|| RuleMacro.FilterType || int ||  ||   ||
|| RuleMacro.ID || int || Primary Key for the Table ||   ||
|| RuleMacro.IndirectTriggerType || int ||  ||   ||
|| RuleMacro.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| RuleMacro.IsPrivate || bit ||  ||   ||
|| RuleMacro.IsSystem || bit || Used to Mark Required Records ||   ||
|| RuleMacro.LastModifiedDate || datetime ||  ||   ||
|| RuleMacro.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| RuleMacro.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| RuleMacro.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| RuleMacro.OwnsQuery || bit ||  ||   ||
|| RuleMacro.ParentID || int || ID of Category/Group Above ||   ||
|| RuleMacro.ParentStoreID || int || Not Used. ||   ||
|| RuleMacro.ProceedCondition || text ||  ||   ||
|| RuleMacro.ProceedConditionType || int ||  ||   ||
|| RuleMacro.ProceedType || int ||  ||   ||
|| RuleMacro.QueryClassTypeID || int ||  ||   ||
|| RuleMacro.QueryID || int ||  ||   ||
|| RuleMacro.QueryStoreID || int || Not Used. ||   ||
|| RuleMacro.QueryType || int ||  ||   ||
|| RuleMacro.RuleDataSource || int ||  ||   ||
|| RuleMacro.RuleExecuteType || int ||  ||   ||
|| RuleMacro.RuleName || nvarchar(35) ||  ||   ||
|| RuleMacro.SecurityRightID || int ||  ||   ||
|| RuleMacro.SeqID || int ||  ||   ||
|| RuleMacro.SQLQuery || text ||  ||   ||
|| RuleMacro.StoreID || int || Not Used. ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]