EscalationRules Table

Applies to QAComplete 12.80 SaaS, last modified on April 19, 2021

Description

Stores primary information for defined escalation rules. Detailed actions for escalation rules are held on the EscalationRuleActions table, in a one to many relationship.

Columns

The table contains the following columns:

RuleId  :  int, primary key, allows null: no

The unique identifier of the escalation rule.

FilterId  :  int, allows null: yes

The ID of the filter that is used as a criterion to activate the rule.

ProjId  :  int, allows null: no

The ID of the project that contains the rule.

TemplateId  :  int, allows null: yes

The ID of the email template that is used in the rule.

ApplyOrder  :  int, allows null: no

The order in which to apply the rule.

CreateUserId  :  int, allows null: yes

The ID of the user who created the item.

DateCreated  :  datetime, allows null: yes

The date and time when the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: yes

The date and time the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

Description  :  varchar (max), allows null: yes

The description of the rule.

Duration  :  int, allows null: no

The duration to wait for the rule to fire.

DurationUnits  :  varchar (max 50 chars), allows null: no

The time measurement for the duration (minutes, hours, days, weeks, months, or years).

EmailSubject  :  varchar (max 255 chars), allows null: yes

The subject of the email that the rule generates.

EntityCode  :  varchar (max 100 chars), allows null: no

The module where the rule is used.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FromName  :  varchar (max 100 chars), allows null: yes

The email address from which the rule sends the generated message.

IsActive  :  varchar (max 1 char), allows null: no

Indicates whether the rule is active.

NotifyEmails  :  varchar (max), allows null: yes

The email address for notifications generated by the rule. [OwnerName] and [AssignedToName] correspond to the email address of the item owner and of the user to whom the item is assigned.

Status  :  varchar (max 100 chars), allows null: no

The status of the rule.

Title  :  varchar (max 100 chars), allows null: no

The title of the escalation rule.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

See Also

EscalationRules View
EscalationRuleActions Table
Setup

Highlight search results