| Table Name: | cl_action |
| Table Number: | 5386 |
| Group: | Mixed Media |
| Description: | The action to be taken when the related rule evaluates true. The action is always to run a cl_act_src function |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| action | CHAR | varchar | 80 | Function name, either JScript or VBScript function entry | ||||
| active | LONG | tinyint | 1 | DIRECT | Indicates whether the action is active; i.e., 0=inactive, 1=active, default=1 | |||
| auto_exec_ind | LONG | tinyint | 0 | DIRECT | Indicates if the action will execute without review; i.e., 0=no, suggest only, 1=yes, execute automatically, default=0 | |||
| description | CHAR | varchar | 255 | Description of the individual action | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| rank | LONG | int | DIRECT | Sequence number of the action. Used for ordering the execution of actions within a rule | ||||
| title | CHAR | varchar | 2 | 80 | Common name of the individual action | |||
| type | LONG | tinyint | 0 | DIRECT | Execution type; i.e., 0=script, 1=auto-suggest, 2=java action, default=0 |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| cl_action2cl_act_src | MTO | cl_act_src | cl_act_src2cl_action | Related function source code | |||
| cl_action2cl_param | OTM | cl_param | cl_param2cl_action | Parameters for the function | |||
| cl_action2cl_result | OTM | cl_result | cl_result2cl_action | The action instances of the matching rule | |||
| cl_action2cl_rule | MTO | cl_rule | cl_rule2cl_action | Rule that triggers the action | |||
| cl_action2template | MTO | template | tmplt2cl_action | Template used by the action |
| Index Name | Fields | Flags |
|---|---|---|
| cl_action_ind | cl_action2cl_rule:title | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| cl_action_ind | cl_action2cl_rule, title | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| cl_action | |||