Collect

Table (Rule) H

Table (Rule) V

Use this page to Register Rules to Tables.

To access this page:

  1. Click Collect > Targets in Navigation pane.
  2. Click Sources for target.
  3. Click Tables for source.
  4. Click Rules for table.

Field

Description

PRIORITY

Displays order that rules are run.

RULE

Displays name of rule that builds the download package.

RULE TYPE

Displays type of rule.

Values are:

  • Rule – Performed after the data has been downloaded by the package.
  • Action – Generic and performed at the field level, where rules are customized and can be performed against an entire table or single column.

Default value is Action

PRECEDENCE

Displays execution order to determine whether the rule runs before or after download process.

Values are: After, Before

Default value is After

FIELDNAME

Displays field name impacted by action (does not apply to rules).

ACTIVE

If enabled, rule or action is available for processing. Default value is Active.

ADD TARGET DB PARAM

If enabled, the database parameter is added to the stored procedure when the rule or action is run. This field is helpful when rules are stored in Collect database and run in another database; users are able to clearly see the originating database.  Default is Disabled.

WHERE CLAUSE

Displays a Where Clause that limits the rule to run only part of the data.

Table (Rule) V

Table (Rule) H

Use this page to Register Rules to Tables.

Field

Description

Priority

Displays order that rules are run.

Rule

Displays name of rule that builds the download package.

Rule Type

Displays type of rule.

Values are:

  • Rule – Performed after the data has been downloaded by the package.
  • Action – Generic and performed at the field level, where rules are customized and can be performed against an entire table or single column.

Default value is Action.

Precedence

Displays execution order to determine whether the rule runs before or after download process.

Values are: After, Before

Default value is After.

FieldName

Displays field name impacted by action (does not apply to rules).

Active

If enabled, rule or action is available for processing. Default value is Active.

Add Target DB Param

If enabled, the database parameter is added to stored procedure when rule or action is run. This field is helpful when rules are stored in Collect database and run in another database; users are able to clearly see the originating database.  Default is Disabled.

Where Clause

Displays a Where Clause that limits the rule or action to run only part of the data.

Comment

Displays notes about rule or action, e.g., description of what the rule does.

Spec ID

Displays client’s specification for a custom rule or action.

Publish Group

Displays name of group that the table is published with.

Duration

Displays amount of time (in seconds) the rule took to run.

Record Count

Displays the number of records affected by the rule or action (which may be limited if a Where clause is applied).

Job ID

Displays unique identifier associated with the job that ran the rule or action.

Rule Preview

Displays the SQL for the rule after the user clicks Generate Rule Preview.

Generate Rule Preview

Click to generate a preview of the SQL for the rule.