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

You could leave a comment if you were logged in.